public static void SaveCustomerMaster(MasterCustomer objMasterCustomer) { using (var dbInvoice = new IncubXpertInvoicingDb()) { dbInvoice.MasterCustomers.AddOrUpdate(objMasterCustomer); dbInvoice.SaveChanges(); } }
public ActionResult SaveCustomerMaster(MasterCustomer objMasterCustomer) { if (ModelState.IsValid) { CustomerMasterBl.SaveCustomerMaster(objMasterCustomer); return(Redirect("~/CustomerMaster")); } else { return(View("CustomerMasterDetail", objMasterCustomer)); } }
public async Task <bool> AddMasterCustomer(MasterCustomerModel model) { MasterCustomer customer = new MasterCustomer() { Id = model.Id, Name = model.Name, Phone = model.Phone }; await _dbContext.MasterCustomers.AddAsync(customer); int affectedRows = await _dbContext.SaveChangesAsync(); return(affectedRows > 0); }
public MasterCustomerCollection GetAllCustomersInColl(DateTime dtCreated) { MasterCustomerCollection customers = null; if (this.TryConnection()) { DatabaseParameters parameters = new DatabaseParameters(); string str = dtCreated.Year.ToString() + "-" + dtCreated.Month.ToString() + "-" + dtCreated.Day.ToString() + " 00:00:00"; base.CurSQLFactory.SelectCommand(parameters, this.DataStructrure.Tables.MasterCustomer.ActualTableName); base.CurSQLFactory.SQL = base.CurSQLFactory.SQL + " WHERE dt_created >= CAST('" + str + "' AS DATETIME)"; DataTable table = base.CurDBEngine.SelectQuery(base.CurSQLFactory.SQL); if (table == null) { return(customers); } customers = new MasterCustomerCollection(); foreach (DataRow row in table.Rows) { MasterCustomer customer = new MasterCustomer(row[this.DataStructrure.Tables.MasterCustomer.CustomerID.ActualFieldName].ToString()) { cust_name1 = row[this.DataStructrure.Tables.MasterCustomer.Name1.ActualFieldName].ToString(), cust_name2 = row[this.DataStructrure.Tables.MasterCustomer.Name2.ActualFieldName].ToString(), cust_city = row[this.DataStructrure.Tables.MasterCustomer.City.ActualFieldName].ToString(), cust_country = row[this.DataStructrure.Tables.MasterCustomer.Country.ActualFieldName].ToString(), cust_currency = row[this.DataStructrure.Tables.MasterCustomer.Currency.ActualFieldName].ToString(), cust_distrchannel = row[this.DataStructrure.Tables.MasterCustomer.DistrChannel.ActualFieldName].ToString(), cust_division = row[this.DataStructrure.Tables.MasterCustomer.DistrChannel.ActualFieldName].ToString(), cust_fax = row[this.DataStructrure.Tables.MasterCustomer.Fax.ActualFieldName].ToString(), cust_incoterms = row[this.DataStructrure.Tables.MasterCustomer.Incoterms.ActualFieldName].ToString(), cust_incoterms2 = row[this.DataStructrure.Tables.MasterCustomer.Incoterms2.ActualFieldName].ToString(), cust_peymentterms = row[this.DataStructrure.Tables.MasterCustomer.PaymentTerms.ActualFieldName].ToString(), cust_po = row[this.DataStructrure.Tables.MasterCustomer.PO.ActualFieldName].ToString(), cust_region = row[this.DataStructrure.Tables.MasterCustomer.Region.ActualFieldName].ToString(), cust_salesorg = row[this.DataStructrure.Tables.MasterCustomer.SalesOrg.ActualFieldName].ToString(), cust_street = row[this.DataStructrure.Tables.MasterCustomer.Street.ActualFieldName].ToString(), cust_tel1 = row[this.DataStructrure.Tables.MasterCustomer.Tel.ActualFieldName].ToString(), dt_created = row[this.DataStructrure.Tables.MasterCustomer.dtCreated.ActualFieldName].ToString() }; customers.Add(customer); } } return(customers); }
public void Create(ref MeasurementTool tool, List <MasterItem> items = null, List <MasterCustomer> customers = null) { int workloadSize = 10_00; long maxVal = Customers.OrderByDescending(cus => cus.ID).First().ID; MasterCustomer[] cusArray = MasterCustomer.GenerateCustomers(500, "createDeNorm", maxVal).ToArray(); MasterItem[] itemArray = items.ToArray(); Random new_or_oldSelector = new Random(4573); Random customerGenSelector = new Random(867542); Random customerSelector = new Random(456542); Random satisfySelector = new Random(2678); Random storeSelector = new Random(236786); Random diffItemSelector = new Random(83457); Random quantityItemSelector = new Random(6526); Random itemSelector = new Random(572); Random dateSelector = new Random(6762); DateTime startDate = new DateTime(2020, 1, 2); DateTime endDate = new DateTime(2020, 5, 28); int range = (endDate - startDate).Days; for (int i = 0; i < workloadSize; i++) { Console.WriteLine($"{i} ud af {workloadSize}"); int new_old = new_or_oldSelector.Next(0, 2); string title = new_old == 0 ? "PostgreSQL,Sale,DeNorm,Create,New user" : "PostgreSQL,Sale,DeNorm,Create,Existing user"; Customer customer = null; //New if (new_old == 0) { MasterCustomer tmpcustomer = cusArray[customerGenSelector.Next(0, cusArray.Length)]; customer = new Customer { Age = tmpcustomer.Age, Email = tmpcustomer.Email, Gender = tmpcustomer.Gender, }; tool.Stopwatch.Start(); Customers.Add(customer); Console.WriteLine(customer.ID); SaveChanges(); tool.Stopwatch.Stop(); } //Exisiting else { int max = (int)Customers.OrderByDescending(cus => cus.ID).First().ID; long ranpos = (long)customerSelector.Next(1, max); customer = Customers.Find(ranpos); } int satisfactorynumber = satisfySelector.Next(0, 10); //Item selection and Saleitem creation List <string> usedItems = new List <string>(); int diffItems = diffItemSelector.Next(1, 5); long? tmpSaleId = null; for (int j = 0; j < diffItems; j++) { int itemIndex = itemSelector.Next(0, itemArray.Length); if (!usedItems.Contains(itemArray[itemIndex].Name)) { // Find item usedItems.Add(itemArray[itemIndex].Name); int itemQuant = quantityItemSelector.Next(1, 5); Item foundItem = Items.Where(it => it.Name.Equals(itemArray[itemIndex].Name)).First(); //Sale creation Sale sale = new Sale { ID = tmpSaleId, ItemId = foundItem.ID, ItemName = foundItem.Name, ItemPrice = foundItem.Price, ItemQuantity = itemQuant, CustomerId = customer.ID, CustomerAge = customer.Age, CustomerEmail = customer.Email, CustomerGender = customer.Gender, Date = startDate.AddDays(dateSelector.Next(range)), CouponUsed = false, PurchaseMethod = "Card", StoreLocation = StoreLocation.Locations[storeSelector.Next(0, 9)], CustomerSatisfactoryNumber = satisfactorynumber }; tool.Stopwatch.Start(); Sales.Add(sale); SaveChanges(); tool.Stopwatch.Stop(); tmpSaleId = sale.ID; } else { break; } } //Saves measurements every sale update tool.SaveAndReset(title); } }
static void Main(string[] args) { Console.WriteLine("Initialising"); Console.WriteLine("Reading files"); //Both CSV files has the properties: BuildAction=None, CopyToOutputDir=Always List <MasterItem> Items = ParseItem(); List <string> tags = TagList(Items); List <MasterCustomer> Customers = MasterCustomer.GenerateCustomers(30); DbRunnerTest(PsqlSaleDeNormDbContext.GetTypeName().FullName, Customers, Items, tags); int cmd = 0; if (args.Length > 0) { int.TryParse(args[0], out cmd); } switch (cmd) { case 0: // run all as default, arguments can be used when using multiple docker containers Console.WriteLine("Running all dbs"); //DbRunner(MonBankDeNormDbContext.GetTypeName().FullName, Customers, Items); /* * DbRunner(MonBankNormDbContext.GetTypeName().FullName, Customers, Items); * DbRunner(MonSaleDeNormDbContext.GetTypeName().FullName, Customers, Items); * DbRunner(MonSaleNormDbContext.GetTypeName().FullName, Customers, Items); * DbRunner(PsqlBankDeNormDbContext.GetTypeName().FullName, Customers, Items); * DbRunner(PsqlBankNormDbContext.GetTypeName().FullName, Customers, Items); * DbRunner(PsqlSaleDeNormDbContext.GetTypeName().FullName, Customers, Items); * DbRunner(PsqlSaleNormDbContext.GetTypeName().FullName, Customers, Items); */ break; case 1: Console.WriteLine("Running MonBankDeNormDbContext"); DbRunner(MonBankDeNormDbContext.GetTypeName().FullName, Customers, Items, tags); break; case 2: Console.WriteLine("Running MonBankNormDbContext"); DbRunner(MonBankNormDbContext.GetTypeName().FullName, Customers, Items, tags); break; case 3: Console.WriteLine("Running MonSaleDeNormDbContext"); DbRunner(MonSaleDeNormDbContext.GetTypeName().FullName, Customers, Items, tags); break; case 4: Console.WriteLine("Running MonSaleNormDbContext"); DbRunner(MonSaleNormDbContext.GetTypeName().FullName, Customers, Items, tags); break; case 5: Console.WriteLine("Running PsqlBankDeNormDbContext"); DbRunner(PsqlBankDeNormDbContext.GetTypeName().FullName, Customers, Items, tags); break; case 6: Console.WriteLine("Running PsqlBankNormDbContext"); DbRunner(PsqlBankNormDbContext.GetTypeName().FullName, Customers, Items, tags); break; case 7: Console.WriteLine("Running PsqlSaleDeNormDbContext"); DbRunner(PsqlSaleDeNormDbContext.GetTypeName().FullName, Customers, Items, tags); break; case 8: Console.WriteLine("Running PsqlSaleNormDbContext"); DbRunner(PsqlSaleNormDbContext.GetTypeName().FullName, Customers, Items, tags); break; } }