public int CreateBasicProductTransfer_Semi_toRPD(MTN obj, Batch.Status NextStatus, string BasicProductCode, decimal BasicQty)
{
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("@NextBatchStatus", Convert.ToInt32(NextStatus)),
new SqlParameter("@outParam", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_Output(Connection, "SPADD_MTN_BasicProductTransfer_Semi", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public void LoadBatches(Batch.Status Status)
{
try
{
dtBatchList = objBatchDL.Get_DataView(Status, CurrentUser.UserID);
if (dtBatchList.Rows.Count > 0)
{
gvBatchList.AutoGenerateColumns = false;
bindBatch.DataSource = dtBatchList;
gvBatchList.DataSource = bindBatch;
bindBatch.ResetBindings(true);
}
else
{
gvBatchList.AutoGenerateColumns = false;
bindBatch.DataSource = null;
gvBatchList.DataSource = bindBatch;
bindBatch.ResetBindings(true);
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void LoadBatches(Batch.Status Status)
{
try
{
bindBatch.DataSource = objBatchDL.Get_DataView(Status, CurrentUser.UserID);
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DataTable Get_DataView(Batch.Status Status, long UserID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Status", Status),
new SqlParameter("@UserID", UserID)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public DataTable Get_DataView_Rework(Batch.Status Status, string BatchType1, string BatchType2)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BatchStatus", Status),
new SqlParameter("@BatchType1", BatchType1),
new SqlParameter("@BatchType2", BatchType2)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_ReworkBatchList", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update_QCStatus(string BatchID, string ChangedBy, Batch.Status TheStatus)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BatchID", BatchID),
new SqlParameter("@ChangedBy", ChangedBy),
new SqlParameter("@BatchStatus", Convert.ToInt32(TheStatus))
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_Batch_QCStatus", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public DataTable Get_DataView_FinishPrimaryPacking(Batch.Status Status, long UserID, int BatchActivity_Finished, string ActType)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Status", Status),
new SqlParameter("@UserID", UserID),
new SqlParameter("@BatchActivity_Finished", BatchActivity_Finished),
new SqlParameter("@ActType", ActType)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_FinishPrimaryPacking", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public DataTable Get_DataView_Packing(Batch.Status Status1, Batch.Status Status2, long UserID, string BasicProductType)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Status1", Status1),
new SqlParameter("@Status2", Status2),
new SqlParameter("@UserID", UserID),
new SqlParameter("@BasicProductType", BasicProductType)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_Packing", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public DataTable Get_DataView_Admin(Batch.Status Status1, Batch.Status Status2, Batch.Status Status3, Batch.Status Status4, Batch.Status Status5)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Status1", (int)Status1),
new SqlParameter("@Status2", (int)Status2),
new SqlParameter("@Status3", (int)Status3),
new SqlParameter("@Status4", (int)Status4),
new SqlParameter("@Status5", (int)Status5)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_Admin", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public DataTable Get_DataView_PrimaryPacking_Edit(Batch.Status Status1, Batch.Status Status2, long UserID, string BasicProductType, string ActType, int BatchActivity_Initial, int BatchActivity_Start, int BatchActivity_Finish)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Status1", Status1),
new SqlParameter("@Status2", Status2),
new SqlParameter("@UserID", UserID),
new SqlParameter("@BasicProductType", BasicProductType),
new SqlParameter("@ActType", ActType),
new SqlParameter("@BatchActivity_Initial", BatchActivity_Initial),
new SqlParameter("@BatchActivity_Start", BatchActivity_Start),
new SqlParameter("@BatchActivity_Finish", BatchActivity_Finish)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_PrimaryPacking_Edit", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
