public ActionResult Edit(FormCollection frm, int?id) { A_Category updateCate = new A_Category(); updateCate.CategoryName = frm["CategoryName"]; updateCate.CategoryCode = frm["CategoryCode"].ToUpper(); updateCate.LastUpdatedDate = DateTime.Now; updateCate.LastUpdatedBy = Convert.ToInt32(Session["UserId"]); db.UpdateCategory(updateCate, (int)id); return(RedirectToAction("Index")); }
public ActionResult Create(FormCollection frm) { A_Category saveCate = new A_Category(); saveCate.CategoryName = frm["CategoryName"]; saveCate.CategoryCode = frm["CategoryCode"].ToUpper(); saveCate.EnteredDate = DateTime.Now; saveCate.EnteredBy = Convert.ToInt32(Session["UserId"]); saveCate.DepartmentId = Convert.ToInt32(Session["DepartmentId"]); db.AddCategory(saveCate); return(RedirectToAction("Index")); }
public int AddCategory(A_Category saveCate) { string sql = "insert into A_Category(CategoryName,CategoryCode,EnteredBy,EnteredDate,LastUpdatedBy,LastUpdatedDate,DepartmentId," + "IsDeleted,DeletedBy,DeletedDate)" + " values(@CategoryName,@CategoryCode,@EnteredBy,@EnteredDate,0,null,@DepartmentId," + "0,0,null)"; using (var db = DbHelper.GetDBConnection()) { int id = db.Query <int>(sql, saveCate).SingleOrDefault(); db.Close(); return(id); } }
public bool UpdateCategory(A_Category updateCate, int Id) { string sql = " Update A_Category set CategoryName=@CategoryName, CategoryCode=@CategoryCode," + "LastUpdatedDate=@LastUpdatedDate, LastUpdatedBy=@LastUpdatedBy where IsDeleted=0 and CategoryId= " + Id; using (var db = DbHelper.GetDBConnection()) { var lst = db.Execute(sql, updateCate); db.Close(); if (lst > 0) { return(true); } else { return(false); } } }