public object DeleteCategory(CategoryParam MP) { try { Tbl_Category_Master objcategory = db.Tbl_Category_Master.Where(r => r.CategoryID == MP.CategoryID).FirstOrDefault(); if (objcategory.Status == 1) { objcategory.Status = 0; } else { objcategory.Status = 1; } db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Category Updated Successfully!" }); } catch (Exception ex) { return(new Error() { IsError = true, Message = ex.Message }); } }
public object SaveCategory(CategoryParam MP) { try { string msg = ""; if (MP.BtnStatus == "Save") { var usercode = db.Tbl_Category_Master.Where(r => r.CategoryName == MP.CategoryName.ToUpper()).FirstOrDefault(); if (usercode != null) { return(new Error() { IsError = true, Message = "Category Name Already Exists!" }); } Tbl_Category_Master objCategory = new Tbl_Category_Master(); objCategory.CategoryName = MP.CategoryName.ToUpper(); objCategory.CreatedBy = MP.CreatedBy; objCategory.CreatedDate = DateTime.Now; objCategory.Status = 1; db.Tbl_Category_Master.Add(objCategory); db.SaveChanges(); msg = "Category Saved Successfully!"; } else { Tbl_Category_Master objCategory = db.Tbl_Category_Master.Where(r => r.CategoryID == MP.CategoryID).FirstOrDefault(); var data = db.Tbl_Category_Master.Where(r => r.CategoryName == MP.CategoryName).FirstOrDefault(); if (data != null) { return(new Error() { IsError = true, Message = "Category Name Already Exists!" }); } objCategory.CategoryName = MP.CategoryName.ToUpper(); objCategory.ModifiedDate = DateTime.Now; objCategory.CategoryID = MP.CategoryID; db.SaveChanges(); msg = "Category Updated Successfully!"; } return(new Result() { IsSucess = true, ResultData = msg }); } catch (Exception ex) { return(new Error() { IsError = true, Message = ex.Message }); } }