protected void btnSave_Click(object sender, EventArgs e) { QCParameterBL objQCParameterBL = new QCParameterBL(); objQCParameterBL.SaveQcParameters("1", txtNpaRangeFrom.Text, NPARangeTo.Text, NXXRangeFrom.Text, NXXRangeTo.Text, OtherNPA.Text, OtherNXX.Text, NPA_NXX_combos.Text, Last_four_digits.Text, PRICE_Below.Text, PRICE_Above.Text, ModelPriorTo.Text, ModelTo.Text, MileageGreaterthan.Text, MileageLessThan.Text, LeadDatePriorTo.Text, txtFuture_date.Text); lblErrUpdated.Text = "Qc Parameters Updated Successfully"; lblErrUpdated.Visible = true; mpealteruserUpdated.Show(); MpeQcPopUp.Hide(); }
protected void lbtnQcShow_Click(object sender, EventArgs e) { QCParameterBL objQCParameterBL = new QCParameterBL(); DataSet ds = objQCParameterBL.GetQCParmeter("1"); if (ds.Tables[0].Rows.Count > 0) { txtNpaRangeFrom.Text = ds.Tables[0].Rows[0]["NPARangeFrom"].ToString(); NPARangeTo.Text = ds.Tables[0].Rows[0]["NPARangeTo"].ToString(); NXXRangeFrom.Text = ds.Tables[0].Rows[0]["NXXRangeFrom"].ToString(); NXXRangeTo.Text = ds.Tables[0].Rows[0]["NXXRangeTo"].ToString(); OtherNPA.Text = ds.Tables[0].Rows[0]["OtherNPA"].ToString(); OtherNXX.Text = ds.Tables[0].Rows[0]["OtherNXX"].ToString(); NPA_NXX_combos.Text = ds.Tables[0].Rows[0]["NPA_NXX_combos"].ToString(); Last_four_digits.Text = ds.Tables[0].Rows[0]["Last_four_digits"].ToString(); PRICE_Below.Text = ds.Tables[0].Rows[0]["PRICE_Below"].ToString(); PRICE_Above.Text = ds.Tables[0].Rows[0]["PRICE_Above"].ToString(); ModelPriorTo.Text = ds.Tables[0].Rows[0]["ModelPriorTo"].ToString(); ModelTo.Text = ds.Tables[0].Rows[0]["ModelTo"].ToString(); MileageGreaterthan.Text = ds.Tables[0].Rows[0]["MileageGreaterthan"].ToString(); MileageLessThan.Text = ds.Tables[0].Rows[0]["MileageLessThan"].ToString(); LeadDatePriorTo.Text = ds.Tables[0].Rows[0]["LeadDatePriorTo"].ToString(); txtFuture_date.Text = ds.Tables[0].Rows[0]["Future_date"].ToString(); } MpeQcPopUp.Show(); }
protected void btnUpload_Click(object sender, EventArgs e) { //LeadsInfo objLeadsInfo=new LeadsInfo(); SmtpClient smtpClient = new SmtpClient(); MailMessage mymail = new MailMessage(); clsMailFormats objClsMailformat = new clsMailFormats(); DbTransaction Transaction = null; DbConnection Connection = null; try { SalesfilesUpload(Convert.ToInt32(ViewState["Count"]), ViewState["FileName"].ToString()); for (int index = 0; index < grdIntroInfo.Rows.Count; index++) { LeadsUploadExcel(index, ref Transaction, ref Connection); } if (Count > 0) { //string strSrc = Server.MapPath("SalesUpload\\" + ddlCampaigns.SelectedItem.Text + "\\"); ///Server.MapPath("SalesUpload\\" + ddlCampaigns.SelectedItem.Text + "\\" + FILENAME) System.IO.FileInfo dirInfo = new System.IO.FileInfo(Session["FileName"].ToString()); QCParameterBL objQCParameterBL = new QCParameterBL(); DataSet ds = objQCParameterBL.UpdateLeadsQcStatusUpdate(Session["FileId"].ToString()); //string filePath = strSrc; //string sAttach = filePath + Session["FileName"].ToString(); //mymail.Attachments.Add(new Attachment(sAttach)); //objFileType = (File_Type_Info)Session["Email_Sales"]; //if (objFileType.Email_To != "") //{ // mymail.To.Add(objFileType.Email_To); //} //MailAddress fromAddress = new MailAddress(Session[GenValidations.Email.ToString()].ToString()); //mymail.CC.Add(Session[GenValidations.Email.ToString()].ToString()); //mymail.Bcc.Add(objFileType.Email_bCc); //mymail.From = fromAddress; //mymail.Subject = Session["LocName"].ToString() + " " + ddlCampaigns.SelectedItem.Text + " " + txtFrom.Text + " Sales Uploaded On " + GenFunc.DateTimeFormat(System.DateTime.Now.ToString()); string s = string.Empty; string SalesMailFile = (Server.MapPath("MailFormats") + @"\Sale Upload Mail Body text.txt"); //objClsMailformat.sendSalesUpload(SalesMailFile,System.DateTime.Now.ToString(),ViewState["Count"].ToString(),txtFrom.Text.ToString(),txtTo.Text.ToString(),Session[GenValidations.USER_NAME].ToString(),ref s) //if (objClsMailformat.sendSalesUpload(SalesMailFile, System.DateTime.Now.ToString(), ViewState["Count"].ToString(), txtFrom.Text.ToString(), Session[GenValidations.USER_NAME].ToString(), ref s)) //{ // //Specify true if it is html message // mymail.IsBodyHtml = true; // mymail.Body = s.ToString(); // smtpClient.Host = "127.0.0.1"; // smtpClient.Port = 25; // smtpClient.Send(mymail); //} //System.IO.File.Delete(Session["SaveLoc"].ToString()); // Total records in the file: 2000 //Duplicates found: 200 //Records uploaded: 1800 //QC passed leads: 1600 //QC failed leads: 200 lblErrorMsg.Text = grdIntroInfo.Rows.Count + " Record Uploaded Successfully </br> " + ds.Tables[0].Rows[0][0].ToString() + " QC Passed <br/> " + (Convert.ToInt32(grdIntroInfo.Rows.Count) - Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString())) + " QC Failed"; btnSubmit.Enabled = true; btnUpload.Enabled = false; grdIntroInfo.DataSource = null; grdIntroInfo.DataBind(); } else { lblErrorMsg.Text = "There are no Rows to Upload"; } } catch (Exception ex) { Transaction.Rollback(); Connection.Close(); lblErrorMsg.Text = "Sales Uploaded, but Mail Could not be Found."; } finally { mymail.Dispose(); smtpClient = null; } }