public ActionResult Create([Bind(Include = "tid,name")] Type type) { if (ModelState.IsValid) { db.Types.Add(type); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(type)); }
public ActionResult Create([Bind(Include = "uid,username,password,name,accessLevel")] User user) { if (ModelState.IsValid) { db.Users.Add(user); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult Create([Bind(Include = "mid,name")] Manufacturer manufacturer) { if (ModelState.IsValid) { db.Manufacturers.Add(manufacturer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(manufacturer)); }
public ActionResult Create([Bind(Include = "cid,fname,mname,lname,gender,dob,phone,mob,mobAlt,email,address,dlNo,tinNo")] Customer customer) { if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.gender = new SelectList(db.Genders, "value", "value", customer.gender); return(View(customer)); }
public ActionResult Create([Bind(Include = "pid,name,weight,tid,mid,mrp,rate,vat,discount")] Product product) { if (ModelState.IsValid) { db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.mid = new SelectList(db.Manufacturers, "mid", "name", product.mid); ViewBag.tid = new SelectList(db.Types, "tid", "name", product.tid); return(View(product)); }
public ActionResult GenerateNewInvoice(Invoice mdl) { int?invoiceId = db.Invoice_IdMax().First(); mdl.id = (int)invoiceId + 1; mdl.date = DateTime.Now; mdl.uid = 1; mdl.status = 11; db.Invoices.Add(mdl); db.SaveChanges(); return(RedirectToAction("GenerateInvoice", new { id = mdl.id })); //return View("GenerateInvoice", mdl); }
public ActionResult Create([Bind(Include = "iid,pid,quantity,exDate,batchNo,status")] Inventory inventory) { if (ModelState.IsValid) { db.Inventories.Add(inventory); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.pid = new SelectList(db.Products, "pid", "name", inventory.pid); ViewBag.status = new SelectList(db.Status, "id", "description", inventory.status); return(View(inventory)); }
public ActionResult Create([Bind(Include = "id,cid,uid,date,dueDate,status")] Invoice invoice) { if (ModelState.IsValid) { db.Invoices.Add(invoice); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.cid = new SelectList(db.Customers, "cid", "fname", invoice.cid); ViewBag.status = new SelectList(db.Status, "id", "description", invoice.status); ViewBag.uid = new SelectList(db.Users, "uid", "username", invoice.uid); return(View(invoice)); }
protected void btnLogin_Click(object sender, EventArgs e) { if (txtUser.Text == "") { lbMsg.Text = "กรุณาระบุ Username !!!"; return; } if (txtPass.Text == "") { lbMsg.Text = "กรุณาระบุ Password !!!"; return; } MasUserLogin o = new MasUserLogin(); Session["Username"] = txtUser.Text; using (BillingEntities cre = new BillingEntities()) { o = cre.MasUserLogins.FirstOrDefault(w => w.Username.Equals(txtUser.Text) && w.Password.Equals(txtPass.Text)); if (o != null && o.Active == "Y") { Session["Username"] = o.Username; o.LastLogin = DateTime.Now; cre.SaveChanges(); } else { lbMsg.Text = "Username, Password ไม่ถูกต้อง !!!"; return; } }; Response.Redirect("/Default.aspx"); }
protected void imgbtnDelete_Click(object sender, ImageClickEventArgs e) { try { ImageButton imb = new ImageButton(); imb = (ImageButton)sender; if (imb != null) { Int32 ID = ToInt32(imb.CommandArgument); TransSaleHeader o = new TransSaleHeader(); using (BillingEntities cre = new BillingEntities()) { o = cre.TransSaleHeaders.FirstOrDefault(w => w.SaleHeaderID.Equals(ID)); if (o != null) { cre.TransSaleHeaders.Remove(o); cre.SaveChanges(); } }; } ShowMessageBox("ลบรายการสำเร็จ."); BindData(); } catch (Exception ex) { } }
protected void btnModalSave_Click(object sender, EventArgs e) { try { //Validate if (txtMUnitCode.Text == "") { ShowMessageBox("กรุณาระบุ ชื่อลูกค้า !!!"); ModalPopupExtender1.Show(); return; } if (txtMUnitName.Text == "") { ShowMessageBox("กรุณาระบุ รหัส !!!"); ModalPopupExtender1.Show(); return; } MasUnit o = new MasUnit(); if (hddMode.Value == "Add") // Add { o = new MasUnit(); o.UnitCode = txtMUnitCode.Text; o.UnitName = txtMUnitName.Text; o.Active = "Y"; o.CreatedBy = GetUsername(); o.CreatedDate = DateTime.Now; using (BillingEntities cre = new BillingEntities()) { cre.MasUnits.Add(o); cre.SaveChanges(); }; } else //Edit { int objID = ToInt32(hddID.Value); using (BillingEntities cre = new BillingEntities()) { o = cre.MasUnits.FirstOrDefault(w => w.UnitID.Equals(objID)); if (o != null) { o.UnitCode = txtMUnitCode.Text; o.UnitName = txtMUnitName.Text; o.UpdatedBy = GetUsername(); o.UpdatedDate = DateTime.Now; } cre.SaveChanges(); }; } BindData(); ShowMessageBox("บันทึกข้อมูลสำเร็จ."); } catch (Exception ex) { ShowMessageBox("เกิดข้อผิดพลาด กรุณาติดต่อผู้ดูแลระบบ."); SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void imgbtnDelete_Click(object sender, ImageClickEventArgs e) { try { ImageButton imb = (ImageButton)sender; if (imb != null) { MasUnit obj = new MasUnit(); int objID = ToInt32(imb.CommandArgument); using (BillingEntities cre = new BillingEntities()) { obj = cre.MasUnits.FirstOrDefault(w => w.UnitID.Equals(objID)); if (obj != null) { obj.Active = "N"; obj.UpdatedBy = GetUsername(); obj.UpdatedDate = DateTime.Now; } //cre.MasUnits.Remove(obj); cre.SaveChanges(); }; BindData(); } else { SendMailError("imb is null", System.Reflection.MethodBase.GetCurrentMethod()); } } catch (Exception ex) { ShowMessageBox("เกิดข้อผิดพลาด กรุณาติดต่อผู้ดูแลระบบ."); SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }
public ActionResult Delete(int id) { BillingEntities db = new BillingEntities(); var getdata = db.Bills.FirstOrDefault(m => m.B_no == id); db.Bills.Remove(getdata); db.SaveChanges(); return(RedirectToAction("Display", "Home")); }
public ActionResult Insert(BillModel d) { BillingEntities db = new BillingEntities(); Bill B = new Bill(); B.Product = d.Product; B.Price = d.Price; B.Date = d.Date; db.Bills.Add(B); db.SaveChanges(); ViewBag.Text = "Details Inserted"; return(RedirectToAction("Display", "Home")); }
public ActionResult Update(int ID, BillModel dt) { BillingEntities db = new BillingEntities(); var getdata = db.Bills.FirstOrDefault(m => m.B_no == ID); getdata.Product = (string)dt.Product; getdata.Price = (Decimal)dt.Price; getdata.Date = (DateTime)dt.Date; db.SaveChanges(); ViewBag.Text = "Details Updated"; return(RedirectToAction("Display", "Home")); }
protected void LoginUser_LoggedIn(object sender, EventArgs e) { var loginForm = (System.Web.UI.WebControls.Login)sender; BillingEntities db = new BillingEntities(); User user = db.Users.FirstOrDefault(s => s.Login.ToLower() == loginForm.UserName.ToLower()); if (user == null) return; db.UsersLogs.AddObject(new UsersLog { Date = DateTime.Now, Text = "User logged in from Ip " + Request.UserHostAddress, UserId = user.Id }); //user.IpAddress = Request.UserHostAddress; db.SaveChanges(); }
protected void btnModalSave_Click(object sender, EventArgs e) { try { //Validate if (txtMNewPass.Text == "" || txtMCheckPass.Text == "") { ShowMessageBox("กรุณาระบุ Password !!!"); ModalPopupExtender1.Show(); return; } if (txtMNewPass.Text != txtMCheckPass.Text) { ShowMessageBox("ระบุ Password ไม่ตรงกัน !!!"); ModalPopupExtender1.Show(); return; } MasUserLogin o = new MasUserLogin(); if (hddMode.Value == "Add") // Add { o = new MasUserLogin(); o.Username = txtMUsername.Text; o.Password = txtMNewPass.Text; o.Active = chkActive.Checked ? "Y" : "N"; using (BillingEntities cre = new BillingEntities()) { cre.MasUserLogins.Add(o); cre.SaveChanges(); }; BindData(); ShowMessageBox("บันทึกข้อมูลสำเร็จ."); } else //Edit { using (BillingEntities cre = new BillingEntities()) { o = cre.MasUserLogins.FirstOrDefault(w => w.Username.Equals(txtMUsername.Text)); if (o != null) { if (o.Password != txtMOldPass.Text) { ShowMessageBox("Password ไม่ถูกต้อง !!!"); ModalPopupExtender1.Show(); } else { o.Password = txtMNewPass.Text; o.Active = chkActive.Checked ? "Y" : "N"; cre.SaveChanges(); BindData(); ShowMessageBox("บันทึกข้อมูลสำเร็จ."); } } }; } } catch (Exception ex) { ShowMessageBox("เกิดข้อผิดพลาด กรุณาติดต่อผู้ดูแลระบบ."); SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }
public virtual T Add(T t) { _context.Set <T>().Add(t); _context.SaveChanges(); return(t); }