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