public static whar2 GetAsnOrderDetail(int TrxNo, int LineItemNo) { var connection = ApiService.dbConnection; whar2 myAsnOrderDetail = null; try { connection.Open(); myAsnOrderDetail = connection.QueryFirstOrDefault <whar2>(qryAsnOrder.selectAsnOrderDetail, new { TrxNo, LineItemNo }); } catch (Exception) { throw; } finally { connection.Close(); } return(myAsnOrderDetail); }
public IHttpActionResult saveAsnOrderDetail(whar2 AsnOrderDetail) { // incorrect date issue if (!ModelState.IsValid) { return(BadRequest()); } int afRecCnt = AsnOrderHelper.SaveAsnOrderDetail(AsnOrderDetail); if (afRecCnt <= 0) { return(BadRequest()); } return(Ok()); }
public static int SaveAsnOrderDetail(whar2 AsnOrderDetail) { var connection = ApiService.dbConnection; string storeProcName; int afRecCnt = 0; //int TrxNo = AsnOrderDetail.TrxNo; //int LineItemNo = AsnOrderDetail.LineItemNo; //string Description = AsnOrderDetail.Description; //string DimensionFlag = AsnOrderDetail.DimensionFlag; //DateTime? ExpiryDate = AsnOrderDetail.ExpiryDate.Value; //decimal? Height = AsnOrderDetail.Height; //decimal? Length = AsnOrderDetail.Length; //decimal? Qty = AsnOrderDetail.Qty; //DateTime? ManufactureDate = AsnOrderDetail.ManufactureDate; //string ItemCode = AsnOrderDetail.ItemCode; //decimal? SpaceArea = AsnOrderDetail.SpaceArea; //string UomCode = AsnOrderDetail.UomCode; //decimal? Volume = AsnOrderDetail.Volume; //decimal? Weight = AsnOrderDetail.Weight; //decimal? Width = AsnOrderDetail.Width; try { connection.Open(); int recCnt = connection.ExecuteScalar <int>(qryAsnOrder.selectWhar2Count, new { TrxNo = AsnOrderDetail.TrxNo, LineItemNo = AsnOrderDetail.LineItemNo }); if (recCnt <= 0) { storeProcName = qryAsnOrder.insertAsnOrderDetail; //afRecCnt = connection.Execute(qryAsnOrder.insertAsnOrderDetail, // new // { // TrxNo, // LineItemNo, // Description, // DimensionFlag, // ExpiryDate, // Height, // Length, // Qty, // ManufactureDate, // ItemCode, // SpaceArea, // UomCode, // Volume, // Weight, // Width // }, // null, null, CommandType.StoredProcedure); } else { storeProcName = qryAsnOrder.updateAsnOrderDetail; //afRecCnt = connection.Execute(qryAsnOrder.updateAsnOrderDetail, // new // { // TrxNo, // LineItemNo, // Description, // DimensionFlag, // ExpiryDate, // Height, // Length, // Qty, // ManufactureDate, // ItemCode, // SpaceArea, // UomCode, // Volume, // Weight, // Width // }, // null, null, CommandType.StoredProcedure); } var param = connection.GetStoreProcParams(storeProcName, AsnOrderDetail); afRecCnt = connection.Execute(storeProcName, param, null, null, CommandType.StoredProcedure); } catch (Exception) { throw; } finally { connection.Close(); } return(afRecCnt); }