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 int Update_RPD(BatchPackingMR obj, MTN.Status MTNState, MTN.Type MTNType, MTN.ItemType MTNItemType, string EnteredBy)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BatchID", obj.BatchID),
new SqlParameter("@BatchUsed", obj.BatchUsed),
new SqlParameter("@BatchDamaged", obj.BatchDamaged),
new SqlParameter("@BatchReturned", obj.BatchReturned),
new SqlParameter("@State", obj.State),
new SqlParameter("@MTNStatus", Convert.ToInt32(MTNState)),
new SqlParameter("@MTNType", Convert.ToInt32(MTNType)),
new SqlParameter("@MTNItemType", Convert.ToInt32(MTNItemType)),
new SqlParameter("@EnteredBy", EnteredBy),
new SqlParameter("@IssuedBy", Convert.ToInt32(MTNType)),
new SqlParameter("@StartQty", obj.StartQty),
new SqlParameter("@ID", obj.ID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_BatchPackingMR_RPD", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public System.Data.DataTable GetDataViewByStateAndType(MTN.Status Status, MTN.Type Type)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MTNStatus", Status),
new SqlParameter("@MTNType", Type)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_MTNByTypeAndState", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public System.Data.DataTable GetDataByDpByStatus(long DepID, MTN.Status Status)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@DepID", DepID),
new SqlParameter("@Status", Status)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_MTNByDepByStatus", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(long MTNNO, MTN.Status Status)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Status", Status),
new SqlParameter("@MTNNO", MTNNO)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MTN_ChangeStatus", paramList));
}
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);
}
}
public int Actual_Cost(MTN.Status status, long MTNNO, String MTNBudgetCostBy)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Status", status),
new SqlParameter("@MTNNO", MTNNO),
new SqlParameter("@MTNCostBy", MTNBudgetCostBy)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MTN_CostActual", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Receive(MTN.Status status, long MTNNO, String RecievedBy)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Status", status),
new SqlParameter("@MTNNO", MTNNO),
new SqlParameter("@MTNReceivedBy", RecievedBy)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MTN_Recieved", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public System.Data.DataTable GetDataView(long UserID, MTN.Status Status)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@UserID", UserID),
new SqlParameter("@Status", Status)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTN_ByFromDep_Status", paramList);
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int AddGRN(long MTNNO, MTN.Status MTNstatus, String GRNBy, string StoreID, GRN.Type GRNType, GRN.Status GRNStatus)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MTNNO", MTNNO),
new SqlParameter("@MTNStatus", MTNstatus),
new SqlParameter("@GRNBy", GRNBy),
new SqlParameter("@StoreID", StoreID),
new SqlParameter("@GRNType", Convert.ToInt32(GRNType)),
new SqlParameter("@GRNStatus", Convert.ToInt32(GRNStatus)),
new SqlParameter("@outParam", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_Output(Connection, "SPUPDATE_MTN_GRN", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public System.Data.DataTable GetDataView(DateTime To, DateTime From, long Department, MTN.Status Status)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@FromDate", From),
new SqlParameter("@ToDate", To),
new SqlParameter("@MTNStatus", Status),
new SqlParameter("@DepID", Department)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTN_Dataview_Manage", paramList);
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int CreateBasicProductTransfer_Basic_toRPD(MTN obj, string BasicProductCode, decimal BasicQty, MTN.Status MTNRejectStatus, Batch.Status BatchStatusTransferred)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MTNBatchID", obj.MTNBatch),
new SqlParameter("@MTNEnterdBy", obj.MTNEnterdBy.EmployeeID),
new SqlParameter("@MTNToDepID", obj.MTNDepartmentTo.DepID),
new SqlParameter("@MTNStatus", obj.MTNStatus),
new SqlParameter("@MTNType", obj.MTNType),
new SqlParameter("@MTNItemType", obj.MTNItemType),
new SqlParameter("@BasicProductCode", BasicProductCode),
new SqlParameter("@Qty", BasicQty),
new SqlParameter("@MTNStatus_Reject", (int)MTNRejectStatus),
new SqlParameter("@BatchStatus_Transferred", (int)BatchStatusTransferred),
new SqlParameter("@outParam", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_Output(Connection, "SPADD_MTN_BasicProductTransfer_Basic", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
