/// <summary>
/// to get the data from the database and bind it to the gridView
/// </summary>
private void BindGrid()
{
MajorshockBLL MajorshockBLLobj = new MajorshockBLL();
grdshocks.DataSource = MajorshockBLLobj.GetMshock(Convert.ToInt32(Session["HH_ID"]));
grdshocks.DataBind();
}
private void GetShock()
{
MajorshockBLL MajorshockBLLobj = new MajorshockBLL();
int PAP_SHOCKID1 = 0;
if (ViewState["PAP_SHOCKID"] != null)
{
PAP_SHOCKID1 = Convert.ToInt32(ViewState["PAP_SHOCKID"]);
}
MajorshockBO Majorshockobj = new MajorshockBO();
Majorshockobj = MajorshockBLLobj.GetPapShochId(PAP_SHOCKID1);
pap_shockidTextBox.Text = Majorshockobj.PAP_SHOCKID1.ToString();
typeofshockDropDownList.ClearSelection();
if (typeofshockDropDownList.Items.FindByValue(Majorshockobj.SHOCKID1.ToString()) != null)
{
typeofshockDropDownList.Items.FindByValue(Majorshockobj.SHOCKID1.ToString()).Selected = true;
}
helpedDropDownList.ClearSelection();
if (helpedDropDownList.Items.FindByValue(Majorshockobj.SUPPORTID1.ToString()) != null)
{
helpedDropDownList.Items.FindByValue(Majorshockobj.SUPPORTID1.ToString()).Selected = true;
}
copingmechDropDownList.ClearSelection();
if (copingmechDropDownList.Items.FindByValue(Majorshockobj.COP_MECHANISMID1.ToString()) != null)
{
copingmechDropDownList.Items.FindByValue(Majorshockobj.COP_MECHANISMID1.ToString()).Selected = true;
}
}
/// <summary>
/// to Edit and Delete the command
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdUsers_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
ViewState["PAP_SHOCKID"] = e.CommandArgument;
GetShock();
SetUpdateMode(true);
}
else if (e.CommandName == "DeleteRow")
{
ViewState["PAP_SHOCKID"] = e.CommandArgument;
int PAP_SHOCKID1 = Convert.ToInt32(ViewState["PAP_SHOCKID"]);
MajorshockBLL MajorshockBLLobj = new MajorshockBLL();
MajorshockBLLobj.Delete(PAP_SHOCKID1);
BindGrid();
clearfields();
SetUpdateMode(false);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data deleted successfully');", true);
}
}
/// <summary>
/// to save the data to the database
/// and clear the data fields by calling clearfields() method
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string message = string.Empty;
ChangeRequestStatusMajorSchock();
MajorshockBLL MajorshockBLLobj = new MajorshockBLL();
if (pap_shockidTextBox.Text == string.Empty)
{
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
MajorshockBO Majorshockobj = new MajorshockBO();
Majorshockobj.COP_MECHANISMID1 = Convert.ToInt32(copingmechDropDownList.SelectedValue.ToString());
Majorshockobj.SHOCKID1 = Convert.ToInt32(typeofshockDropDownList.SelectedValue.ToString());
Majorshockobj.SUPPORTID1 = Convert.ToInt32(helpedDropDownList.SelectedValue.ToString());
Majorshockobj.CREATEDBY1 = Convert.ToInt32(Session["USER_ID"]);
Majorshockobj.HHID1 = Convert.ToInt32(hhid);
MajorshockBLL BLLobj = new MajorshockBLL();
message = BLLobj.Insert(Majorshockobj);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data saved successfully');", true);
BindGrid();
clearfields();
}
catch (Exception ex)
{
throw ex;
}
finally
{
MajorshockBLLobj = null;
}
}
//edit the data existing in the Grid
else
{
MajorshockBLL BLLobj = new MajorshockBLL();
try
{
string uID = Session["USER_ID"].ToString();
MajorshockBO Majorshockobj = new MajorshockBO();
Majorshockobj.PAP_SHOCKID1 = Convert.ToInt32(pap_shockidTextBox.Text);
Majorshockobj.SHOCKID1 = Convert.ToInt32(typeofshockDropDownList.SelectedValue);
Majorshockobj.COP_MECHANISMID1 = Convert.ToInt32(copingmechDropDownList.SelectedValue);
Majorshockobj.SUPPORTID1 = Convert.ToInt32(helpedDropDownList.SelectedValue);
Majorshockobj.CREATEDBY1 = Convert.ToInt32(Session["USER_ID"]);
message = BLLobj.EDITMshock(Majorshockobj);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
BindGrid();
clearfields();
SetUpdateMode(false);
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data updated successfully');", true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
MajorshockBLLobj = null;
}
}
string AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
projectFrozen(); //Added BY Ramu
}
