protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
long lngCustomerId = 0;
string strUniqueNo = "", strAltNo = "", strValidNumberCus = "";
bool blnFlagSMSCus = false;
string strCustomerMessage = "";
if ((ddlProductDiv.SelectedIndex != 0) && (txtQuantity.Text != "") && (txtComplaintDetails.Text != ""))
{
CreateRow();
}
if (!blnFlag)
{
DataSet dsTemp = (DataSet)ViewState["ds"];
if (dsTemp.Tables[0].Rows.Count > 0)
{
objCallRegistration.Type = "INSERT_UPDAT_CUSTOMER_DATA";
objCallRegistration.CustomerId = int.Parse(hdnCustomerId.Value);
objCallRegistration.UpdateCustDeatil = "N";
objCallRegistration.Active_Flag = "1";
objCallRegistration.Prefix = ddlPrefix.SelectedValue.ToString();
objCallRegistration.FirstName = txtFirstName.Text.Trim();
objCallRegistration.MiddleName = txtMiddleName.Text.Trim(); // Bhawesh 11 Feb 13
objCallRegistration.LastName = txtLastName.Text.Trim();
objCallRegistration.Customer_Type = "O"; // for web form outside customer
objCallRegistration.Company_Name = txtCompanyName.Text.Trim();
objCallRegistration.Address1 = txtAdd1.Text.ToString();
objCallRegistration.Address2 = txtAdd2.Text.ToString();
objCallRegistration.Landmark = txtLandmark.Text.Trim();
objCallRegistration.PinCode = txtPinCode.Text.Trim();
objCallRegistration.Country = "1"; //For country india
objCallRegistration.State = ddlState.SelectedValue.ToString();
objCallRegistration.City = ddlCity.SelectedValue.ToString();
if (ddlCity.SelectedValue.ToString() == "0")
{
objCallRegistration.CityOther = txtOtherCity.Text.Trim();
}
else
{
objCallRegistration.CityOther = null;
}
objCallRegistration.Language = "4";
objCallRegistration.Email = txtEmail.Text.Trim();
if ((txtContactNo.Text.Trim().Substring(0, 1) != "0") && (txtContactNo.Text.Trim().Length == 10))
{
objCallRegistration.UniqueContact_No = "0" + txtContactNo.Text.Trim();
}
else
{
objCallRegistration.UniqueContact_No = txtContactNo.Text.Trim();
}
if (txtAltConatctNo.Text.Trim() == "")
{
txtAltConatctNo.Text = txtContactNo.Text.Trim();
}
if (txtAltConatctNo.Text.Trim() != "")
{
if ((txtAltConatctNo.Text.Trim().Substring(0, 1) != "0") && (txtAltConatctNo.Text.Trim().Length == 10))
{
objCallRegistration.AltTelNumber = "0" + txtAltConatctNo.Text.Trim();
}
else
{
objCallRegistration.AltTelNumber = txtAltConatctNo.Text.Trim();
}
}
else
{
objCallRegistration.AltTelNumber = txtAltConatctNo.Text.Trim();
}
if (txtExtension.Text.Trim() == "")
{
objCallRegistration.Extension = 0;
}
else
{
objCallRegistration.Extension = int.Parse(txtExtension.Text.Trim());
}
// BP : 28 dec 12
int SCNo = Convert.ToInt32(TxtSCName.Attributes["SC_SNo"]);
if (SCNo == 0)
{
objCallRegistration.EmpCode = "customer";
}
else
{
objCallRegistration.EmpCode = TxtSCName.Text.Trim();
}
objCallRegistration.SaveCustomerData();
if (objCallRegistration.ReturnValue == 1)
{
lngCustomerId = objCallRegistration.CustomerId;
}
ArrayList arrListFiles = new ArrayList();
//Inserting DraftComplaintDetails
if (lngCustomerId > 0)
{
//uploading Files to Server on Folder Docs/Customer
strFileSavePath = ConfigurationSettings.AppSettings["CustomerFilePath"].ToString();
dTableFile = (DataTable)ViewState["dTableFile"];
if (flUpload.Value != "")
{
try
{
if (!Directory.Exists(strFileSavePath))
{
Directory.CreateDirectory(Server.MapPath(strFileSavePath));
}
strvFileName = flUpload.Value;
strFileName = Path.GetFileName(strvFileName);
strExt = Path.GetExtension(strvFileName);
strFileName = Path.GetFileNameWithoutExtension(strvFileName) + "_" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
strFileName = strFileName + strExt;
DataRow dRow = dTableFile.NewRow();
dRow["FileName"] = strFileName;
dTableFile.Rows.Add(dRow);
ViewState["dTableFile"] = dTableFile;
flUpload.PostedFile.SaveAs(Server.MapPath(strFileSavePath + strFileName));
}
catch (Exception ex)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
dTableFile = (DataTable)ViewState["dTableFile"];
for (intCnt = 0; intCnt < dTableFile.Rows.Count; intCnt++)
{
arrListFiles.Add(dTableFile.Rows[intCnt]["FileName"].ToString());
}
//Uploading Files End
//Create Temp table for Complaint + SC Name
DataTable dTableTemp = new DataTable();
DataColumn dColNo = new DataColumn("SNo");
DataColumn dColComplaintNo = new DataColumn("ComplaintRefNo");
DataColumn dColProd = new DataColumn("ProductDivision");
dTableTemp.Columns.Add(dColNo);
dTableTemp.Columns.Add(dColComplaintNo);
dTableTemp.Columns.Add(dColProd);
// BP : 28 dec 12
int SCSNo = Convert.ToInt32(TxtSCName.Attributes["SC_SNo"]);
if (SCSNo == 0)
{
objCallRegistration.EmpCode = "customer";
}
else
{
objCallRegistration.EmpCode = TxtSCName.Text.Trim();
}
for (int intCnt = 0; intCnt < dsTemp.Tables[0].Rows.Count; intCnt++)
{
objCallRegistration.CustomerId = lngCustomerId;
objCallRegistration.ModeOfReceipt = dsTemp.Tables[0].Rows[intCnt]["ModeOfReceipt_SNo"].ToString();
objCallRegistration.ProductDivision = dsTemp.Tables[0].Rows[intCnt]["ProductDivision_Sno"].ToString();
objCallRegistration.ProductLine = dsTemp.Tables[0].Rows[intCnt]["ProductLine_Sno"].ToString();
objCallRegistration.Language = dsTemp.Tables[0].Rows[intCnt]["Language_Sno"].ToString();
objCallRegistration.IsFiles = dsTemp.Tables[0].Rows[intCnt]["IsFiles"].ToString();
objCallRegistration.Quantity = int.Parse(dsTemp.Tables[0].Rows[intCnt]["Quantity"].ToString());
objCallRegistration.NatureOfComplaint = dsTemp.Tables[0].Rows[intCnt]["NatureOfComplaint"].ToString();
objCallRegistration.InvoiceDate = dsTemp.Tables[0].Rows[intCnt]["InvoiceDate"].ToString();
objCallRegistration.PurchasedDate = dsTemp.Tables[0].Rows[intCnt]["PurchasedDate"].ToString();
objCallRegistration.PurchasedFrom = dsTemp.Tables[0].Rows[intCnt]["PurchasedFrom"].ToString();
objCallRegistration.AppointmentReq = dsTemp.Tables[0].Rows[intCnt]["AppointmentReq"].ToString();
objCallRegistration.IsSRF = dsTemp.Tables[0].Rows[intCnt]["SRF"].ToString();
objCallRegistration.Frames = dsTemp.Tables[0].Rows[intCnt]["Frames"].ToString();
objCallRegistration.InvoiceNum = dsTemp.Tables[0].Rows[intCnt]["InvoiceNum"].ToString();
objCallRegistration.State = ddlState.SelectedValue;
objCallRegistration.City = ddlCity.SelectedValue;
if (ddlCity.SelectedValue.ToString() == "0")
{
objCallRegistration.CityOther = txtOtherCity.Text.Trim();
}
else
{
objCallRegistration.CityOther = null;
}
objCallRegistration.BusinessLine = "2";
objCallRegistration.Type = "INSERT_COMPLAINT_DATA_BY_CUSTOMER";
objCallRegistration.SaveComplaintData();
if (objCallRegistration.ReturnValue == -1)
{
//Writing Error message to File using CommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), objCallRegistration.MessageOut.ToString());
}
if (objCallRegistration.ReturnValue == 1)
{
#region Save FileData
RequestRegistration objCallreg = new RequestRegistration();
//Saving FileNames to DB
for (int i = 0; i < arrListFiles.Count; i++)
{
objCallreg.EmpCode = "customer";
objCallreg.Type = "INSERT_COMPLAINT_FILES_DATA";
objCallreg.SaveFilesWithComplaintno(objCallRegistration.Complaint_RefNoOUT, arrListFiles[i].ToString());
}
objCallreg = null;
//End Saving
#endregion Save FileData
# region add a coopy in Feedback Table (For Reporting Purpose only) Bhawesh 18 Apr 13
objwscfeedback.Prefix = objCallRegistration.Prefix;
objwscfeedback.FirstName = objCallRegistration.FirstName;
objwscfeedback.MiddleName = objCallRegistration.MiddleName;
objwscfeedback.LastName = objCallRegistration.LastName;
objwscfeedback.Address = objCallRegistration.Address1 + " " + objCallRegistration.Address2;
objwscfeedback.StateSNo = Convert.ToInt32(objCallRegistration.State);
objwscfeedback.CitySNo = Convert.ToInt32(objCallRegistration.City);
objwscfeedback.CompanyName = objCallRegistration.Company_Name;
objwscfeedback.ContactNo = objCallRegistration.UniqueContact_No;
objwscfeedback.Email = objCallRegistration.Email;
objwscfeedback.FeedBackByASCID = Convert.ToInt32(TxtSCName.Attributes["SC_SNo"]);
objwscfeedback.FeedbackDesc = "ComplaintNo: " + objCallRegistration.Complaint_RefNoOUT + ";Detail: " + objCallRegistration.NatureOfComplaint;
objwscfeedback.FeedBackTypeID = Convert.ToInt32(ddlFeedbackType.SelectedValue);
objwscfeedback.ProddivSNO = Convert.ToInt32(objCallRegistration.ProductDivision);
objwscfeedback.ProdLineSNO = Convert.ToInt32(objCallRegistration.ProductLine); // Bhawesh 8-4-13
try
{
String StrMsg = objwscfeedback.SaveData("INSERT_FEEDBACK");
}
catch (Exception exx)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), exx.StackTrace.ToString() + "-->" + "Error in Feedback Insert portion " + exx.Message.ToString());
}
#endregion
#region SMS Store to SMS_TRANS Live 4 March 13
try
{
strUniqueNo = txtContactNo.Text.Trim();
strAltNo = txtAltConatctNo.Text.Trim();
if (CommonClass.ValidateMobileNumber(strUniqueNo, ref strValidNumberCus))
{
blnFlagSMSCus = true;
}
else if (CommonClass.ValidateMobileNumber(strAltNo, ref strValidNumberCus))
{
blnFlagSMSCus = true;
}
if (blnFlagSMSCus)
{
strCustomerMessage = "Your Complaint No :" + objCallRegistration.Complaint_RefNoOUT + " will be attended soon. Preserve this no for future communications.";
CommonClass.SendSMS(strValidNumberCus, objCallRegistration.Complaint_RefNoOUT, lngCustomerId.ToString(), DateTime.Now.Date.ToString("yyyyMMdd"), "CGL", strCustomerMessage, strCustomerMessage, "CUS");
}
}
catch (Exception ex)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
#endregion SMS Store to SMS_TRANS
#region For Display Final Grid
//Creating row for temp table
DataRow dRowTEMP = dTableTemp.NewRow();
dRowTEMP["SNo"] = dTableTemp.Rows.Count + 1;
dRowTEMP["ProductDivision"] = dsTemp.Tables[1].Rows[intCnt]["ProductDivision"].ToString();
dRowTEMP["ComplaintRefNo"] = objCallRegistration.Complaint_RefNoOUT;
dTableTemp.Rows.Add(dRowTEMP);
#endregion For Display Final Grid
}
}
LblMsgg.Text = "Thank you for submitting your Complaint we will back to you soon. Your complaint no is " + objCallRegistration.Complaint_RefNoOUT + " .<br/> "
+ "Preserve this no. for future communications.";
//Assigning DataSource to Grid
gvFinal.DataSource = dTableTemp;
gvFinal.DataBind();
//End
//Clear Files For File Upload Grid
dTableFile = (DataTable)ViewState["dTableFile"];
dTableFile.Rows.Clear();
ViewState["dTableFile"] = dTableFile;
BindGridFiles();
gvFiles.Visible = false;
//End
//Clear Product Grid
dsProduct = (DataSet)ViewState["ds"];
dsProduct.Tables[1].Rows.Clear();
ViewState["ds"] = dsProduct;
BindGridView();
gvComm.Visible = false;
//End
btnSubmit.CausesValidation = true;
tableResult.Visible = true;
btnSubmit.Enabled = false;
btnCancel.Enabled = false;
ClearControls();
lblMsg.Text = "";
}
}
}
else
{
lblMsg.Text = "Product division " + ddlProductDiv.SelectedItem.Text + " is already added. You can update data from above listing.";
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
objCallRegistration.Type = "REGISTER_MTO_COMPLAINT";
// objCallRegistration.CustomerID = int.Parse(hdnCustomerId.Value);
// save additional info for RSD
//if (ddlProductDiv.SelectedValue == "31") //31 live
// objRequestReg.SaveWebRequestMTO(hdnwebreqno.Value, txtequipname.Text, txtcoachNo.Text, txtTrainNo.Text, txtAvailblty.Text, txtCommissionDate.Text, txtDateofReporting.Text, txtPoDate.Text);
objCallRegistration.Prefix = ddlPrefix.SelectedValue.ToString();
objCallRegistration.FirstName = txtFirstName.Text.Trim();
objCallRegistration.MiddleName = txtMiddleName.Text.Trim();
objCallRegistration.LastName = txtLastName.Text.Trim();
objCallRegistration.CompanyName = txtCompanyName.Text.Trim();
objCallRegistration.OEMCustomerName = TxtOEMCustName.Text.Trim();
objCallRegistration.Address1 = txtAdd1.Text.ToString();
objCallRegistration.Address2 = txtAdd2.Text.ToString();
objCallRegistration.Landmark = txtLandmark.Text.Trim();
objCallRegistration.CountrySNo = Convert.ToInt32(ddlCountry.SelectedValue);
objCallRegistration.CountryName = ddlCountry.SelectedItem.Text;
objCallRegistration.City = TxtCity.Text.Trim();
objCallRegistration.Email = txtEmail.Text.Trim();
objCallRegistration.ContactNo = txtContactNo.Text.Trim();
objCallRegistration.AlternateContactNo = txtAltConatctNo.Text.Trim();
objCallRegistration.Extension = txtExtension.Text.Trim();
objCallRegistration.EmpCode = Membership.GetUser().UserName.ToString();
objCallRegistration.ProductDivSNo = Convert.ToInt32(ddlProductDiv.SelectedValue);
objCallRegistration.ProductLineSno = Convert.ToInt32(ddlProductLine.SelectedValue);
objCallRegistration.ProductSNo = Convert.ToInt32(ddlProduct.SelectedValue);
objCallRegistration.InvoiceNo = txtInvoiceNum.Text.Trim();
objCallRegistration.Remarks = txtComplaintDetails.Text.Trim();
objCallRegistration.Remarks = txtComplaintDetails.Text.Trim();
objCallRegistration.InvoiceNo = txtInvoiceNum.Text.Trim();
objCallRegistration.PurchaseDate = txtxPurchaseDate.Text.Trim();
objCallRegistration.ManufactureDate = txtPoDate.Text.Trim();
objCallRegistration.Warranty_Expiry_date = txtWarrantyDate.Text.Trim();
objCallRegistration.DateOfCommission = txtCommissionDate.Text.Trim();
objCallRegistration.DateOfReporting = txtDateofReporting.Text.Trim();
objCallRegistration.ProductSRNo = txtPrdSRNo.Text.Trim();
objCallRegistration.DispatchDate = txtDateofDispatch.Text.Trim();
objCallRegistration.EquipmentName = txtequipname.Text.Trim();
objCallRegistration.TrainNo = txtTrainNo.Text.Trim();
objCallRegistration.CoachNo = txtcoachNo.Text.Trim();
objCallRegistration.AvailablityDepot = txtAvailblty.Text.Trim();
objCallRegistration.RegisterMTOComplaint();
ArrayList arrListFiles = new ArrayList();
if (objCallRegistration.CustomerID > 0)
{
#region Upload file
strFileSavePath = ConfigurationSettings.AppSettings["CustomerFilePath"].ToString();
dTableFile = (DataTable)ViewState["dTableFile"];
if (flUpload.Value != "")
{
try
{
if (!Directory.Exists(strFileSavePath))
{
Directory.CreateDirectory(Server.MapPath(strFileSavePath));
}
strvFileName = flUpload.Value;
strFileName = Path.GetFileName(strvFileName);
strExt = Path.GetExtension(strvFileName);
strFileName = Path.GetFileNameWithoutExtension(strvFileName) + "_" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
strFileName = strFileName + strExt;
DataRow dRow = dTableFile.NewRow();
dRow["FileName"] = strFileName;
dTableFile.Rows.Add(dRow);
ViewState["dTableFile"] = dTableFile;
flUpload.PostedFile.SaveAs(Server.MapPath(strFileSavePath + strFileName));
}
catch (Exception ex)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
dTableFile = (DataTable)ViewState["dTableFile"];
for (intCnt = 0; intCnt < dTableFile.Rows.Count; intCnt++)
{
arrListFiles.Add(dTableFile.Rows[intCnt]["FileName"].ToString());
}
//Uploading Files End
#endregion Upload file
//Create Temp table for Complaint + SC Name
DataTable dTableTemp = new DataTable();
DataColumn dColNo = new DataColumn("SNo");
DataColumn dColComplaintNo = new DataColumn("ComplaintRefNo");
DataColumn dColProd = new DataColumn("ProductDivision");
dTableTemp.Columns.Add(dColNo);
dTableTemp.Columns.Add(dColComplaintNo);
dTableTemp.Columns.Add(dColProd);
if (objCallRegistration.ReturnValue == 1)
{
#region Save FileData
RequestRegistration objCallreg = new RequestRegistration();
//Saving FileNames to DB
for (int i = 0; i < arrListFiles.Count; i++)
{
objCallreg.EmpCode = Membership.GetUser().UserName.ToString();
objCallreg.Type = "INSERT_COMPLAINT_FILES_DATA";
objCallreg.SaveFilesWithComplaintno(objCallRegistration.Complaint_RefNoOUT, arrListFiles[i].ToString());
}
objCallreg = null;
//End Saving
#endregion Save FileData
#region For Display Final Grid
//Creating row for temp table
DataRow dRowTEMP = dTableTemp.NewRow();
dRowTEMP["SNo"] = dTableTemp.Rows.Count + 1;
dRowTEMP["ProductDivision"] = ddlProductDiv.SelectedItem.Text;
dRowTEMP["ComplaintRefNo"] = objCallRegistration.Complaint_RefNoOUT;
dTableTemp.Rows.Add(dRowTEMP);
#endregion
}
//Assigning DataSource to Grid
gvFinal.DataSource = dTableTemp;
gvFinal.DataBind();
//End
//Clear Files For File Upload Grid
dTableFile = (DataTable)ViewState["dTableFile"];
dTableFile.Rows.Clear();
ViewState["dTableFile"] = dTableFile;
gvFiles.Visible = false;
btnSubmit.CausesValidation = true;
tableResult.Visible = true;
btnSubmit.Enabled = false;
btnCancel.Enabled = false;
ClearControls();
ClearComplaintDetails();
lblMsg.Text = "";
}
#endregion
}
