//#region Handle Button btnAssigned Click Event
//protected void btnAssigned_Click(object sender, EventArgs e)
//{
// #region Fetch Each Row from GridView,and Check Which Check Box is Selected
// foreach (GridViewRow gv in grdvwChange.Rows)
// {
// string gvIDs;
// #region Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
// CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
// #endregion
// #region If deleteChkBxItem is Checked then ,mapped Current site to this user
// if (deleteChkBxItem.Checked)
// {
// #region Declare local Variables
// int Changeid;
// int varSiteid;
// int oldtechnicianvalue;
// #endregion
// #region Get the Problemid from variable of Label type declare in GridView of grdvwSite
// gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
// #endregion
// #region Convert to incident id into integer
// Changeid = Convert.ToInt16(gvIDs);
// #endregion
// #region If Incident id in Not Null
// if (gvIDs != "")
// {
// Change_mst Obj = new Change_mst();
// Obj = ObjChange.Get_By_id(Changeid);
// if (Obj.Changeid!= 0)
// {
// int technicianid = Convert.ToInt16(drpTechnician1.SelectedValue);
// if (technicianid != 0)
// {
// Obj.Technician= technicianid;
// Obj.Update();
// }
// }
// }
// #endregion
// }
// #endregion
// }
// BindGridForAllParameter();
// #endregion
//}
//#endregion
#region Handle Button btnCancell Click Event
protected void btnCancell_Click(object sender, EventArgs e)
{
#region Fetch Each Row from GridView,and Check Which Check Box is Selected
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
#region Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
#endregion
#region If deleteChkBxItem is Checked then ,mapped Current site to this user
if (deleteChkBxItem.Checked)
{
#region Declare local Variables
int Changeid;
int varSiteid;
int oldtechnicianvalue;
#endregion
#region Get the Problemid from variable of Label type declare in GridView of grdvwSite
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
#endregion
#region Convert to incident id into integer
Changeid = Convert.ToInt16(gvIDs);
#endregion
#region If Incident id in Not Null
if (gvIDs != "")
{
Change_mst Obj = new Change_mst();
Obj = ObjChange.Get_By_id(Changeid);
if (Obj.Changeid != 0)
{
Obj.Active = false;
Obj.Update();
}
}
#endregion
}
#endregion
}
BindGridForAllParameter();
#endregion
}
public void SentMailToChangeCommittee(int changeid, int changetypeid)
{
string strYourSinscerely = Resources.MessageResource.strYourSinscerely.ToString();
string strContactNumber = Resources.MessageResource.strContactNumber.ToString();
Cab_mst Objcabmember = new Cab_mst();
ObjChange = ObjChange.Get_By_id(changeid);
BLLCollection <Cab_mst> colmembers = new BLLCollection <Cab_mst>();
UserLogin_mst objUserCreator = new UserLogin_mst();
int FlagUser;
int roleid;
string varServerName;
varServerName = Resources.MessageResource.serverNameForChangePage.ToString();
// varServerName = "10.80.0.15";
string url11;
url11 = "http://" + varServerName + "/BEST/LoginPageAccess/ApproveorRejectChangeRequest.aspx?changeid=" + changeid;
colmembers = Objcabmember.Get_All_By_ChangeTypeid(changetypeid);
string url;
foreach (Cab_mst objmember in colmembers)
{
url = "<a href=" + url11 + "&userid=" + objmember.Membername + " ' onclick=window.open()>Click Here For Approval</a>";
obj.From = Resources.MessageResource.strAdminEmail.ToString();
obj.To = objmember.Emailid;
obj.Subject = "New Change Added. Change Id : " + changeid;
obj.Body = "Dear Sir/Madam,<br/>A New Change has been requested.Please.<br/><br/><b>Solution Details : </b> <br/><br/><b>Changeid Id :</b>" + ObjChange.Changeid + "<br/><b>Title :</b>" + ObjChange.Title + " <br/><b>Added By :</b>" + ObjChange.CreatedByID + "<br/><b>Created Date   :</b>" + ObjChange.Createdtime + "<br/><b>Content :</b>" + ObjChange.Description + "<br/><br/>This is an auto generated mail. Please do not reply.</b><br/><br/></b><br/><b>Kindly Click the following link to Aprove or Reject the Change Request. <br></br>" + url + " <b><br/><br/><b>Yours sincerely,</b><br/> <b>" + strYourSinscerely + "</b>";
obj.SmtpServer = Resources.MessageResource.strSMTPServer.ToString();
obj.SentMail();
}
}
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
{
# region Declare Local Variable
string StrStatusRequested;
string StrStatusRejected;
string StrStatusApproval;
string StrStatusApproved;
string StrStatusPlanning;
string StrStatusTesting;
string StrStatusRelease;
string StrStatusImplemented;
string StrStatusCompleted;
string StrStatusString = "";
int userid = 0;
int changeid = Convert.ToInt32(Request.QueryString[0]);
string userName = "";
#endregion
#region Fetch the Status Value from Resource File
StrStatusString = GetChangeStatusString(Convert.ToInt32(drpStatus.SelectedValue));
StrStatusRejected = Resources.MessageResource.StrRejected.ToString();
StrStatusApproval = Resources.MessageResource.StrApproval.ToString();
StrStatusRequested = Resources.MessageResource.StrRequested.ToString();
StrStatusApproved = Resources.MessageResource.StrApproved.ToString();
StrStatusPlanning = Resources.MessageResource.StrPlanning.ToString();
StrStatusTesting = Resources.MessageResource.StrTesting.ToString();
StrStatusRelease = Resources.MessageResource.StrRelease.ToString();
StrStatusImplemented = Resources.MessageResource.StrImplemented.ToString();
StrStatusCompleted = Resources.MessageResource.StrCompleted.ToString();
#endregion
MembershipUser User = Membership.GetUser();
userName = User.UserName.ToString();
#region On the basis of Username ,get Userid by calling Function Get_UserLogin_By_UserName(),via passing parameter Username and organizationid
if (userName != "")
{
Objorganization = Objorganization.Get_Organization();
ObjUser = ObjUser.Get_UserLogin_By_UserName(userName, Objorganization.Orgid);
if (ObjUser.Userid != 0)
{
userid = ObjUser.Userid;
}
}
#endregion
#region Insert Historyvalue in Change History Table
int result = String.Compare(StrStatusString, StrStatusRequested, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Requested";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusRejected, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Rejected";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusApproval, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Approval";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusApproved, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Approved";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusPlanning, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Planning";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusTesting, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Testing";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusRelease, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Release";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusImplemented, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Implemented";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusCompleted, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Completed";
ObjChangeHistory.Insert();
}
#endregion
#region Get the Current historyid by calling function Get_Current_ProblemHistoryid()
int historyid = ObjChangeHistory.Get_Current_ChangeHistoryid();
#endregion
#region Find Current value of Problem aBy Calling Function Get_By_id(),via passing problemid
ObjChange = ObjChange.Get_By_id(changeid);
#endregion
#region Insert into ChangeHistoryDiff table ,By Comparing Current value and Updated Values
if (ObjChange.Changeid != 0)
{
#region Declare local variable
string columnName;
string prev_value;
string curnt_value;
#endregion
#region If Priority value is changed,Insert into ChangeHistoryDiff table
if (ObjChange.Priority != Convert.ToInt32(drpPriority.SelectedValue))
{
columnName = Resources.MessageResource.strColumnPriorityid.ToString();
prev_value = Convert.ToString(ObjChange.Priority);
curnt_value = Convert.ToString(drpPriority.SelectedValue);
ObjChangeHistoryDiff.Historyid = historyid;
ObjChangeHistoryDiff.Columnname = columnName;
ObjChangeHistoryDiff.Current_value = curnt_value;
ObjChangeHistoryDiff.Prev_value = prev_value;
ObjChangeHistoryDiff.Insert();
}
#endregion
#region If Technician value is changed,Insert into ChangeHistoryDiff table
if (ObjChange.Technician != Convert.ToInt32(drpTechnician.SelectedValue))
{
columnName = Resources.MessageResource.strColumnTechnicianid.ToString();
prev_value = Convert.ToString(ObjChange.Technician);
curnt_value = Convert.ToString(drpTechnician.SelectedValue);
ObjChangeHistoryDiff.Historyid = historyid;
ObjChangeHistoryDiff.Columnname = columnName;
ObjChangeHistoryDiff.Current_value = curnt_value;
ObjChangeHistoryDiff.Prev_value = prev_value;
ObjChangeHistoryDiff.Insert();
}
#endregion
#region If category value is changed,Insert into ChangeHistoryDiff table
if (ObjChange.Categoryid != Convert.ToInt32(drpCategory.SelectedValue))
{
columnName = Resources.MessageResource.strColumnCategoryid.ToString();
prev_value = Convert.ToString(ObjChange.Categoryid);
curnt_value = Convert.ToString(drpCategory.SelectedValue);
ObjChangeHistoryDiff.Historyid = historyid;
ObjChangeHistoryDiff.Columnname = columnName;
ObjChangeHistoryDiff.Current_value = curnt_value;
ObjChangeHistoryDiff.Prev_value = prev_value;
ObjChangeHistoryDiff.Insert();
}
#endregion
#region If Subcategory value is changed,Insert into ChangeHistoryDiff table
if (ObjChange.Subcategoryid != Convert.ToInt32(drpSubcategory.SelectedValue))
{
columnName = Resources.MessageResource.strColumnSubcategoryid.ToString();
prev_value = Convert.ToString(ObjChange.Subcategoryid);
curnt_value = Convert.ToString(drpSubcategory.SelectedValue);
ObjChangeHistoryDiff.Historyid = historyid;
ObjChangeHistoryDiff.Columnname = columnName;
ObjChangeHistoryDiff.Current_value = curnt_value;
ObjChangeHistoryDiff.Prev_value = prev_value;
ObjChangeHistoryDiff.Insert();
}
#endregion
#region If Changetype value is changed,Insert into ChangeHistoryDiff table
if (ObjChange.Changetype != Convert.ToInt32(drpchangetype.SelectedValue))
{
columnName = Resources.MessageResource.strColumnChangeType.ToString();
prev_value = Convert.ToString(ObjChange.Changetype);
curnt_value = Convert.ToString(drpchangetype.SelectedValue);
ObjChangeHistoryDiff.Historyid = historyid;
ObjChangeHistoryDiff.Columnname = columnName;
ObjChangeHistoryDiff.Current_value = curnt_value;
ObjChangeHistoryDiff.Prev_value = prev_value;
ObjChangeHistoryDiff.Insert();
}
#endregion
#region If Changestatus value is changed,Insert into ChangeHistoryDiff table
if (ObjChange.Changetype != Convert.ToInt32(drpStatus.SelectedValue))
{
columnName = Resources.MessageResource.strColumnstatusid.ToString();
prev_value = Convert.ToString(ObjChange.Statusid);
curnt_value = Convert.ToString(drpStatus.SelectedValue);
ObjChangeHistoryDiff.Historyid = historyid;
ObjChangeHistoryDiff.Columnname = columnName;
ObjChangeHistoryDiff.Current_value = curnt_value;
ObjChangeHistoryDiff.Prev_value = prev_value;
ObjChangeHistoryDiff.Insert();
}
#endregion
}
#endregion
#region Update the completed status
#endregion
#region update the data in change_mst table
ObjChange.Technician = Convert.ToInt32(drpTechnician.SelectedValue);
ObjChange.Categoryid = Convert.ToInt32(drpCategory.SelectedValue);
ObjChange.Subcategoryid = Convert.ToInt32(drpSubcategory.SelectedValue);
ObjChange.Priority = Convert.ToInt32(drpPriority.SelectedValue);
ObjChange.Changetype = Convert.ToInt32(drpchangetype.SelectedValue);
ObjChange.Statusid = Convert.ToInt32(drpStatus.SelectedValue);
ObjChange.Changeid = Convert.ToInt32(Request.QueryString[0]);
ObjChange.Active = true;
#region If Current status is closed,then Assign Completed time
result = String.Compare(StrStatusString, StrStatusCompleted, true);
if (result == 0)
{
BLLCollection<Incident_To_Change> colincidentchnage = new BLLCollection<Incident_To_Change>();
colincidentchnage = Objincidenttochange.Get_All_By_Changeid(changeid);
int id = 0;
foreach (Incident_To_Change objitoc in colincidentchnage)
{
id = Convert.ToInt32(objitoc.Incidentid);
}
IncidentStates objstate = new IncidentStates();
objstate = objstate.Get_By_id(id);
Status_mst objincidentstats = new Status_mst();
objincidentstats = objincidentstats.Get_By_id(objstate.Statusid);
string currentincidentstatus = objincidentstats.Statusname.ToString();
int comparestatus = String.Compare(currentincidentstatus, Resources.MessageResource.strStatusClose.ToString(), true);
if (comparestatus == 0)
{
ObjChange.Completedtime = DateTime.Now.ToString();
Change_mst Objcurrentchange = new Change_mst();
ChangeStatus_mst Objchangestatus = new ChangeStatus_mst();
Objcurrentchange = Objcurrentchange.Get_By_id(changeid);
Objchangestatus = Objchangestatus.Get_By_id(Objcurrentchange.Statusid);
string status = Objchangestatus.Statusname.ToString();
int result1 = String.Compare(status, StrStatusCompleted, true);
if (result1 == 0)
{
ObjChange.Completedtime = Objcurrentchange.Completedtime;
ObjChange.Update();
}
else
{
ObjChange.Completedtime = DateTime.Now.ToString();
ObjChange.Update();
}
}
else
{
string myScript;
//myScript = "<script language=javascript>javascript:alert('Please Close All the Attached Incident');</script>";
ScriptManager.RegisterStartupScript(this, this.GetType(), "Javascript:alert('Please Close Alll the attached incident');", "Javascript:alert('Please Close Alll the attached incident');", true);
///'''Page.RegisterClientScriptBlock("MyScript", myScript);
}
}
else
{
#endregion
ObjChange.Update();
}
#endregion
// #region Update Include Assets in Change value in IncludedAssetinchange
//objincludeasset.Delete(changeid);
//for (int i = lstassetupdate.Items.Count - 1; i >= 0; i--)
//{
// if (lstassetupdate.Items[i].Selected == true)
// {
// objincludeasset.Assetid = Convert.ToInt32(lstassetupdate.Items[i].Value);
// objincludeasset.Changeid = changeid;
// objincludeasset.Insert();
// }
//}
//#endregion
Showchangeinfo();
btnUpdate.Visible = false;
btnCancel.Visible = false;
}
protected void btnupdateRollOutPlan_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 = "RollOutPlanUpdated";
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 Function Get_By_id(),via passing problemid
ObjChange = ObjChange.Get_By_id(changeid);
#endregion
#region Find the value of current symptom
ObjChangeRollOutPlan = ObjChangeRollOutPlan.Get_By_id(ObjChange.Changeid);
#endregion
#region Insert the values in history difference table
prev_value = Convert.ToString(ObjChangeRollOutPlan.Description);
curnt_value = Convert.ToString(EditorRollOutPlan.Text);
ObjChangeHistoryDiff.Historyid = historyid;
ObjChangeHistoryDiff.Columnname = "Description";
ObjChangeHistoryDiff.Current_value = curnt_value;
ObjChangeHistoryDiff.Prev_value = prev_value;
ObjChangeHistoryDiff.Insert();
#endregion
ObjChangeRollOutPlan.Changeid = changeid;
ObjChangeRollOutPlan.Description = EditorRollOutPlan.Text.ToString();
ObjChangeRollOutPlan.Update();
ShowRollOutPlanPlaceholder();
btnupdateRollOutPlan.Visible = false;
btnsaveRollOutPlan.Visible = false;
btncancellRollOutPlan.Visible = false;
EditorRollOutPlan.Visible = false;
lnkRollOutPlanedit.Visible = true;
lnkRollOutPlanadd.Visible = false;
ShowImpactPlaceholder();
ShowBackOutPlanPlaceholder();
}
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();
}
}
protected void Showchangeinfo()
{
Approvalpanal.Visible = true;
btnApprove.Visible = true;
btnReject.Visible = true;
Alreadyapprovedpanal.Visible = false;
NameValueCollection n = Request.QueryString;
int changeid = Convert.ToInt32(Request.QueryString[0]);
//lblchangeid.Text = changeid.ToString();
ObjChange = ObjChange.Get_By_id(changeid);
lblchangeid.Text = ObjChange.Changeid.ToString();
lbltitle.Text = ObjChange.Title;
lbldescription.Text = ObjChange.Description;
//lblDateDisp.Text = ObjChange.Createdtime.ToString();
int requesterid = Convert.ToInt32(ObjChange.Requestedby);
//lblTitle.Text = ObjChange.Title.ToString();
//lblDescription.Text = ObjChange.Description.ToString();
lblserviceeffected.Text = "Email";
int chantypeid = Convert.ToInt32(ObjChange.Changetype);
ObjChangeType = ObjChangeType.Get_By_id(chantypeid);
if (chantypeid != 0)
{
lblchangetype.Text = ObjChangeType.Changetypename.ToString();
}
int changestatus = Convert.ToInt32(ObjChange.Statusid);
Objchangestatus = Objchangestatus.Get_By_id(changestatus);
if (changestatus != 0)
{
lblStatus.Text = Objchangestatus.Statusname;
}
int priorityid = Convert.ToInt32(ObjChange.Priority);
ObjPriority = ObjPriority.Get_By_id(priorityid);
if (priorityid != 0)
{
lblpriority.Text = ObjPriority.Name.ToString();
}
else
{
lblpriority.Text = "";
}
int category = Convert.ToInt32(ObjChange.Categoryid);
ObjCategory = ObjCategory.Get_By_id(category);
if (category != 0)
{
lblcategory.Text = ObjCategory.CategoryName.ToString();
}
else
{
lblcategory.Text = "";
}
int subcategory = Convert.ToInt32(ObjChange.Subcategoryid);
Objsubcategory = Objsubcategory.Get_By_id(subcategory);
if (subcategory != 0)
{
lblsubcategory.Text = Objsubcategory.Subcategoryname.ToString();
}
else
{
lblsubcategory.Text = "";
}
int creator = Convert.ToInt32(ObjChange.CreatedByID);
ObjUser = ObjUser.Get_By_id(creator);
lblCreatedby.Text = ObjUser.Username.ToString();
lblCreatedDate.Text = ObjChange.Createdtime.ToString();
int techid = Convert.ToInt32(ObjChange.Technician);
ObjUser = ObjUser.Get_By_id(techid);
if (techid != 0)
{
lbltechid.Text = ObjUser.Username.ToString();
}
else
{
lbltechid.Text = "";
}
colassetincludeinchange = objincludeasset.Get_All_IncludeAssetinchange(changeid);
BLLCollection <Configuration_mst> colasset = new BLLCollection <Configuration_mst>();
Configuration_mst ObjAsset = new Configuration_mst();
foreach (IncludedAssetinchange obj in colassetincludeinchange)
{
ObjAsset = ObjAsset.Get_By_id(obj.Assetid);
colasset.Add(ObjAsset);
}
lstAsset.DataTextField = "Serialno";
lstAsset.DataValueField = "assetid";
lstAsset.DataSource = colasset;
lstAsset.DataBind();
}
protected void btnApprove_Click(object sender, EventArgs e)
{
ObjChangeApproveTrans.Changeid =Convert.ToInt16(Request.QueryString[0]);
ObjChangeApproveTrans.Approvalcomment = txtcomment.Text.ToString();
ObjChangeApproveTrans.ApproverName =Request.QueryString[1];
int changestatusid=Objchangestatus.Get_By_StatusName(Resources.MessageResource.StrApproved);
ObjChangeApproveTrans.Approvestatus=changestatusid;
ObjChangeApproveTrans.Insert();
Change_mst Obj = new Change_mst();
Obj=Obj.Get_By_id(Convert.ToInt16(Request.QueryString[0]));
ObjChange.Statusid = changestatusid;
ObjChange.Changeid = Convert.ToInt16(Request.QueryString[0]);
ObjChange.Active =true;
ObjChange.Assignetime = Obj.Assignetime;
ObjChange.Categoryid =Obj.Categoryid ;
ObjChange.Changetype = Obj.Changetype;
ObjChange.Subcategoryid = Obj.Subcategoryid;
ObjChange.Technician = Obj.Technician;
ObjChange.Title = Obj.Title;
//ObjChange.Completedtime = "";
ObjChange.CreatedByID = Obj.CreatedByID;
ObjChange.Description = Obj.Description;
ObjChange.Priority = Obj.Priority;
ObjChange.Requestedby = Obj.Requestedby;
ObjChange.Sceduledstarttime = Obj.Sceduledstarttime;
ObjChange.Sceduledendtime = Obj.Sceduledendtime;
ObjChange.Approvalstatus = Obj.Approvalstatus;
ObjChange.Impact = Obj.Impact;
ObjChange.Update();
Change_mst ObjNewChange = new Change_mst();
ObjNewChange = ObjNewChange.Get_By_id(Convert.ToInt16(Request.QueryString[0]));
string approvalrequest=Resources.MessageResource.StrApproved.ToString();
int modeid = ObjMode.Get_Mode_By_Mname("Email");
if(approvalrequest=="Approved")
{
BLLCollection<Incident_To_Change> colIncToChng = new BLLCollection<Incident_To_Change>();
colIncToChng=Objincidenttochange.Get_All_By_Changeid(ObjNewChange.Changeid);
int FlagStatus=0;
foreach (Incident_To_Change obj in colIncToChng)
{
FlagStatus = FlagStatus + 1;
}
if (FlagStatus == 0)
{
string statusname = Resources.MessageResource.strStatusOpen.ToString();
int statusid = Convert.ToInt16(Objstatus.Get_By_StatusName(statusname));
Objincludeassetinchange = Objincludeassetinchange.Get_By_Changeid(ObjNewChange.Changeid);
Objconfiguration = Objconfiguration.Get_By_id(Objincludeassetinchange.Assetid);
int priorityid = Convert.ToInt16(Objconfiguration.Severity);
Incident_mst Objincident = new Incident_mst();
int slaid = Objincident.Get_By_SLAid(Objconfiguration.Siteid, priorityid);
Objincident.Requesterid = ObjNewChange.Requestedby;
Objincident.Title = ObjNewChange.Title;
Objincident.Siteid = Objconfiguration.Siteid;
Objincident.Createdbyid = ObjNewChange.CreatedByID;
Objincident.Slaid = Convert.ToInt16(slaid);
Objincident.Modeid = modeid;
Objincident.Insert();
int incidentid = Objincident.Get_Current_Incidentid();
IncidentStates Objincidentstattes = new IncidentStates();
Objincidentstattes.Incidentid = incidentid;
Objincidentstattes.Priorityid = Convert.ToInt16(Objconfiguration.Severity);
Objincidentstattes.Subcategoryid = ObjNewChange.Subcategoryid;
Objincidentstattes.Categoryid = ObjNewChange.Categoryid;
Objincidentstattes.Statusid = statusid;
Objincidentstattes.Requesttypeid = 2;
Objincidentstattes.Insert();
objincidenthistory.Incidentid = incidentid;
objincidenthistory.Operation = "create";
objincidenthistory.Operationownerid = ObjNewChange.CreatedByID;
objincidenthistory.Insert();
Objincidenttochange.Changeid = ObjNewChange.Changeid;
Objincidenttochange.Incidentid = incidentid;
Objincidenttochange.Insert();
string myScript;
myScript = "<script language=javascript>CloseWindow();</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
}
}
}
public CollectionBase GenerateChange_mstCollection(ref IDataReader returnData)
{
BLLCollection<Change_mst> col = new BLLCollection<Change_mst>();
while (returnData.Read())
{
Change_mst obj = new Change_mst();
obj.Changeid = (int)returnData["Changeid"];
obj.Active = (bool)returnData["Active"];
obj.Approvalstatus = (string)returnData["ApprovalStatus"];
obj.Categoryid = (int)returnData["Categoryid"];
obj.Subcategoryid = (int)returnData["Subcategoryid"];
obj.Changetype = (int)returnData["ChangeType"];
obj.Requestedby = (int)returnData["RequestedBy"];
obj.Statusid = (int)returnData["Statusid"];
obj.Technician = (int)returnData["Technician"];
obj.Priority = (int)returnData["Priority"];
obj.Impact = (int)returnData["Impact"];
obj.CreatedByID = (int)returnData["CreatedBy"];
obj.Title = (string)returnData["Title"];
if (returnData["Description"] != DBNull.Value)
{
obj.Description = (string)returnData["Description"];
}
if (returnData["CreatedTime"] != DBNull.Value)
{
DateTime Mydatetime = new DateTime();
Mydatetime = (DateTime)returnData["CreatedTime"];
obj.Createdtime = Mydatetime.ToString();
}
if (returnData["CompletedTime"] != DBNull.Value)
{
DateTime Mydatetime1 = new DateTime();
Mydatetime1 = (DateTime)returnData["CompletedTime"];
obj.Completedtime = Mydatetime1.ToString();
}
if (returnData["Assignetime"] != DBNull.Value)
{
DateTime Mydatetime3 = new DateTime();
Mydatetime3 = (DateTime)returnData["Assignetime"];
obj.Assignetime = Mydatetime3.ToString();
}
if (returnData["Sceduledstarttime"] != DBNull.Value)
{
DateTime Mydatetime4 = new DateTime();
Mydatetime4 = (DateTime)returnData["Sceduledstarttime"];
obj.Sceduledstarttime = Mydatetime4.ToString();
}
if (returnData["Sceduledendtime"] != DBNull.Value)
{
DateTime Mydatetime5 = new DateTime();
Mydatetime5 = (DateTime)returnData["Sceduledendtime"];
obj.Sceduledendtime = Mydatetime5.ToString();
}
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
protected void btnReject_Click(object sender, EventArgs e)
{
ObjChangeApproveTrans.Changeid = Convert.ToInt16(Request.QueryString[0]);
ObjChangeApproveTrans.Approvalcomment = txtcomment.Text.ToString();
ObjChangeApproveTrans.ApproverName = Request.QueryString[1];
int changestatusid = Objchangestatus.Get_By_StatusName(Resources.MessageResource.StrRejected);
ObjChangeApproveTrans.Approvestatus = changestatusid;
ObjChangeApproveTrans.Insert();
ObjChangeApproveTrans.Approvestatus = changestatusid;
ObjChangeApproveTrans.Insert();
Change_mst Obj = new Change_mst();
Obj = Obj.Get_By_id(Convert.ToInt16(Request.QueryString[0]));
ObjChange.Statusid = changestatusid;
ObjChange.Changeid = Convert.ToInt16(Request.QueryString[0]);
ObjChange.Active = true;
ObjChange.Assignetime = Obj.Assignetime;
ObjChange.Categoryid = Obj.Changetype;
ObjChange.Subcategoryid = Obj.Subcategoryid;
ObjChange.Technician = Obj.Technician;
ObjChange.Title = Obj.Title;
ObjChange.Completedtime = Obj.Createdtime;
ObjChange.CreatedByID = Obj.CreatedByID;
ObjChange.Description = Obj.Description;
ObjChange.Priority = Obj.Priority;
ObjChange.Requestedby = Obj.Requestedby;
ObjChange.Sceduledstarttime = Obj.Sceduledstarttime;
ObjChange.Sceduledendtime = Obj.Sceduledendtime;
ObjChange.Approvalstatus = Obj.Approvalstatus;
ObjChange.Impact = Obj.Impact;
ObjChange.Update();
string myScript;
myScript = "<script language=javascript>CloseWindow();</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
}
protected void btnupdateRollOutPlan_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 = "RollOutPlanUpdated";
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 Function Get_By_id(),via passing problemid
ObjChange = ObjChange.Get_By_id(changeid);
#endregion
#region Find the value of current symptom
ObjChangeRollOutPlan = ObjChangeRollOutPlan.Get_By_id(ObjChange.Changeid);
#endregion
#region Insert the values in history difference table
prev_value = Convert.ToString(ObjChangeRollOutPlan.Description);
curnt_value = Convert.ToString(EditorRollOutPlan.Text);
ObjChangeHistoryDiff.Historyid = historyid;
ObjChangeHistoryDiff.Columnname = "Description";
ObjChangeHistoryDiff.Current_value = curnt_value;
ObjChangeHistoryDiff.Prev_value = prev_value;
ObjChangeHistoryDiff.Insert();
#endregion
ObjChangeRollOutPlan.Changeid = changeid;
ObjChangeRollOutPlan.Description = EditorRollOutPlan.Text.ToString();
ObjChangeRollOutPlan.Update();
ShowRollOutPlanPlaceholder();
btnupdateRollOutPlan.Visible = false;
btnsaveRollOutPlan.Visible = false;
btncancellRollOutPlan.Visible = false;
EditorRollOutPlan.Visible = false;
lnkRollOutPlanedit.Visible = true;
lnkRollOutPlanadd.Visible = false;
ShowImpactPlaceholder();
ShowBackOutPlanPlaceholder();
}
public int Update_Change_By_id(Change_mst ObjChange)
{
return (int)ExecuteNonQuery(Sp_Change_Update, new object[] { ObjChange.Technician, ObjChange.Statusid, ObjChange.Priority, ObjChange.Categoryid, ObjChange.Subcategoryid, ObjChange.Changetype, ObjChange.Completedtime, ObjChange.Sceduledstarttime, ObjChange.Sceduledendtime, ObjChange.Assignetime, ObjChange.Active, ObjChange.Changeid ,ObjChange.servicename});
}
public int Insert_Change_mst(Change_mst ObjChange)
{
return (int)ExecuteNonQuery(Sp_Change_Insert, new object[] { ObjChange.Categoryid, ObjChange.Subcategoryid, ObjChange.Statusid, ObjChange.Technician, ObjChange.Priority, ObjChange.Changetype, ObjChange.Impact, ObjChange.Requestedby, ObjChange.Approvalstatus, ObjChange.Assignetime, ObjChange.Title, ObjChange.Description, ObjChange.CreatedByID ,ObjChange.servicename});
}
public object GenerateChange_mstObject(ref IDataReader returnData)
{
Change_mst obj = new Change_mst();
while (returnData.Read())
{
obj.Changeid = (int)returnData["Changeid"];
obj.Active = (bool)returnData["Active"];
obj.Approvalstatus = (string)returnData["ApprovalStatus"];
obj.Categoryid = (int)returnData["Categoryid"];
obj.Subcategoryid = (int)returnData["Subcategoryid"];
obj.Changetype = (int)returnData["ChangeType"];
obj.Requestedby = (int)returnData["RequestedBy"];
obj.Statusid = (int)returnData["Statusid"];
obj.Technician = (int)returnData["Technician"];
obj.Priority = (int)returnData["Priority"];
obj.Impact = (int)returnData["Impact"];
obj.CreatedByID = (int)returnData["CreatedBy"];
//////////////////////////////change dne by meenakshi 4th oct
// obj.servicename = (string)returnData["servicename"];
if (returnData["servicename"] != DBNull.Value)
{
obj.servicename = (string)returnData["servicename"];
}
////////////////////////////////////////end
obj.Title = (string)returnData["Title"];
if (returnData["Description"] != DBNull.Value)
{
obj.Description = (string)returnData["Description"];
}
if (returnData["CreatedTime"] != DBNull.Value)
{
DateTime Mydatetime = new DateTime();
Mydatetime = (DateTime)returnData["CreatedTime"];
obj.Createdtime = Mydatetime.ToString();
}
if (returnData["CompletedTime"] != DBNull.Value)
{
DateTime Mydatetime1 = new DateTime();
Mydatetime1 = (DateTime)returnData["CompletedTime"];
obj.Completedtime = Mydatetime1.ToString();
}
if (returnData["Assignetime"] != DBNull.Value)
{
DateTime Mydatetime3 = new DateTime();
Mydatetime3 = (DateTime)returnData["Assignetime"];
obj.Assignetime = Mydatetime3.ToString();
}
if (returnData["Sceduledstarttime"] != DBNull.Value)
{
DateTime Mydatetime4 = new DateTime();
Mydatetime4 = (DateTime)returnData["Sceduledstarttime"];
obj.Sceduledstarttime = Mydatetime4.ToString();
}
if (returnData["Sceduledendtime"] != DBNull.Value)
{
DateTime Mydatetime5 = new DateTime();
Mydatetime5 = (DateTime)returnData["Sceduledendtime"];
obj.Sceduledendtime = Mydatetime5.ToString();
}
}
returnData.Close();
returnData.Dispose();
return obj;
}
protected void btnCancell_Click(object sender, EventArgs e)
{
#region Fetch Each Row from GridView,and Check Which Check Box is Selected
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
#region Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
#endregion
#region If deleteChkBxItem is Checked then ,mapped Current site to this user
if (deleteChkBxItem.Checked)
{
#region Declare local Variables
int Changeid;
int varSiteid;
int oldtechnicianvalue;
#endregion
#region Get the Problemid from variable of Label type declare in GridView of grdvwSite
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
#endregion
#region Convert to incident id into integer
Changeid = Convert.ToInt32(gvIDs);
#endregion
#region If Incident id in Not Null
if (gvIDs != "")
{
Change_mst Obj = new Change_mst();
Obj = ObjChange.Get_By_id(Changeid);
if (Obj.Changeid != 0)
{
Obj.Active = false;
Obj.Update();
}
}
#endregion
}
#endregion
}
BindGridForAllParameter();
#endregion
}
protected void Showchangeinfo()
{
Approvalpanal.Visible = true;
btnApprove.Visible = true;
btnReject.Visible = true;
Alreadyapprovedpanal.Visible = false;
NameValueCollection n = Request.QueryString;
int changeid = Convert.ToInt16(Request.QueryString[0]);
//lblchangeid.Text = changeid.ToString();
ObjChange = ObjChange.Get_By_id(changeid);
lblchangeid.Text = ObjChange.Changeid.ToString();
lbltitle.Text = ObjChange.Title;
lbldescription.Text = ObjChange.Description;
//lblDateDisp.Text = ObjChange.Createdtime.ToString();
int requesterid = Convert.ToInt16(ObjChange.Requestedby);
//lblTitle.Text = ObjChange.Title.ToString();
//lblDescription.Text = ObjChange.Description.ToString();
lblserviceeffected.Text = "Email";
int chantypeid = Convert.ToInt16(ObjChange.Changetype);
ObjChangeType = ObjChangeType.Get_By_id(chantypeid);
if (chantypeid != 0)
{
lblchangetype.Text = ObjChangeType.Changetypename.ToString();
}
int changestatus = Convert.ToInt16(ObjChange.Statusid);
Objchangestatus = Objchangestatus.Get_By_id(changestatus);
if (changestatus != 0)
{
lblStatus.Text = Objchangestatus.Statusname;
}
int priorityid = Convert.ToInt16(ObjChange.Priority);
ObjPriority = ObjPriority.Get_By_id(priorityid);
if (priorityid != 0)
{
lblpriority.Text = ObjPriority.Name.ToString();
}
else
{
lblpriority.Text = "";
}
int category = Convert.ToInt16(ObjChange.Categoryid);
ObjCategory = ObjCategory.Get_By_id(category);
if (category != 0)
{
lblcategory.Text = ObjCategory.CategoryName.ToString();
}
else
{
lblcategory.Text = "";
}
int subcategory = Convert.ToInt16(ObjChange.Subcategoryid);
Objsubcategory = Objsubcategory.Get_By_id(subcategory);
if (subcategory != 0)
{
lblsubcategory.Text = Objsubcategory.Subcategoryname.ToString();
}
else
{
lblsubcategory.Text = "";
}
int creator = Convert.ToInt16(ObjChange.CreatedByID);
ObjUser = ObjUser.Get_By_id(creator);
lblCreatedby.Text = ObjUser.Username.ToString();
lblCreatedDate.Text = ObjChange.Createdtime.ToString();
int techid = Convert.ToInt16(ObjChange.Technician);
ObjUser = ObjUser.Get_By_id(techid);
if (techid != 0)
{
lbltechid.Text = ObjUser.Username.ToString();
}
else
{
lbltechid.Text = "";
}
colassetincludeinchange = objincludeasset.Get_All_IncludeAssetinchange(changeid);
BLLCollection<Configuration_mst> colasset = new BLLCollection<Configuration_mst>();
Configuration_mst ObjAsset = new Configuration_mst();
foreach (IncludedAssetinchange obj in colassetincludeinchange)
{
ObjAsset = ObjAsset.Get_By_id(obj.Assetid);
colasset.Add(ObjAsset);
}
lstAsset.DataTextField = "Serialno";
lstAsset.DataValueField = "assetid";
lstAsset.DataSource = colasset;
lstAsset.DataBind();
}
public void SentMailToChangeCommittee(int changeid, int changetypeid)
{
string strYourSinscerely = Resources.MessageResource.strYourSinscerely.ToString();
string strContactNumber = Resources.MessageResource.strContactNumber.ToString();
Cab_mst Objcabmember = new Cab_mst();
ObjChange = ObjChange.Get_By_id(changeid);
BLLCollection<Cab_mst> colmembers = new BLLCollection<Cab_mst>();
UserLogin_mst objUserCreator = new UserLogin_mst();
int FlagUser;
int roleid;
string varServerName;
varServerName = Resources.MessageResource.serverNameForChangePage.ToString();
// varServerName = "10.80.0.15";
string url11;
url11 = "http://" + varServerName + "/BEST/LoginPageAccess/ApproveorRejectChangeRequest.aspx?changeid=" + changeid;
colmembers = Objcabmember.Get_All_By_ChangeTypeid(changetypeid);
string url;
foreach (Cab_mst objmember in colmembers)
{
url = "<a href=" + url11 + "&userid=" + objmember.Membername + " ' onclick=window.open()>Click Here For Approval</a>";
obj.From = Resources.MessageResource.strAdminEmail.ToString();
obj.To = objmember.Emailid;
obj.Subject = "New Change Added. Change Id : " + changeid;
obj.Body = "Dear Sir/Madam,<br/>A New Change has been requested.Please.<br/><br/><b>Solution Details : </b> <br/><br/><b>Changeid Id :</b>" + ObjChange.Changeid + "<br/><b>Title :</b>" + ObjChange.Title + " <br/><b>Added By :</b>" + ObjChange.CreatedByID + "<br/><b>Created Date   :</b>" + ObjChange.Createdtime + "<br/><b>Content :</b>" + ObjChange.Description + "<br/><br/>This is an auto generated mail. Please do not reply.</b><br/><br/></b><br/><b>Kindly Click the following link to Aprove or Reject the Change Request. <br></br>" + url + " <b><br/><br/><b>Yours sincerely,</b><br/> <b>" + strYourSinscerely + "</b>";
obj.SmtpServer = Resources.MessageResource.strSMTPServer.ToString();
obj.SentMail();
}
}
