public ActionResult DeleteConfirmed(int id)
{
INV_Unit iNV_Unit = db.INV_Unit.Find(id);
db.INV_Unit.Remove(iNV_Unit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public int AddUnit(INV_Unit saveUnit)
{
string sql = "insert into INV_Unit(UnitName,UnitCode,EnteredBy,EnteredDate,LastUpdatedBy,LastUpdatedDate,DepartmentId,IsDeleted)" +
" values(@UnitName,@UnitCode,@EnteredBy,@EnteredDate,0,null,@DepartmentId,0)";
using (var db = DbHelper.GetDBConnection())
{
int id = db.Query <int>(sql, saveUnit).SingleOrDefault();
db.Close();
return(id);
}
}
public ActionResult Edit(FormCollection frm, int?id)
{
INV_Unit updateUnit = new INV_Unit();
updateUnit.UnitName = frm["UnitName"];
updateUnit.UnitCode = frm["UnitCode"].ToUpper();
updateUnit.LastUpdatedDate = DateTime.Now;
updateUnit.LastUpdatedBy = Convert.ToInt32(frm["SesUserId"]);
db.UpdateUnit(updateUnit, (int)id);
return(RedirectToAction("Index"));
}
public ActionResult Create(FormCollection frm)
{
INV_Unit saveUnit = new INV_Unit();
saveUnit.UnitName = frm["UnitName"];
saveUnit.UnitCode = frm["UnitCode"].ToUpper();
saveUnit.EnteredDate = DateTime.Now;
saveUnit.EnteredBy = Convert.ToInt32(frm["SesUserId"]);
saveUnit.DepartmentId = Convert.ToInt32(frm["SesDepartmentId"]);
db.AddUnit(saveUnit);
return(RedirectToAction("Index"));
}
// GET: INV_Unit/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
INV_Unit iNV_Unit = db.INV_Unit.Find(id);
if (iNV_Unit == null)
{
return(HttpNotFound());
}
return(View(iNV_Unit));
}
public ActionResult Create([Bind(Include = "UnitID,UserID,Unit,Remarks,Created,Modified")] INV_Unit iNV_Unit)
{
if (ModelState.IsValid)
{
iNV_Unit.Created = DateTime.Now;
iNV_Unit.Modified = DateTime.Now;
if (Session["UserID"] != null)
{
iNV_Unit.UserID = Convert.ToInt16(Session["UserID"].ToString());
}
db.INV_Unit.Add(iNV_Unit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(iNV_Unit));
}
public bool UpdateUnit(INV_Unit updateUnit, int Id)
{
string sql = " Update INV_Unit set UnitName=@UnitName, UnitCode=@UnitCode," +
"LastUpdatedDate=@LastUpdatedDate, LastUpdatedBy=@LastUpdatedBy where UnitId= " + Id;
using (var db = DbHelper.GetDBConnection())
{
var lst = db.Execute(sql, updateUnit);
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public ActionResult Edit([Bind(Include = "UnitID,UserID,Unit,Remarks,Created,Modified")] INV_Unit iNV_Unit)
{
if (iNV_Unit.UnitID > 0)
{
if (iNV_Unit.Remarks == null || iNV_Unit.Remarks == "")
{
ModelState.AddModelError("", "Enter Remarks");
return(View(iNV_Unit));
}
}
if (ModelState.IsValid)
{
db.Entry(iNV_Unit).State = EntityState.Modified;
iNV_Unit.Created = Convert.ToDateTime(iNV_Unit.Created);
iNV_Unit.Modified = DateTime.Now;
if (Session["UserID"] != null)
{
iNV_Unit.UserID = Convert.ToInt16(Session["UserID"].ToString());
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(iNV_Unit));
}
// GET: INV_Unit/Create
public ActionResult Create()
{
INV_Unit iNV_Unit = new INV_Unit();
return(View("Edit", iNV_Unit));
}
