public void btnBlock_Click(Object sender, EventArgs e) { var id = Page.Request.Params["id"]; var userInSession = (Users)Session["userinsession"]; var user = new Users { ID = Convert.ToInt32(id), Status = 3 }; user.Update(userInSession.ID, OtherMethods.GetIPAddress(), "ClientEdit"); user.GetById(); var emailNotification = new EmailNotifications { Name = "account_blocked" }; emailNotification.GetByName(); EmailMethods.MailSendHTML( emailNotification.Title, string.Format(emailNotification.Body, BackendHelper.TagToValue("current_app_address"), BackendHelper.TagToValue("not_official_name"), BackendHelper.TagToValue("main_phones")), user.Email, true); Page.Response.Redirect(Request.RawUrl); }
public void btnActivate_Click(Object sender, EventArgs e) { var id = Page.Request.Params["id"]; var regUser = new Users { ID = Convert.ToInt32(id) }; var userInSession = (Users)Session["userinsession"]; //var newPassword = OtherMethods.CreateUniqId(DateTime.Now.ToString("yyMdHms")); var user = new Users { ID = Convert.ToInt32(id), Status = 2, ActivatedDate = DateTime.Now, Password = regUser.Password }; user.Update(userInSession.ID, OtherMethods.GetIPAddress(), "ClientEdit"); user.GetById(); var emailNotification = new EmailNotifications { Name = "account_activated" }; emailNotification.GetByName(); EmailMethods.MailSendHTML( emailNotification.Title, string.Format(emailNotification.Body, user.Login, regUser.Password, BackendHelper.TagToValue("official_name"), BackendHelper.TagToValue("current_app_address"), BackendHelper.TagToValue("not_official_name")), user.Email, true); Page.Response.Redirect(Request.RawUrl); }
public void btnSendPrice_Click(Object sender, EventArgs e) { var id = Page.Request.Params["id"]; //читаем старый файл if (!Directory.Exists(HttpContext.Current.Server.MapPath("~/Temp/SendedPrices/"))) { Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/Temp/SendedPrices/")); } var fileName = "Прайс " + BackendHelper.TagToValue("official_name") + " (" + OtherMethods.CreateUniqId(id + DateTime.Now.ToString("hh:mm:ssttzz")) + ").xls"; var dataFile = HttpContext.Current.Server.MapPath("~/Temp/SendedPrices/" + fileName); var dm = new DataManager(); //получаем данные отправителя прайса из сотрудников var userInSession = (Users)Session["userinsession"]; var emailSenderData = new Users() { ID = userInSession.ID }; emailSenderData.GetById(); var ds = new DataSet(); var ifUserHaveAssignSection = dm.QueryWithReturnDataSet(String.Format("SELECT * FROM `userstocategory` WHERE `UserID` = {0}", id)); if (ifUserHaveAssignSection.Tables[0].Rows.Count == 0) { ds = dm.QueryWithReturnDataSet( "SELECT Name as 'Наименование', " + "MarginCoefficient as 'Юр. лицо', " + "MarginCoefficient as 'Физ. лицо', " + "MarginCoefficient as 'Физ. лица в скид.' " + "FROM `titles` ORDER BY `Name`"); } else { ds = dm.QueryWithReturnDataSet(String.Format( "SELECT C.Name as 'Наименование', " + "C.MarginCoefficient as 'Юр. лицо', " + "C.MarginCoefficient as 'Физ. лицо', " + "C.MarginCoefficient as 'Физ. лица в скид.' " + "FROM `titles` C WHERE C.`CategoryID` IN (SELECT `CategoryID` FROM `userstocategory` WHERE `UserID` = {0}) ORDER BY C.`Name`", id)); } var goodList = new List <GoodsFromAPI>(); var goods = new GoodsFromAPI(); var tableToSend = "<table class='table' style='width: 100%; border-collapse: collapse;'><tr>" + "<th style='border: 1px solid #666666; padding: 3px 6px; text-align: left;'>Наименование</th>" + "<th style='border: 1px solid #666666; padding: 3px 6px;'>ЮЛ/ТТН</th>" + "<th style='border: 1px solid #666666; padding: 3px 6px;'>ФЛ/Регион</th>" + "<th style='border: 1px solid #666666; padding: 3px 6px;'>ФИЗ. Л. регион/область</th>" + "</tr>"; foreach (DataRow row in ds.Tables[0].Rows) { goodList.Clear(); goods.Description = row[0].ToString(); goods.Number = 1; goods.IsAdditional = 0; goods.WithoutAkciza = 0; goods.Coefficient = 0; goodList.Add(goods); row[1] = Calculator.Calculate(goodList, 187, Convert.ToInt32(id), null, "2"); //за обычный город берем Петриков row[2] = Calculator.Calculate(goodList, 187, Convert.ToInt32(id), null, "1"); //за обычный город берем Петриков row[3] = Calculator.Calculate(goodList, 16, Convert.ToInt32(id), null, "1"); //за скидочный город берем Гродно tableToSend += string.Format("<tr>" + "<td style='border: 1px solid #666666; padding: 3px 6px; text-align: left;'>{0}</td>" + "<td style='border: 1px solid #666666; padding: 3px 6px;'>{1}</td>" + "<td style='border: 1px solid #666666; padding: 3px 6px;'>{2}</td>" + "<td style='border: 1px solid #666666; padding: 3px 6px;'>{3}</td>" + "</tr>", row[0], MoneyMethods.MoneySeparator(row[1].ToString()), MoneyMethods.MoneySeparator(row[2].ToString()), MoneyMethods.MoneySeparator(row[3].ToString())); } tableToSend += "</table>"; DataRow emptyRow = ds.Tables[0].NewRow(); DataRow newRow = ds.Tables[0].NewRow(); newRow[0] = String.Format("Наш {5}: {1} {2}, тел.: {0}, email: {3}, skype: {4}", emailSenderData.PhoneWorkOne, emailSenderData.Name, emailSenderData.Family, emailSenderData.Email, emailSenderData.Skype, userInSession.RussRole.ToLower()); ds.Tables[0].Rows.Add(emptyRow); ds.Tables[0].Rows.Add(newRow); ds.Tables[0].TableName = "Прайс " + BackendHelper.TagToValue("not_official_name"); Workbook book = Workbook.Load(HttpContext.Current.Server.MapPath("~/" + BackendHelper.TagToValue("comprop_tpl_file_name"))); AddDataTableToWorkBook(ds.Tables[0], ref book); var user = new Users() { ID = Convert.ToInt32(id) }; user.GetById(); book.Save(dataFile); var emailNotification = new EmailNotifications { Name = "comprop_message" }; emailNotification.GetByName(); EmailMethods.MailSendHTML( string.Format(emailNotification.Title, BackendHelper.TagToValue("not_official_name")), string.Format(emailNotification.Body, emailSenderData.PhoneWorkOne, emailSenderData.Name, emailSenderData.Family, emailSenderData.Email, emailSenderData.Skype, tableToSend, userInSession.RussRole.ToLower(), BackendHelper.TagToValue("official_name"), BackendHelper.TagToValue("current_app_address"), BackendHelper.TagToValue("not_official_name")), user.Email, dataFile, true); Session["flash:now"] = "<span style='color: green; font-size: bold'>Прайс отправлен!</span>"; Page.Response.Redirect("~/ManagerUI/Menu/Souls/ClientEdit.aspx?id=" + id); }
public void btnSendComProp_Click(Object sender, EventArgs e) { //читаем старый файл if (!Directory.Exists(HttpContext.Current.Server.MapPath("~/Temp/SendedPrices/"))) { Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/Temp/SendedPrices/")); } var fileName = "Прайс " + BackendHelper.TagToValue("not_official_name") + " (" + OtherMethods.CreateUniqId(tbEmail.Text + DateTime.Now.ToString("hh:mm:ssttzz")) + ").xls"; var dataFile = HttpContext.Current.Server.MapPath("~/Temp/SendedPrices/" + fileName); var dm = new DataManager(); //получаем данные отправителя прайса из сотрудников var userInSession = (Users)Session["userinsession"]; var emailSenderData = new Users() { ID = userInSession.ID }; emailSenderData.GetById(); var categoryIds = string.Empty; var haveCheckedCategory = false; foreach (var items in lvAllCategory.Items) { var hfCategoryId = (HiddenField)items.FindControl("hfCategoryId"); var cbCategory = (CheckBox)items.FindControl("cbCategory"); if (cbCategory.Checked) { categoryIds += string.Format("{0},", hfCategoryId.Value); haveCheckedCategory = true; } } DataSet ds; if (!haveCheckedCategory) { ds = dm.QueryWithReturnDataSet( "SELECT Name as 'Наименование', " + "MarginCoefficient as 'Юр. лицо', " + "MarginCoefficient as 'Физ. лицо', " + "MarginCoefficient as 'Физ. лица в скид.' " + "FROM `titles` ORDER BY `Name`"); } else { categoryIds = categoryIds.Remove(categoryIds.Length - 1, 1); ds = dm.QueryWithReturnDataSet(String.Format( "SELECT C.Name as 'Наименование', " + "C.MarginCoefficient as 'Юр. лицо', " + "C.MarginCoefficient as 'Физ. лицо', " + "C.MarginCoefficient as 'Физ. лица в скид.' " + "FROM `titles` C WHERE C.`CategoryID` IN ({0}) ORDER BY C.`Name`", categoryIds)); } var goodList = new List <GoodsFromAPI>(); var goods = new GoodsFromAPI(); var tableToSend = "<table class='table' style='width: 100%; border-collapse: collapse;'><tr>" + "<th style='border: 1px solid #666666; padding: 3px 6px; text-align: left;'>Наименование</th>" + "<th style='border: 1px solid #666666; padding: 3px 6px;'>По РБ</th>" + "<th style='border: 1px solid #666666; padding: 3px 6px;'>По Минску</th>" + "</tr>"; List <ModelSortingCosts> table_list = new List <ModelSortingCosts>(); DataTable sortedDS = new DataTable(); sortedDS.Columns.Add(string.Format("Наименование", 0), typeof(string)); sortedDS.Columns.Add(string.Format("Дверь/Дверь", 1), typeof(string)); sortedDS.Columns.Add(string.Format("Склад/Дверь", 2), typeof(string)); sortedDS.Columns.Add(string.Format("По Минску", 3), typeof(string)); foreach (DataRow row in ds.Tables[0].Rows) { ModelSortingCosts row_list = new ModelSortingCosts(); goodList.Clear(); goods.Description = row[0].ToString(); goods.Number = 1; goods.IsAdditional = 0; goods.WithoutAkciza = 0; goods.Coefficient = 0; goodList.Add(goods); row_list.name = row[0].ToString(); row_list.costDD = Calculator.Calculate(goodList, 187, 1, 239, "1", null, null, true); row_list.costSD = Calculator.Calculate(goodList, 187, 1, 239, "1"); row_list.costMinsk = Calculator.Calculate(goodList, 11, 1, 239, "1"); table_list.Add(row_list); } table_list = table_list.OrderBy(x => x.costSD).ToList(); foreach (ModelSortingCosts model in table_list) { DataRow dsRow = sortedDS.NewRow(); dsRow[0] = model.name; dsRow[1] = model.costDD; dsRow[2] = model.costSD; dsRow[3] = model.costMinsk; sortedDS.Rows.Add(dsRow); } foreach (ModelSortingCosts row in table_list) { tableToSend += string.Format("<tr>" + "<td style='border: 1px solid #666666; padding: 3px 6px; text-align: left;'>{0}</td>" + "<td style='border: 1px solid #666666; padding: 3px 6px;'>{1}</td>" + "<td style='border: 1px solid #666666; padding: 3px 6px;'>{2}</td>" + "</tr>", row.name, MoneyMethods.MoneySeparator(row.costDD.ToString()), MoneyMethods.MoneySeparator(row.costSD.ToString()), MoneyMethods.MoneySeparator(row.costMinsk.ToString())); } tableToSend += "</table>"; DataRow emptyRow = sortedDS.NewRow(); DataRow newRow = sortedDS.NewRow(); newRow[0] = String.Format("тел.: {0}, email: {3}, skype: {4}", emailSenderData.PhoneWorkOne, emailSenderData.Name, emailSenderData.Family, emailSenderData.Email, emailSenderData.Skype, userInSession.RussRole.ToLower()); sortedDS.Rows.Add(emptyRow); sortedDS.Rows.Add(newRow); sortedDS.TableName = "Прайс" + BackendHelper.TagToValue("not_official_name"); Workbook book = Workbook.Load(HttpContext.Current.Server.MapPath("~/OtherFiles/" + BackendHelper.TagToValue("comprop_tpl_file_name"))); AddDataTableToWorkBook(sortedDS, ref book); book.Save(dataFile); var emailNotification = new EmailNotifications { Name = "comprop_guest_message" }; emailNotification.GetByName(); EmailMethods.MailSendHTML(tbSubject.Text, string.Format(emailNotification.Body, emailSenderData.PhoneWorkOne, emailSenderData.Name, emailSenderData.Family, emailSenderData.Email, emailSenderData.Skype, tableToSend, userInSession.RussRole.ToLower(), BackendHelper.TagToValue("official_name"), BackendHelper.TagToValue("current_app_address"), BackendHelper.TagToValue("not_official_name")), tbEmail.Text, dataFile, false); Session["flash:now"] = "<span style='color: white;'>Комерческое предложение успешно отправлено на e-mail <b>" + tbEmail.Text + "</b>!</span>"; Page.Response.Redirect("~/ManagerUI/Menu/Documents/SendComProp.aspx"); }