Exemple #1
0
        public static bool SaveGinDetail(whgi2 ginDetail)
        {
            int    afRecCnt = 0;
            string storeProcName;

            using (var connection = new ConnectionProvider(ApiService.Site).CreateDbConnection())
            {
                try
                {
                    connection.Open();
                    int ginDetailCnt = connection.ExecuteScalar <int>(qryGoodsIssueNote.selectGinDetailCount,
                                                                      new
                    {
                        TrxNo      = ginDetail.TrxNo,
                        LineItemNo = ginDetail.LineItemNo
                    });

                    if (ginDetailCnt > 0)
                    {
                        storeProcName = qryGoodsIssueNote.updateGinDetail;
                    }
                    else
                    {
                        storeProcName = qryGoodsIssueNote.insertGinDetail;
                    }

                    var param = connection.GetStoreProcParams(storeProcName, ginDetail);
                    afRecCnt = connection.Execute(storeProcName, param, null, null, CommandType.StoredProcedure);
                }
                catch (Exception) { throw; }
                finally { connection.Close(); }
            }

            return(afRecCnt > 0 ? true : false);
        }
Exemple #2
0
        public IHttpActionResult SaveGinDetail(whgi2 ginDetail)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest());
            }
            bool isValid = GinHelper.SaveGinDetail(ginDetail);

            if (!isValid)
            {
                return(InternalServerError());
            }
            return(Ok());
        }
Exemple #3
0
        public static whgi2 GetGinDetail(int TrxNo, int LineItemNo)
        {
            whgi2 ginDetail = null;

            using (var connection = new ConnectionProvider(ApiService.Site).CreateDbConnection())
            {
                try
                {
                    connection.Open();
                    ginDetail = connection.QuerySingleOrDefault <whgi2>(qryGoodsIssueNote.selectGinDetail, new { TrxNo, LineItemNo });
                }
                catch (Exception) { throw; }
                finally { connection.Close(); }
            }

            return(ginDetail);
        }