private void UpdateDistDesignation(int id)
{
try
{
//DBconnection obj = new DBconnection();
//obj.SetCommandSP = "z_UpdateDisttDesignation";
//obj.AddParam("@id", id);
//obj.AddParam("@years", DDLYears.SelectedItem.Text.Trim().ToString());
//obj.AddParam("@designation", txtDesig.Text.Trim().ToString());
//int exe = obj.ExecuteNonQuery();
DistrictDesignations desig = new DistrictDesignations();
desig.Id = id;
desig.Years = DDLYears.SelectedItem.Text.Trim().ToString();
desig.Designation = txtDesig.Text.Trim().ToString();
int exe = desig.UpdateDesignation();
if (exe > 0)
{
clear();
showmsg("Record has been updated successfully !", "view_distt_designations.aspx");
}
}
catch { }
}
private void GetDesignation(int id)
{
DistrictDesignations desig = new DistrictDesignations();
desig.Id = id;
DataTable dt = new DataTable();
dt = desig.GetDesignation();
if (dt.Rows.Count > 0)
{
DDLYears.SelectedItem.Text = dt.Rows[0]["years"].ToString();
txtDesig.Text = dt.Rows[0]["designation"].ToString();
}
}
protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
int id = 0;
if (e.CommandName == "Delete")
{
id = Int32.Parse(e.CommandArgument.ToString());
DistrictDesignations desig = new DistrictDesignations();
desig.Id = id;
int exe = desig.DeleteSubDesignation();
if (exe > 0)
{
//RadGrid1.DataBind();
ManageGrid();
}
}
}
private void GetSubDesignation(int id)
{
DistrictDesignations desig = new DistrictDesignations();
desig.Sub_desig_id = id;
DataTable dt = new DataTable();
dt = desig.GetSubDesignation();
if (dt.Rows.Count > 0)
{
string years = dt.Rows[0]["years"].ToString();
GetDistDesignation(years);
DDLYears.SelectedItem.Text = years;
DDLDesig.SelectedValue = dt.Rows[0]["desig_id"].ToString();
txtSubDesig.Text = dt.Rows[0]["sub_designation"].ToString();
}
}
private void UpdateDistSubDesignation(int id)
{
try
{
DistrictDesignations desig = new DistrictDesignations();
desig.Sub_desig_id = id;
desig.Id = int.Parse(DDLDesig.SelectedValue.ToString());
desig.Years = DDLYears.SelectedItem.Text.Trim().ToString();
desig.Sub_designation = txtSubDesig.Text.Trim().ToString();
int exe = desig.UpdateSubDesignation();
if (exe > 0)
{
clear();
showmsg("Record has been updated successfully !", "view_distt_designations_sub.aspx");
}
}
catch { throw; }
}
private void AddDistSubDesignation()
{
try
{
DistrictDesignations desig = new DistrictDesignations();
desig.Years = DDLYears.SelectedItem.Text.Trim().ToString();
desig.Id = int.Parse(DDLDesig.SelectedValue.ToString());
desig.Designation = DDLDesig.SelectedItem.Text.Trim().ToString();
desig.Sub_designation = txtSubDesig.Text.Trim().ToString();
int exe = desig.AddSubDesignation();
if (exe > 0)
{
clear();
string jv = "<script>alert('Record has been added successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
private void AddDistDesignation()
{
try
{
DistrictDesignations desig = new DistrictDesignations();
desig.Years = DDLYears.SelectedItem.Text.Trim().ToString();
desig.Designation = txtDesig.Text.Trim().ToString();
int exe = desig.AddDesignation();
//DBconnection obj = new DBconnection();
//obj.SetCommandSP = "z_AddDisttDesignation";
//obj.AddParam("@years", DDLYears.SelectedItem.Text.Trim().ToString());
//obj.AddParam("@designation", txtDesig.Text.Trim().ToString());
//int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
string jv = "<script>alert('Record has been added successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
int id = 0;
if (e.CommandName == "Delete")
{
id = Int32.Parse(e.CommandArgument.ToString());
DistrictDesignations desig = new DistrictDesignations();
desig.Id = id;
int exe = desig.DeleteDesignation();
//DBconnection obj = new DBconnection();
//obj.SetCommandSP = "sp_DeleteDisttDesig";
//obj.AddParam("@id", uid);
//int i = obj.ExecuteNonQuery();
if (exe > 0)
{
//RadGrid1.DataBind();
ManageGrid();
}
}
}
