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);
}
}
