protected void btnupdateImpact_Click(object sender, EventArgs e)
{
///Add Exception handilng try catch change by vishal 21-05-2012
try
{
string prev_value;
string curnt_value;
int historyid;
int changeid = Convert.ToInt32(Request.QueryString[0]);
#region For updating values in Problem history table
ObjChangeHistory.Changeid = changeid;
MembershipUser User = Membership.GetUser();
string username = User.UserName.ToString();
Objorganization = Objorganization.Get_Organization();
int userid = ObjUser.Get_By_UserName(username, Objorganization.Orgid);
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "ImpactUpdated";
ObjChangeHistory.Insert();
#endregion
#region Get the Current historyid by calling function Get_Current_ProblemHistoryid()
historyid = ObjChangeHistory.Get_Current_ChangeHistoryid();
#endregion
#region Find Current value of Problem aBy Calling ObjProblem = ObjProblem.Get_By_id(problemid);
ObjChange = ObjChange.Get_By_id(changeid);
#endregion
#region Find the value of current symptom
ObjChangeImpact = ObjChangeImpact.Get_By_id(ObjChange.Changeid);
#endregion
#region Insert the values in history difference table
prev_value = Convert.ToString(ObjChangeImpact.Description);
curnt_value = Convert.ToString(Editorimpact.Text);
ObjChangeHistoryDiff.Historyid = historyid;
ObjChangeHistoryDiff.Columnname = "Description";
ObjChangeHistoryDiff.Current_value = curnt_value;
ObjChangeHistoryDiff.Prev_value = prev_value;
ObjChangeHistoryDiff.Insert();
#endregion
ObjChangeImpact.Changeid = changeid;
ObjChangeImpact.Description = Editorimpact.Text.ToString();
ObjChangeImpact.Update();
ShowImpactPlaceholder();
btnupdateImpact.Visible = false;
btncancellImpact.Visible = false;
btncancellImpact.Visible = false;
Editorimpact.Visible = false;
lnimpedit.Visible = true;
lnkimpadd.Visible = false;
ShowImpactPlaceholder();
ShowBackOutPlanPlaceholder();
ShowRollOutPlanPlaceholder();
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void btnupdateImpact_Click(object sender, EventArgs e)
{
string prev_value;
string curnt_value;
int historyid;
int changeid = Convert.ToInt16(Request.QueryString[0]);
#region For updating values in Problem history table
ObjChangeHistory.Changeid = changeid;
MembershipUser User = Membership.GetUser();
string username = User.UserName.ToString();
Objorganization = Objorganization.Get_Organization();
int userid = ObjUser.Get_By_UserName(username, Objorganization.Orgid);
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "ImpactUpdated";
ObjChangeHistory.Insert();
#endregion
#region Get the Current historyid by calling function Get_Current_ProblemHistoryid()
historyid = ObjChangeHistory.Get_Current_ChangeHistoryid();
#endregion
#region Find Current value of Problem aBy Calling ObjProblem = ObjProblem.Get_By_id(problemid);
ObjChange = ObjChange.Get_By_id(changeid);
#endregion
#region Find the value of current symptom
ObjChangeImpact = ObjChangeImpact.Get_By_id(ObjChange.Changeid);
#endregion
#region Insert the values in history difference table
prev_value = Convert.ToString(ObjChangeImpact.Description);
curnt_value = Convert.ToString(Editorimpact.Text);
ObjChangeHistoryDiff.Historyid = historyid;
ObjChangeHistoryDiff.Columnname = "Description";
ObjChangeHistoryDiff.Current_value = curnt_value;
ObjChangeHistoryDiff.Prev_value = prev_value;
ObjChangeHistoryDiff.Insert();
#endregion
ObjChangeImpact.Changeid = changeid;
ObjChangeImpact.Description = Editorimpact.Text.ToString();
ObjChangeImpact.Update();
ShowImpactPlaceholder();
btnupdateImpact.Visible = false;
btncancellImpact.Visible = false;
btncancellImpact.Visible = false;
Editorimpact.Visible = false;
lnimpedit.Visible = true;
lnkimpadd.Visible = false;
ShowImpactPlaceholder();
ShowBackOutPlanPlaceholder();
ShowRollOutPlanPlaceholder();
}
public int Insert_ChangeImpact_mst(ChangeImpact ObjChangeImpact)
{
return (int)ExecuteNonQuery(Sp_ChangeImpact_Insert, new object[] { ObjChangeImpact.Changeid, ObjChangeImpact.Description });
}
public int Update_ChangeImpact_By_id(ChangeImpact ObjChangeImpact)
{
return (int)ExecuteNonQuery(Sp_ChangeImpact_Update, new object[] { ObjChangeImpact.Changeid, ObjChangeImpact.Description });
}
public object GenerateChangeImpact_mstObject(ref IDataReader returnData)
{
ChangeImpact obj = new ChangeImpact();
while (returnData.Read())
{
obj.Changeid = (int)returnData["Changeid"];
obj.Impactid = (int)returnData["Impactid"];
if (returnData["Description"] != DBNull.Value)
{
obj.Description = (string)returnData["Description"];
}
}
returnData.Close();
returnData.Dispose();
return obj;
}
