protected void Servicegrdvw_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string name, desc, id;
int ServiceId = 0;
name = ((TextBox)Servicegrdvw.Rows[e.RowIndex].Cells[1].Controls[0].FindControl("txtServiceName")).Text;
desc = ((TextBox)Servicegrdvw.Rows[e.RowIndex].Cells[2].Controls[0].FindControl("txtServicedesc")).Text;
id = Convert.ToString(Servicegrdvw.Rows[e.RowIndex].Cells[0].Text);
ServiceId = Convert.ToInt32(id);
servicenamecount = ObjService.Get_By_ServiceName(name);
ObjService = ObjService.Get_By_id(ServiceId);
if ((servicenamecount == 0) && (name != ""))
{
ObjService.Serviceid = ServiceId;
ObjService.servicename = name;
ObjService.Description = desc;
ObjService.Update();
Servicegrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else if (name == "")
{
lblerrmsg.Text = Resources.MessageResource.errnotempty.ToString();
}
else if (ObjService.servicename == name)
{
ObjService.Serviceid = ServiceId;
ObjService.servicename = name;
ObjService.Description = desc;
ObjService.Update();
Servicegrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else
{
lblerrmsg.Text = Resources.MessageResource.errServiceExist.ToString();
}
Servicegrdvw.EditIndex = -1;
BindGrid();
}
protected void Servicegrdvw_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string name, desc, id;
int ServiceId = 0;
name = ((TextBox)Servicegrdvw.Rows[e.RowIndex].Cells[1].Controls[0].FindControl("txtServiceName")).Text;
desc = ((TextBox)Servicegrdvw.Rows[e.RowIndex].Cells[2].Controls[0].FindControl("txtServicedesc")).Text;
id = Convert.ToString(Servicegrdvw.Rows[e.RowIndex].Cells[0].Text);
ServiceId = Convert.ToInt32(id);
servicenamecount = ObjService.Get_By_ServiceName(name);
ObjService = ObjService.Get_By_id(ServiceId);
if ((servicenamecount == 0) && (name != ""))
{
ObjService.Serviceid = ServiceId;
ObjService.servicename = name;
ObjService.Description = desc;
ObjService.Update();
Servicegrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else if (name == "")
{
lblerrmsg.Text = Resources.MessageResource.errnotempty.ToString();
}
else if (ObjService.servicename == name)
{
ObjService.Serviceid = ServiceId;
ObjService.servicename = name;
ObjService.Description = desc;
ObjService.Update();
Servicegrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else
{
lblerrmsg.Text = Resources.MessageResource.errServiceExist.ToString();
}
Servicegrdvw.EditIndex = -1;
BindGrid();
}
protected void buttonadd_click(object sender, EventArgs e)
{
/////Add Exception handilng try catch change by vishal 21-05-2012
try
{
#region Find Userid of User who is Requesting to log a call
#region If User Already Exist
if (ViewState["UserCreate"].ToString() == "Exist")
{
objOrganization = objOrganization.Get_Organization();
ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid);
if (ObjUserLogin.Userid != 0)
{
requesterid = ObjUserLogin.Userid;
}
}
#endregion
#region If New User is to be Created
else if (ViewState["UserCreate"].ToString() == "create")
{
string varEmail = "";
string varRoleName = Resources.MessageResource.BasicUserRole.ToString();
if (txtEmail.Text == "")
{
varEmail = Resources.MessageResource.errMemshipCreateUserEmail.ToString();
}
else
{
varEmail = txtEmail.Text;
}
int roleid = objRole.Get_By_RoleName(varRoleName);
int status;
objOrganization = objOrganization.Get_Organization();
objuser.Username = txtUsername.Text.ToString();
objuser.Password = Resources.MessageResource.strDefaultPassword.ToString();
objuser.Roleid = roleid;
objuser.Orgid = objOrganization.Orgid;
objuser.ADEnable = false;
objuser.Enable = true;
objuser.Createdatetime = DateTime.Now.ToString();
status = objuser.Insert();
if (status == 1)
{
// Create Mstatus field to send in Membership.CreateUser function as Out Variable for creating Membership User database
MembershipCreateStatus Mstatus = default(MembershipCreateStatus);
// Call Membership.CreateUser function to create Membership user
Membership.CreateUser(txtUsername.Text.ToString().Trim(), Resources.MessageResource.strDefaultPassword.ToString(), varEmail, "Project Name", "Helpdesk", true, out Mstatus);
// Call Roles.AddUserToRole Function to Add User To Role
Roles.AddUserToRole(txtUsername.Text.ToString().Trim(), varRoleName);
// Declare Local Variable Userid to fetch userid of newly created user
// Create Object objUserLogin of UserLogin_mst()Class
objuser = new UserLogin_mst();
// Fetch userid of Newly created user and assign to local variable userid by calling function objUserLogin.Get_By_UserName
requesterid = objuser.Get_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid);
// If userid not equal to 0 then we get userid of Newly created user otherwise error Occured
ContactInfo_mst objContactInfo = new ContactInfo_mst();
objContactInfo.Userid = requesterid;
objContactInfo.Emailid = varEmail;
objContactInfo.Firstname = txtUsername.Text.ToString();
objContactInfo.Lastname = txtUsername.Text.ToString();
objContactInfo.Insert();
}
}
#endregion
#region If User is Not to be Created
else if (ViewState["UserCreate"].ToString() == "notcreate")
{
// FlagUserStatus = false;
}
#endregion
#endregion
ObjChange.Active = true;
ObjChange.Statusid = Convert.ToInt32(drpStatus.SelectedValue);
ObjChange.Categoryid = Convert.ToInt32(drpCategory.SelectedValue);
ObjChange.Subcategoryid = Convert.ToInt32(drpSubcategory.SelectedValue);
///ObjChange.Technician = "";
ObjChange.Title = txtTitle.Text;
ObjChange.Description = txtDescription.Text;
ObjChange.Createdtime = DateTime.Now.ToString();
ObjChange.Changetype = Convert.ToInt32(drpchangetype.SelectedValue);
ObjChange.Approvalstatus = "Send For Approval";
MembershipUser user = Membership.GetUser();
string username = user.UserName.ToString();
objOrganization = objOrganization.Get_Organization();
ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(username, objOrganization.Orgid);
int userid = Convert.ToInt32(ObjUserLogin.Userid);
ObjChange.CreatedByID = userid;
//////////change doneby meenakshi
objservice = objservice.Get_By_id(Convert.ToInt32(drpservices.SelectedValue));
if (objservice.servicename != null)
{
ObjChange.servicename = objservice.servicename;
}
else
{
ObjChange.servicename = "";
}
////////end
ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(txtUsername.Text, objOrganization.Orgid);
ObjChange.Requestedby = ObjUserLogin.Userid;
//ObjChange.Priority = Convert.ToInt32(drpPriority.SelectedValue);
ObjChange.Insert();
int changeid = ObjChange.Get_Current_Changeid();
for (int i = ListAsset.Items.Count - 1; i >= 0; i--)
{
if (ListAsset.Items[i].Selected == true)
{
Objincludeaasetchange.Assetid = Convert.ToInt32(ListAsset.Items[i].Value);
Objincludeaasetchange.Changeid = changeid;
Objincludeaasetchange.Insert();
}
}
objIncidentToChange.Changeid = changeid;
objIncidentToChange.Incidentid = Convert.ToInt32(Session["incidentid"]);
objIncidentToChange.Insert();
int changetype = Convert.ToInt32(ObjChange.Changetype);
objSentEmailToChange.SentMailToChangeCommittee(changeid, changetype);
ScriptManager.RegisterStartupScript(this, this.GetType(), "Close()", "Close();", true);
}
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
{
# 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);
/////////////////////////////////////////////change in status done by meenakshi 3rd oct
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 = "Closed";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusApproval, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Approved";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusApproved, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Planning";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusPlanning, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Testing";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusTesting, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Release";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusRelease, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Implemented";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusImplemented, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Approval";
ObjChangeHistory.Insert();
}
result = String.Compare(StrStatusString, StrStatusCompleted, true);
if (result == 0)
{
ObjChangeHistory.Changeid = changeid;
ObjChangeHistory.Operationownerid = userid;
ObjChangeHistory.Operation = "Rejected";
ObjChangeHistory.Insert();
}
#endregion
/////////////////////////////////////////end
#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
////////////////////////////////////////////////////////////////change done by meenakshi
//#region If serviceeffected value is changed,Insert into ChangeHistoryDiff table
//if (ObjChange.servicename!= Convert.ToInt32(drpserviceeffect.SelectedValue))
//{
// columnName = Resources.MessageResource.strColumnserviceeffected.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
////////////////////////////////////////////////////////////////end
}
#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]);
//////change done by meenakshi
objservice = objservice.Get_By_id(Convert.ToInt32(drpserviceeffect.SelectedValue));
ObjChange.servicename = objservice.servicename;
//ObjChange.servicename = drpserviceeffect.SelectedValue;
/////end
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 buttonadd_click(object sender, EventArgs e)
{
/////Add Exception handilng try catch change by vishal 21-05-2012
try
{
#region Find Userid of User who is Requesting to log a call
#region If User Already Exist
if (ViewState["UserCreate"].ToString() == "Exist")
{
objOrganization = objOrganization.Get_Organization();
ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid);
if (ObjUserLogin.Userid != 0)
{
requesterid = ObjUserLogin.Userid;
}
}
#endregion
#region If New User is to be Created
else if (ViewState["UserCreate"].ToString() == "create")
{
string varEmail = "";
string varRoleName = Resources.MessageResource.BasicUserRole.ToString();
if (txtEmail.Text == "")
{
varEmail = Resources.MessageResource.errMemshipCreateUserEmail.ToString();
}
else
{
varEmail = txtEmail.Text;
}
int roleid = objRole.Get_By_RoleName(varRoleName);
int status;
objOrganization = objOrganization.Get_Organization();
objuser.Username = txtUsername.Text.ToString();
objuser.Password = Resources.MessageResource.strDefaultPassword.ToString();
objuser.Roleid = roleid;
objuser.Orgid = objOrganization.Orgid;
objuser.ADEnable = false;
objuser.Enable = true;
objuser.Createdatetime = DateTime.Now.ToString();
status = objuser.Insert();
if (status == 1)
{
// Create Mstatus field to send in Membership.CreateUser function as Out Variable for creating Membership User database
MembershipCreateStatus Mstatus = default(MembershipCreateStatus);
// Call Membership.CreateUser function to create Membership user
Membership.CreateUser(txtUsername.Text.ToString().Trim(), Resources.MessageResource.strDefaultPassword.ToString(), varEmail, "Project Name", "Helpdesk", true, out Mstatus);
// Call Roles.AddUserToRole Function to Add User To Role
Roles.AddUserToRole(txtUsername.Text.ToString().Trim(), varRoleName);
// Declare Local Variable Userid to fetch userid of newly created user
// Create Object objUserLogin of UserLogin_mst()Class
objuser = new UserLogin_mst();
// Fetch userid of Newly created user and assign to local variable userid by calling function objUserLogin.Get_By_UserName
requesterid = objuser.Get_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid);
// If userid not equal to 0 then we get userid of Newly created user otherwise error Occured
ContactInfo_mst objContactInfo = new ContactInfo_mst();
objContactInfo.Userid = requesterid;
objContactInfo.Emailid = varEmail;
objContactInfo.Firstname = txtUsername.Text.ToString();
objContactInfo.Lastname = txtUsername.Text.ToString();
objContactInfo.Insert();
}
}
#endregion
#region If User is Not to be Created
else if (ViewState["UserCreate"].ToString() == "notcreate")
{
// FlagUserStatus = false;
}
#endregion
#endregion
ObjChange.Active = true;
ObjChange.Statusid = Convert.ToInt32(drpStatus.SelectedValue);
ObjChange.Categoryid = Convert.ToInt32(drpCategory.SelectedValue);
ObjChange.Subcategoryid = Convert.ToInt32(drpSubcategory.SelectedValue);
// ObjChange.Technician =Convert.ToInt32(drpTechnician.SelectedValue);
ObjChange.Title = txtTitle.Text;
ObjChange.Description = txtDescription.Text;
ObjChange.Createdtime = DateTime.Now.ToString();
ObjChange.Changetype = Convert.ToInt32(drpchangetype.SelectedValue);
ObjChange.Approvalstatus = "Send For Approval";
MembershipUser user = Membership.GetUser();
string username = user.UserName.ToString();
objOrganization = objOrganization.Get_Organization();
ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(username, objOrganization.Orgid);
int userid = Convert.ToInt32(ObjUserLogin.Userid);
ObjChange.CreatedByID = userid;
//////////change doneby meenakshi
objservice = objservice.Get_By_id(Convert.ToInt32(drpservices.SelectedValue));
if (objservice.servicename != null)
{
ObjChange.servicename = objservice.servicename;
}
else
{
ObjChange.servicename = "";
}
////////end
ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(txtUsername.Text, objOrganization.Orgid);
ObjChange.Requestedby = ObjUserLogin.Userid;
// ObjChange.Priority = Convert.ToInt32(drpPriority.SelectedValue);
ObjChange.Insert();
int changeid = ObjChange.Get_Current_Changeid();
for (int i = ListAsset.Items.Count - 1; i >= 0; i--)
{
if (ListAsset.Items[i].Selected == true)
{
Objincludeaasetchange.Assetid = Convert.ToInt32(ListAsset.Items[i].Value);
Objincludeaasetchange.Changeid = changeid;
Objincludeaasetchange.Insert();
}
}
ObjChangeHistory.Changeid = changeid;
// ObjChangeHistory.Description = "create";
ObjChangeHistory.Operation = "create";
ObjChangeHistory.Operationownerid = ObjUserLogin.Userid;
ObjChangeHistory.Insert();
int changetype = Convert.ToInt32(drpchangetype.SelectedValue);
objSentEmailToChange.SentMailToChangeCommittee(changeid, changetype);
Response.Redirect("~/Change/EditChange.aspx?" + changeid + " ");
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
public int Update_Service_mst_By_id(Service_mst objService)
{
return (int)ExecuteNonQuery(Sp_Service_Update, new object[] { objService.servicename, objService.Serviceid, objService.Description });
}
public int Insert_Service_mst(Service_mst objService)
{
return (int)ExecuteNonQuery(Sp_Service_Insert, new object[] { objService.servicename, objService.Serviceid, objService.Description });
}
public object GenerateService_mstObject(ref IDataReader returnData)
{
Service_mst obj = new Service_mst();
while (returnData.Read())
{
obj.Serviceid = (int)returnData["serviceid"];
obj.servicename = (string)returnData["servicename"];
obj.Description = (string)returnData["Description"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateService_mstCollection(ref IDataReader returnData)
{
BLLCollection<Service_mst> col = new BLLCollection<Service_mst>();
while (returnData.Read())
{
Service_mst obj = new Service_mst();
obj.Serviceid = (int)returnData["serviceid"];
obj.Description = (string)returnData["description"];
obj.servicename = (string)returnData["servicename"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
