public static int SaveUom(rfum1 Uom) { var connection = ApiService.dbConnection; int afRecCnt = 0; string UomCode = Uom.UomCode; string UomDescription = Uom.UomDescription; string Remark = Uom.Remark; string WorkStation = ApiService.HostName; string StatusCode = Uom.StatusCode; string CreateBy = ApiService.UserId; string UpdateBy = ApiService.UserId; try { connection.Open(); int uomCnt = connection.ExecuteScalar <int>(qryUom.selectUomCount, new { UomCode = Uom.UomCode }); if (uomCnt <= 0) { afRecCnt += connection.Execute(qryUom.insertUom, new { UomCode, UomDescription, Remark, WorkStation, StatusCode, CreateBy, UpdateBy }, null, null, CommandType.StoredProcedure); } else { afRecCnt += connection.Execute(qryUom.updateUom, new { UomCode, UomDescription, Remark, WorkStation, StatusCode, UpdateBy }, null, null, CommandType.StoredProcedure); } } catch (Exception) { throw; } finally { connection.Close(); } return(afRecCnt); }
public IHttpActionResult SaveUom(rfum1 Uom) { if (!ModelState.IsValid) { return(BadRequest()); } int afRecCnt = UomHelper.SaveUom(Uom); if (afRecCnt <= 0) { return(BadRequest()); } return(Ok()); }
public static rfum1 GetUom(string UomCode) { var connection = ApiService.dbConnection; rfum1 myUom = null; try { connection.Open(); myUom = connection.QuerySingle <rfum1>(qryUom.selectUom, new { UomCode }); } catch (Exception) { throw; } finally { connection.Close(); } return(myUom); }