public async Task <IActionResult> Edit(int id, [Bind("Id,FirstName,LastName,Title,BirthDate,City")] Empl empl) { if (id != empl.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(empl); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!EmplExists(empl.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(empl)); }
/// <summary> /// Process employees. Some come, some go. /// </summary> /// <param name="connection">DB Connection</param> private Boolean ProcessEmployees(SqlConnection connection, Random r, TextBox txtResults, String description, int amount) { txtResults.AppendText(Environment.NewLine + description); SqlDataReader reader = null; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Select * from vStoresNotClosedForever"; cmd.CommandType = CommandType.Text; cmd.Connection = connection; int storeID; // Add a random employee for each store that is not closed forever try { reader = cmd.ExecuteReader(); while (reader.Read()) { storeID = Convert.ToInt32(reader.GetValue(0)); Empl.AddRandomEmpl(storeID, r, connection); } reader.Close(); Empl.RandomizeWorkStatusForAllEmployees(connection, r, Write); } catch (Exception ex) { Console.WriteLine("AddTransactions.ProcessEmployees(): " + ex.Message); } finally { try { reader.Close(); } catch (Exception ex) { Utils.Log(ex.Message); } } return(true); }
static void Main(string[] args) { Empl e = AcceptData(); InsertData(e); Console.WriteLine("Record Added Successfully"); SelectData(); }
public ActionResult ConfirmDelete(int id) { Empl empl = repo.Get(id); if (empl != null) { return(View(empl)); } return(NotFound()); }
public ActionResult Details(int id) { Empl empl = repo.Get(id); if (empl != null) { return(View(empl)); } return(NotFound()); }
public async Task <IActionResult> Create([Bind("Id,FirstName,LastName,Title,BirthDate,City")] Empl empl) { if (ModelState.IsValid) { _context.Add(empl); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(empl)); }
private static Empl AcceptData() { Console.WriteLine("Enter Empid, Empname, Gender, city and Deptid"); Empl e = new Empl(); e.Empid = Convert.ToInt32(Console.ReadLine()); e.Name = Console.ReadLine(); e.Gender = Console.ReadLine(); e.Newcity = Console.ReadLine(); e.Deptid = Convert.ToInt32(Console.ReadLine()); return(e); }
public void Main() { Empl test = new Empl() { TestProp = "blub", TestInt = 1 }; if (test.ValidateProperties(Validations.CheckEmptyStringsAndZeroInts)) { Console.WriteLine("validation passed"); } else { Console.WriteLine("validation failed"); } }
private static void Demo() { SimulatorNamespace.SimGrocery sg = new SimulatorNamespace.SimGrocery(); Config.randomNumberSeed = 42; Config.random = new Random(Config.randomNumberSeed); Config.verboseConsoleMode = false; Config.elapsedMinutesToRun = 0; // zero means ignore this limit Config.setTransactionDelay(5); // Seconds Config.useCurrentDateStampForTransaction = true; Config.startDate = DateTime.Now; Config.throughDate = DateTime.Now.AddYears(10); Config.mode = Config.modeEnum.running; Config.server = "il-server-002.uccc.uc.edu\\mssqlserver2019"; Config.login = "******"; Config.password = "******"; Config.database = "GroceryStoreSimulatorIsaiah"; Config.useCoupons = true; Config.checkForAllStoresClosed = true; Config.executeFailSafeOptions = false; // false = do not delete all the history from stores, employees, etc. Config.prioritizeProducts = true; // This is tricky: the index of the selected item in the combo box must map to a specific enum. Be sure both are zero based: Config.storeCheckInterval = Config.enum_availableCheckIntervals.OnThe10s; Config.emplCheckInterval = Config.enum_availableCheckIntervals.OnThe10s; Config.productCheckInterval = Config.enum_availableCheckIntervals.OnThe10s; Config.couponCheckInterval = Config.enum_availableCheckIntervals.OnThe10s; //String[] tmp = cbCouponAmountToAdd.SelectedItem.ToString().Split(); Config.couponAmountToAdd = 100; // After couponCheckInterval int numOfTransactionsToAdd = 0; // 0 = infinite transactions if (Config.executeFailSafeOptions) { ProductPriceHist.CopyFromFromProductTableIntoProductPriceHist(Config.startDate); // Config.earliestPossibleDate); // Fail-safe strategy Empl.MakeAllEmplAvailableToWork(Config.startDate); // Config.earliestPossibleDate); // Fail-safe strategy Store.MakeAllStoreOpenForBusiness(Config.startDate); // Config.earliestPossibleDate); // Fail-safe strategy } //***************************** // Finally, start transacting //***************************** Utils.Log("Starting Simulator..."); sg.StartTransactionSimulation(numOfTransactionsToAdd, Config.random, null, null); }
private static void InsertData(Empl e1) { db.Empls.Add(e1); db.SaveChanges(); }
private void btnStartTransactionSimulator_Click(object sender, EventArgs e) { TextBox.CheckForIllegalCrossThreadCalls = false; // We will spawn a thread that writes to a control on this thread. Boolean validInput = true; DateTime startDate = DateTime.Now, throughDate = DateTime.Now; switch (Config.mode) { case Config.modeEnum.idle: try { // Check to see if the user wants to run for a period of elapsed time or run forever if (cbIgnoreElapsedTime.Checked == true) { Config.elapsedMinutesToRun = 0; // zero means ignore this limit } else { int hours = 0, minutes = 0; String[] split = txtElapsedTimeToRun.Text.Trim().Split(':'); hours = Convert.ToInt32(split[0]); if (split.Length == 2) { minutes = Convert.ToInt32(split[1]); } Config.elapsedMinutesToRun = hours * 60 + minutes; } } catch (Exception ex) { validInput = false; MessageBox.Show("Input error: " + ex.Message, "Check Hours:Minutes to run."); } try { Config.setTransactionDelay(Convert.ToInt32(txtTransactionDelay.Text)); } catch (Exception ex) { MessageBox.Show("Input error: " + ex.Message, "Check Transaction Delay."); Utils.Log(ex.Message); validInput = false; } if (validInput && !cbUseCurrentDateStampForTransaction.Checked) { try { // Don't store these values in the Config object unless both are valid. startDate = Convert.ToDateTime(txtStartDate.Text); throughDate = Convert.ToDateTime(txtThroughDate.Text); if ((throughDate - startDate).TotalDays < 0) { throw new Exception("Through Date must follow or equal Start Date."); } if (startDate < Config.earliestPossibleDate) { throw new Exception("Start date cannot be earlier than " + Config.earliestPossibleDate.ToShortDateString()); } } catch (Exception ex) { validInput = false; MessageBox.Show("Input error: " + ex.Message, "Check Start Date and Through Date."); } } if (validInput) { Config.useCurrentDateStampForTransaction = cbUseCurrentDateStampForTransaction.Checked; Config.startDate = startDate; Config.throughDate = throughDate; Config.mode = Config.modeEnum.running; Config.server = txtServer.Text; Config.login = txtLogin.Text; Config.password = txtPassword.Text; Config.database = txtDatabase.Text; Config.useCoupons = cbUseCoupons.Checked; Config.executeFailSafeOptions = cbExecuteFailSafe.Checked; // This is tricky: the index of the selected item in the combo box must map to a specific enum. Be sure both are zero based: Config.storeCheckInterval = (Config.enum_availableCheckIntervals)cbStoreCheckInterval.SelectedIndex; Config.emplCheckInterval = (Config.enum_availableCheckIntervals)cbEmplCheckInterval.SelectedIndex; Config.productCheckInterval = (Config.enum_availableCheckIntervals)cbProductCheckInterval.SelectedIndex; Config.couponCheckInterval = (Config.enum_availableCheckIntervals)cbCouponCheckInterval.SelectedIndex; String[] tmp = cbCouponAmountToAdd.SelectedItem.ToString().Split(); Config.couponAmountToAdd = Convert.ToInt32(tmp[0]); int numOfTransactionsToAdd; if (cbRunForever.Checked == true) { numOfTransactionsToAdd = 0; // Zero means run forever } else { try { numOfTransactionsToAdd = Convert.ToInt32(txtNumOfTransactionsToAdd.Text); } catch (Exception ex) { MessageBox.Show("Enter the number of transactions to add or select Run Forever", "Invalid Number"); txtNumOfTransactionsToAdd.Focus(); Utils.Log(ex.Message); return; } } try { if (Config.executeFailSafeOptions) { ProductPriceHist.CopyFromFromProductTableIntoProductPriceHist(Config.startDate); // Config.earliestPossibleDate); // Fail-safe strategy Empl.MakeAllEmplAvailableToWork(Config.startDate); // Config.earliestPossibleDate); // Fail-safe strategy Store.MakeAllStoreOpenForBusiness(Config.startDate); // Config.earliestPossibleDate); // Fail-safe strategy } sg.StartTransactionSimulation(numOfTransactionsToAdd, Config.random, txtResults, lblStatus); } catch (Exception ex) { txtResults.Text += "btnGo_Click:" + "sg.StartSimulation: " + ex.Message; } btnStartTransactionSimulator.Text = "Halt"; watch = Stopwatch.StartNew(); lblElapsedTime.Text = ""; ShowTimerControls(true); timer1.Enabled = true; txtSeed.Enabled = false; lblStartTime.Text = (String.Format("{0:hh\\:mm\\:ss tt}", DateTime.Now)); } break; case Config.modeEnum.running: Config.mode = Config.modeEnum.idle; btnStartTransactionSimulator.Text = "Go"; sg.Halt(); watch = null; timer1.Enabled = false; txtSeed.Enabled = true; break; } }
public ActionResult Edit(Empl empl) { repo.Update(empl); return(RedirectToAction("Index")); }
public ActionResult Create(Empl user) { repo.Create(user); return(RedirectToAction("Index")); }
/// <summary> /// Compute random record IDs for the random transaction we will add /// </summary> /// <param name="tp">The set of transaction parameters upon which to operate</param> private void computeRandomValuesForTransaction(TransactionParameters tp, Random r) { try { // Date/time of transaction if (Config.useCurrentDateStampForTransaction) { tp.dateOfTransaction = DateTime.Now.ToShortDateString(); tp.timeOftransaction = DateTime.Now.ToLongTimeString(); } else { tp.dateOfTransaction = Utils.GetRandomDate(r); tp.timeOftransaction = Utils.GetRandomTime(r); } tp.emplID = 0; tp.storeID = Utils.GetRandomStoreID(r, DefaultValues.storeID_count); //tp.storeID = 10; //tp.dateOfTransaction = "1/9/2017"; //tp.timeOftransaction = "12:29:1.656"; //if (tp.storeID == 29) //{ // int tmp = 42; //} while (true) { int emplID; // Pick a random employee that is available for work at the storeID try { emplID = (int)Utils.MyDLookup("EmplID", "SELECT TOP 1 EmplID FROM [fEmplWhoCanWorkOnASpecificDateAtASpecificStore](" + Utils.QuoteMeForSQL(tp.dateOfTransaction) + " ," + tp.storeID + ") ORDER BY NEWID()", "", ""); // SELECT top 1 * FROM [fEmplWhoCanWorkOnASpecificDateAtASpecificStore]('1/1/2016', 2) order by newID() } catch (Exception ex) { emplID = 0; Utils.Log("AddTransactions.computeRandomValuesForTransaction(): " + ex.Message); } // emplID = (int)Utils.MyDLookup("EmplID", "(SELECT ROW_NUMBER() OVER (ORDER BY emplID) AS RowNum, * FROM tEmpl) sub ", " RowNum = " + (r.Next(DefaultValues.emplID_count) + 1), ""); if (emplID > 0) { tp.emplID = emplID; break; } else { //if (tp.storeID == 21) { // int foo = -42; //} Write("### It appears that no employees are available for work. Adding one... ###"); emplID = Empl.AddRandomEmplAndMakeThemAvailableForWork(tp.storeID, DateTime.Parse(tp.dateOfTransaction), connection, r); tp.emplID = emplID; break; } } if (tp.emplID == 0) // Uh oh. No employees available for work at this store... // todo: something here //int tmp = 0; { } tp.loyaltyID = (int)Utils.MyDLookup("loyaltyID", "(SELECT ROW_NUMBER() OVER (ORDER BY loyaltyID) AS RowNum, * FROM tloyalty) sub ", " RowNum = " + (r.Next(DefaultValues.loyaltyID_count) + 1), ""); // A high percentage of transactions should be purchases. int selector = r.Next(100) + 1; // 1 to 100 if (selector >= Config.percentageOfPurchaseTransactions) { // It can be another type of transaction so we will look it up randomly tp.transactionTypeID = (int)Utils.MyDLookup("transactionTypeID", "(SELECT ROW_NUMBER() OVER (ORDER BY transactionTypeID) AS RowNum, * FROM tTransactionType) sub ", " RowNum = " + (r.Next(DefaultValues.transactionTypeID_count) + 1), ""); } else { // It has to be a purchase transaction tp.transactionTypeID = DefaultValues.transactionTypeID_Purchase; } } catch (Exception ex) { // Something went wrong. txtResults.AppendText(Environment.NewLine + "AddTransactions.computeRandomValuesForTransaction: " + ex.Message); } }
// GET: api/Emp/5 public IHttpActionResult GetById(int id) { Empl e = new Empl(); var myObjectResponse = GetObjectFromDb(id); }