protected void FindProblemToChangeAttach()
{
int incidentid = Convert.ToInt32(Session["incidentid"].ToString());
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
// Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
// If deleteChkBxItem is Checked then ,mapped Current site to this user
int chanid;
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
chanid = Convert.ToInt32(gvIDs);
// Check if gvIDs is not null
if (gvIDs != "")
{
ObjincidentToChange = ObjincidentToChange.Get_By_id(incidentid, chanid);
if (ObjincidentToChange.Changeid != 0)
{
deleteChkBxItem.Checked = true;
}
}
}
}
protected void btnAttach_Click(object sender, EventArgs e)
{
int incidentid = Convert.ToInt16(Session["incident"].ToString());
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
// Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
// If deleteChkBxItem is Checked then ,mapped Current site to this user
if (deleteChkBxItem.Checked)
{
int chanid;
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
chanid = Convert.ToInt16(gvIDs);
// Check if gvIDs is not null
if (gvIDs != "")
{
ObjincidentToChange = ObjincidentToChange.Get_By_id(incidentid, chanid);
if (ObjincidentToChange.Changeid == 0)
{
ObjincidentToChange.Changeid = chanid;
ObjincidentToChange.Incidentid = incidentid;
ObjincidentToChange.Insert();
}
}
}
}
lblErrorMsg.Text = "Change is Attached to Current Problems";
}
protected void btnAttach_Click(object sender, EventArgs e)
{
int incidentid = Convert.ToInt16(Session["incident"].ToString());
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
// Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
// If deleteChkBxItem is Checked then ,mapped Current site to this user
if (deleteChkBxItem.Checked)
{
int chanid;
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
chanid = Convert.ToInt16(gvIDs);
// Check if gvIDs is not null
if (gvIDs != "")
{
ObjincidentToChange = ObjincidentToChange.Get_By_id(incidentid, chanid);
if (ObjincidentToChange.Changeid == 0)
{
ObjincidentToChange.Changeid = chanid;
ObjincidentToChange.Incidentid = incidentid;
ObjincidentToChange.Insert();
}
}
}
}
lblErrorMsg.Text = "Change is Attached to Current Problems";
}
protected void btnAttach_Click(object sender, EventArgs e)
{
//Add Exception handilng try catch change by vishal 21-05-2012
try
{
int incidentid = Convert.ToInt32(Session["incident"].ToString());
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
// Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
// If deleteChkBxItem is Checked then ,mapped Current site to this user
if (deleteChkBxItem.Checked)
{
int chanid;
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
chanid = Convert.ToInt32(gvIDs);
// Check if gvIDs is not null
if (gvIDs != "")
{
ObjincidentToChange = ObjincidentToChange.Get_By_id(incidentid, chanid);
if (ObjincidentToChange.Changeid == 0)
{
ObjincidentToChange.Changeid = chanid;
ObjincidentToChange.Incidentid = incidentid;
ObjincidentToChange.Insert();
}
}
}
}
lblErrorMsg.Text = "Change is Attached to Current Problems";
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void btnAttach_Click(object sender, EventArgs e)
{//Add Exception handilng try catch change by vishal 21-05-2012
try
{
int incidentid = Convert.ToInt32(Session["incident"].ToString());
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
// Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
// If deleteChkBxItem is Checked then ,mapped Current site to this user
if (deleteChkBxItem.Checked)
{
int chanid;
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
chanid = Convert.ToInt32(gvIDs);
// Check if gvIDs is not null
if (gvIDs != "")
{
ObjincidentToChange = ObjincidentToChange.Get_By_id(incidentid, chanid);
if (ObjincidentToChange.Changeid == 0)
{
ObjincidentToChange.Changeid = chanid;
ObjincidentToChange.Incidentid = incidentid;
ObjincidentToChange.Insert();
}
}
}
}
lblErrorMsg.Text = "Change is Attached to Current Problems";
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
/////Add Exception handilng try catch change by vishal 21-05-2012
try
{
//added by lalit on 14 march
int currentstatus = Convert.ToInt32(ViewState["currentstatus"]);
//////////////////////////////////////////change done by meenakshi 3rd october 2012
if (Session["CMDBUpdate"] == "true")
{
currentstatus = 14;
}
//////////////////////////////////////////end
string strStatusResolved = Resources.MessageResource.strStatusResolved.ToString();
int statusidOnresolved = objStatus.Get_By_StatusName(strStatusResolved);
string statusClose = Resources.MessageResource.strStatusClose.ToString();
if (currentstatus != statusidOnresolved)
{
int statusidClose = objStatus.Get_By_StatusName(statusClose);
if ((Convert.ToInt32(drpStatus.SelectedValue) == statusidClose))
{
Lblstatusupdatemsg.Text = "You can not close this call. This call is not resolved yet.";
return;
}
}
//end
Incident_To_Change Objincidenttochange = new Incident_To_Change();
Objincidenttochange = Objincidenttochange.Get_By_Incidentid(Convert.ToInt32(Request.QueryString[0]));
/////////////////////////////////////////////////change done by meenakshi 3rd oct
//if (Objincidenttochange.Incidentid != 0 )
//////////////////////////////////////////////////end
if (Objincidenttochange.Incidentid != 0 && Session["CMDBUpdate"] != "true")
{
string statusOnClose = Resources.MessageResource.strStatusClose.ToString();
int statusidOnClose = objStatus.Get_By_StatusName(statusOnClose);
if (Convert.ToInt32(drpStatus.SelectedValue) == statusidOnClose)
{
Session["drpStatus.SelectedValue"] = drpStatus.SelectedValue;
Session["drpMode.SelectedValue"] = drpMode.SelectedValue;
Session["drpCategory.SelectedValue"] = drpCategory.SelectedValue;
Session["drpSubcategory.SelectedValue"] = drpSubcategory.SelectedValue;
Session["Incidentidforchange"] = Convert.ToInt32(Request.QueryString[0]);
ScriptManager.RegisterStartupScript(this, this.GetType(), "window.open('../CMDB/UpdateCMDB.aspx','popupwindow','width=650,height=400,left=380,top=230,Scrollbars=yes')", "window.open('../CMDB/UpdateCMDB.aspx','popupwindow','width=650,height=400,left=380,top=230,Scrollbars=yes');", true);
string myScript;
myScript = "<script language=javascript>javascript:window.open('../CMDB/UpdateCMDB.aspx','popupwindow','width=650,height=400,left=380,top=230,Scrollbars=yes');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
}
else
{
FunctionUpdate();
}
}
else { FunctionUpdate(); }
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void lnkNewchange_Click(object sender, EventArgs e)
{
/////Add Exception handilng try catch change by vishal 21-05-2012
try
{
Incident_To_Change Objincidenttochange = new Incident_To_Change();
Objincidenttochange = Objincidenttochange.Get_By_Incidentid(Convert.ToInt32(Request.QueryString[0]));
if (Objincidenttochange.Incidentid == 0)
{
Session["incidentid"] = Convert.ToInt32(Request.QueryString[0]);
string myScript;
Session["RequestFromProblem"] = "True";
myScript = "<script language=javascript>javascript:window.open('../Change/CreateChangefromIncident.aspx','popupwindow2','width=950,height=640,left=200,top=250,Scrollbars=yes');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
}
else
{
string myScript;
Session["RequestFromProblem"] = "True";
myScript = "<script language=javascript>javascript:alert('Change request is already opened for this ticket');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
}
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void FindProblemToChangeAttach()
{
int incidentid = Convert.ToInt32(Session["incidentid"].ToString());
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
// Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
// If deleteChkBxItem is Checked then ,mapped Current site to this user
int chanid;
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
chanid = Convert.ToInt32(gvIDs);
// Check if gvIDs is not null
if (gvIDs != "")
{
ObjincidentToChange = ObjincidentToChange.Get_By_id(incidentid, chanid);
if (ObjincidentToChange.Changeid != 0)
{
deleteChkBxItem.Checked = true;
}
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Incident_To_Change Objincidenttochange = new Incident_To_Change();
Objincidenttochange = Objincidenttochange.Get_By_Incidentid(Convert.ToInt16(Request.QueryString[0]));
if (Objincidenttochange.Incidentid != 0)
{
string statusOnClose = Resources.MessageResource.strStatusClose.ToString();
int statusidOnClose = objStatus.Get_By_StatusName(statusOnClose);
if (Convert.ToInt16(drpStatus.SelectedValue) == statusidOnClose)
{
Session["drpStatus.SelectedValue"] = drpStatus.SelectedValue;
Session["drpMode.SelectedValue"] = drpMode.SelectedValue;
Session["drpCategory.SelectedValue"] = drpCategory.SelectedValue;
Session["drpSubcategory.SelectedValue"] = drpSubcategory.SelectedValue;
Session["Incidentidforchange"] = Convert.ToInt16(Request.QueryString[0]);
ScriptManager.RegisterStartupScript(this, this.GetType(), "window.open('../CMDB/UpdateCMDB.aspx','popupwindow','width=650,height=400,left=380,top=230,Scrollbars=yes')", "window.open('../CMDB/UpdateCMDB.aspx','popupwindow','width=650,height=400,left=380,top=230,Scrollbars=yes');", true);
string myScript;
myScript = "<script language=javascript>javascript:window.open('../CMDB/UpdateCMDB.aspx','popupwindow','width=650,height=400,left=380,top=230,Scrollbars=yes');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
}
else
{
FunctionUpdate();
}
}
else { FunctionUpdate(); }
}
protected void btnupdate_Click(object sender, EventArgs e)
{
TextBox txtp1 = (TextBox)PlaceHolderParams.FindControl("txtparam1Id");
TextBox txtp2 = (TextBox)PlaceHolderParams.FindControl("txtparam2Id");
TextBox txtp3 = (TextBox)PlaceHolderParams.FindControl("txtparam3Id");
TextBox txtp4 = (TextBox)PlaceHolderParams.FindControl("txtparam4Id");
TextBox txtp5 = (TextBox)PlaceHolderParams.FindControl("txtparam5Id");
TextBox txtp6 = (TextBox)PlaceHolderParams.FindControl("txtparam6Id");
TextBox txtp7 = (TextBox)PlaceHolderParams.FindControl("txtparam7Id");
TextBox txtp8 = (TextBox)PlaceHolderParams.FindControl("txtparam8Id");
TextBox txtp9 = (TextBox)PlaceHolderParams.FindControl("txtparam9Id");
TextBox txtp10 = (TextBox)PlaceHolderParams.FindControl("txtparam10Id");
int Incidentidforchange = Convert.ToInt16(Session["Incidentidforchange"]);
ObjIncidentochange = ObjIncidentochange.Get_By_Incidentid(Incidentidforchange);
int changeid = Convert.ToInt16(ObjIncidentochange.Changeid);
Objincludeasset = Objincludeasset.Get_By_Changeid(changeid);
int Assetid = Convert.ToInt16(Objincludeasset.Assetid);
ObjConfiguration = ObjConfiguration.Get_By_id(Assetid);
int itemid = Convert.ToInt16(ObjConfiguration.Itemid);
ObjConfigurableitem = ObjConfigurableitem.Get_By_id(itemid);
ObjCMDB = ObjCMDB.Get_By_id(Assetid);
//ObjCMDB.Assetid = ObjConfiguration.Assetid;
CMDB objcmdb = new CMDB();
objcmdb.Assetid = ObjConfiguration.Assetid;
if (ObjConfigurableitem.Param1 != "")
{
if (txtp1.Text == ObjCMDB.Param1)
{
objcmdb.Param1 = txtp1.Text.ToString();
}
else
{
objcmdb.Param1 = txtp1.Text.ToString();
Objcmdbtrans.Currentvalue = txtp1.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param1;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param1;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param1 = ObjCMDB.Param1;
}
if (ObjConfigurableitem.Param2 != "")
{
if (txtp2.Text == ObjCMDB.Param2)
{
objcmdb.Param2 = txtp2.Text.ToString();
}
else
{
objcmdb.Param2 = txtp2.Text.ToString();
Objcmdbtrans.Currentvalue = txtp2.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param2;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param2;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param2 = ObjCMDB.Param2;
}
if (ObjConfigurableitem.Param3 != "")
{
if (txtp3.Text == ObjCMDB.Param3)
{
objcmdb.Param3 = txtp3.Text.ToString();
}
else
{
objcmdb.Param3 = txtp3.Text.ToString();
Objcmdbtrans.Currentvalue = txtp3.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param3;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param3;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param3 = ObjCMDB.Param3;
}
if (ObjConfigurableitem.Param4 != "")
{
if (txtp4.Text == ObjCMDB.Param4)
{
objcmdb.Param4 = txtp4.Text.ToString();
}
else
{
objcmdb.Param4 = txtp4.Text.ToString();
Objcmdbtrans.Currentvalue = txtp4.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param4;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param4;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param4 = ObjCMDB.Param4;
}
if (ObjConfigurableitem.Param5 != "")
{
if (txtp5.Text == ObjCMDB.Param5)
{
objcmdb.Param5 = txtp5.Text.ToString();
}
else
{
objcmdb.Param5 = txtp5.Text.ToString();
Objcmdbtrans.Currentvalue = txtp5.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param5;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param5;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param5 = ObjCMDB.Param5;
}
if (ObjConfigurableitem.Param6 != "")
{
if (txtp6.Text == ObjCMDB.Param6)
{
objcmdb.Param6 = txtp6.Text.ToString();
}
else
{
objcmdb.Param6 = txtp6.Text.ToString();
Objcmdbtrans.Currentvalue = txtp6.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param6;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param6;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param6 = ObjCMDB.Param6;
}
if (ObjConfigurableitem.Param7 != "")
{
if (txtp7.Text == ObjCMDB.Param7)
{
objcmdb.Param7 = txtp7.Text.ToString();
}
else
{
objcmdb.Param7 = txtp7.Text.ToString();
Objcmdbtrans.Currentvalue = txtp7.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param7;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param7;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param7 = ObjCMDB.Param7;
}
if (ObjConfigurableitem.Param8 != "")
{
if (txtp8.Text == ObjCMDB.Param8)
{
objcmdb.Param8 = txtp8.Text.ToString();
}
else
{
objcmdb.Param8 = txtp8.Text.ToString();
Objcmdbtrans.Currentvalue = txtp8.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param8;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param8;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param8 = ObjCMDB.Param8;
}
if (ObjConfigurableitem.Param9 != "")
{
if (txtp8.Text == ObjCMDB.Param9)
{
objcmdb.Param9 = txtp9.Text.ToString();
}
else
{
objcmdb.Param9 = txtp9.Text.ToString();
Objcmdbtrans.Currentvalue = txtp9.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param9;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param9;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param9 = ObjCMDB.Param9;
}
if (ObjConfigurableitem.Param10 != "")
{
if (txtp10.Text == ObjCMDB.Param10)
{
objcmdb.Param10 = txtp10.Text.ToString();
}
else
{
objcmdb.Param10 = txtp10.Text.ToString();
Objcmdbtrans.Currentvalue = txtp10.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param10;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param10;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param10 = ObjCMDB.Param10;
}
objcmdb.Update();
Configuration_mst obj = new Configuration_mst();
obj.Assetid = ObjConfiguration.Assetid;
obj.Vendorid = ObjConfiguration.Vendorid;
obj.Itemid = ObjConfiguration.Itemid;
obj.Serialno = ObjConfiguration.Serialno;
int versionno = ObjConfiguration.Version;
versionno = versionno + 1;
obj.Version = versionno;
obj.Siteid = ObjConfiguration.Siteid;
obj.Severity = ObjConfiguration.Severity;
obj.Purchasedate = ObjConfiguration.Purchasedate;
obj.Update();
Session["CMDBUpdate"] = "true";
string myScript;
//myScript = "<script language=javascript>javascript:window.close();</script>";
ScriptManager.RegisterStartupScript(this, this.GetType(), "refreshParent();", "refreshParent();", true);
// Page.RegisterClientScriptBlock("MyScript", myScript);
}
public int Update_Incident_To_Change_By_id(Incident_To_Change objIncident_To_Change)
{
return (int)ExecuteNonQuery(Sp_Incident_To_Change_Update, new object[] { objIncident_To_Change.Changeid, objIncident_To_Change.Incidentid });
}
public int Insert_Incident_To_Change(Incident_To_Change objIncident_To_Change)
{
return (int)ExecuteNonQuery(Sp_Incident_To_Change_Insert, new object[] { objIncident_To_Change.Changeid, objIncident_To_Change.Incidentid });
}
public object GenerateIncidet_to_change_incidentid_mstObject(ref IDataReader returnData)
{
Incident_To_Change Obj = new Incident_To_Change();
while (returnData.Read())
{
Obj.Changeid = (int)returnData["Changeid"];
Obj.Incidentid = (int)returnData["Incidentid"];
}
returnData.Close();
returnData.Dispose();
return Obj;
}
public CollectionBase GenerateIncident_To_Change_mstCollection(ref IDataReader returnData)
{
BLLCollection<Incident_To_Change> col = new BLLCollection<Incident_To_Change>();
while (returnData.Read())
{
Incident_To_Change obj = new Incident_To_Change();
obj.Incidentid = (int)returnData["Incidentid"];
obj.Changeid = (int)returnData["Changeid"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
protected void showCMDBValues()
{
panalupdatecmdb.Visible = true;
int Incidentidforchange = Convert.ToInt32(Session["Incidentidforchange"]);
ObjIncidentochange = ObjIncidentochange.Get_By_Incidentid(Incidentidforchange);
int changeid = Convert.ToInt32(ObjIncidentochange.Changeid);
Objincludeasset = Objincludeasset.Get_By_Changeid(changeid);
int Assetid = Convert.ToInt32(Objincludeasset.Assetid);
ObjConfiguration = ObjConfiguration.Get_By_id(Assetid);
int itemid = Convert.ToInt32(ObjConfiguration.Itemid);
ObjConfigurableitem = ObjConfigurableitem.Get_By_id(itemid);
ObjCMDB = ObjCMDB.Get_By_id(Assetid);
Objchange = Objchange.Get_By_id(changeid);
int categoryid = Convert.ToInt32(Objchange.Categoryid);
Objcategory = Objcategory.Get_By_id(categoryid);
if (categoryid != 0)
{
lblcategory.Text = Objcategory.CategoryName.ToString();
}
int Subcategoryid = Convert.ToInt32(Objchange.Subcategoryid);
Objsubcategory = Objsubcategory.Get_By_id(Subcategoryid);
if (Subcategoryid != 0)
{
lblsubcategory.Text = Objsubcategory.Subcategoryname.ToString();
}
lblassetid.Text = ObjConfiguration.Assetid.ToString();
int itemid1 = Convert.ToInt32(ObjConfiguration.Itemid);
Objcategory = Objcategory.Get_By_id(itemid1);
lblitemname.Text = Objcategory.CategoryName.ToString();
Objvendor = Objvendor.Get_By_id(ObjConfiguration.Vendorid);
lblvendor.Text = Objvendor.Vendorname.ToString();
lblchangeid.Text = Objchange.Changeid.ToString();
lblserialno.Text = ObjConfiguration.Serialno.ToString();
int changetypid = Convert.ToInt32(Objchange.Changetype);
Objchangetype = Objchangetype.Get_By_id(changetypid);
lblchangetype.Text = Objchangetype.Changetypename.ToString();
lbltitle.Text = Objchange.Title.ToString();
if (ObjConfigurableitem.Param1 != "")
{
txtparam1.Visible = true;
lblparam1.Text = ObjConfigurableitem.Param1.ToString();
txtparam1.Text = ObjCMDB.Param1.ToString();
}
if (ObjConfigurableitem.Param2 != "")
{
txtparam2.Visible = true;
lblparam2.Text = ObjConfigurableitem.Param2.ToString();
txtparam2.Text = ObjCMDB.Param2.ToString();
}
if (ObjConfigurableitem.Param3 != "")
{
txtparam3.Visible = true;
lblparam3.Text = ObjConfigurableitem.Param3.ToString();
txtparam3.Text = ObjCMDB.Param3.ToString();
}
if (ObjConfigurableitem.Param4 != "")
{
txtparam4.Visible = true;
lblparam4.Text = ObjConfigurableitem.Param4.ToString();
txtparam4.Text = ObjCMDB.Param4.ToString();
}
if (ObjConfigurableitem.Param5 != "")
{
txtparam5.Visible = true;
lblparam5.Text = ObjConfigurableitem.Param5.ToString();
txtparam5.Text = ObjCMDB.Param5.ToString();
}
if (ObjConfigurableitem.Param6 != "")
{
txtparam6.Visible = true;
lblparam6.Text = ObjConfigurableitem.Param6.ToString();
txtparam6.Text = ObjCMDB.Param6.ToString();
}
if (ObjConfigurableitem.Param7 != "")
{
txtparam7.Visible = true;
lblparam7.Text = ObjConfigurableitem.Param7.ToString();
txtparam7.Text = ObjCMDB.Param7.ToString();
}
if (ObjConfigurableitem.Param8 != "")
{
txtparam8.Visible = true;
lblparam8.Text = ObjConfigurableitem.Param8.ToString();
txtparam8.Text = ObjCMDB.Param8.ToString();
}
if (ObjConfigurableitem.Param9 != "")
{
txtparam9.Visible = true;
lblparam9.Text = ObjConfigurableitem.Param9.ToString();
txtparam9.Text = ObjCMDB.Param9.ToString();
}
if (ObjConfigurableitem.Param10 != "")
{
txtparam10.Visible = true;
lblparam10.Text = ObjConfigurableitem.Param10.ToString();
txtparam10.Text = ObjCMDB.Param10.ToString();
}
}
protected void btnupdate_Click(object sender, EventArgs e)
{///Add Exception handilng try catch change by vishal 21-05-2012
try
{
TextBox txtp1 = (TextBox)PlaceHolderParams.FindControl("txtparam1Id");
TextBox txtp2 = (TextBox)PlaceHolderParams.FindControl("txtparam2Id");
TextBox txtp3 = (TextBox)PlaceHolderParams.FindControl("txtparam3Id");
TextBox txtp4 = (TextBox)PlaceHolderParams.FindControl("txtparam4Id");
TextBox txtp5 = (TextBox)PlaceHolderParams.FindControl("txtparam5Id");
TextBox txtp6 = (TextBox)PlaceHolderParams.FindControl("txtparam6Id");
TextBox txtp7 = (TextBox)PlaceHolderParams.FindControl("txtparam7Id");
TextBox txtp8 = (TextBox)PlaceHolderParams.FindControl("txtparam8Id");
TextBox txtp9 = (TextBox)PlaceHolderParams.FindControl("txtparam9Id");
TextBox txtp10 = (TextBox)PlaceHolderParams.FindControl("txtparam10Id");
int Incidentidforchange = Convert.ToInt32(Session["Incidentidforchange"]);
ObjIncidentochange = ObjIncidentochange.Get_By_Incidentid(Incidentidforchange);
int changeid = Convert.ToInt32(ObjIncidentochange.Changeid);
Objincludeasset = Objincludeasset.Get_By_Changeid(changeid);
int Assetid = Convert.ToInt32(Objincludeasset.Assetid);
ObjConfiguration = ObjConfiguration.Get_By_id(Assetid);
int itemid = Convert.ToInt32(ObjConfiguration.Itemid);
ObjConfigurableitem = ObjConfigurableitem.Get_By_id(itemid);
ObjCMDB = ObjCMDB.Get_By_id(Assetid);
//ObjCMDB.Assetid = ObjConfiguration.Assetid;
CMDB objcmdb = new CMDB();
objcmdb.Assetid = ObjConfiguration.Assetid;
if (ObjConfigurableitem.Param1 != "")
{
if (txtp1.Text == ObjCMDB.Param1)
{
objcmdb.Param1 = txtp1.Text.ToString();
}
else
{
objcmdb.Param1 = txtp1.Text.ToString();
Objcmdbtrans.Currentvalue = txtp1.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param1;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param1;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param1 = ObjCMDB.Param1;
}
if (ObjConfigurableitem.Param2 != "")
{
if (txtp2.Text == ObjCMDB.Param2)
{
objcmdb.Param2 = txtp2.Text.ToString();
}
else
{
objcmdb.Param2 = txtp2.Text.ToString();
Objcmdbtrans.Currentvalue = txtp2.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param2;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param2;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param2 = ObjCMDB.Param2;
}
if (ObjConfigurableitem.Param3 != "")
{
if (txtp3.Text == ObjCMDB.Param3)
{
objcmdb.Param3 = txtp3.Text.ToString();
}
else
{
objcmdb.Param3 = txtp3.Text.ToString();
Objcmdbtrans.Currentvalue = txtp3.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param3;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param3;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param3 = ObjCMDB.Param3;
}
if (ObjConfigurableitem.Param4 != "")
{
if (txtp4.Text == ObjCMDB.Param4)
{
objcmdb.Param4 = txtp4.Text.ToString();
}
else
{
objcmdb.Param4 = txtp4.Text.ToString();
Objcmdbtrans.Currentvalue = txtp4.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param4;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param4;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param4 = ObjCMDB.Param4;
}
if (ObjConfigurableitem.Param5 != "")
{
if (txtp5.Text == ObjCMDB.Param5)
{
objcmdb.Param5 = txtp5.Text.ToString();
}
else
{
objcmdb.Param5 = txtp5.Text.ToString();
Objcmdbtrans.Currentvalue = txtp5.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param5;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param5;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param5 = ObjCMDB.Param5;
}
if (ObjConfigurableitem.Param6 != "")
{
if (txtp6.Text == ObjCMDB.Param6)
{
objcmdb.Param6 = txtp6.Text.ToString();
}
else
{
objcmdb.Param6 = txtp6.Text.ToString();
Objcmdbtrans.Currentvalue = txtp6.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param6;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param6;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param6 = ObjCMDB.Param6;
}
if (ObjConfigurableitem.Param7 != "")
{
if (txtp7.Text == ObjCMDB.Param7)
{
objcmdb.Param7 = txtp7.Text.ToString();
}
else
{
objcmdb.Param7 = txtp7.Text.ToString();
Objcmdbtrans.Currentvalue = txtp7.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param7;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param7;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param7 = ObjCMDB.Param7;
}
if (ObjConfigurableitem.Param8 != "")
{
if (txtp8.Text == ObjCMDB.Param8)
{
objcmdb.Param8 = txtp8.Text.ToString();
}
else
{
objcmdb.Param8 = txtp8.Text.ToString();
Objcmdbtrans.Currentvalue = txtp8.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param8;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param8;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param8 = ObjCMDB.Param8;
}
if (ObjConfigurableitem.Param9 != "")
{
if (txtp8.Text == ObjCMDB.Param9)
{
objcmdb.Param9 = txtp9.Text.ToString();
}
else
{
objcmdb.Param9 = txtp9.Text.ToString();
Objcmdbtrans.Currentvalue = txtp9.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param9;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param9;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param9 = ObjCMDB.Param9;
}
if (ObjConfigurableitem.Param10 != "")
{
if (txtp10.Text == ObjCMDB.Param10)
{
objcmdb.Param10 = txtp10.Text.ToString();
}
else
{
objcmdb.Param10 = txtp10.Text.ToString();
Objcmdbtrans.Currentvalue = txtp10.Text.ToString();
Objcmdbtrans.Previousvalue = ObjCMDB.Param10;
Objcmdbtrans.Assetid = ObjConfiguration.Assetid;
Objcmdbtrans.Parametername = ObjConfigurableitem.Param10;
Objcmdbtrans.Insert();
}
}
else
{
objcmdb.Param10 = ObjCMDB.Param10;
}
objcmdb.Update();
Configuration_mst obj = new Configuration_mst();
obj.Assetid = ObjConfiguration.Assetid;
obj.Vendorid = ObjConfiguration.Vendorid;
obj.Itemid = ObjConfiguration.Itemid;
obj.Serialno = ObjConfiguration.Serialno;
int versionno = ObjConfiguration.Version;
versionno = versionno + 1;
obj.Version = versionno;
obj.Siteid = ObjConfiguration.Siteid;
obj.Severity = ObjConfiguration.Severity;
obj.Purchasedate = ObjConfiguration.Purchasedate;
obj.Update();
Session["CMDBUpdate"] = "true";
string myScript;
//myScript = "<script language=javascript>javascript:window.close();</script>";
ScriptManager.RegisterStartupScript(this, this.GetType(), "refreshParent();", "refreshParent();", true);
// Page.RegisterClientScriptBlock("MyScript", myScript);
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void showCMDBValues()
{
panalupdatecmdb.Visible = true;
int Incidentidforchange = Convert.ToInt16(Session["Incidentidforchange"]);
ObjIncidentochange = ObjIncidentochange.Get_By_Incidentid(Incidentidforchange);
int changeid = Convert.ToInt16(ObjIncidentochange.Changeid);
Objincludeasset = Objincludeasset.Get_By_Changeid(changeid);
int Assetid = Convert.ToInt16(Objincludeasset.Assetid);
ObjConfiguration = ObjConfiguration.Get_By_id(Assetid);
int itemid = Convert.ToInt16(ObjConfiguration.Itemid);
ObjConfigurableitem = ObjConfigurableitem.Get_By_id(itemid);
ObjCMDB = ObjCMDB.Get_By_id(Assetid);
Objchange = Objchange.Get_By_id(changeid);
int categoryid = Convert.ToInt16(Objchange.Categoryid);
Objcategory = Objcategory.Get_By_id(categoryid);
if (categoryid != 0)
{
lblcategory.Text = Objcategory.CategoryName.ToString();
}
int Subcategoryid = Convert.ToInt16(Objchange.Subcategoryid);
Objsubcategory = Objsubcategory.Get_By_id(Subcategoryid);
if (Subcategoryid != 0)
{
lblsubcategory.Text = Objsubcategory.Subcategoryname.ToString();
}
lblassetid.Text = ObjConfiguration.Assetid.ToString();
int itemid1=Convert.ToInt16(ObjConfiguration.Itemid);
Objcategory = Objcategory.Get_By_id(itemid1);
lblitemname.Text = Objcategory.CategoryName.ToString();
Objvendor = Objvendor.Get_By_id(ObjConfiguration.Vendorid);
lblvendor.Text = Objvendor.Vendorname.ToString();
lblchangeid.Text = Objchange.Changeid.ToString();
lblserialno.Text = ObjConfiguration.Serialno.ToString();
int changetypid=Convert.ToInt16(Objchange.Changetype);
Objchangetype = Objchangetype.Get_By_id(changetypid);
lblchangetype.Text = Objchangetype.Changetypename.ToString();
lbltitle.Text = Objchange.Title.ToString();
if (ObjConfigurableitem.Param1 != "")
{
txtparam1.Visible = true;
lblparam1.Text = ObjConfigurableitem.Param1.ToString();
txtparam1.Text = ObjCMDB.Param1.ToString();
}
if (ObjConfigurableitem.Param2 != "")
{
txtparam2.Visible = true;
lblparam2.Text = ObjConfigurableitem.Param2.ToString();
txtparam2.Text = ObjCMDB.Param2.ToString();
}
if (ObjConfigurableitem.Param3 != "")
{
txtparam3.Visible = true;
lblparam3.Text = ObjConfigurableitem.Param3.ToString();
txtparam3.Text = ObjCMDB.Param3.ToString();
}
if (ObjConfigurableitem.Param4 != "")
{
txtparam4.Visible = true;
lblparam4.Text = ObjConfigurableitem.Param4.ToString();
txtparam4.Text = ObjCMDB.Param4.ToString();
}
if (ObjConfigurableitem.Param5 != "")
{
txtparam5.Visible = true;
lblparam5.Text = ObjConfigurableitem.Param5.ToString();
txtparam5.Text = ObjCMDB.Param5.ToString();
}
if (ObjConfigurableitem.Param6 != "")
{
txtparam6.Visible = true;
lblparam6.Text = ObjConfigurableitem.Param6.ToString();
txtparam6.Text = ObjCMDB.Param6.ToString();
}
if (ObjConfigurableitem.Param7 != "")
{
txtparam7.Visible = true;
lblparam7.Text = ObjConfigurableitem.Param7.ToString();
txtparam7.Text = ObjCMDB.Param7.ToString();
}
if (ObjConfigurableitem.Param8 != "")
{
txtparam8.Visible = true;
lblparam8.Text = ObjConfigurableitem.Param8.ToString();
txtparam8.Text = ObjCMDB.Param8.ToString();
}
if (ObjConfigurableitem.Param9 != "")
{
txtparam9.Visible = true;
lblparam9.Text = ObjConfigurableitem.Param9.ToString();
txtparam9.Text = ObjCMDB.Param9.ToString();
}
if (ObjConfigurableitem.Param10 != "")
{
txtparam10.Visible = true;
lblparam10.Text = ObjConfigurableitem.Param10.ToString();
txtparam10.Text = ObjCMDB.Param10.ToString();
}
}
