public ActionResult DeleteConfirmed(int id) { PinCodes pinCodes = db.PinCodes.Find(id); db.PinCodes.Remove(pinCodes); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(PinCodesViewModel model) { PinCodes pin = new PinCodes(); pin.Id_PinCode = model.Id_PinCode; pin.PinCode = model.PinCode; pin.CreatedAt = model.CreatedAt; pin.LastModifiedAt = DateTime.Now; pin.DeletedAt = model.DeletedAt; pin.Active = model.Active; int customerId = model.Id_Customer ?? 0; if (customerId > 0) { Customers cus = db.Customers.Find(customerId); pin.Id_Customer = customerId; pin.Id_Customer = cus.Id_Customer; } ViewBag.CustomerName = new SelectList((from c in db.Customers select new { Id_Customer = c.Id_Customer, CustomerName = c.CustomerName }), "Id_Customer", "CustomerName", pin.Id_Customer); int contractorId = model.Id_Contractor ?? 0; if (contractorId > 0) { Contractors con = db.Contractors.Find(contractorId); pin.Id_Contractor = customerId; pin.Id_Contractor = con.Id_Contractor; } ViewBag.CompanyName = new SelectList((from co in db.Contractors select new { Id_Contractor = co.Id_Contractor, CompanyName = co.CompanyName }), "Id_Contractor", "CompanyName", pin.Id_Contractor); int employeeId = model.Id_Employee ?? 0; if (employeeId > 0) { Employees emp = db.Employees.Find(employeeId); pin.Id_Employee = employeeId; pin.Id_Employee = emp.Id_Employee; } ViewBag.FirstName = new SelectList((from c in db.Employees select new { Id_Employee = c.Id_Employee, FirstName = c.FirstName }), "Id_Employee", "FirstName", pin.Id_Employee); ViewBag.LastName = new SelectList((from c in db.Employees select new { Id_Employee = c.Id_Employee, LastName = c.LastName }), "Id_Employee", "LastName", pin.Id_Employee); db.SaveChanges(); return(RedirectToAction("Index")); }//edit
}//Index // GET: PinCodes/Details/5 public ActionResult Details(int?id) { PinCodesViewModel model = new PinCodesViewModel(); MobileWorkDataEntities entities = new MobileWorkDataEntities(); try { PinCodes pincodedetail = entities.PinCodes.Find(id); if (pincodedetail == null) { return(HttpNotFound()); } // muodostetaan näkymämalli tietokannan rivien pohjalta PinCodesViewModel view = new PinCodesViewModel(); view.Id_PinCode = pincodedetail.Id_PinCode; view.PinCode = pincodedetail.PinCode; view.CreatedAt = pincodedetail.CreatedAt; view.LastModifiedAt = pincodedetail.LastModifiedAt; view.DeletedAt = pincodedetail.DeletedAt; view.Active = pincodedetail.Active; view.Id_Customer = pincodedetail.Customers?.Id_Customer; view.CustomerName = pincodedetail.Customers?.CustomerName; ViewBag.CustomerName = new SelectList((from c in db.Customers select new { Id_Customer = c.Id_Customer, CustomerName = c.CustomerName }), "Id_Customer", "CustomerName", null); view.Id_Contractor = pincodedetail.Contractors?.Id_Contractor; view.CompanyName = pincodedetail.Contractors?.CompanyName; ViewBag.CompanyName = new SelectList((from co in db.Contractors select new { Id_Contractor = co.Id_Contractor, CompanyName = co.CompanyName }), "Id_Contractor", "CompanyName", null); view.Id_Employee = pincodedetail.Employees?.Id_Employee; view.FirstName = pincodedetail.Employees?.FirstName; view.LastName = pincodedetail.Employees?.LastName; model = view; } finally { entities.Dispose(); } return(View(model)); }//details
public HelperMiddleware(IMiddleware next, StatsPlugin statsPlugin, JsonStoragePlugin jsonStoragePlugin) : base(next) { _r = new Random(); this._statsPlugin = statsPlugin; _jsonStoragePlugin = jsonStoragePlugin; this.HandlerMappings = new HandlerMapping[1] { new HandlerMapping() { ValidHandles = new[] { new AlwaysMatchHandle() }, Description = "Supreme Ruler Roger Ver does not need to explain himself to you", EvaluatorFunc = DiscourseSearch } }; jokes = jsonStoragePlugin.ReadFile <Joke>("jokes").ToList(); PinCodes = jsonStoragePlugin.ReadFile <PinCode>("pincodes").ToList(); UpdateSubscriptions = jsonStoragePlugin.ReadFile <UpdateSubscription>("subscriptions").ToList(); if (!jokes.Any()) { jokes.Add(new Joke() { Content = "bcash is the superior cryptocurrency because big blocks are cool, I guess" }); } if (!PinCodes.Any()) { PinCodes.Add(new PinCode() { Pin = "7dd7aa3a-a5e3-42d5-b651-1de152c75bcb", UserId = "U96S14QGY" }); } _httpClient = new HttpClient(); }
public ActionResult Create(CustomersViewModel model) { MobileWorkDataEntities entities = new MobileWorkDataEntities(); Customers cus = new Customers(); cus.CustomerName = model.CustomerName; cus.ContactPerson = model.ContactPerson; cus.PhoneNumber = model.PhoneNumber; cus.EmailAddress = model.EmailAddress; cus.CreatedAt = DateTime.Now; cus.LastModifiedAt = DateTime.Now; cus.Active = model.Active; db.Customers.Add(cus); PinCodes pic = new PinCodes(); pic.PinCode = model.PinCode; //usr.Password = "******"; pic.Customers = cus; ViewBag.PinCode = new SelectList((from p in db.PinCodes select new { Id_PinCode = p.Id_PinCode, PinCode = p.PinCode }), "Id_PinCode", "PinCode", null); db.PinCodes.Add(pic); try { db.SaveChanges(); } catch (Exception ex) { } return(RedirectToAction("Index")); }//create
}//edit // GET: PinCodes/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PinCodes pincodedetail = db.PinCodes.Find(id); if (pincodedetail == null) { return(HttpNotFound()); } PinCodesViewModel view = new PinCodesViewModel(); view.Id_PinCode = pincodedetail.Id_PinCode; view.PinCode = pincodedetail.PinCode; view.CreatedAt = pincodedetail.CreatedAt; view.LastModifiedAt = DateTime.Now; view.DeletedAt = DateTime.Now; view.Active = pincodedetail.Active; view.Id_Customer = pincodedetail.Customers?.Id_Customer; view.CustomerName = pincodedetail.Customers?.CustomerName; ViewBag.CustomerName = new SelectList((from c in db.Customers select new { Id_Customer = c.Id_Customer, CustomerName = c.CustomerName }), "Id_Customer", "CustomerName", view.Id_Customer); view.Id_Contractor = pincodedetail.Contractors?.Id_Contractor; view.CompanyName = pincodedetail.Contractors?.CompanyName; ViewBag.CompanyName = new SelectList((from co in db.Contractors select new { Id_Contractor = co.Id_Contractor, CompanyName = co.CompanyName }), "Id_Contractor", "CompanyName", view.Id_Contractor); view.Id_Employee = pincodedetail.Employees?.Id_Employee; view.FirstName = pincodedetail.Employees?.FirstName; view.LastName = pincodedetail.Employees?.LastName; return(View(view)); }
public ActionResult Edit(CustomersViewModel model) { Customers cus = new Customers(); cus.CustomerName = model.CustomerName; cus.ContactPerson = model.ContactPerson; cus.PhoneNumber = model.PhoneNumber; cus.EmailAddress = model.EmailAddress; cus.CreatedAt = model.CreatedAt; cus.LastModifiedAt = DateTime.Now; cus.DeletedAt = model.DeletedAt; cus.Active = model.Active; if (cus.PinCodes == null) { PinCodes pic = new PinCodes(); pic.PinCode = model.PinCode; //usr.Password = "******"; pic.Customers = cus; db.PinCodes.Add(pic); } else { PinCodes pic = cus.PinCodes.FirstOrDefault(); if (pic != null) { pic.PinCode = model.PinCode; } } ViewBag.PinCode = new SelectList((from u in db.PinCodes select new { Id_PinCode = u.Id_PinCode, PinCode = u.PinCode }), "Id_PinCode", "PinCode", null); db.SaveChanges(); return(View("Index")); }//edit
public ActionResult Create(PinCodesViewModel model) { MobileWorkDataEntities entities = new MobileWorkDataEntities(); PinCodes pin = new PinCodes(); pin.Id_PinCode = model.Id_PinCode; pin.PinCode = model.PinCode; pin.CreatedAt = DateTime.Now; pin.LastModifiedAt = DateTime.Now; pin.DeletedAt = model.DeletedAt; pin.Active = model.Active; db.PinCodes.Add(pin); int customerId = int.Parse(model.CustomerName); if (customerId > 0) { Customers cus = db.Customers.Find(customerId); pin.Id_Customer = cus.Id_Customer; } ViewBag.CustomerName = new SelectList((from c in db.Customers select new { Id_Customer = c.Id_Customer, CustomerName = c.CustomerName }), "Id_Customer", "CustomerName", null); int contractorId = int.Parse(model.CompanyName); if (contractorId > 0) { Contractors con = db.Contractors.Find(contractorId); pin.Id_Contractor = con.Id_Contractor; } int employeeId = int.Parse(model.FirstName); if (employeeId > 0) { Employees emp = db.Employees.Find(employeeId); pin.Id_Employee = emp.Id_Employee; } int employLastId = int.Parse(model.LastName); if (employLastId > 0) { Employees emp = db.Employees.Find(employLastId); pin.Id_Employee = emp.Id_Employee; } try { db.SaveChanges(); } catch (Exception ex) { } return(RedirectToAction("Index")); }//create
private int getPin(string programName) { return(PinCodes.Where(x => x.ProgramName == programName).First().Pin); }