Accordion Menu Using JQUERY IN MVC

Add a new controller. Assume I have added a Home Controller.

 

public ActionResult Index()

        {

            MenuModel ObjMenuModel = new MenuModel();

            ObjMenuModel.MainMenuModel = new List<MainMenu>();

            ObjMenuModel.MainMenuModel = GetMainMenu();            

            ObjMenuModel.SubMenuModel = new List<SubMenu>();

            ObjMenuModel.SubMenuModel = GetSubMenu();

            return View(ObjMenuModel);

        }

        public List<MainMenu>GetMainMenu()

        {

            List<MainMenu>ObjMainMenu = new List<MainMenu>();

            ObjMainMenu.Add(new MainMenu { ID = 1, MainMenuItem = "Telugu Actors", MainMenuURL = "#" });

            ObjMainMenu.Add(new MainMenu { ID = 2, MainMenuItem = "Telugu Comedians Actors", MainMenuURL = "#" });

            ObjMainMenu.Add(new MainMenu { ID = 3, MainMenuItem = "Telugu Villian Actors", MainMenuURL = "#" });

            ObjMainMenu.Add(new MainMenu { ID = 4, MainMenuItem = "Telugu Music Directors", MainMenuURL = "#" });

            return ObjMainMenu;

        }

        public List<SubMenu>GetSubMenu()

        {

            List<SubMenu>ObjSubMenu = new List<SubMenu>();

            ObjSubMenu.Add(new SubMenu { MainMenuID = 1, SubMenuItem = "Pawan Kalyan", SubMenuURL = "#" });

            ObjSubMenu.Add(new SubMenu { MainMenuID = 1, SubMenuItem = "Mahesh Babu", SubMenuURL = "#" });

            ObjSubMenu.Add(new SubMenu { MainMenuID = 1, SubMenuItem = "Prabhas", SubMenuURL = "#" });

            ObjSubMenu.Add(new SubMenu { MainMenuID = 1, SubMenuItem = "Jr Ntr", SubMenuURL = "#" });

            ObjSubMenu.Add(new SubMenu { MainMenuID = 2, SubMenuItem = "Ali", SubMenuURL = "#" });

            ObjSubMenu.Add(new SubMenu { MainMenuID = 2, SubMenuItem = "Venu Madhav", SubMenuURL = "#" });

            ObjSubMenu.Add(new SubMenu { MainMenuID = 2, SubMenuItem = "Sapthagiri", SubMenuURL = "#" });

            ObjSubMenu.Add(new SubMenu { MainMenuID = 3, SubMenuItem = "Mani Sharma", SubMenuURL = "#" });

            ObjSubMenu.Add(new SubMenu { MainMenuID = 4, SubMenuItem = "Devi Sri Prasad", SubMenuURL = "#" });

            ObjSubMenu.Add(new SubMenu { MainMenuID = 4, SubMenuItem = "Koti", SubMenuURL = "#" });

            ObjSubMenu.Add(new SubMenu { MainMenuID = 4, SubMenuItem = "Keervani", SubMenuURL = "#" });

            return ObjSubMenu;

        }

Screen Shot:

In Model Add a new class  MenuModel.cs , and write the following code

In Views in Index.cs.html add the following code

<link href="Css/styles.css" rel="stylesheet" type="text/css" />
<script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript"></script>

<script type="text/javascript">  
    $(document).ready(function () {
        $("#accordian h3").click(function () {         
            $("#accordian ul ul").slideUp();          
            if (!$(this).next().is(":visible")) {
                $(this).next().slideDown();
            }
        });
    });
</script>

