public ActionResult vendorreply(string orderid) { DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE); var s1 = ViewBag.orderdetails = orderService.allorderslist1().ToList().Where(m => m.orderid == long.Parse(orderid)).FirstOrDefault(); var userdata = userLoginDetailsService.GetUserId((int)s1.cutomerid); var userdetails = userLoginDetailsService.GetUser((int)s1.cutomerid); QuotationsList quotationsList = new QuotationsList(); var s12 = ViewBag.orderdetails = orderService.allorderslist1().ToList().Where(m => m.orderid == long.Parse(orderid)).ToList(); var vendordetails = newmanageuse.getvendor(Convert.ToInt32(s1.vid)); List <SPGETNpkg_Result> package = new List <SPGETNpkg_Result>(); List <SPGETNpkg_Result> package1 = new List <SPGETNpkg_Result>(); List <SPGETNpkg_Result> package2 = new List <SPGETNpkg_Result>(); package = viewservicesss.getvendorpkgs(Convert.ToString(s1.vid)); txtto = vendordetails.EmailId; string vname = vendordetails.BusinessName; ViewBag.name = vendordetails.BusinessName; ViewBag.Email = vendordetails.EmailId; ViewBag.bookdate = s1.bookdate.ToString(); ViewBag.orderid = orderid; return(View()); }
public void OpenTheQuoteByIdAndReachTheQuotationPage() { NavigationHelper.NavigateToUrl(ObjectRepository.Config.GetWebSite()); DropDownListHelper.SelectElementByText(By.Id("cmbCompanies"), "Vered Hasharon"); LoginPagePOM veredLog = new LoginPagePOM(ObjectRepository.Driver); WelcomToTcoPage veredWelcom = veredLog.ClickLogin(ObjectRepository.Config.GetVeredUser(), ObjectRepository.Config.GetVeredPassword()); QuotationsList verdquote = veredWelcom.ClickIncoming(); // var mainWindow = BrowserHelper.GettheParentPage(); verdquote.ticTcheckBoxAll(); verdquote.clickShowButton(); // make sure that you are in the right page -->assert the title of the page Assert.AreEqual("QUOTATION / GROUPS LIST", verdquote.PageTitle, "the titles are not equals"); var HoverAnElement = ObjectRepository.Driver.FindElement(By.XPath("//td[@id='ctl00_ContentPlaceHolder1_mnuTopn0']//a[contains(text(),'Sheets')]")); var ElementClick = ObjectRepository.Driver.FindElement(By.XPath("//a[contains(text(),'Open Calc.sheet/Group by number')]")); MouseActionsHelper.HoverAndClick(ObjectRepository.Driver, HoverAnElement, ElementClick); //switch to the new frame by invoking OpenExistingQuote Method GenericHelper.OpenExistingQuote(TestContext.DataRow["QuotationId"].ToString()); Thread.Sleep(2000); //switch to the new window BrowserHelper.SwitchToWindow(1); }
public static void Test_LoggInVeredHasharon() { NavigationHelper.NavigateToUrl(ObjectRepository.Config.GetWebSite()); DropDownListHelper.SelectElementByText(By.Id("cmbCompanies"), "Vered Hasharon"); LoginPagePOM veredLog = new LoginPagePOM(ObjectRepository.Driver); WelcomToTcoPage veredWelcom = veredLog.ClickLogin(ObjectRepository.Config.GetVeredUser(), ObjectRepository.Config.GetVeredPassword()); QuotationsList verdquote = veredWelcom.ClickIncoming(); }
public static void SelectIncoming() { LoginFromConfigFile(); LoginPagePOM LogMe = new LoginPagePOM(ObjectRepository.Driver); QuotationsList quoteList = LogMe.WelcomToTco.ClickIncoming(); //Assert that you are in the right page Assert.AreEqual("QUOTATION / GROUPS LIST", quoteList.PageTitle, "the titles are not equals"); var HoverAnElement = ObjectRepository.Driver.FindElement(By.XPath("//td[@id='ctl00_ContentPlaceHolder1_mnuTopn0']//a[contains(text(),'Sheets')]")); var ElementClick = ObjectRepository.Driver.FindElement(By.XPath("//a[contains(text(),'New Calc.sheet')]")); MouseActionsHelper.HoverAndClick(ObjectRepository.Driver, HoverAnElement, ElementClick); }
public int UpdateQuote(QuotationsList quotationsList) { var GetMasterRecord = _dbContext.QuotationsList.FirstOrDefault(m => m.Id == quotationsList.Id); GetMasterRecord.FirstTime = quotationsList.FirstTime; GetMasterRecord.FirstTimeQuoteDate = quotationsList.FirstTimeQuoteDate; GetMasterRecord.SecondTime = quotationsList.SecondTime; GetMasterRecord.SecondTimeQuoteDate = quotationsList.SecondTimeQuoteDate; GetMasterRecord.ThirdTime = quotationsList.ThirdTime; GetMasterRecord.ThirdTimeQuoteDate = quotationsList.ThirdTimeQuoteDate; GetMasterRecord.Status = "Quote Replied"; _dbContext.Entry(GetMasterRecord).CurrentValues.SetValues(quotationsList); int count = _dbContext.SaveChanges(); return(count); }
public static void SelectIncomingToursAndOpenById() { LoginFromConfigFile(); LoginPagePOM LogMe = new LoginPagePOM(ObjectRepository.Driver); QuotationsList quoteList = LogMe.WelcomToTco.ClickIncoming(); string FilePath = @"E:\Users\Bassam\Documents\Training\DataDriven\ExcelTestData\TcoData.xlsx"; //Assert that you are in the right page Assert.AreEqual("QUOTATION / GROUPS LIST", quoteList.PageTitle, "the titles are not equals"); var HoverAnElement = ObjectRepository.Driver.FindElement(By.XPath("//td[@id='ctl00_ContentPlaceHolder1_mnuTopn0']//a[contains(text(),'Sheets')]")); var ElementClick = ObjectRepository.Driver.FindElement(By.XPath("//a[contains(text(),'Open Calc.sheet/Group by number')]")); MouseActionsHelper.HoverAndClick(ObjectRepository.Driver, HoverAnElement, ElementClick); //switch to the new frame by invoking OpenExistingQuote Method GenericHelper.OpenExistingQuote(ExcelReaderHelper.GetCelldata(FilePath, "Quotations", 1, 0).ToString()); }
public int AddQuotationList(QuotationsList quotationsList) { _dbContext.QuotationsList.Add(quotationsList); _dbContext.SaveChanges(); return(1); }
public int UpdateQuote(QuotationsList quotationsList) { return(quotationListsRepository.UpdateQuote(quotationsList)); }
public int AddQuotationList(QuotationsList quotationsList) { return(quotationListsRepository.AddQuotationList(quotationsList)); }
public JsonResult ParticularQuoteReply(QuotationsList quoteResponse, string id, HttpPostedFileBase data1, string message, string replyto, string messagetype, string ext) { DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE); var s1 = orderService.allorderslist1().ToList().Where(m => m.orderid == long.Parse(quoteResponse.OrderID)).FirstOrDefault(); var userdata = userLoginDetailsService.GetUserId((int)s1.cutomerid); var userdetails = userLoginDetailsService.GetUser((int)s1.cutomerid); QuotationsList quotationsList = new QuotationsList(); var s12 = ViewBag.orderdetails = orderService.allorderslist1().ToList().Where(m => m.orderid == long.Parse(quoteResponse.OrderID)).ToList(); HttpPostedFileBase image1; if (ext != null || ext != "" || ext != "undefined") { image1 = Request.Files["/Quotefile/" + ext + ""]; } else { image1 = null; } if (replyto == "Vendor") { // quotationsList.EmailId = userdata.UserName; quotationsList.Name = userdetails.FirstName; var vendordetails = newmanageuse.getvendor(Convert.ToInt32(s1.vid)); string txtto1 = vendordetails.EmailId; string vname = vendordetails.BusinessName; // vname = home.Capitalise(vname); } else if (replyto == "Customer") { quotationsList.EmailId = s1.username; quotationsList.Name = s1.fname; } quotationsList.ServiceType = s1.servicetype; quotationsList.PhoneNo = s1.customerphoneno; quotationsList.EventStartDate = Convert.ToDateTime(s1.bookdate); quotationsList.EventStartTime = DateTime.UtcNow; quotationsList.EventEnddate = DateTime.UtcNow; quotationsList.EventEndtime = DateTime.UtcNow; quotationsList.VendorId = ""; quotationsList.OrderID = quoteResponse.OrderID; quotationsList.VendorMasterId = s1.vid.ToString(); quotationsList.Persons = s1.guestno.ToString(); string ip = HttpContext.Request.UserHostAddress; quotationsList.IPaddress = ip; quotationsList.UpdatedTime = DateTime.UtcNow; quotationsList.Status = "Active"; quotationsList.Reply_Type = messagetype; quotationsList.ReplyToType = replyto; quotationsList.Description = message; quotationListsService.AddQuotationList(quotationsList); if (replyto == "Vendor") { mail = "/mailtemplate/kansiris1.html"; } else if (replyto == "Customer") { mail = "/mailtemplate/kansiris.html"; } FileInfo File = new FileInfo(Server.MapPath(mail)); // FileInfo File = new FileInfo(Server.MapPath("/mailtemplate/QuoteReply.html")); string readFile = File.OpenText().ReadToEnd(); StringBuilder cds = new StringBuilder(); StringBuilder cds1 = new StringBuilder(); if (replyto == "Vendor") { var vendordetails = newmanageuse.getvendor(Convert.ToInt32(s1.vid)); txtto = vendordetails.EmailId; string vname = vendordetails.BusinessName; readFile = readFile.Replace("[name]", vendordetails.BusinessName); readFile = readFile.Replace("[Email]", vendordetails.EmailId); // readFile = readFile.Replace("[bookdate]", s1.bookdate.ToString()); cds1.Append("<table style='width: 70 %;border: 1px solid #fffff;'><tbody style='width: 70 %;border: 1px solid #fffff;'>"); // cds1.Append("<tr><td style='width: 70 %;border: 1px solid #fffff;'></td><td style='width: 70 %;border: 1px solid #fffff;'><strong> Event Type</strong> </td></tr>"); cds1.Append("<tr><td style='width: 70 %;border: 1px solid #fffff;'> <p>" + "<strong>No. of Guests:</strong> " + s1.guestno + "</p> <p><strong>Event Type:</strong> " + s1.eventtype + "</p> <p><strong>Event Date:</strong> " + s1.bookdate + " </td> </tr>"); cds1.Append("</tbody></table>"); cds.Append("<table class='example - table'><tbody>"); // cds.Append("<tr><td ><strong>Packgename</strong></td><td ><strong> Ahwanam Price</strong> </td><td ><strong> Market Price </strong> </td><td><strong>Availablity(Yes/No)</strong> </td></tr>"); foreach (var item in s12) { string image; if (item.logo != null) { image = "/vendorimages/" + item.logo.Trim(',') + ""; } else { image = "/noimages.png"; } cds.Append("<tr><td style='width: 70 %;border: 1px solid #000;'> <p>" + "<strong>Packgename:</strong>" + item.packagename + "</p><strong><p>Please provide the information for booking :</p><p>Date Available: Y / N(if no pls give alternate available date)</p><p>Package Price for Customer incl GST:</p><p>Package Price for Ahwanam incl GST:</p> </strong> </td></tr></tr>"); } cds.Append("</tbody></table>"); } else if (replyto == "Customer") { readFile = readFile.Replace("[name]", s1.fname); readFile = readFile.Replace("[Email]", s1.username); txtto = s1.username; cds.Append("<table style='width:70%;'><tbody>"); cds.Append("<tr><td style = 'width:20%;'></td><td><strong> Details</strong> </td><td> <strong>Event Type</strong> </td><td><strong>Total Amount</strong></td></tr>"); foreach (var item in s12) { string image; if (item.logo != null) { image = "/vendorimages/" + item.logo.Trim(',') + ""; } else { image = "/noimages.png"; } cds.Append("<tr><td style = 'width:20%;'> <img src = " + image + " style='height: 182px;width: 132px;'/></td><td style = '' > <p>" + "<strong>Business Name: </strong>" + item.BusinessName + "</p><p>" + "<strong>Packgename: </strong>" + item.packagename + "</p><p>" + "<strong>Price/person:</strong> " + '₹' + item.perunitprice.ToString().Replace(".00", "") + "</p><p>" + "<strong>No. of Guests:</strong> " + item.guestno + "</p> </td><td > " + item.eventtype + " </td><td style = ''><p>" + '₹' + item.totalprice.ToString().Replace(".00", "") + "</p> </td> </tr>"); } cds.Append("</tbody></table>"); } if (message == "") { message = null; } readFile = readFile.Replace("[message]", message); string url = Request.Url.Scheme + "://" + Request.Url.Authority; readFile = readFile.Replace("[ActivationLink]", url); readFile = readFile.Replace("[name]", name); readFile = readFile.Replace("[orderid]", quoteResponse.OrderID); readFile = readFile.Replace("[table]", cds.ToString()); readFile = readFile.Replace("[table1]", cds1.ToString()); string txtmessage = readFile; string subj = "Response to your Quote #" + s1.orderid + ""; EmailSendingUtility emailSendingUtility = new EmailSendingUtility(); emailSendingUtility.Email_maaaahwanam(txtto, txtmessage, subj, image1); return(Json("Success")); }