public MTNTransferList Get(long MTNNO, long StcokID, long GRNNO) { MTN_DL objMTN_DL = new MTN_DL(Connection); Stock_DL objStock_DL = new Stock_DL(Connection); GRN_DL objGRN_DL = new GRN_DL(Connection); MTNTransferList objMTNTransferList = new MTNTransferList(); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Original_MTNNO", MTNNO), new SqlParameter("@Original_StockID", StcokID), new SqlParameter("@Original_GRNNO", GRNNO) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTNTransferListByID", paramList); objMTNTransferList.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[0]["GRNNO"])); objMTNTransferList.MTN = objMTN_DL.Get(Convert.ToInt64(dt.Rows[0]["MTNNO"])); objMTNTransferList.Stock = objStock_DL.Get(Convert.ToInt64(dt.Rows[0]["StockID"])); objMTNTransferList.Qty = Convert.ToDecimal(dt.Rows[0]["StockID"]); return(objMTNTransferList); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(MTNTransferList obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MTNNO", obj.MTN.MTNNo), new SqlParameter("@StockID", obj.Stock.StockID), new SqlParameter("@GRNNO", obj.GRN.GRNNo), new SqlParameter("@Qty", obj.Qty) }; return(Execute.RunSP_RowsEffected(Connection, "SPADD_MTNTransferList", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Update(MTNTransferList obj, long OriginalMTNNO, long OriginalStockID, long OriginalGRNNO) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MTNNO", obj.MTN.MTNNo), new SqlParameter("@StockID", obj.Stock.StockID), new SqlParameter("@GRNNO", obj.GRN.GRNNo), new SqlParameter("@Qty", obj.Qty), new SqlParameter("@Original_MTNNO", OriginalMTNNO), new SqlParameter("@Original_StockID", OriginalStockID), new SqlParameter("@Original_GRNNO", OriginalGRNNO) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MTNTransferList", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }