public bool UpdateUnit(MS_Unit unit) { string sql = " Update MS_Unit set UnitName=@UnitName, UnitCode=@UnitCode, " + " OrganizationId=@OrganizationId, " + " EnteredBy=@EnteredBy, EnteredDate=@EnteredDate,LastUpdatedBy=@LastUpdatedBy, " + " LastUpdatedDate=@LastUpdatedDate, IsDeleted=0, DeletedBy=0, DeletedDate=null" + " where UnitId=@UnitId"; using (var db = DbHelper.GetDBConnection()) { using (var trsn = new TransactionScope()) { //db.Execute(sql); var lst = db.Execute(sql, unit); trsn.Complete(); db.Close(); if (lst > 0) { return(true); } else { return(false); } } } }
public bool InsertUnit(MS_Unit unit) { string sql = " Insert into MS_Unit (UnitName, UnitCode,OrganizationId, EnteredBy, EnteredDate," + " LastUpdatedBy, LastUpdatedDate, IsDeleted, DeletedBy, DeletedDate) " + " values " + "(@UnitName, @UnitCode,@OrganizationId, @EnteredBy, @EnteredDate," + " 0, null, 0, 0, null)"; using (var db = DbHelper.GetDBConnection()) { using (var trsn = new TransactionScope()) { //db.Execute(sql); var lst = db.Execute(sql, unit); trsn.Complete(); db.Close(); if (lst > 0) { return(true); } else { return(false); } } } }
// GET: Unit/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MS_Unit mS_Unit = db.GetUnitById((int)id); if (mS_Unit == null) { return(HttpNotFound()); } return(View(mS_Unit)); }
public ActionResult Edit(FormCollection frm) { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; MS_Unit mS_Unit = db.GetUnitById(Convert.ToInt32(frm["UnitId"])); mS_Unit.UnitName = frm["UnitName"]; // mS_Unit.UnitCode = frm["UnitCode"]; mS_Unit.OrganizationId = orgid; mS_Unit.LastUpdatedBy = (User as CustomPrincipal).UserId; mS_Unit.LastUpdatedDate = DateTime.Now; if (ModelState.IsValid) { db.UpdateUnit(mS_Unit); return(RedirectToAction("Index")); } return(View(mS_Unit)); }
public ActionResult Create(FormCollection frm) { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; MS_Unit mS_Unit = new MS_Unit(); mS_Unit.UnitName = frm["UnitName"]; //mS_Unit.UnitCode = frm["UnitCode"]; mS_Unit.OrganizationId = orgid; mS_Unit.EnteredBy = (User as CustomPrincipal).UserId; mS_Unit.EnteredDate = DateTime.Now; if (ModelState.IsValid) { db.InsertUnit(mS_Unit); return(RedirectToAction("Index")); } return(View(mS_Unit)); }