public CarrierEntity GetCarrier(Int32 M_Carrier_Slno) { String updateQuery = @"Select * From [M_Carrier] Where [M_Carrier_Slno] = @M_Carrier_Slno"; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _ConnStr; SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = updateQuery; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@M_Carrier_Slno", M_Carrier_Slno); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader dataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection); DataTable dataTable = new DataTable(); dataTable.Load(dataReader); CarrierEntity existingcarrier = new CarrierEntity(); foreach (DataRow row in dataTable.Rows) { existingcarrier.M_Carrier_Slno = Convert.ToInt32(row["M_Carrier_Slno"]); existingcarrier.M_Carrier_Name = Convert.ToString(row["M_Carrier_Name"]); existingcarrier.M_Carrier_Sname = Convert.ToString(row["M_Carrier_Sname"]); } return(existingcarrier); } }
protected void ibtnEdit_Click(object sender, ImageClickEventArgs e) { GridViewRow gvRow = (GridViewRow)((ImageButton)sender).NamingContainer; Int32 M_Carrier_Slno = Convert.ToInt32(gvCarrier.DataKeys[gvRow.RowIndex].Value); CarrierEntity carrier = GetCarrier(M_Carrier_Slno); // Now set value to modal popup carrieridEditpopup.Value = carrier.M_Carrier_Slno.ToString(); txtcarriernameEditpopup.Text = carrier.M_Carrier_Name; txtcarriershortnameEditpopup.Text = carrier.M_Carrier_Sname; mpeCarrierEditpopup.Show(); }
protected void ibtnView_Click(object sender, ImageClickEventArgs e) { //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Successfully')", true); GridViewRow gvRow = (GridViewRow)((ImageButton)sender).NamingContainer; Int32 M_Carrier_Slno = Convert.ToInt32(gvCarrier.DataKeys[gvRow.RowIndex].Value); CarrierEntity carrier = GetCarrier(M_Carrier_Slno); // Now set value to modal popup carrieridViewpopup.Value = carrier.M_Carrier_Slno.ToString(); viewcarriername.Text = carrier.M_Carrier_Name; viewcarriershortname.Text = carrier.M_Carrier_Sname; mpeCarrierViewpopup.Show(); }
protected void btnSave_Click1(object sender, EventArgs e) { if (Page.IsValid) { CarrierEntity carrier = new CarrierEntity(); carrier.M_Carrier_Slno = Convert.ToInt32(carrieridEditpopup.Value); carrier.M_Carrier_Name = txtcarriernameEditpopup.Text.Trim(); carrier.M_Carrier_Sname = txtcarriershortnameEditpopup.Text.Trim(); if (carrier.M_Carrier_Slno != 0) { UpdateCarrier(carrier); } LoadData(); } }
public bool AddNewCarrier(CarrierEntity carrier) { String insertQuery = @"INSERT INTO [M_Carrier] ([M_Carrier_Name],[M_Carrier_Sname]) VALUES(@M_Carrier_Name, @M_Carrier_Sname)"; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _ConnStr; SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = insertQuery; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@M_Carrier_Name", carrier.M_Carrier_Name); cmd.Parameters.AddWithValue("@M_Carrier_Sname", carrier.M_Carrier_Sname); if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.ExecuteNonQuery(); return(true); } }
public bool UpdateCarrier(CarrierEntity carrier) { String updateQuery = @"UPDATE [M_Carrier] SET [M_Carrier_Name] = @M_Carrier_Name ,[M_Carrier_Sname] = @M_Carrier_Sname Where[M_Carrier_Slno] = @M_Carrier_Slno"; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _ConnStr; SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = updateQuery; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@M_Carrier_Slno", carrier.M_Carrier_Slno); cmd.Parameters.AddWithValue("@M_Carrier_Name", carrier.M_Carrier_Name); cmd.Parameters.AddWithValue("@M_Carrier_Sname", carrier.M_Carrier_Sname); if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.ExecuteNonQuery(); return(true); } }