public System.Data.DataTable GetDataView(long To, long From, MTN.Status Status) { Employee_DL objEmployee_DL = new Employee_DL(Connection); Department_DL objDepartment_DL = new Department_DL(Connection); MTNCollec objMTNCollec = new MTNCollec(); Store_DL objStore_DL = new Store_DL(Connection); GRN_DL objGRN_DL = new GRN_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MTNToDepID", To), new SqlParameter("@MTNFromDepID", From), new SqlParameter("@MTNStatus", Status) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTN_Dataview_By_ToDep_FromDep", paramList); return(dt); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public System.Data.DataTable GetDataView(long MTNNO) { Employee_DL objEmployee_DL = new Employee_DL(Connection); Department_DL objDepartment_DL = new Department_DL(Connection); MTNCollec objMTNCollec = new MTNCollec(); Store_DL objStore_DL = new Store_DL(Connection); GRN_DL objGRN_DL = new GRN_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MTNNO", MTNNO) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTN_Items", paramList); return(dt); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public StockGRN Get(long StockID, long GRNNO) { GRN_DL objGRNDL = new GRN_DL(Connection); Stock_DL objStockDL = new Stock_DL(Connection); StockGRN objStockGRN = new StockGRN(); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Original_StockID", StockID), new SqlParameter("@Original_StockGRNNO", GRNNO) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_StockGRNByID", paramList); objStockGRN.GRN = objGRNDL.Get(Convert.ToInt64(dt.Rows[0]["StockGRNNO"])); objStockGRN.IssuedQty = Convert.ToInt64(dt.Rows[0]["StockIssuedQty"]); objStockGRN.Stock = objStockDL.Get(Convert.ToInt64(dt.Rows[0]["StockID"])); objStockGRN.StockGRNDate = Convert.ToDateTime(dt.Rows[0]["StockDate"]); return(objStockGRN); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
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 MTNCollec Get(long FromDepID, MTN.Status Status) { Employee_DL objEmployee_DL = new Employee_DL(Connection); Department_DL objDepartment_DL = new Department_DL(Connection); MTNCollec objMTNCollec = new MTNCollec(); Store_DL objStore_DL = new Store_DL(Connection); GRN_DL objGRN_DL = new GRN_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@DepID", FromDepID), new SqlParameter("@MTNStatus", Status) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTN_ByFromDep_Status", paramList); for (int i = 0; i < dt.Rows.Count; i++) { MTN objMTN = new MTN(); objMTN.MTNApprovedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["MTNApprovedBy"])); objMTN.MTNApprovedDate = Convert.ToDateTime(dt.Rows[i]["MTNApproveDate"]); objMTN.MTNBatch = "No"; objMTN.MTNDate = Convert.ToDateTime(dt.Rows[i]["MTNDate"]); objMTN.MTNDepartmentFrom = objDepartment_DL.Get(Convert.ToInt64(dt.Rows[i]["MTNFromDepID"])); objMTN.MTNDepartmentTo = objDepartment_DL.Get(Convert.ToInt64(dt.Rows[i]["MTNToDepID"])); objMTN.MTNEnterdBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["MTNEnterdBy"])); objMTN.MTNNo = Convert.ToInt64(dt.Rows[i]["MTNNo"]); objMTN.MTNReceivedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["MTNReceivedBy"])); objMTN.MTNReceivedDate = Convert.ToDateTime(dt.Rows[i]["MTNReceivedDate"]); objMTN.MTNStatus = (MTN.Status)dt.Rows[i]["MTNStatus"]; objMTN.MTNType = (MTN.Type)dt.Rows[i]["MTNType"]; objMTN.MTNItemType = (MTN.ItemType)dt.Rows[i]["MTNItemType"]; objMTN.MTNStore = objStore_DL.Get(Convert.ToString(dt.Rows[i]["MTNStore"])); objMTNCollec.Add(objMTN); } return(objMTNCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }