public void BindGrid()
{
BLLCollection<ChangeStatus_mst> col = new BLLCollection<ChangeStatus_mst>();
ChangeStatus_mst ObjStatus2 = new ChangeStatus_mst();
col = ObjStatus2.Get_All();
Statusgrdvw.DataSource = col;
Statusgrdvw.DataBind();
Clearcontrol();
}
public void BindGrid()
{
BLLCollection <ChangeStatus_mst> col = new BLLCollection <ChangeStatus_mst>();
ChangeStatus_mst ObjStatus2 = new ChangeStatus_mst();
col = ObjStatus2.Get_All();
Statusgrdvw.DataSource = col;
Statusgrdvw.DataBind();
Clearcontrol();
}
protected void Statusgrdvw_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string name, desc, id;
int StatusId = 0;
ChangeStatus_mst ObjStatus1 = new ChangeStatus_mst();
name = ((TextBox)Statusgrdvw.Rows[e.RowIndex].Cells[1].Controls[0].FindControl("txtStatusName")).Text;
desc = ((TextBox)Statusgrdvw.Rows[e.RowIndex].Cells[2].Controls[0].FindControl("txtStatusdesc")).Text;
id = Convert.ToString(Statusgrdvw.Rows[e.RowIndex].Cells[0].Text);
StatusId = Convert.ToInt16(id);
statusnamecount = ObjStatus1.Get_By_StatusName(name);
ObjStatus1 = ObjStatus1.Get_By_id(StatusId);
if ((statusnamecount == 0) && (name != ""))
{
ObjStatus1.Statusname = name;
ObjStatus1.ChangeStatusid = StatusId;
ObjStatus1.Description = desc;
ObjStatus1.Update();
Statusgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else if (name == "")
{
BindGrid();
lblerrmsg.Text = "Status name should not be empty";
}
else if (ObjStatus1.Statusname == name)
{
ObjStatus1.ChangeStatusid = StatusId;
ObjStatus1.Statusname = name;
ObjStatus1.Description = desc;
ObjStatus1.Update();
Statusgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else
{
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errStatusExist.ToString();
}
Statusgrdvw.EditIndex = -1;
}
protected void grdvwChange_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
#region Bind Data Row at Run time with requesterid to Requester name
int requesterid = Convert.ToInt16(e.Row.Cells[3].Text);
objUser = objUser.Get_By_id(requesterid);
if (objUser.Userid != 0)
{
e.Row.Cells[3].Text = objUser.Username.ToString();
}
else
{
e.Row.Cells[3].Text = "";
}
#endregion
#region Bind Datarow at Run Time with Createdbyid to Created by name
int createdbyid = Convert.ToInt16(e.Row.Cells[4].Text);
objUser = objUser.Get_By_id(createdbyid);
if (objUser.Userid != 0)
{
e.Row.Cells[4].Text = objUser.Username.ToString();
}
else
{
e.Row.Cells[4].Text = "";
}
#endregion
#region Bind Datarow at Run Time with technicianid to technician name
int technicianid = Convert.ToInt16(e.Row.Cells[5].Text);
objUser = objUser.Get_By_id(technicianid);
if (objUser.Userid != 0)
{
e.Row.Cells[5].Text = objUser.Username.ToString();
}
else
{
e.Row.Cells[5].Text = "";
}
#endregion
#region Bind Datarow at run time with Statusid to Status
int statusid = Convert.ToInt16(e.Row.Cells[6].Text);
objStatus = objStatus.Get_By_id(statusid);
if (objStatus.ChangeStatusid != 0)
{
e.Row.Cells[6].Text = objStatus.Statusname.ToString();
}
else
{
e.Row.Cells[6].Text = "";
}
#endregion
#region Bind Datarow at run time with Priorityid to Priority
int priorityid = Convert.ToInt16(e.Row.Cells[7].Text);
objPriority = objPriority.Get_By_id(priorityid);
if (objPriority.Priorityid != 0)
{
e.Row.Cells[7].Text = objPriority.Name.ToString();
}
else
{
e.Row.Cells[7].Text = "";
}
#endregion
#region Bind Datarow at run time with CategoryId to Category
int categoryid = Convert.ToInt16(e.Row.Cells[8].Text);
objCategory = objCategory.Get_By_id(categoryid);
if (objCategory.Categoryid != 0)
{
e.Row.Cells[8].Text = objCategory.CategoryName.ToString();
}
else
{
e.Row.Cells[8].Text = "";
}
#endregion
}
}
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 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();
}
protected void Statusgrdvw_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string name, desc, id;
int StatusId = 0;
ChangeStatus_mst ObjStatus1 = new ChangeStatus_mst();
name = ((TextBox)Statusgrdvw.Rows[e.RowIndex].Cells[1].Controls[0].FindControl("txtStatusName")).Text;
desc = ((TextBox)Statusgrdvw.Rows[e.RowIndex].Cells[2].Controls[0].FindControl("txtStatusdesc")).Text;
id = Convert.ToString(Statusgrdvw.Rows[e.RowIndex].Cells[0].Text);
StatusId = Convert.ToInt16(id);
statusnamecount = ObjStatus1.Get_By_StatusName(name);
ObjStatus1 = ObjStatus1.Get_By_id(StatusId);
if ((statusnamecount == 0) && (name != ""))
{
ObjStatus1.Statusname = name;
ObjStatus1.ChangeStatusid = StatusId;
ObjStatus1.Description = desc;
ObjStatus1.Update();
Statusgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else if (name == "")
{
BindGrid();
lblerrmsg.Text = "Status name should not be empty";
}
else if (ObjStatus1.Statusname == name)
{
ObjStatus1.ChangeStatusid = StatusId;
ObjStatus1.Statusname = name;
ObjStatus1.Description = desc;
ObjStatus1.Update();
Statusgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else
{
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errStatusExist.ToString();
}
Statusgrdvw.EditIndex = -1;
}
protected void grdvwChange_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
#region Bind Data Row at Run time with requesterid to Requester name
int requesterid = Convert.ToInt16(e.Row.Cells[3].Text);
objUser = objUser.Get_By_id(requesterid);
if (objUser.Userid != 0)
{
e.Row.Cells[3].Text = objUser.Username.ToString();
}
else { e.Row.Cells[3].Text = ""; }
#endregion
#region Bind Datarow at Run Time with Createdbyid to Created by name
int createdbyid = Convert.ToInt16(e.Row.Cells[4].Text);
objUser = objUser.Get_By_id(createdbyid);
if (objUser.Userid != 0)
{
e.Row.Cells[4].Text = objUser.Username.ToString();
}
else { e.Row.Cells[4].Text = ""; }
#endregion
#region Bind Datarow at Run Time with technicianid to technician name
int technicianid = Convert.ToInt16(e.Row.Cells[5].Text);
objUser = objUser.Get_By_id(technicianid);
if (objUser.Userid != 0)
{
e.Row.Cells[5].Text = objUser.Username.ToString();
}
else { e.Row.Cells[5].Text = ""; }
#endregion
#region Bind Datarow at run time with Statusid to Status
int statusid = Convert.ToInt16(e.Row.Cells[6].Text);
objStatus = objStatus.Get_By_id(statusid);
if (objStatus.ChangeStatusid != 0)
{ e.Row.Cells[6].Text = objStatus.Statusname.ToString(); }
else { e.Row.Cells[6].Text = ""; }
#endregion
#region Bind Datarow at run time with Priorityid to Priority
int priorityid = Convert.ToInt16(e.Row.Cells[7].Text);
objPriority = objPriority.Get_By_id(priorityid);
if (objPriority.Priorityid != 0)
{ e.Row.Cells[7].Text = objPriority.Name.ToString(); }
else { e.Row.Cells[7].Text = ""; }
#endregion
#region Bind Datarow at run time with CategoryId to Category
int categoryid = Convert.ToInt16(e.Row.Cells[8].Text);
objCategory = objCategory.Get_By_id(categoryid);
if (objCategory.Categoryid != 0)
{ e.Row.Cells[8].Text = objCategory.CategoryName.ToString(); }
else { e.Row.Cells[8].Text = ""; }
#endregion
}
}
protected void grdvwChange_RowDataBound(Object sender, GridViewRowEventArgs e)
{
//Add Exception handilng try catch change by vishal 21-05-2012
try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
#region Bind Data Row at Run time with requesterid to Requester name
int requesterid = Convert.ToInt32(e.Row.Cells[3].Text);
objUser = objUser.Get_By_id(requesterid);
if (objUser.Userid != 0)
{
e.Row.Cells[3].Text = objUser.Username.ToString();
}
else
{
e.Row.Cells[3].Text = "";
}
#endregion
#region Bind Datarow at Run Time with Createdbyid to Created by name
int createdbyid = Convert.ToInt32(e.Row.Cells[4].Text);
objUser = objUser.Get_By_id(createdbyid);
if (objUser.Userid != 0)
{
e.Row.Cells[4].Text = objUser.Username.ToString();
}
else
{
e.Row.Cells[4].Text = "";
}
#endregion
#region Bind Datarow at Run Time with technicianid to technician name
int technicianid = Convert.ToInt32(e.Row.Cells[5].Text);
objUser = objUser.Get_By_id(technicianid);
if (objUser.Userid != 0)
{
e.Row.Cells[5].Text = objUser.Username.ToString();
}
else
{
e.Row.Cells[5].Text = "";
}
#endregion
#region Bind Datarow at run time with Statusid to Status
int statusid = Convert.ToInt32(e.Row.Cells[6].Text);
objStatus = objStatus.Get_By_id(statusid);
if (objStatus.ChangeStatusid != 0)
{
e.Row.Cells[6].Text = objStatus.Statusname.ToString();
}
else
{
e.Row.Cells[6].Text = "";
}
#endregion
#region Bind Datarow at run time with Priorityid to Priority
int priorityid = Convert.ToInt32(e.Row.Cells[7].Text);
objPriority = objPriority.Get_By_id(priorityid);
if (objPriority.Priorityid != 0)
{
e.Row.Cells[7].Text = objPriority.Name.ToString();
}
else
{
e.Row.Cells[7].Text = "";
}
#endregion
#region Bind Datarow at run time with CategoryId to Category
int categoryid = Convert.ToInt32(e.Row.Cells[8].Text);
objCategory = objCategory.Get_By_id(categoryid);
if (objCategory.Categoryid != 0)
{
e.Row.Cells[8].Text = objCategory.CategoryName.ToString();
}
else
{
e.Row.Cells[8].Text = "";
}
#endregion
}
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
public int Insert_ChangeStatus_mst(ChangeStatus_mst objChangeStatus)
{
return (int)ExecuteNonQuery(Sp_ChangeStatus_Insert, new object[] { objChangeStatus.Statusname, objChangeStatus.Description });
}
public object GenerateChangeStatus_mstObject(ref IDataReader returnData)
{
ChangeStatus_mst obj = new ChangeStatus_mst();
while (returnData.Read())
{
obj.ChangeStatusid = (int)returnData["changestatusid"];
obj.Statusname = (string)returnData["statusname"];
obj.Description = (string)returnData["description"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateChangeStatus_mstCollection(ref IDataReader returnData)
{
BLLCollection<ChangeStatus_mst> col = new BLLCollection<ChangeStatus_mst>();
while (returnData.Read())
{
ChangeStatus_mst obj = new ChangeStatus_mst();
obj.ChangeStatusid = (int)returnData["changestatusid"];
obj.Description = (string)returnData["description"];
obj.Statusname = (string)returnData["statusname"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
protected void grdvwChange_RowDataBound(Object sender, GridViewRowEventArgs e)
{
//System.Drawing.ColorConverter colConvert = new ColorConverter();
//BLLCollection<ColorScheme_mst> colColor = new BLLCollection<ColorScheme_mst>();
if (e.Row.RowType == DataControlRowType.DataRow)
{
//if(col.Count!=0)
//{
#region Autogenerate Serial number
//Label lblSerial = (Label)e.Row.FindControl("lblSerial");
//lblSerial.Text = i.ToString();
//i++;
#endregion
int TotalTimeSpentonCall;
int TotalResolutionTime;
string varStatusOpen = Resources.MessageResource.strStatusOpen.ToString();
string varStatusClose = Resources.MessageResource.strStatusClose.ToString();
string varStatusOnHold = Resources.MessageResource.strStatusOnHold.ToString();
string varStatusResolved = Resources.MessageResource.strStatusResolved.ToString();
#region Bind Data Row at Run time with requesterid to Requester name
int requesterid = Convert.ToInt16(e.Row.Cells[2].Text);
objUser = objUser.Get_By_id(requesterid);
if (objUser.Userid != 0)
{
e.Row.Cells[2].Text = objUser.Username.ToString();
}
else { e.Row.Cells[2].Text = ""; }
#endregion
#region Bind Datarow at Run Time with Createdbyid to Created by name
int createdbyid = Convert.ToInt16(e.Row.Cells[3].Text);
objUser = objUser.Get_By_id(createdbyid);
if (objUser.Userid != 0)
{
e.Row.Cells[3].Text = objUser.Username.ToString();
}
else { e.Row.Cells[3].Text = ""; }
#endregion
#region Bind Datarow at Run Time with technicianid to technician name
int technicianid = Convert.ToInt16(e.Row.Cells[4].Text);
objUser = objUser.Get_By_id(technicianid);
if (objUser.Userid != 0)
{
e.Row.Cells[4].Text = objUser.Username.ToString();
}
else { e.Row.Cells[4].Text = ""; }
#endregion
#region Bind Datarow at run time with Statusid to Status
int statusid = Convert.ToInt16(e.Row.Cells[5].Text);
ObjChangeStatus = ObjChangeStatus.Get_By_id(statusid);
if (ObjChangeStatus.ChangeStatusid != 0)
{
e.Row.Cells[5].Text = ObjChangeStatus.Statusname.ToString();
}
else { e.Row.Cells[5].Text = ""; }
#endregion
#region Bind Datarow at run time with Priorityid to Priority
int priorityid = Convert.ToInt16(e.Row.Cells[6].Text);
objPriority = objPriority.Get_By_id(priorityid);
if (objPriority.Priorityid != 0)
{ e.Row.Cells[6].Text = objPriority.Name.ToString(); }
else { e.Row.Cells[6].Text = ""; }
#endregion
}
}
protected void grdvwChange_RowDataBound(Object sender, GridViewRowEventArgs e)
{
//Add Exception handilng try catch change by vishal 21-05-2012
try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
#region Bind Data Row at Run time with requesterid to Requester name
int requesterid = Convert.ToInt32(e.Row.Cells[3].Text);
objUser = objUser.Get_By_id(requesterid);
if (objUser.Userid != 0)
{
e.Row.Cells[3].Text = objUser.Username.ToString();
}
else { e.Row.Cells[3].Text = ""; }
#endregion
#region Bind Datarow at Run Time with Createdbyid to Created by name
int createdbyid = Convert.ToInt32(e.Row.Cells[4].Text);
objUser = objUser.Get_By_id(createdbyid);
if (objUser.Userid != 0)
{
e.Row.Cells[4].Text = objUser.Username.ToString();
}
else { e.Row.Cells[4].Text = ""; }
#endregion
#region Bind Datarow at Run Time with technicianid to technician name
int technicianid = Convert.ToInt32(e.Row.Cells[5].Text);
objUser = objUser.Get_By_id(technicianid);
if (objUser.Userid != 0)
{
e.Row.Cells[5].Text = objUser.Username.ToString();
}
else { e.Row.Cells[5].Text = ""; }
#endregion
#region Bind Datarow at run time with Statusid to Status
int statusid = Convert.ToInt32(e.Row.Cells[6].Text);
objStatus = objStatus.Get_By_id(statusid);
if (objStatus.ChangeStatusid != 0)
{ e.Row.Cells[6].Text = objStatus.Statusname.ToString(); }
else { e.Row.Cells[6].Text = ""; }
#endregion
#region Bind Datarow at run time with Priorityid to Priority
int priorityid = Convert.ToInt32(e.Row.Cells[7].Text);
objPriority = objPriority.Get_By_id(priorityid);
if (objPriority.Priorityid != 0)
{ e.Row.Cells[7].Text = objPriority.Name.ToString(); }
else { e.Row.Cells[7].Text = ""; }
#endregion
#region Bind Datarow at run time with CategoryId to Category
int categoryid = Convert.ToInt32(e.Row.Cells[8].Text);
objCategory = objCategory.Get_By_id(categoryid);
if (objCategory.Categoryid != 0)
{ e.Row.Cells[8].Text = objCategory.CategoryName.ToString(); }
else { e.Row.Cells[8].Text = ""; }
#endregion
}
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
public int Update_ChangeStatus_mst_By_id(ChangeStatus_mst objChangeStatus)
{
return (int)ExecuteNonQuery(Sp_ChangeStatus_Update, new object[] { objChangeStatus.Statusname, objChangeStatus.ChangeStatusid, objChangeStatus.Description });
}
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 grdvwChange_RowDataBound(Object sender, GridViewRowEventArgs e)
{
//System.Drawing.ColorConverter colConvert = new ColorConverter();
//BLLCollection<ColorScheme_mst> colColor = new BLLCollection<ColorScheme_mst>();
if (e.Row.RowType == DataControlRowType.DataRow)
{
//if(col.Count!=0)
//{
#region Autogenerate Serial number
//Label lblSerial = (Label)e.Row.FindControl("lblSerial");
//lblSerial.Text = i.ToString();
//i++;
#endregion
int TotalTimeSpentonCall;
int TotalResolutionTime;
string varStatusOpen = Resources.MessageResource.strStatusOpen.ToString();
string varStatusClose = Resources.MessageResource.strStatusClose.ToString();
string varStatusOnHold = Resources.MessageResource.strStatusOnHold.ToString();
string varStatusResolved = Resources.MessageResource.strStatusResolved.ToString();
#region Bind Data Row at Run time with requesterid to Requester name
int requesterid = Convert.ToInt16(e.Row.Cells[2].Text);
objUser = objUser.Get_By_id(requesterid);
if (objUser.Userid != 0)
{
e.Row.Cells[2].Text = objUser.Username.ToString();
}
else
{
e.Row.Cells[2].Text = "";
}
#endregion
#region Bind Datarow at Run Time with Createdbyid to Created by name
int createdbyid = Convert.ToInt16(e.Row.Cells[3].Text);
objUser = objUser.Get_By_id(createdbyid);
if (objUser.Userid != 0)
{
e.Row.Cells[3].Text = objUser.Username.ToString();
}
else
{
e.Row.Cells[3].Text = "";
}
#endregion
#region Bind Datarow at Run Time with technicianid to technician name
int technicianid = Convert.ToInt16(e.Row.Cells[4].Text);
objUser = objUser.Get_By_id(technicianid);
if (objUser.Userid != 0)
{
e.Row.Cells[4].Text = objUser.Username.ToString();
}
else
{
e.Row.Cells[4].Text = "";
}
#endregion
#region Bind Datarow at run time with Statusid to Status
int statusid = Convert.ToInt16(e.Row.Cells[5].Text);
ObjChangeStatus = ObjChangeStatus.Get_By_id(statusid);
if (ObjChangeStatus.ChangeStatusid != 0)
{
e.Row.Cells[5].Text = ObjChangeStatus.Statusname.ToString();
}
else
{
e.Row.Cells[5].Text = "";
}
#endregion
#region Bind Datarow at run time with Priorityid to Priority
int priorityid = Convert.ToInt16(e.Row.Cells[6].Text);
objPriority = objPriority.Get_By_id(priorityid);
if (objPriority.Priorityid != 0)
{
e.Row.Cells[6].Text = objPriority.Name.ToString();
}
else
{
e.Row.Cells[6].Text = "";
}
#endregion
}
}
protected void grdvwChange_RowDataBound(Object sender, GridViewRowEventArgs e)
{
//Add Exception handilng try catch change by vishal 21-05-2012
try
{
//System.Drawing.ColorConverter colConvert = new ColorConverter();
//BLLCollection<ColorScheme_mst> colColor = new BLLCollection<ColorScheme_mst>();
if (e.Row.RowType == DataControlRowType.DataRow)
{
//if(col.Count!=0)
//{
#region Autogenerate Serial number
//Label lblSerial = (Label)e.Row.FindControl("lblSerial");
//lblSerial.Text = i.ToString();
//i++;
#endregion
int TotalTimeSpentonCall;
int TotalResolutionTime;
string varStatusOpen = Resources.MessageResource.strStatusOpen.ToString();
string varStatusClose = Resources.MessageResource.strStatusClose.ToString();
string varStatusOnHold = Resources.MessageResource.strStatusOnHold.ToString();
string varStatusResolved = Resources.MessageResource.strStatusResolved.ToString();
#region Bind Data Row at Run time with requesterid to Requester name
int requesterid = Convert.ToInt32(e.Row.Cells[2].Text);
objUser = objUser.Get_By_id(requesterid);
if (objUser.Userid != 0)
{
e.Row.Cells[2].Text = objUser.Username.ToString();
}
else { e.Row.Cells[2].Text = ""; }
#endregion
#region Bind Datarow at Run Time with Createdbyid to Created by name
int createdbyid = Convert.ToInt32(e.Row.Cells[3].Text);
objUser = objUser.Get_By_id(createdbyid);
if (objUser.Userid != 0)
{
e.Row.Cells[3].Text = objUser.Username.ToString();
}
else { e.Row.Cells[3].Text = ""; }
#endregion
#region Bind Datarow at Run Time with technicianid to technician name
int technicianid = Convert.ToInt32(e.Row.Cells[4].Text);
objUser = objUser.Get_By_id(technicianid);
if (objUser.Userid != 0)
{
e.Row.Cells[4].Text = objUser.Username.ToString();
}
else { e.Row.Cells[4].Text = ""; }
#endregion
#region Bind Datarow at run time with Statusid to Status
int statusid = Convert.ToInt32(e.Row.Cells[5].Text);
ObjChangeStatus = ObjChangeStatus.Get_By_id(statusid);
if (ObjChangeStatus.ChangeStatusid != 0)
{
e.Row.Cells[5].Text = ObjChangeStatus.Statusname.ToString();
}
else { e.Row.Cells[5].Text = ""; }
#endregion
#region Bind Datarow at run time with Priorityid to Priority
int priorityid = Convert.ToInt32(e.Row.Cells[6].Text);
objPriority = objPriority.Get_By_id(priorityid);
if (objPriority.Priorityid != 0)
{ e.Row.Cells[6].Text = objPriority.Name.ToString(); }
else { e.Row.Cells[6].Text = ""; }
#endregion
}
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void grdvwChange_RowDataBound(Object sender, GridViewRowEventArgs e)
{//Add Exception handilng try catch change by vishal 21-05-2012
try
{
//System.Drawing.ColorConverter colConvert = new ColorConverter();
//BLLCollection<ColorScheme_mst> colColor = new BLLCollection<ColorScheme_mst>();
if (e.Row.RowType == DataControlRowType.DataRow)
{
//if(col.Count!=0)
//{
#region Autogenerate Serial number
//Label lblSerial = (Label)e.Row.FindControl("lblSerial");
//lblSerial.Text = i.ToString();
//i++;
#endregion
int TotalTimeSpentonCall;
int TotalResolutionTime;
string varStatusOpen = Resources.MessageResource.strStatusOpen.ToString();
string varStatusClose = Resources.MessageResource.strStatusClose.ToString();
string varStatusOnHold = Resources.MessageResource.strStatusOnHold.ToString();
string varStatusResolved = Resources.MessageResource.strStatusResolved.ToString();
#region Bind Data Row at Run time with requesterid to Requester name
int requesterid = Convert.ToInt32(e.Row.Cells[2].Text);
objUser = objUser.Get_By_id(requesterid);
if (objUser.Userid != 0)
{
e.Row.Cells[2].Text = objUser.Username.ToString();
}
else
{
e.Row.Cells[2].Text = "";
}
#endregion
#region Bind Datarow at Run Time with Createdbyid to Created by name
int createdbyid = Convert.ToInt32(e.Row.Cells[3].Text);
objUser = objUser.Get_By_id(createdbyid);
if (objUser.Userid != 0)
{
e.Row.Cells[3].Text = objUser.Username.ToString();
}
else
{
e.Row.Cells[3].Text = "";
}
#endregion
#region Bind Datarow at Run Time with technicianid to technician name
int technicianid = Convert.ToInt32(e.Row.Cells[4].Text);
objUser = objUser.Get_By_id(technicianid);
if (objUser.Userid != 0)
{
e.Row.Cells[4].Text = objUser.Username.ToString();
}
else
{
e.Row.Cells[4].Text = "";
}
#endregion
#region Bind Datarow at run time with Statusid to Status
int statusid = Convert.ToInt32(e.Row.Cells[5].Text);
ObjChangeStatus = ObjChangeStatus.Get_By_id(statusid);
if (ObjChangeStatus.ChangeStatusid != 0)
{
e.Row.Cells[5].Text = ObjChangeStatus.Statusname.ToString();
}
else
{
e.Row.Cells[5].Text = "";
}
#endregion
#region Bind Datarow at run time with Priorityid to Priority
int priorityid = Convert.ToInt32(e.Row.Cells[6].Text);
objPriority = objPriority.Get_By_id(priorityid);
if (objPriority.Priorityid != 0)
{
e.Row.Cells[6].Text = objPriority.Name.ToString();
}
else
{
e.Row.Cells[6].Text = "";
}
#endregion
}
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
