public long AddProductVersion(product_version product_version, long created_by) { try { product_version insert_product_version = new product_version { product_version_name = product_version.product_version_name, created_by = created_by, created_date = DateTime.Now, updated_by = created_by, updated_date = DateTime.Now, is_active = true, is_deleted = false, }; _entities.product_version.Add(insert_product_version); _entities.SaveChanges(); long last_insert_id = insert_product_version.product_version_id; return(last_insert_id); } catch (Exception ex) { return(0); } }
public bool DeleteProductVersion(long product_version_id) { try { product_version oProductVersion = _entities.product_version.FirstOrDefault(c => c.product_version_id == product_version_id); oProductVersion.is_active = false; oProductVersion.is_deleted = true; _entities.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool EditProductVersion(product_version product_version, long updated_by) { try { product_version oProductVersion = _entities.product_version.Find(product_version.product_version_id); oProductVersion.product_version_name = product_version.product_version_name; oProductVersion.is_active = product_version.is_active; oProductVersion.updated_by = updated_by; oProductVersion.updated_date = DateTime.Now; _entities.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public HttpResponseMessage Post([FromBody] Models.product_version product_version, long created_by) { try { if (string.IsNullOrEmpty(product_version.product_version_name)) { var formatter = RequestFormat.JsonFormaterString(); return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { output = "error", msg = "Version Name is Empty" }, formatter)); } else { if (productVersionRepository.CheckDuplicateProductVersion(product_version.product_version_name)) { var formatter = RequestFormat.JsonFormaterString(); return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { output = "error", msg = "Version Name Already Exists" }, formatter)); } else { product_version insert_product_version = new product_version { product_version_name = product_version.product_version_name, }; productVersionRepository.AddProductVersion(insert_product_version, created_by); var formatter = RequestFormat.JsonFormaterString(); return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { output = "success", msg = "Product Version save successfully" }, formatter)); } } } catch (Exception ex) { var formatter = RequestFormat.JsonFormaterString(); return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { output = "error", msg = ex.ToString() }, formatter)); } }