private void populateCompanyProducts() { cblProducts.Items.Clear(); int tmp = 0; int i = 0; List <CompanyProducts> CP = CompanyProducts.GetAll(); foreach (CompanyProducts P in CP) { if (tmp != Convert.ToInt32(P.ParentID)) { cblProducts.Items.Add(new ListItem("<u><b style=\"font-size: large\">" + P.ProductName + "</b></u>", "0")); } tmp = Convert.ToInt32(P.ParentID); cblProducts.Items.Add(new ListItem(P.CategoryProductName, P.ChildID.ToString())); } for (i = 0; i < cblProducts.Items.Count; i++) { if (cblProducts.Items[i].Value == "0") { cblProducts.Items[i].Enabled = false; } } }
public IActionResult GetProductSalesAgents(string CompanyId, string ProductSupplierId) { try { AgentDetails model = new AgentDetails(); request = new AgentGetReq() { CompanyId = CompanyId }; AgentGetRes response = agentProviders.GetAgentDetailedInfo(request, token).Result; model.CompanyId = CompanyId; model.Issupplier = response.AgentDetails.Issupplier ?? false; CompanyProducts product = response.AgentDetails.Products.Where(x => x.ProductSupplier_Id == ProductSupplierId).FirstOrDefault(); List <Branches> lst = new List <Branches>(); foreach (var s in product.SalesAgent) { Branches prod = new Branches(); prod.ParentCompanyId = s.Company_Id; prod.BranchCompanyId = s.ProductSupplierSalesAgent_Id; // Array Id assigned prod.BranchCompanyName = s.Company_Name; prod.BranchCompanyCode = s.Company_Code; lst.Add(prod); } model.Branches = lst.OrderBy(x => x.BranchCompanyName).ToList(); model.IsForSalesAgent = true; model.ProductSupplierId = ProductSupplierId; return(PartialView("_AgentDetailsBranches", model)); } catch (Exception ex) { throw; } }
private void populateCheckedCompanyProducts() { int selectedID = Convert.ToInt32(Request.Form["ctl00$ContentPlaceHolder1$ddExporter"]); List <CompanyProducts> CPC = CompanyProducts.GetProductCategories(selectedID); txtLocation.Text = ""; if (CPC.Count > 0) { txtLocation.Text = CPC[0].Location; int j = 0; for (int i = 0; i < cblProducts.Items.Count; i++) { if (Convert.ToInt32(cblProducts.Items[i].Value) == CPC[j].ChildEquipID) { cblProducts.Items[i].Selected = true; if (j < CPC.Count - 1) { j++; } } } } }
public async Task <IActionResult> CreateForCompany(int companyId, [Bind("Id,CompanyId,ProductId")] CompanyProducts companyProducts) { companyProducts.CompanyId = companyId; if (ModelState.IsValid) { var comp_prod = _context.CompanyProducts.Where(c => c.ProductId == companyProducts.ProductId).Where(c => c.CompanyId == companyId).FirstOrDefault(); if (comp_prod != null) { ModelState.AddModelError("Error", "Для цієї компанії вже існує дана категорія"); } else { _context.Add(companyProducts); await _context.SaveChangesAsync(); //return RedirectToAction(nameof(Index)); return(RedirectToAction("IndexForCompany", "CompanyProducts", new { id = companyId, name = _context.Companies.Where(c => c.Id == companyId).FirstOrDefault().Name })); } } //ViewData["CompanyId"] = new SelectList(_context.Companies, "Id", "Name", companyProducts.CompanyId); ViewData["ProductId"] = new SelectList(_context.Products, "Id", "Name", companyProducts.ProductId); //return View(companyProducts); return(RedirectToAction("IndexForCompany", "CompanyProducts", new { id = companyId, name = _context.Companies.Where(c => c.Id == companyId).FirstOrDefault().Name })); }
public async Task <IActionResult> Edit(int id, [Bind("Id,CompanyId,ProductId")] CompanyProducts companyProducts) { if (id != companyProducts.Id) { return(NotFound()); } string?productName = _context.Products.Where(c => c.Id == companyProducts.ProductId).FirstOrDefault().Name; if (ModelState.IsValid) { try { _context.Update(companyProducts); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CompanyProductsExists(companyProducts.Id)) { return(NotFound()); } else { throw; } } //return RedirectToAction(nameof(Index)); return(RedirectToAction("Index", "CompanyProducts", new { id = companyProducts.ProductId, name = productName })); } ViewData["CompanyId"] = new SelectList(_context.Companies, "Id", "Name", companyProducts.CompanyId); ViewData["ProductId"] = new SelectList(_context.Products, "Id", "Name", companyProducts.ProductId); return(RedirectToAction("Index", "CompanyProducts", new { id = companyProducts.ProductId, name = productName })); //return View(companyProducts); }
public async Task <IActionResult> Import(IFormFile fileExcel) { if (ModelState.IsValid) { try { if (fileExcel == null) { throw new FileLoadException("Файл не обрано"); } if (fileExcel != null) { using (var stream = new FileStream(fileExcel.FileName, FileMode.Create)) { await fileExcel.CopyToAsync(stream); using (XLWorkbook workBook = new XLWorkbook(stream, XLEventTracking.Disabled)) { foreach (IXLWorksheet worksheet in workBook.Worksheets) { Products newCategory; var c = (from cat in _context.Products where cat.Name.Contains(worksheet.Name) select cat).ToList(); if (c.Count > 0) { newCategory = c[0]; } else { if (Regex.IsMatch(worksheet.Name, _regexCategory) == false) { throw new Exception("Некоректна назва аркуша"); } newCategory = new Products(); newCategory.Name = worksheet.Name; _context.Products.Add(newCategory); } //await _context.SaveChangesAsync(); CheckNameRow(worksheet); //проверка рядка с названиями столбцов //просмотр всех рядков foreach (IXLRow row in worksheet.RowsUsed().Skip(1)) { if (Regex.IsMatch(row.Cell(1).Value.ToString(), _regexModel) == false) { throw new Exception("Некоректна назва товару"); } ModelsOfProduct Model = new ModelsOfProduct(); Model.Name = row.Cell(1).Value.ToString(); if (Model.Name == "") { throw new Exception("Порожнє поле назви товару"); } if (row.Cell(3).Value.ToString() != "") { try { Model.Price = Convert.ToDouble(row.Cell(3).Value); } catch (Exception) { throw new Exception("Некоректне поле ціни"); } } else { throw new Exception("Порожнє поле ціни"); } Model.Information = row.Cell(4).Value.ToString(); if (row.Cell(2).Value.ToString().Length > 0) { Companies Company; var comp = (from cmp in _context.Companies where cmp.Name.Contains(row.Cell(2).Value.ToString()) select cmp).ToList(); if (comp.Count > 0) { Company = comp[0]; } else { if (Regex.IsMatch(row.Cell(2).Value.ToString(), _regexCompany) == false) { throw new Exception("Некоректна назва компанії"); } Company = new Companies(); Company.Name = row.Cell(2).Value.ToString(); _context.Companies.Add(Company); } //await _context.SaveChangesAsync(); if (row.Cell(5).Value.ToString().Length > 0) { Colors Color; var clr = (from col in _context.Colors where col.Name.Contains(row.Cell(5).Value.ToString()) select col).ToList(); if (clr.Count > 0) { Color = clr[0]; } else { if (Regex.IsMatch(row.Cell(5).Value.ToString(), _regexColor) == false) { throw new Exception("Некоректна назва кольору"); } Color = new Colors(); Color.Name = row.Cell(5).Value.ToString(); _context.Colors.Add(Color); } Model.Color = Color; CompanyProducts companyProducts; if (!IsExistCompanyInProduct(newCategory, Company)) { companyProducts = new CompanyProducts(); companyProducts.Product = newCategory; companyProducts.Company = Company; _context.CompanyProducts.Add(companyProducts); } else { companyProducts = _context.CompanyProducts.Where(c => c.CompanyId == Company.Id && c.ProductId == newCategory.Id).FirstOrDefault(); } await _context.SaveChangesAsync(); Model.CompProdId = companyProducts.Id; } else { throw new Exception("Порожнє поле кольору"); } } else { throw new Exception("Порожня назва компанії"); } if (!IsExistModel(Model)) { _context.ModelsOfProduct.Add(Model); } } } } } } } catch (ArgumentException ex) { //неправильное название столбцов return(RedirectToAction("Index", "Products", new { searchString = "", errorString = ex.Message })); } catch (FileLoadException ex) { //ошибка загрузки файла или файл не выбран return(RedirectToAction("Index", "Products", new { errorString = ex.Message })); } catch (Exception ex) { //некоретные данные if (ex.Message == "") { return(RedirectToAction("Index", "Products", new { errorString = "Помилка завантаження файлу" })); } return(RedirectToAction("Index", "Products", new { errorString = ex.Message })); } await _context.SaveChangesAsync(); } return(RedirectToAction(nameof(Index))); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["expid"] != "0") { List <CompanyProducts> CP = CompanyProducts.GetProductsByCompanyID(Convert.ToInt32(Request.QueryString["expid"])); List <BIRegistration> BIU = BIRegistration.GetAll(); string[] arrProdInterest = new string[10]; string strTemp = ""; int i, j, k, l; int counter = 0; bool check = false; bool newLine = false; string[] arrPhraseWords = new string[2]; if (CP.Count > 0) { VisitorsPlaceHolder.Text += "<center><b style='font-size: 16pt'><u>" + CP[0].CompanyName + "</u></b></center><br />"; VisitorsPlaceHolder.Text += "<br />"; for (i = 0; i < BIU.Count; i++) { strTemp = BIU[i].ProductInterest; arrProdInterest = strTemp.Split(';'); for (l = 0; l < arrProdInterest.Length; l++) { if (arrProdInterest[l] != null) { counter++; } } for (j = 0; j < counter; j++) { for (k = 0; k < CP.Count; k++) { if (arrProdInterest[j] == Convert.ToString(CP[k].ParentID)) { if (check == false) { VisitorsPlaceHolder.Text += "<strong><u>" + Translator.DirectTranslation(BIU[i].FirstName) + " " + Translator.DirectTranslation(BIU[i].LastName) + "</u></strong><br />"; VisitorsPlaceHolder.Text += "Job Title " + Translator.DictionaryTranslation(BIU[i].JobTitle) + " Company " + Translator.DictionaryTranslation(BIU[i].Company) + "<br />"; VisitorsPlaceHolder.Text += "Country " + Translator.DictionaryTranslation(BIU[i].Country) + " City " + Translator.DictionaryTranslation(BIU[i].City) + "<br />"; VisitorsPlaceHolder.Text += "Email " + BIU[i].Email + " Web Site " + BIU[i].Website + "<br />"; VisitorsPlaceHolder.Text += "Phone: " + BIU[i].Phone + " Fax: " + BIU[i].Fax + "<br /><br />"; VisitorsPlaceHolder.Text += "<strong>Interested Products:</strong><br/>"; check = true; newLine = true; } strTemp = CP[k].ProductName; arrPhraseWords = strTemp.Split('('); VisitorsPlaceHolder.Text += " * " + arrPhraseWords[0] + "<br />"; } } } check = false; counter = 0; if (newLine == true) { VisitorsPlaceHolder.Text += "<br />"; newLine = false; } } } else { VisitorsPlaceHolder.Text += "<b>Equipment was not chosen for the company</b>"; } } else { VisitorsPlaceHolder.Text += "<b>The company was not chosen</b>"; } }
protected void btnSaveData_Click(object sender, EventArgs e) { List <CompanyProducts> CPC = CompanyProducts.GetProductCategories(Convert.ToInt32(Request.Form["ctl00$ContentPlaceHolder1$ddExporter"])); int i; int j = 0; SqlConnection conn = ConnectionHelper.GetSQLConnection(); SqlCommand command = new SqlCommand("UPDATE Exporters SET Location= @Location WHERE ExporterID = @ExpID", conn); command.Parameters.AddWithValue("@Location", txtLocation.Text); command.Parameters.AddWithValue("@ExpID", Convert.ToInt32(Request.Form["ctl00$ContentPlaceHolder1$ddExporter"])); command.Connection.Open(); SqlDataReader rs = command.ExecuteReader(); rs.Read(); rs.Close(); if (CPC.Count > 0) { for (i = 0; i < cblProducts.Items.Count; i++) { if ((Convert.ToInt32(cblProducts.Items[i].Value) == CPC[j].ChildEquipID) && (cblProducts.Items[i].Selected == false)) { CompanyProducts.Delete(CPC[j].ChildEquipID); if (j < CPC.Count - 1) { j++; } } else if ((Convert.ToInt32(cblProducts.Items[i].Value) == CPC[j].ChildEquipID) && (cblProducts.Items[i].Selected == true)) { if (j < CPC.Count - 1) { j++; } } } j = 0; for (i = 0; i < cblProducts.Items.Count; i++) { if ((cblProducts.Items[i].Selected == true) && (Convert.ToInt32(cblProducts.Items[i].Value) != CPC[j].ChildEquipID)) { CompanyProducts.Insert(Convert.ToInt32(Request.Form["ctl00$ContentPlaceHolder1$ddExporter"]), Convert.ToInt32(cblProducts.Items[i].Value)); //ProductsPlaceHolder.Text += cblProducts.Items[i].Value + "<br />"; } else if ((cblProducts.Items[i].Selected == true) && (Convert.ToInt32(cblProducts.Items[i].Value) == CPC[j].ChildEquipID)) { if (j < CPC.Count - 1) { j++; } } } } else { for (i = 0; i < cblProducts.Items.Count; i++) { if (cblProducts.Items[i].Selected == true) { CompanyProducts.Insert(Convert.ToInt32(Request.Form["ctl00$ContentPlaceHolder1$ddExporter"]), Convert.ToInt32(cblProducts.Items[i].Value)); } } } }
protected void Page_Load(object sender, EventArgs e) { int i; BIRegistration bir = new BIRegistration(Convert.ToInt32(Request.QueryString["id"])); string[] arrProdInterest = new string[11]; string strTemp = bir.ProductInterest; arrProdInterest = strTemp.Split(';'); int counter = 0; for (i = 0; i < arrProdInterest.Length; i++) { if (arrProdInterest[i] != null) { counter++; } } int tmpExpID = 0; int tmpParentID = 0; if ((Request.QueryString["id"] != null) && (Request.QueryString["view"] == "0")) { List <CompanyProducts> CP = CompanyProducts.GetAllDataForReport(0); if (Request.QueryString["translator"] == "0") { ProductsPlaceHolder.Text += "<center><b style='font-size: 16pt'>Visitor's name: <u>" + bir.FirstName + " " + bir.LastName + "</u></b></center><br />"; } else if (Request.QueryString["translator"] == "1") { ProductsPlaceHolder.Text += "<center><b style='font-size: 16pt'>Visitor's name: <u>" + Translator.DirectTranslation(bir.FirstName) + " " + Translator.DirectTranslation(bir.LastName) + "</u></b></center><br />"; } for (i = 0; i < CP.Count; i++) { if (CP[i].ExpID != tmpExpID) { if (SearchCompany(arrProdInterest, counter, CP, CP[i].ExpID) == true) { ProductsPlaceHolder.Text += "<br /><br />"; ProductsPlaceHolder.Text += "<u><b>" + CP[i].CompanyName + "</b></u><br />"; ProductsPlaceHolder.Text += "<b>Products description:</b> " + CP[i].ProductDescription + "<br />"; ProductsPlaceHolder.Text += "<b>Contact:</b> " + CP[i].ContactPersonName + "<br/><b>Phone:</b> " + CP[i].Phone + ", "; if (CP[i].Fax != "") { ProductsPlaceHolder.Text += " <b>Fax:</b> " + CP[i].Fax + ","; } if (CP[i].CellPhone != "") { ProductsPlaceHolder.Text += " <b>Cell:</b> " + CP[i].CellPhone; } ProductsPlaceHolder.Text += "<br /><b>Email:</b> " + CP[i].Email; ProductsPlaceHolder.Text += "<br /><b>Location on Big Iron:</b> " + CP[i].Location + "<br /><br /> <b>Products produced by the company:</b> <br />"; } tmpExpID = CP[i].ExpID; tmpParentID = 0; } if (SearchVisitorProduct(arrProdInterest, counter, Convert.ToString(CP[i].ParentID)) == true) { if (tmpParentID != CP[i].ParentID) { ProductsPlaceHolder.Text += CP[i].ProductName + "<br />"; tmpParentID = CP[i].ParentID; } ProductsPlaceHolder.Text += " * <i>" + CP[i].CategoryProductName + "</i><br />"; } } } else if ((Request.QueryString["id"] != null) && (Request.QueryString["view"] == "1")) { List <CompanyProducts> CP = CompanyProducts.GetAllDataForReport(1); int numOutputs = 1; if (Request.QueryString["translator"] == "0") { ProductsPlaceHolder.Text += "<center><b style='font-size: 16pt'>Visitor's name: <u>" + bir.FirstName + " " + bir.LastName + "</u></b></center><br />"; } else if (Request.QueryString["translator"] == "1") { ProductsPlaceHolder.Text += "<center><b style='font-size: 16pt'>Visitor's name: <u>" + Translator.DirectTranslation(bir.FirstName) + " " + Translator.DirectTranslation(bir.LastName) + "</u></b></center><br />"; } for (i = 0; i < CP.Count; i++) { if (SearchVisitorProduct(arrProdInterest, counter, Convert.ToString(CP[i].ParentID)) == true) { if (tmpExpID != CP[i].ExpID) { tmpParentID = 0; tmpExpID = CP[i].ExpID; numOutputs = 1; } if (tmpParentID != CP[i].ParentID) { ProductsPlaceHolder.Text += "<u><b>" + CP[i].ProductName + "</b></u><br />"; tmpParentID = CP[i].ParentID; numOutputs = 1; } ProductsPlaceHolder.Text += " * <i>" + CP[i].CategoryProductName + "</i>" + GetNumberOfSubcotegories(CP, CP[i].ParentID, CP[i].ExpID) + " " + CP[i].ParentID + " " + CP[i].ExpID + "<br />"; if (GetNumberOfSubcotegories(CP, CP[i].ParentID, CP[i].ExpID) == numOutputs) { ProductsPlaceHolder.Text += "<br />"; ProductsPlaceHolder.Text += " <b>" + CP[i].CompanyName + "</b><br />"; ProductsPlaceHolder.Text += "<table><tr><td> </td><td><b>Products description:</b> " + CP[i].ProductDescription + "<br /></td></tr></table>"; ProductsPlaceHolder.Text += " <b>Contact:</b> " + CP[i].ContactPersonName + "<br/> <b>Phone:</b> " + CP[i].Phone + ", "; if (CP[i].Fax != "") { ProductsPlaceHolder.Text += " <b>Fax:</b> " + CP[i].Fax + ","; } if (CP[i].CellPhone != "") { ProductsPlaceHolder.Text += " <b>Cell:</b> " + CP[i].CellPhone; } ProductsPlaceHolder.Text += "<br /> <b>Email:</b> " + CP[i].Email; ProductsPlaceHolder.Text += "<br /> <b>Location on Big Iron:</b> " + CP[i].Location + "<br /><br /> "; numOutputs = 0; tmpParentID = 0; } numOutputs++; } } } }