public ActionResult TripEstimate(CustomerInquiryVm customerInquiryVm) { var customerInquiryBO = new CustomerInquiryBO(); var customerInquiry = new CustomerInquiry(); customerInquiry.MobileNo = customerInquiryVm.MobileNo; customerInquiry.EmailID = customerInquiryVm.EmailID; customerInquiry.CustomerName = customerInquiryVm.CustomerName; customerInquiry.InquiryType = UTILITY.CONFIG_INQ_EST; customerInquiry.InquiryDate = DateTime.Now; customerInquiryBO.Save(customerInquiry); TempData["TD:CustomerInquiry"] = customerInquiryVm; bool _IsTripEstimate = false; if (customerInquiryVm.Distance.HasValue) { var fareChartList = customerInquiryBO.GetApproximateFareWEB(customerInquiryVm.Distance.Value, customerInquiryVm.Duration.Value); TempData["TD:FareChartList"] = fareChartList; _IsTripEstimate = true; } return(RedirectToAction("Index", "Dashboard", new { IsTripEstimate = _IsTripEstimate })); }
public void CanCustomerInquiryInsert() { int isSaved = 0; using (var context = new CustomerInquiryRepository(new UnitOfWork())) { var cust = new CustomerInquiry { cust_name = "KK", email_addr_txt = "*****@*****.**", //inquiry_id=1, notes = "Jesus is the Savior", ph_nbr = "", rec_crt_by = "KK", rec_crt_ts = DateTime.UtcNow, rec_upd_by = "KK", rec_upd_ts = DateTime.UtcNow }; context.InsertOrUpdate(cust) ; isSaved = context.Save(); Assert.AreEqual(1, isSaved); } }
public void HaveUserResolveConcurrency(CustomerInquiry entity, CustomerInquiry databaseValues, CustomerInquiry resolvedValues) { // Show the current, database, and resolved values to the user and have // them update the resolved values to get the correct resolution. }
public ActionResult HelpDeskSave(CustomerInquiry customer) { customer.InquiryDate = DateTime.Now; var result = new CustomerInquiryBO().SaveContactUs(customer); if (result) { if (customer.InquiryType == 1503) { TempData["DisplayMessage"] = "Your request is submitted successfully"; } else if (customer.InquiryType == 1504) { TempData["DisplayMessage"] = "Thanks for your feedback"; } else { TempData["DisplayMessage"] = "Our customer support team will revert shortly"; } } //customersupport:our customer support team will revert shortly; //contactus:your request is submitted succesfully; //feedback:Thanks for your feedback; var emailResult = SendMessageToPickC(customer); return(RedirectToAction("HelpDesk", "Dashboard")); }
public ActionResult Inquiry([Bind(Include = "inquiry_id,cust_name,email_addr_txt,ph_nbr,notes,rec_crt_ts,rec_crt_by,rec_upd_by,rec_upd_ts")] CustomerInquiry customerInquiry) { if (ModelState.IsValid) { db.InsertOrUpdate(customerInquiry); db.Save(); DisplaySuccessMessage("Success! You have sent a message."); return(RedirectToAction("Contact")); } DisplayErrorMessage(); return(View(customerInquiry)); }
public void InsertOrUpdate(CustomerInquiry customerinquiry) { if (customerinquiry.inquiry_id == default(long)) { // New entity context.CustomerInquiries.Add(customerinquiry); } else { // Existing entity context.Entry(customerinquiry).State = System.Data.Entity.EntityState.Modified; } }
/// <summary> /// Customer Inquiry /// </summary> /// <param name="firstName"></param> /// <param name="lastName"></param> /// <param name="paging"></param> /// <returns></returns> public List <CustomerInquiry> CustomerInquiry(string firstName, string lastName, DataGridPagingInformation paging) { string sortExpression = paging.SortExpression; if (paging.SortDirection != string.Empty) { sortExpression = sortExpression + " " + paging.SortDirection; } var customerQuery = Customers.AsQueryable(); if (firstName != null && firstName.Trim().Length > 0) { customerQuery = customerQuery.Where(c => c.FirstName.StartsWith(firstName)); } if (lastName != null && lastName.Trim().Length > 0) { customerQuery = customerQuery.Where(c => c.LastName.StartsWith(lastName)); } var customers = from c in customerQuery join p in PaymentTypes on c.PaymentTypeID equals p.PaymentTypeID select new { c.CustomerID, c.FirstName, c.LastName, c.EmailAddress, c.City, c.Country, p.Description }; int numberOfRows = customers.Count(); customers = customers.OrderBy(sortExpression); var customerList = customers.Skip((paging.CurrentPageNumber - 1) * paging.PageSize).Take(paging.PageSize); paging.TotalRows = numberOfRows; paging.TotalPages = Utilities.CalculateTotalPages(numberOfRows, paging.PageSize); List <CustomerInquiry> customerInquiry = new List <CustomerInquiry>(); foreach (var customer in customerList) { CustomerInquiry customerData = new CustomerInquiry(); customerData.CustomerID = customer.CustomerID; customerData.FirstName = customer.FirstName; customerData.LastName = customer.LastName; customerData.EmailAddress = customer.EmailAddress; customerData.City = customer.City; customerData.Country = customer.Country; customerData.PaymentTypeDescription = customer.Description; customerInquiry.Add(customerData); } return(customerInquiry); }
public bool SaveContactUs(CustomerInquiry customerInquiry) { var result = 0; var connection = db.CreateConnection(); connection.Open(); var transaction = connection.BeginTransaction(); try { var savecommand = db.GetStoredProcCommand(DBRoutine.CUSTOMERSAVE); db.AddInParameter(savecommand, "InquiryType", System.Data.DbType.Int16, customerInquiry.InquiryType); db.AddInParameter(savecommand, "InquiryDate", System.Data.DbType.DateTime, customerInquiry.InquiryDate); db.AddInParameter(savecommand, "MobileNo", System.Data.DbType.String, customerInquiry.MobileNo); db.AddInParameter(savecommand, "EmailID", System.Data.DbType.String, customerInquiry.EmailID); db.AddInParameter(savecommand, "CustomerName", System.Data.DbType.String, customerInquiry.CustomerName); db.AddInParameter(savecommand, "Subject", System.Data.DbType.String, customerInquiry.Subject); db.AddInParameter(savecommand, "Description", System.Data.DbType.String, customerInquiry.Description); result = db.ExecuteNonQuery(savecommand, transaction); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw; } finally { transaction.Dispose(); connection.Close(); } return(result > 0 ? true : false); }
public bool SaveContactUs(CustomerInquiry inquiry) { return(customerInquiryDAL.SaveContactUs(inquiry)); }
public bool Save(CustomerInquiry customerInquiry) { return(customerInquiryDAL.Save(customerInquiry)); }
/// <summary> /// Customer Inquiry /// </summary> /// <param name="firstName"></param> /// <param name="lastName"></param> /// <param name="paging"></param> /// <returns></returns> public List <CustomerInquiry> CustomerInquiry(string firstName, string lastName, DataGridPagingInformation paging) { List <Customer> customers = new List <Customer>(); string sortExpression = paging.SortExpression; int maxRowNumber; int minRowNumber; minRowNumber = (paging.PageSize * (paging.CurrentPageNumber - 1)) + 1; maxRowNumber = paging.PageSize * paging.CurrentPageNumber; StringBuilder sqlBuilder = new StringBuilder(); StringBuilder sqlWhereBuilder = new StringBuilder(); string sqlWhere = string.Empty; if (firstName != null && firstName.Trim().Length > 0) { sqlWhereBuilder.Append(" c.FirstName LIKE @FirstName AND "); } if (lastName != null && lastName.Trim().Length > 0) { sqlWhereBuilder.Append(" c.LastName LIKE @LastName AND "); } if (sqlWhereBuilder.Length > 0) { sqlWhere = " WHERE " + sqlWhereBuilder.ToString().Substring(0, sqlWhereBuilder.Length - 4); } sqlBuilder.Append(" SELECT COUNT(*) as total_records FROM Customers c "); sqlBuilder.Append(sqlWhere); sqlBuilder.Append(";"); sqlBuilder.Append(" SELECT * FROM ( "); sqlBuilder.Append(" SELECT (ROW_NUMBER() OVER (ORDER BY " + paging.SortExpression + " " + paging.SortDirection + ")) as record_number, "); sqlBuilder.Append(" c.*, p.Description as PaymentTypeDescription "); sqlBuilder.Append(" FROM Customers c "); sqlBuilder.Append(" INNER JOIN PaymentTypes p ON p.PaymentTypeID = c.PaymentTypeID "); sqlBuilder.Append(sqlWhere); sqlBuilder.Append(" ) Rows "); sqlBuilder.Append(" where record_number between " + minRowNumber + " and " + maxRowNumber); string sql = sqlBuilder.ToString(); SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = sql; sqlCommand.Connection = dbConnection; if (firstName != null && firstName.Trim().Length > 0) { sqlCommand.Parameters.Add("@FirstName", System.Data.SqlDbType.VarChar); sqlCommand.Parameters["@FirstName"].Value = firstName + "%"; } if (lastName != null && lastName.Trim().Length > 0) { sqlCommand.Parameters.Add("@LastName", System.Data.SqlDbType.VarChar); sqlCommand.Parameters["@LastName"].Value = lastName + "%"; } SqlDataReader reader = sqlCommand.ExecuteReader(); reader.Read(); paging.TotalRows = Convert.ToInt32(reader["Total_Records"]); paging.TotalPages = Utilities.CalculateTotalPages(paging.TotalRows, paging.PageSize); reader.NextResult(); List <CustomerInquiry> customerList = new List <CustomerInquiry>(); while (reader.Read()) { CustomerInquiry customer = new CustomerInquiry(); DataReader dataReader = new DataReader(reader); customer.CustomerID = dataReader.GetGuid("CustomerID"); customer.FirstName = dataReader.GetString("FirstName"); customer.LastName = dataReader.GetString("LastName"); customer.EmailAddress = dataReader.GetString("EmailAddress"); customer.City = dataReader.GetString("City"); customer.Country = dataReader.GetString("Country"); customer.PaymentTypeDescription = dataReader.GetString("PaymentTypeDescription"); customerList.Add(customer); } reader.Close(); return(customerList); }
public ActionResult InquiryForm(InquiryVM eq) { Emailsending objEmailsending = new Emailsending(); var response = Request["g-recaptcha-response"]; var catptchastatus = false; string secreatekey = "6LdU_nUUAAAAAD6JiuKTysnVW6Aa4D5SU0z1Fl4u"; var client = new WebClient(); string resstring = string.Format("https://www.google.com/recaptcha/api/siteverify?secret={0}&response={1}", secreatekey, response); var result = client.DownloadString(resstring); if (result.ToLower().Contains("false")) { catptchastatus = false; } else { catptchastatus = true; } // ViewBag.Message = status ? "Google recaptcha validation success" : "Google recaptcha validation fails"; CustomerInquiry e = new CustomerInquiry(); var Formname = string.Empty; int FormTypeId; string Publisher = string.Empty; if (catptchastatus == true) { if (ModelState.IsValid) { // cap = Session["Captcha"].ToString(); cap = ExcellentMarketResearch.Areas.Admin.Models.Common.Decrypt(eq.RealCaptcha); if (eq.ReportId > 0) { var Publish = (from l in db.ReportMasters join p in db.PublisherMasters on l.PublishereId equals p.PublisherId where l.ReportId == eq.ReportId select p).FirstOrDefault(); Publisher = Publish.PublisherName; } else { Publisher = "!"; } //if (eq.CaptchaCode == cap) //{ CustomerInquiry cst = new CustomerInquiry(); var IpAddress = ExcellentMarketResearch.Models.PaymentGateway.IPAddress.GetIPAddress(); cst.Company = eq.Company; cst.Country = eq.Country; cst.CustomerMessage = eq.CustomerMessage; cst.Designation = eq.Designation; cst.EmailId = eq.EmailId; cst.Name = eq.Name; eq.AreaCode += "-" + eq.PhoneNumber; cst.PhoneNumber = eq.AreaCode; cst.ReportId = eq.ReportId; cst.CaptchaCode = eq.CaptchaCode; cst.FormType = eq.FormType; cst.CaptchaCode = "121321"; if (eq.FormType == "InquiryForm") { Formname = "Inquiry"; FormTypeId = 1; } else if (eq.FormType == "SampleRequestForm") { Formname = "Request Sample"; FormTypeId = 2; } else if (eq.FormType == "ContactUs") { FormTypeId = 4; } else { // Checkout page FormTypeId = 3; } try { db.CustomerInquiries.Add(cst); //db.Entry(cst).State = EntityState.Added; db.SaveChanges(); // QYGroupRepository.PaymentGateway.Emailsending objEmailsending = new QYGroupRepository.PaymentGateway.Emailsending(); // string ipAddress = QYGroupRepository.PaymentGateway.IPAddress.GetIPAddress(); // Task.Run(() => new CRMWebService.WebServiceSoapClient().InsertUpdateKey(0, eq.ReportId, eq.ReportTitle, FormTypeId, 34, 1, 1, eq.ReportUrl, ipAddress, eq.Name, eq.EmailId, eq.AreaCode, eq.Company, eq.Designation, "!", "!", eq.Country, "!", eq.CustomerMessage, 1, "!", "!", "!", Publisher, 38, "BW&Zk^HfZ44P339nEzqrrawY4HL_VXw-5f+%8b4Hdw?$?m$G*!+kCGLK%3JjDn-74NY*LyhdJr6RAte&8MBWy6F2j82+qn7ap&DB@z-*q3sdH*#D-kwACucyaM7vzet4pSa?m^xnP@3zN5K9=*L6WLpDurTSuVTR3Hd&3XLHJnCcR!h*dL#fQhp^*#25LEFrMTt@z&8RWdf^CQcj!QrQU^WkdC5$Ub$8qnu!g7?*$$4%%M9?8spAugyCzZg5@dLGBNS_^7?x3VczR75J&=+9yFDVg*Qpd@R^_Jz-GtWgHxv4Kf$=2pxT@bqhx%aqgzZAN6RzZZ%rNX7km3fu$h?Z=+V3b_MQPLAxJBVT!=Ta+7Xd?CF3#4w44L@HU%nf4m#y-d2vgn6Gp2t7w!qFY%kN#y6DNAy#TbrZnqnjMtgeAd%BHSm9H29z4G_?qnBHE5J2EyutZ2RSh?P2fUE-sF8bNFdre@G^qQ??JzJuDCT3hby2py#+yfg*jC%&YBkrutHs")); //Auto Mailer Task.Run(() => objEmailsending.SendEmail("*****@*****.**", "Sales", cst.EmailId, "", "*****@*****.**", "excellentmarketresearch.com : " + eq.ReportTitle, objEmailsending.GenerateMailBody_RequestSample_AutoReply(cst.Name, eq.ReportTitle))); //To company // Task.Run(() => objEmailsending.SendEmail("*****@*****.**", "Sales", "*****@*****.**", "", "", "ExcellentMarketResearch.com" + " : " + Formname,objEmailsending.GenerateMailBody_RequestSample(eq.ReportTitle, cst.Name, cst.EmailId, cst.PhoneNumber, cst.Company, cst.Country, cst.Designation, cst.CustomerMessage))); Task.Run(() => objEmailsending.SendEmail("*****@*****.**", "Sales", "*****@*****.**", "", "", "excellentMarketResearch.com" + " : " + Formname, objEmailsending.GenerateMailBody_RequestSample(eq.ReportTitle, cst.Name, cst.EmailId, cst.PhoneNumber, cst.Company, cst.Country, cst.Designation, cst.CustomerMessage, IpAddress))); Session["Name"] = cst.Name; return(RedirectToAction("Index", "InquiryForm", new { reporrtid = cst.ReportId })); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } //} //Return the if model not valid return(View(eq)); } return(View(eq)); } return(View(eq)); }
public ActionResult Index(ContactUsVM eq) { InquiryVM e = new InquiryVM(); Emailsending objEmailsending = new Emailsending(); var response = Request["g-recaptcha-response"]; var catptchastatus = false; string secreatekey = "6LdU_nUUAAAAAD6JiuKTysnVW6Aa4D5SU0z1Fl4u"; var client = new WebClient(); string resstring = string.Format("https://www.google.com/recaptcha/api/siteverify?secret={0}&response={1}", secreatekey, response); var result = client.DownloadString(resstring); if (result.ToLower().Contains("false")) { catptchastatus = false; } else { catptchastatus = true; } //int FormTypeId=4; string Publisher = string.Empty; if (catptchastatus) { if (ModelState.IsValid) { // cap = Session["Captcha"].ToString(); var cap = ExcellentMarketResearch.Areas.Admin.Models.Common.Decrypt(eq.RealCaptcha); Publisher = "!"; if (eq.CaptchaCode == cap) { CustomerInquiry cst = new CustomerInquiry(); cst.CustomerMessage = eq.CustomerMessage; cst.EmailId = eq.EmailId; cst.Name = eq.Name; // eq.AreaCode += "-" + eq.PhoneNumber; cst.PhoneNumber = eq.PhoneNumber; cst.ReportId = eq.ReportId; cst.Country = eq.Country; cst.CaptchaCode = eq.CaptchaCode; string ReportTitle = string.Empty; string ReportUrl = string.Empty; try { db.CustomerInquiries.Add(cst); //db.Entry(cst).State = EntityState.Added; db.SaveChanges(); // QYGroupRepository.PaymentGateway.Emailsending objEmailsending = new QYGroupRepository.PaymentGateway.Emailsending(); //Auto Mailer objEmailsending.SendEmail("*****@*****.**", "Sales", cst.EmailId, "", "", "ExcellentMarketResearch.com : ContactUs" + " ", GenerateMailBody_ContactUs_AutoReply(cst.Name, ReportTitle)); //To company objEmailsending.SendEmail("*****@*****.**", "Sales", "[email protected],", "", "*****@*****.**", "ExcellentMarketResearch.com " + " : " + "Contact Us", GenerateMailBody_ContactUs(ReportTitle, cst.Name, cst.EmailId, cst.PhoneNumber, "!", "!", "!", cst.CustomerMessage)); Session["Name"] = cst.Name; return(RedirectToAction("ContactusThanks", "ContactUs")); //return RedirectToRoute(new //{ // controller = "InquiryForm", // action = "Index", // reporrtid = cst.ReportId //}); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } //Return the if model not valid return(View()); } } return(View(eq)); }
public void AddToCustomerInquiries(CustomerInquiry customerInquiry) { base.AddObject("CustomerInquiries", customerInquiry); }
public static CustomerInquiry CreateCustomerInquiry(int customerInquiryID, int customerID, int customerInquiryCategoryID, int customerInquiryStatusID, int customerInquiryTypeID, global::System.DateTime createdDate) { CustomerInquiry customerInquiry = new CustomerInquiry(); customerInquiry.CustomerInquiryID = customerInquiryID; customerInquiry.CustomerID = customerID; customerInquiry.CustomerInquiryCategoryID = customerInquiryCategoryID; customerInquiry.CustomerInquiryStatusID = customerInquiryStatusID; customerInquiry.CustomerInquiryTypeID = customerInquiryTypeID; customerInquiry.CreatedDate = createdDate; return customerInquiry; }
public bool SendMessageToPickC(CustomerInquiry contactUs) { bool result = true; try { //contactUs.CreatedBy = UTILITY.DEFAULTUSER; // result = new CustomerBO().SaveCustomer(contactUs); string fromMail = string.Empty; var strBody = string.Empty; var strBody1 = string.Empty; if (result == true) { if (contactUs.InquiryType == 1505) { fromMail = "*****@*****.**"; strBody = "Dear " + contactUs.CustomerName + ",<BR><BR>Thanks For Your Valuable Request, our support team will be revert soon.<BR><BR>" + "Regards,<BR>" + "Pick - C Support Team."; strBody1 = "Dear CustomerSupport,<BR><BR>You have received a new request <BR><BR>" + "Customer Name : " + contactUs.CustomerName + "<BR>" + "Contact Number : " + contactUs.MobileNo + "<BR>" + "Email ID :" + contactUs.EmailID + "<BR>" + "Subject : " + contactUs.Subject + "<BR>" + "Message : " + contactUs.Description + "<BR>" + "Please respond to the email soonest."; } else if (contactUs.InquiryType == 1503) { fromMail = "*****@*****.**"; //strBody = "Namaskar " + contactUs.CustomerName + ",<BR><BR>Your request has been submitted succesfully, our support team shall contact you at the earliest.<BR><BR>" + // "Regards,<BR>" + // "Pick - C Support Team."; //strBody = "Dear " + contactUs.CustomerName + ",<BR><BR>Your request has been submitted succesfully.<BR><BR>" + // "Regards,<BR>" + // "Pick - C Support Team."; strBody = "Dear " + contactUs.CustomerName + ",<BR><BR>Thanks For Your Valuable Request, our support team will be revert soon.<BR><BR>" + "Regards,<BR>" + "Pick - C Support Team."; strBody1 = "Dear Contact,<BR><BR>You have received a new request <BR><BR>" + "Customer Name : " + contactUs.CustomerName + "<BR>" + "Contact Number : " + contactUs.MobileNo + "<BR>" + "Email ID :" + contactUs.EmailID + "<BR>" + "Subject : " + contactUs.Subject + "<BR>" + "Message : " + contactUs.Description + "<BR>" + "Please respond to the email soonest."; } else if (contactUs.InquiryType == 1504) { fromMail = "*****@*****.**"; //strBody = "Namaskar " + contactUs.CustomerName + ",<BR><BR>We appreciate your valuable Feedback.<BR><BR>" + // "Regards,<BR>" + // "Pick - C Support Team."; //strBody = "Dear " + contactUs.CustomerName + ",<BR><BR>Thanks for Your Feedback<BR><BR>" + // "Regards,<BR>" + // "Pick - C Support Team."; strBody = "Dear " + contactUs.CustomerName + ",<BR><BR>Thanks For Your Valuable Request, our support team will be revert soon.<BR><BR>" + "Regards,<BR>" + "Pick - C Support Team."; strBody1 = "Dear Feedback,<BR><BR>You have received a new request <BR><BR>" + "Customer Name : " + contactUs.CustomerName + "<BR>" + "Contact Number : " + contactUs.MobileNo + "<BR>" + "Email ID :" + contactUs.EmailID + "<BR>" + "Subject : " + contactUs.Subject + "<BR>" + "Message : " + contactUs.Description + "<BR>" + "Please respond to the email soonest."; } bool sendMailPickC = new EmailGenerator().ConfigMail(fromMail, true, fromMail, contactUs.Subject, strBody1); if (contactUs.EmailID.Length > 0) { //strBody = "Namaskar " + contactUs.CustomerName + ", <BR>" + // "Thank you for your valuable request. Our Customer support team will revert soon. <BR> <BR>" + // "Regards, <BR>" + // "Thank You,"+ // "Pick-C, Support team.<BR><BR>" + // "<BR>This is a system generated e - mail please do not reply to this e - mail," + // "replies to this e - mail are routed to an unmonitored mailbox."+ // "If any queries or clarifications about this invoice, write to us at [email protected]"; bool sendMailCustomer = new EmailGenerator().ConfigMail(contactUs.EmailID, true, fromMail, contactUs.Subject, strBody); } if (sendMailPickC) { return(true); } else { return(false); } } else { return(false); } } catch (Exception ex) { return(false); } }