public IHttpActionResult saveAsnOrder(whar1 AsnOrder) { if (!ModelState.IsValid) { return(BadRequest()); } int TrxNo = AsnOrderHelper.SaveAsnOrder(AsnOrder); if (TrxNo <= 0) { return(BadRequest()); } return(Ok(TrxNo)); }
public static whar1 GetAsnOrder(int TrxNo) { var connection = ApiService.dbConnection; whar1 myAsnOrder = null; try { connection.Open(); myAsnOrder = connection.QueryFirstOrDefault <whar1>(qryAsnOrder.selectAsnOrder, new { TrxNo }); } catch (Exception) { throw; } finally { connection.Close(); } return(myAsnOrder); }
public static int SaveAsnOrder(whar1 AsnOrder) { var connection = ApiService.dbConnection; int TrxNo = AsnOrder.TrxNo; string AsnOrderNo = AsnOrder.AsnOrderNo; string SupplierAsnNo = AsnOrder.SupplierAsnNo; string SupplierCode = AsnOrder.SupplierCode; DateTime?AsnOrderDate = AsnOrder.AsnOrderDate; string Remark = AsnOrder.Remark; string WarehouseCode = AsnOrder.WarehouseCode; string WorkStation = ApiService.HostName; string StatusCode = AsnOrder.StatusCode; string CreateBy = ApiService.UserId; string UpdateBy = ApiService.UserId; try { connection.Open(); if (TrxNo <= 0) { //insert asn Order TrxNo = connection.ExecuteScalar <int>(qryAsnOrder.insertAsnOrder, new { AsnOrderNo, SupplierAsnNo, SupplierCode, AsnOrderDate, Remark, WarehouseCode, WorkStation, StatusCode, CreateBy, UpdateBy }, null, null, CommandType.StoredProcedure); } else { //update asn order connection.Execute(qryAsnOrder.updateAsnOrder, new { TrxNo, AsnOrderNo, SupplierAsnNo, SupplierCode, AsnOrderDate, Remark, WarehouseCode, WorkStation, StatusCode, UpdateBy }, null, null, CommandType.StoredProcedure); } } catch (Exception) { throw; } finally { connection.Close(); } return(TrxNo); }