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_Pack_Slno = Convert.ToInt32(gvPackage.DataKeys[gvRow.RowIndex].Value);
PackageEntity package = GetPackage(M_Pack_Slno);
// Now set value to modal popup
packageidViewpopup.Value = package.M_Pack_Slno.ToString();
viewpackagename.Text = package.M_Pack_Name;
viewpackageshortname.Text = package.M_Pack_Sname;
mpePackageViewpopup.Show();
}
protected void btnSave_Click1(object sender, EventArgs e)
{
if (Page.IsValid)
{
PackageEntity package = new PackageEntity();
package.M_Pack_Slno = Convert.ToInt32(packageidEditpopup.Value);
package.M_Pack_Name = txtpackagenameEditpopup.Text.Trim();
package.M_Pack_Sname = txtpackageshortnameEditpopup.Text.Trim();
if (package.M_Pack_Slno != 0)
{
UpdatePackage(package);
}
LoadData();
}
}
public bool AddNewPackage(PackageEntity package)
{
String insertQuery = @"INSERT INTO [M_Pack] ([M_Pack_Name],[M_Pack_Sname]) VALUES(@M_Pack_Name, @M_Pack_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_Pack_Name", package.M_Pack_Name);
cmd.Parameters.AddWithValue("@M_Pack_Sname", package.M_Pack_Sname);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.ExecuteNonQuery();
return(true);
}
}
public bool UpdatePackage(PackageEntity package)
{
String updateQuery = @"UPDATE [M_Pack] SET [M_Pack_Name] = @M_Pack_Name ,[M_Pack_Sname] = @M_Pack_Sname Where[M_Pack_Slno] = @M_Pack_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_Pack_Slno", package.M_Pack_Slno);
cmd.Parameters.AddWithValue("@M_Pack_Name", package.M_Pack_Name);
cmd.Parameters.AddWithValue("@M_Pack_Sname", package.M_Pack_Sname);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.ExecuteNonQuery();
return(true);
}
}