@using (Html.BeginForm("Index", "Home"))
{
 <div id="accordian">
       <ul>
              <li>
              @{
    foreach (var MenuItem in Model.MainMenuModel)
    {
         var SubMenuItem = Model.SubMenuModel.Where(m => m.MainMenuID == MenuItem.ID);
       <h3><a href="@MenuItem.MainMenuURL"> @MenuItem.MainMenuItem </a></h3>
           if (SubMenuItem.Count() > 0)
              {
                   <ul>
                            @foreach (var SubItem in SubMenuItem)
                            {
                                <li><a href='@SubItem.SubMenuURL'>@SubItem.SubMenuItem</a></li>
                            }
                   </ul>
              }
       }
    }
              </ul>
</div>   
}
<br />
<div  style="text-align:center"><b>dotnetbyudayrajakonda.blogspot.in</b></div>

Output:

HTTP GET or Post in MVC

In asp.net Web Forms, IsPostBack page  property is used to check if the request is POST or GET.

If IsPostBack Property returns true, then we knows the request is http post. Else the request is GET

In asp.net mvc use Request object Http Method property to check if the request is get or a Post Request

Example

First Let me add a controller.

Give any Name of the controller , I have given it as Home Controller.

Write the below code in the Home Controller as shown below

As we cannot have same Index method name twice so I have used Index_Post and specifying the Action Attribute Index.

Created a new method to check Wheather IsPost() is True or False.

Right click on the controller and Add View--Index.cshtml

and click on Add Button

After hitting the url you can see that IsPostback is false

In Debugging Mode after hitting Enter.You can see that Get  method is been called.

When  you click on Submit button you can see that it is calling the post method.

and the output is

HTTP POST vs HTTP GET (GET Request Vs Post Request)

HTTP stands for Hypertext Transfer Protocol. Http is the most common protocol used for the communication between a web server and a client.

For Example, to request a home page of any site, then you would type the url of that site.

GET:

Data is submitted as a part of url.

It is not secure but fast and quick.

It is good when you want user to bookmark page.

Data is limited to max length of query string.

GET method should not be used when sending passwords or other sensitive information.

It use Stack method for passing form variable.

Get Request is generally used to get the data from the server

• When you click on a hyperlink
• When Response.Redirect() statement is executed
• When you type URL in the address bar and hit enter 

Example :  Now i want to submit the data.

Default.aspx

Login.aspx:

Output:

On Clicking on button

In Url you can see the values:

Output Explanation: Default.aspx has username data which is sent using get method to login.aspx (server).

 In the output of second screen shot we can see there is key (username) value(uday) data as query stirng in the URL which is submitted to login.aspx page and the output(Welcome uday) is show in login.aspx page.


POST

Data is submitted in http request body.

It is more secured but slower as compared to GET.

It use heap method for passing form variable

It can post unlimited form variables.

Data is not visible in the url.


Example:

Default.aspx

Login.aspx

Output:

Output Explanation

we can observe the post method did not send any query string like what we have seen in get method

Post Request is generally used to submit data to the server.

• A post request is generally issued
• When you click on submit button
• When AUTOPOST back  is set to true and when a selection in the Drop Down  List is changed

Example 2 :

Now with in the button click we are retrieving the details the user has submitted , and then we are appending the values the user has entered using query string and redirecting to webform2

Output Screen:

When we are typing the URL and hitting Enter this is GET Request

Now I want to check in Fiddler Web Debugger and check the Type of Request

After Filling the Form Values:

And Then Clicking on Submit Btn

On Clicking on Submit Button then We are Posting the Data

Here the data is send to the server as part of the Body.

Note:

In asp.net Web Forms, IsPostBack page  property is used to check if the request is POST or GET.

If IsPostBack Property returns true, then we knows the request is http post. Else the request is GET

GET	POST
Data will be arranged in HTTP header by appending to the URL as query string	Data will be arranged in HTTP message body.
Data is in query string so user can view the data	Not visible to user
Less secured compared to POST method because data is in query string so it will be saved in browser history and web server logs	Bit safer than GET method because data is not saved in history or web server logs
As data is saved in URL so its saves only 2048 bytes data	Can be used for any amount of data
Can be bookmarked	Can’t bookmarked
Hacking will be easy	Hacking is difficult
Only ASCII character data type allowed	No restrictions. Allows binary data also
Caching is possible	No caching

