public int CreatePackingMTN_Secondary_toStores(MTN obj, BatchActivity.Status Status, string FinishProductCode, int Qty, BatchActivity.Status BatchActStatus_Finished, BatchActivity.Status BatchActStatus_Secondary)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MTNPackingBatch", obj.PackingBatch),
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("@FinishProductCode", FinishProductCode),
new SqlParameter("@Qty", Qty),
new SqlParameter("@NextBatchActivityStatus", Convert.ToInt32(Status)),
new SqlParameter("@BatchActStatus_Finished", Convert.ToInt32(BatchActStatus_Finished)),
new SqlParameter("@BatchActStatus_Secondary", Convert.ToInt32(BatchActStatus_Secondary)),
new SqlParameter("@outParam", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_Output(Connection, "SPADD_MTN_Packing_Secondary", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public DataTable Get_DataView_Packing_Secondary(BatchActivity.Status Status, long UserID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BatchActStatus", Status),
new SqlParameter("@UserID", UserID)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_Packing_Secondary", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public DataTable Get_Packing_PrimaryBatchRemainningQty(int PrimaryBatchID, BatchActivity.Status Status_Finished, BatchActivity.Status Status_Secondary)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BatchActStatus_Finished", Status_Finished),
new SqlParameter("@BatchActStatus_Secondary", Status_Secondary),
new SqlParameter("@PrimaryBatchID", PrimaryBatchID)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_Packing_PrimaryBatchRemainningQty", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
