private void EditCompany(Company company) { CustomerDetailsControl details = new CustomerDetailsControl(company.CompanyType.Type); details.DataContext = company; if (details.ShowDialog() == true) { DBResources.Instance.Save(); } }
public static string GetPurchaseOrderNumber(Company supplier, Order order) { string startYear = string.Empty; string endYear = string.Empty; int currentYear = int.Parse(DateTime.Now.ToString("yy")); string poUniqueNumber = order.OrderID.ToString() + "-" + (order.PurchaseOrders.Count + 1).ToString(); string customerCode = order.Customer.Name.Substring(0, 2).ToUpper(); if (DateTime.Now.Month >= 4) { startYear = currentYear.ToString(); endYear = (currentYear + 1).ToString(); } else { startYear = (currentYear - 1).ToString(); endYear = currentYear.ToString(); } return string.Format("TCIPL/{0}-{1}/{2}/{3}",startYear, endYear, customerCode, poUniqueNumber); }
public static string GetSupplierInformation(Company supplier) { StringBuilder sb = new StringBuilder(); sb.AppendLine(supplier.Name + ","); if (!string.IsNullOrEmpty(supplier.Address1)) sb.AppendLine(supplier.Address1 + ","); if (!string.IsNullOrEmpty(supplier.Address2)) sb.AppendLine(supplier.Address2 + ","); sb.AppendLine(supplier.City + "," + supplier.State + ","); sb.AppendLine(supplier.Country + "."); sb.AppendLine("TIN No: "); sb.Append(supplier.TIN); sb.AppendLine("CST No: "); sb.AppendLine(supplier.CST); return sb.ToString(); }
private Company NewCompany(string type, string companyName) { CustomerDetailsControl details = new CustomerDetailsControl(type); Company newCompany = new Company(); newCompany.Name = companyName; details.DataContext = newCompany; if (details.ShowDialog() == true) { return DBResources.Instance.SaveNewCompany(newCompany, type); } return null; }
private string GetPurchaseOrderNumber(Company supplier) { return Constants.GetPurchaseOrderNumber(supplier, Order); }
public Company SaveNewCompany(Company company, string type) { OrderManagerDBEntities localContext = new OrderManagerDBEntities(); try { var companyType = localContext.CompanyTypes.Where(c => c.Type == type).Select(c => c).FirstOrDefault(); company.CompanyTypeID = companyType.CompanyTypeID; company.CompanyType = companyType; localContext.Companies.Add(company); localContext.SaveChanges(); localContext.Dispose(); } catch { throw; } Companies = new ObservableCollection<Company>(dbContext.Companies.ToList()); Company newCompany = null; if (Companies != null) { newCompany = Companies.Where(c => (c.CompanyType.Type == company.CompanyType.Type && c.Name == company.Name)).Select(c => c).FirstOrDefault(); } else return null; switch (company.CompanyType.Type) { case "Customer": Customers = UpdateCompaniesCollection("Customer"); break; case "Agent": Agents = UpdateCompaniesCollection("Agent"); break; case "Supplier": Suppliers = UpdateCompaniesCollection("Supplier"); break; } return newCompany; }
//Create a new Company of type passed in the arguments public Company CreateNewCompany(string type) { Company newCompany = new Company(); var companyType = dbContext.CompanyTypes.Where(c => c.Type == type) .Select(c => c) .FirstOrDefault(); newCompany.CompanyTypeID = companyType.CompanyTypeID; //newCompany.CompanyType = companyType; return newCompany; }
public PurchaseOrder CreateNewPurchaseOrder(Order order, Company supplier, string purchseOrderNumber) { PurchaseOrder newPO = new PurchaseOrder(); newPO.PurchaseOrderNumber = purchseOrderNumber; newPO.SupplierID = supplier.CompanyID; newPO.OrderID = order.OrderID; newPO.PurchaseOrderStatusID = 1; OrderManagerDBEntities newManager = new OrderManagerDBEntities(); newManager.PurchaseOrders.Add(newPO); newManager.SaveChanges(); newManager.Dispose(); newPO = GetPurchaseOrder(purchseOrderNumber); return newPO; }
private bool EditSupplier(Company company) { CustomerDetailsControl details = new CustomerDetailsControl("Supplier"); details.DataContext = company; if (details.ShowDialog() == true) { DBResources.Instance.Save(); return true; } return false; }
public PurchaseOrderNumberInfo(Company supplier, Order order) { Supplier = supplier; PurchaseOrderNumber = Constants.GetPurchaseOrderNumber(supplier, order); }
private string GetAddress(Company supplier) { StringBuilder sb = new StringBuilder(); sb.AppendLine(supplier.Name + ","); if (!string.IsNullOrEmpty(supplier.Address1)) sb.AppendLine(supplier.Address1 + ","); if (!string.IsNullOrEmpty(supplier.Address2)) sb.AppendLine(supplier.Address2 + ","); sb.AppendLine(supplier.City + "," + supplier.State + ","); sb.AppendLine(supplier.Country + "."); return sb.ToString(); }