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;
     }
 }
Exemple #7
0
        /// <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);
        }
Exemple #9
0
 public bool SaveContactUs(CustomerInquiry inquiry)
 {
     return(customerInquiryDAL.SaveContactUs(inquiry));
 }
Exemple #10
0
 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);
        }
Exemple #12
0
        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);
            }
        }