Upload-and-save-insert-multiple-files-to-database using ASP.NET

.

*.aspx

<div>

        <asp:FileUpload ID="FileUpload1" runat="server" />

        <asp:Button ID="Button1" runat="server" Text="Save" OnClick="Button1_Click" />

        <asp:GridView ID="GridView1" runat="server"></asp:GridView>

    </div>

*.cs

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.BindData();
        }
    }

    public void BindData()
    {
        string constr = ConfigurationManager.ConnectionStrings["connecionString"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.CommandText = "SELECT Id, Name FROM images";
                cmd.Connection = con;
                con.Open();
                GridView1.DataSource = cmd.ExecuteReader();
                GridView1.DataBind();
                con.Close();
            }
        }
    }

Button_click Event

foreach (HttpPostedFile postedFile in FileUpload1.PostedFiles)

        {
            string filename = Path.GetFileName(postedFile.FileName);
            string contentType = postedFile.ContentType;
            using (Stream fs = postedFile.InputStream)
            {
                using (BinaryReader br = new BinaryReader(fs))
                {
                    byte[] bytes = br.ReadBytes((Int32)fs.Length);
                    string constr = ConfigurationManager.ConnectionStrings["connecionString"].ConnectionString;
                    using (SqlConnection con = new SqlConnection(constr))
                    {
                        string query = "insert into images values (@Name, @Type, @Data)";
                        using (SqlCommand cmd = new SqlCommand(query))
                        {
                            cmd.Connection = con;
                            cmd.Parameters.AddWithValue("@Name", filename);
                            cmd.Parameters.AddWithValue("@Type", contentType);
                            cmd.Parameters.AddWithValue("@Data", bytes);
                            con.Open();
                            cmd.ExecuteNonQuery();
                            con.Close();
                        }
                    }
                }
            }
        }
        Response.Redirect(Request.Url.AbsoluteUri);

Output:

Generate Barcode using C Sharp.

Barcode Font

First we should download the Font from the Url which is given below

Download Barcode Font

Once downloaded follow the below steps.

1. Extract the ZIP file.

2. Click and Execute INSTALL.exe file.

Output:

*.aspx

<div>

        <table class="auto-style1">

            <tr>

                <td>

                    <asp:Label ID="lblNumber" runat="server" style="text-align:right" Text="Enter Number"></asp:Label>

                </td>

                <td>

                    <asp:TextBox ID="txtNumber" runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>&nbsp;</td>

                <td>

                    <asp:Button ID="btnGenerate" runat="server" Text="Generate" OnClick="btnGenerate_Click" style="height: 26px" />

                </td>

            </tr>

            <tr>

                <td>

                    <asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>

                </td>

            </tr>                  

        </table>

        </div>

*.CS

using System;

using System.Collections.Generic;

using System.Drawing;

using System.IO;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace WebApplication3

{

    public partial class WebForm1 : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

        }

        protected void btnGenerate_Click(object sender, EventArgs e)

        {

            string barCode = txtNumber.Text;

            System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image();

            using (Bitmap bitMap = new Bitmap(barCode.Length * 40, 80))

            {

                using (Graphics graphics = Graphics.FromImage(bitMap))

                {

                    Font oFont = new Font("IDAutomationHC39M", 16);

                    PointF point = new PointF(2f, 2f);

                    SolidBrush blackBrush = new SolidBrush(Color.Black);

                    SolidBrush whiteBrush = new SolidBrush(Color.White);

                    graphics.FillRectangle(whiteBrush, 0, 0, bitMap.Width, bitMap.Height);

                    graphics.DrawString("*" + barCode + "*", oFont, blackBrush, point);

                }

                using (MemoryStream ms = new MemoryStream())

                {

                    bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);

                    byte[] byteImage = ms.ToArray();

                    Convert.ToBase64String(byteImage);

                    imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);

                }

                PlaceHolder1.Controls.Add(imgBarCode);

            }

        }

    }

}