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;
}
}
