public bool DeleteAccessoriesCategory(long accessories_category_id)
{
try
{
accessories_category objAc = _entities.accessories_category.FirstOrDefault(c => c.accessories_category_id == accessories_category_id);
objAc.is_active = false;
objAc.is_deleted = true;
_entities.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public HttpResponseMessage Post([FromBody] Models.accessories_category objAccessoriesCategory, long created_by)
{
try
{
if (string.IsNullOrEmpty(objAccessoriesCategory.accessories_category_name))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Accessories Category Name is Empty"
}, formatter));
}
else
{
if (accessoriesCategoryRepository.CheckDuplicateAccessoriesCategory(objAccessoriesCategory.accessories_category_name))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Accessories Category Name Already Exists"
}, formatter));
}
else
{
accessories_category insert = new accessories_category
{
accessories_category_name = objAccessoriesCategory.accessories_category_name,
price = objAccessoriesCategory.price,
created_date = DateTime.Now,
is_active = true,
is_deleted = false
};
accessoriesCategoryRepository.AddAccessoriesCategory(insert, created_by);
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "success", msg = "Save successfully"
}, formatter));
}
}
}
catch (Exception ex)
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = ex.ToString()
}, formatter));
}
}
public bool EditAccessoriesCategory(accessories_category objAccessoriesCategory, long updated_by)
{
try
{
accessories_category objAc = _entities.accessories_category.Find(objAccessoriesCategory.accessories_category_id);
objAc.accessories_category_name = objAccessoriesCategory.accessories_category_name;
objAc.price = objAccessoriesCategory.price;
objAc.updated_by = updated_by;
objAc.updated_date = DateTime.Now;
objAc.is_active = objAccessoriesCategory.is_active;
objAc.is_deleted = false;
_entities.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public long AddAccessoriesCategory(accessories_category objAccessoriesCategory, long created_by)
{
try
{
accessories_category insert = new accessories_category
{
accessories_category_name = objAccessoriesCategory.accessories_category_name,
price = objAccessoriesCategory.price,
created_by = created_by,
created_date = DateTime.Now,
is_active = true,
is_deleted = false
};
_entities.accessories_category.Add(insert);
_entities.SaveChanges();
long last_insert_id = insert.accessories_category_id;
return(last_insert_id);
}
catch (Exception)
{
return(0);
}
}
