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);
}
}
}
