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