public bool Post([FromBody] RawMaterialEntity rawmaterialEntity) { try { return(_rawmaterialServices.CreateRawMaterial(rawmaterialEntity)); } catch (Exception ex) { throw new ApiDataException(1000, "Product Not Found", HttpStatusCode.NotFound); } }
public bool Put([FromBody] RawMaterialEntity rawmaterialEntity) { try { if (rawmaterialEntity.RawMaterialId > 0) { return(_rawmaterialServices.UpdateRawMaterial(rawmaterialEntity.RawMaterialId, rawmaterialEntity)); } } catch (Exception ex) { throw new ApiDataException(1000, "Product not found", HttpStatusCode.NotFound); } return(false); }
public bool CreateRawMaterial(RawMaterialEntity obj) { bool res = false; SqlCommand cmd = new SqlCommand("sp_Insert_rawMaterialMaster"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@RawMaterialName", obj.RawMaterialName); cmd.Parameters.AddWithValue("@CreatedBy", obj.CreatedBy); var locMas = _unitOfWork.DbLayer.ExecuteNonQuery(cmd); if (locMas != Int32.MaxValue) { res = true; } return(res); }
public bool UpdateRawMaterial(int RawMaterialId, RawMaterialEntity obj) { bool res = false; SqlCommand cmd = new SqlCommand("sp_Update_rawMaterialMaster"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@RawMaterialId", obj.RawMaterialId); cmd.Parameters.AddWithValue("@RawMaterialName", obj.RawMaterialName); cmd.Parameters.AddWithValue("@ModifiedBy", obj.ModifiedBy); cmd.Parameters.AddWithValue("@ModifiedOn", DateTime.Now); var locMas = _unitOfWork.DbLayer.ExecuteNonQuery(cmd); if (locMas != Int32.MaxValue) { res = true; } return(res); }