private void btnSave_Click(object sender, EventArgs e) { int er = 0; if (txtName.Text == "") { er++; ep.SetError(txtName, "Required"); } if (txtPrimaryqty.Text == "") { er++; ep.SetError(txtPrimaryqty, "Required"); } if (er > 0) { return; } DAL.Unit unit = new DAL.Unit(); unit.Name = txtName.Text; unit.PrimaryQty = Convert.ToDouble(txtPrimaryqty.Text); unit.Description = txtDescription.Text; if (unit.Insert()) { MessageBox.Show("Data Saved"); MyControls.Helper.clear(this); txtName.Focus(); } else { MessageBox.Show(unit.Error); } }
private void frmProductPriceNew_Load(object sender, EventArgs e) { DAL.Product p = new DAL.Product(); DAL.Unit u = new DAL.Unit(); cmbProduct.Source(p.Select()); cmbUnit.Source(u.Select()); MyControls.Helper.Numeric(txtPrice); }
public ActionResult SaveUnit(Models.UnitModel data) { if (!ModelState.IsValid) { if (data.uid == 0) { _db = new QSoft_WUEntities(); DAL.Unit code = _db.Unit.Where(p => p.ucode == data.ucode).FirstOrDefault(); if (code != null) { return(Json(false, JsonRequestBehavior.AllowGet)); } else { System.Web.HttpContext.Current.Application.Lock(); _db = new QSoft_WUEntities(); _db.Unit.Add(new DAL.Unit { ucode = data.ucode, uname1 = data.uname1, uname2 = data.uname2, ccode = data.ccode }); _db.SaveChanges(); System.Web.HttpContext.Current.Application.UnLock(); return(Json(true, JsonRequestBehavior.AllowGet)); } } } if (ModelState.IsValid) { if (data.uid != 0) { _db = new QSoft_WUEntities(); DAL.Unit code = _db.Unit.Where(p => p.ucode == data.ucode && p.uid != data.uid).FirstOrDefault(); if (code != null) { return(Json(false, JsonRequestBehavior.AllowGet)); } else { DAL.Unit edit = _db.Unit.Where(p => p.uid == data.uid).FirstOrDefault(); edit.ucode = data.ucode; edit.uname1 = data.uname1; edit.uname2 = data.uname2; edit.ccode = data.ccode; _db.SaveChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); } } } return(View(data)); }
public ActionResult DeleteUnit(int uid) { if (uid != 0) { System.Web.HttpContext.Current.Application.Lock(); DAL.Unit delete = _db.Unit.Where(p => p.uid == uid).FirstOrDefault(); _db.Unit.Remove(delete); _db.SaveChanges(); System.Web.HttpContext.Current.Application.UnLock(); return(Json(true, JsonRequestBehavior.AllowGet)); } return(Json(false, JsonRequestBehavior.AllowGet)); }
private void btnSearch_Click(object sender, EventArgs e) { DAL.Unit unit = new DAL.Unit(); dgvUnit.DataSource = unit.Select().Tables[0]; }