protected void btnAllocate_Click(object sender, EventArgs e) { int intCount = 0; intCallStatus = 10; string assignflag = ""; intAppointment = int.Parse(ddlAppointment.SelectedValue); lblMessage.Text = ""; string strAllRefNo = ""; if (ddlProductDiv.SelectedIndex > 0) { intProductDivision = int.Parse(ddlProductDiv.SelectedValue); } intState = int.Parse(ddlState.SelectedValue); intCity = int.Parse(ddlCity.SelectedValue); if (ddlSC.SelectedValue != "0") { foreach (GridViewRow gvRow in gvFresh.Rows) { // chkChild if (((CheckBox)gvRow.FindControl("chkBxSelect")).Checked == true) { intCount = intCount + 1; objSuspenseAccount.BaseLineId = int.Parse(((HiddenField)gvRow.FindControl("hdnBaselineID")).Value.ToString()); string strRefNo = ((HiddenField)gvRow.FindControl("hdnComplaint_RefNo")).Value.ToString(); objSuspenseAccount.SC_SNo = int.Parse(ddlSC.SelectedValue.ToString()); objSuspenseAccount.EmpID = Membership.GetUser().UserName.ToString(); assignflag = objSuspenseAccount.CheckASCPermission(strRefNo); if (assignflag == "y") { objSuspenseAccount.UpdateCallStatus(); //Code Done By Pravesh To send SMS on Wrong Allocatde Complaints. #region SMS Store to SMS_TRANS try { //If customer no is valid then send message End //If SC no is valid then send message start objSuspenseAccount.Complaint_RefNo = ((HiddenField)gvRow.FindControl("hdnComplaint_RefNo")).Value.ToString(); objCallRegistration.Complaint_RefNoOUT = objSuspenseAccount.Complaint_RefNo; DataSet dsStatus = objSuspenseAccount.GetStatusFromActivityLog(); string strValidNumberCus = "", lngCustomerId = "", strASCMessage = ""; string strValidNumberAsc = "", smsMobNumb = "", strUniqueNo = ""; string strAltNo = "", strCustomerMessage = "", strCity = ""; string strState = "", strTemAdd = "", strTotalSMS = ""; bool blnFlagSMSCus = false, blnFlagSMSASC = false; DataSet dsCustMobNo = objSuspenseAccount.GetCustMobNo(); if (dsCustMobNo.Tables[0].Rows.Count != 0) { strUniqueNo = dsCustMobNo.Tables[0].Rows[0]["UniqueContact_No"].ToString(); strAltNo = dsCustMobNo.Tables[0].Rows[0]["AltTelNumber"].ToString(); lngCustomerId = dsCustMobNo.Tables[0].Rows[0]["CustomerID"].ToString(); } if (CommonClass.ValidateMobileNumber(strUniqueNo, ref strValidNumberCus)) { smsMobNumb = strValidNumberCus; blnFlagSMSCus = true; } else if (CommonClass.ValidateMobileNumber(strAltNo, ref strValidNumberCus)) { smsMobNumb = strValidNumberCus; blnFlagSMSCus = true; } int statusID = 0; foreach (DataRow drw in dsStatus.Tables[0].Rows) { if (int.Parse(drw["StatusId"].ToString()) == 24) { statusID = 24; } } ServiceContractorMaster objSC = new ServiceContractorMaster(); objSC.BindServiceContractorOnSNo(objSuspenseAccount.SC_SNo, "SELECT_INDIVIDUAL_SC_BASED_ON_SCSNO"); //If customer no is valid then send message start if (statusID == 24) { if (blnFlagSMSCus) { //Message for customer strCustomerMessage = "Please Ignore The Previous SMS, Your Complaint No:" + objCallRegistration.Complaint_RefNoOUT + " will now be attended by " + objSC.SCName + "-" + objSC.PhoneNo; CommonClass.SendSMS(smsMobNumb, objCallRegistration.Complaint_RefNoOUT, lngCustomerId, DateTime.Now.Date.ToString("yyyyMMdd"), "CGL", strCustomerMessage, strCustomerMessage, "CUS"); } } else { if (blnFlagSMSCus) { //Message for customer strCustomerMessage = "Your Complaint No:" + objCallRegistration.Complaint_RefNoOUT + " will be attended by " + objSC.SCName + "-" + objSC.PhoneNo; CommonClass.SendSMS(smsMobNumb, objCallRegistration.Complaint_RefNoOUT, lngCustomerId, DateTime.Now.Date.ToString("yyyyMMdd"), "CGL", strCustomerMessage, strCustomerMessage, "CUS"); } } #region SMS For ASC if (objSC.MobileNo != "") { if (CommonClass.ValidateMobileNumber(objSC.MobileNo, ref strValidNumberAsc)) { blnFlagSMSASC = true; } if (blnFlagSMSASC) { //Message for ASC strASCMessage = objCallRegistration.Complaint_RefNoOUT + "-" + ((HiddenField)gvRow.FindControl("hdnUNIT_DESC")).Value.ToString() + "-"; if (bool.Parse(((HiddenField)gvRow.FindControl("hdnAppointmentReq")).Value.ToString())) { strASCMessage += "Y-"; } else { strASCMessage += "N-"; } strASCMessage += ((HiddenField)gvRow.FindControl("hdnLastName")).Value.ToString() + "-" + strUniqueNo; strCity = ((HiddenField)gvRow.FindControl("hdnCity_Desc")).Value.ToString(); strState = ((HiddenField)gvRow.FindControl("hdnState_Desc")).Value.ToString(); strTemAdd = ((HiddenField)gvRow.FindControl("hdnAddress")).Value.ToString(); strTotalSMS = strASCMessage + strTemAdd + " " + strCity + " " + strState; string strASCCityState = ""; int intLen = 0; strASCCityState = strASCMessage + " " + strCity + " " + strState; intLen = strASCCityState.Length; intLen = 159 - intLen; if (strTemAdd.Length > intLen) { strTemAdd = strTemAdd.Substring(0, intLen); } strASCMessage += strTemAdd + " " + strCity + " " + strState; CommonClass.SendSMS(strValidNumberAsc, objCallRegistration.Complaint_RefNoOUT, objSC.SCCode, DateTime.Now.Date.ToString("yyyyMMdd"), "CGL", strASCMessage, strTotalSMS, "ASC"); } } #endregion SMS For ASC //If SC no is valid then send message end } catch (Exception ex) { //Writing Error message to File using CommonClass WriteErrorErrFile method taking arguments as URL of page // trace, error message CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString()); } #endregion SMS Store to SMS_TRANS lblMessage.Visible = true; strAllRefNo = strAllRefNo + strRefNo + ","; } else { lblMessage1.Text = "Can't Allocate Complaint to " + ddlSC.SelectedItem.Text + ".As this Product division is not attach with him."; } } } if (assignflag == "y") { if (ViewState["strUserTypr"] != null) { strUserTypr = ViewState["strUserTypr"].ToString(); objSuspenseAccount.UserName = Membership.GetUser().UserName.ToString(); if (strUserTypr == "CG" || strUserTypr == "CGCE") { intCountRecord = objSuspenseAccount.BindGVSuspensAccount(gvFresh, intProductDivision, intSCNo, intCallStatus, intState, intCity, intAppointment, intCountRecord); } else { intCountRecord = objSuspenseAccount.BindGVSuspensAccountForAllRegion(gvFresh, intProductDivision, intSCNo, intCallStatus, intState, intCity, intAppointment, intCountRecord); } if (gvFresh.Rows.Count == 0) { gvFresh.Visible = false; } if (intCount == 0) { lblMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.RecordUpdated, enuMessageType.UserMessage, true, "Please select any complaint RefNo"); } else { strAllRefNo = strAllRefNo.TrimEnd(','); lblMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.RecordUpdated, enuMessageType.UserMessage, true, "Complaint RefNo " + strAllRefNo + " is allocated to " + ddlSC.SelectedItem.Text); ddlSC.Items.Clear(); ddlSC.Items.Insert(0, new ListItem("Select", "0")); } } else { lblMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.RecordUpdated, enuMessageType.UserMessage, true, "Please click on ‘find button’ to allocate Service Contractor"); } if (gvFresh.Rows.Count > 0) { int intRecord = gvFresh.Rows.Count; lblMessage.Visible = true; tbSearch.Visible = true; tdRowCount.Visible = true; lblRowCount.Text = intCountRecord.ToString(); } else { tdRowCount.Visible = false; tbSearch.Visible = false; } } } }
//method to select data on edit private void BindSelected(int intSCSNo) { lblMessage.Text = ""; txtScCode.Enabled = false; objServiceContractorMaster.BindServiceContractorOnSNo(intSCSNo, "SELECT_INDIVIDUAL_SC_BASED_ON_SCSNO"); txtScCode.Text = objServiceContractorMaster.SCCode; txtScName.Text = objServiceContractorMaster.SCName; txtContactPerson.Text = objServiceContractorMaster.ContactPerson; txtAddOne.Text = objServiceContractorMaster.Address1; txtAddTwo.Text = objServiceContractorMaster.Address2; txtEmail.Text = objServiceContractorMaster.EmailID; txtPhoneNo.Text = objServiceContractorMaster.PhoneNo; txtFaxNo.Text = objServiceContractorMaster.FaxNo; txtMobileNo.Text = objServiceContractorMaster.MobileNo; txtPrefence.Text = objServiceContractorMaster.Prefernce; txtSpecialRemarks.Text = objServiceContractorMaster.SpecialRemarks; for (int intCnt = 0; intCnt < ddlRegion.Items.Count; intCnt++) { if (ddlRegion.Items[intCnt].Value.ToString() == objServiceContractorMaster.RegionSNo.ToString()) { ddlRegion.SelectedIndex = intCnt; } } //showing selected Branch from Database on the base of Region selected if (ddlRegion.SelectedIndex != 0) { objBranchMaster.BindBranchBasedonRegionSNo(ddlBranch, int.Parse(ddlRegion.SelectedValue.ToString())); for (int intCnt = 0; intCnt < ddlBranch.Items.Count; intCnt++) { if (ddlBranch.Items[intCnt].Value.ToString() == objServiceContractorMaster.BranchSNo.ToString()) { ddlBranch.SelectedIndex = intCnt; } } } else { ddlBranch.Items.Clear(); ddlBranch.Items.Insert(0, new ListItem("Select", "0")); } //showing selected weekoffday from database if (ddlState.SelectedValue != null) { for (int intCnt = 0; intCnt < ddlWeeklyOffDay.Items.Count; intCnt++) { if (ddlWeeklyOffDay.Items[intCnt].Value.ToString() == objServiceContractorMaster.WeekOffDay.ToString()) { ddlWeeklyOffDay.SelectedIndex = intCnt; } } } //showing selected state from database // if (ddlState.SelectedValue != null) //{ for (int intCnt = 0; intCnt < ddlState.Items.Count; intCnt++) { if (ddlState.Items[intCnt].Value.ToString() == objServiceContractorMaster.StateSno.ToString()) { ddlState.SelectedIndex = intCnt; } } //} //BINDING CITY FROM DATABASE //RELATIVE TO STATE FROM DATABASE if (ddlState.SelectedIndex != 0) { objCommonClass.BindCity(ddlCity, int.Parse(ddlState.SelectedValue.ToString())); for (int intCnt = 0; intCnt < ddlCity.Items.Count; intCnt++) { if (ddlCity.Items[intCnt].Value.ToString() == objServiceContractorMaster.CitySNo.ToString()) { ddlCity.SelectedIndex = intCnt; } } } else { ddlCity.Items.Clear(); ddlCity.Items.Insert(0, new ListItem("Select", "0")); } // Code for selecting Status as in database for (intCnt = 0; intCnt < rdoStatus.Items.Count; intCnt++) { if (rdoStatus.Items[intCnt].Value.ToString().Trim() == objServiceContractorMaster.ActiveFlag.ToString().Trim()) { rdoStatus.Items[intCnt].Selected = true; } else { rdoStatus.Items[intCnt].Selected = false; } } }