public ActionResult Edit([Bind(Include = "CategoryID,CategoryName,CategoryShortName,Created,Modified,Remarks,UserID")] INV_Category iNV_Category)
{
if (iNV_Category.CategoryID > 0)
{
if (iNV_Category.Remarks == null || iNV_Category.Remarks == "")
{
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", iNV_Category.UserID);
ModelState.AddModelError("", "Enter Remarks");
return(View(iNV_Category));
}
}
if (ModelState.IsValid)
{
iNV_Category.Created = Convert.ToDateTime(iNV_Category.Created);
iNV_Category.Modified = DateTime.Now;
if (Session["UserID"] != null)
{
iNV_Category.UserID = Convert.ToInt16(Session["UserID"].ToString());
}
db.Entry(iNV_Category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", iNV_Category.UserID);
return(View(iNV_Category));
}
// GET: INV_Category/Create
public ActionResult Create()
{
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName");
INV_Category iNV_Category = new INV_Category();
return(View("Edit", iNV_Category));
}
public int AddCategory(INV_Category saveCate)
{
string sql = "insert into INV_Category(CategoryName,CategoryCode,EnteredBy,EnteredDate,LastUpdatedBy,LastUpdatedDate,DepartmentId,IsDeleted)" +
" values(@CategoryName,@CategoryCode,@EnteredBy,@EnteredDate,0,null,@DepartmentId,0)";
using (var db = DbHelper.GetDBConnection())
{
int id = db.Query <int>(sql, saveCate).SingleOrDefault();
db.Close();
return(id);
}
}
public ActionResult Edit(FormCollection frm, int?id)
{
INV_Category updateCate = new INV_Category();
updateCate.CategoryName = frm["CategoryName"];
updateCate.CategoryCode = frm["CategoryCode"].ToUpper();
updateCate.LastUpdatedDate = DateTime.Now;
updateCate.LastUpdatedBy = Convert.ToInt32(frm["SesUserId"]);
db.UpdateCategory(updateCate, (int)id);
return(RedirectToAction("Index"));
}
public ActionResult Create(FormCollection frm)
{
INV_Category saveCate = new INV_Category();
saveCate.CategoryName = frm["CategoryName"];
saveCate.CategoryCode = frm["CategoryCode"].ToUpper();
saveCate.EnteredDate = DateTime.Now;
saveCate.EnteredBy = Convert.ToInt32(frm["SesUserId"]);
saveCate.DepartmentId = Convert.ToInt32(frm["SesDepartmentId"]);
db.AddCategory(saveCate);
return(RedirectToAction("Index"));
}
// GET: INV_Category/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
INV_Category iNV_Category = db.INV_Category.Find(id);
if (iNV_Category == null)
{
return(HttpNotFound());
}
return(View(iNV_Category));
}
// GET: INV_Category/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
INV_Category iNV_Category = db.INV_Category.Find(id);
if (iNV_Category == null)
{
return(HttpNotFound());
}
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", iNV_Category.UserID);
return(View(iNV_Category));
}
public ActionResult DeleteConfirmed(int id)
{
INV_Category iNV_Category = db.INV_Category.Find(id);
try
{
db.INV_Category.Remove(iNV_Category);
db.SaveChanges();
}
catch (Exception ex)
{
ModelState.AddModelError("", "You can not Delete this Category.");
//return RedirectToAction("Index");
return(View(iNV_Category));
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "CategoryID,CategoryName,CategoryShortName,Created,Modified,Remarks,UserID")] INV_Category iNV_Category)
{
if (ModelState.IsValid)
{
iNV_Category.Created = DateTime.Now;
iNV_Category.Modified = DateTime.Now;
if (Session["UserID"] != null)
{
iNV_Category.UserID = Convert.ToInt16(Session["UserID"].ToString());
}
db.INV_Category.Add(iNV_Category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", iNV_Category.UserID);
return(View(iNV_Category));
}
public bool UpdateCategory(INV_Category updateCate, int Id)
{
string sql = " Update INV_Category set CategoryName=@CategoryName, CategoryCode=@CategoryCode," +
"LastUpdatedDate=@LastUpdatedDate, LastUpdatedBy=@LastUpdatedBy where CategoryId= " + Id;
using (var db = DbHelper.GetDBConnection())
{
var lst = db.Execute(sql, updateCate);
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
