private void Load_Batch_List()
{
Status = (RPDBatch.RPDBatchStatus)cmbStatus.SelectedValue;
gvRPDBatch.AutoGenerateColumns = false;
bindRPDBatch.DataSource = objRPDBatchDL.GetDataViewByState(Status, true);
gvRPDBatch.DataSource = bindRPDBatch;
bindRPDBatch.ResetBindings(true);
btnDelete.Enabled = false;
btnSendMR.Visible = false;
if (Status == RPDBatch.RPDBatchStatus.Created)
{
btnManage.Text = "Approve";
btnDelete.Enabled = true;
btnManage.Visible = true;
}
else if (Status == RPDBatch.RPDBatchStatus.Approved)
{
btnManage.Text = "Discarded";
btnManage.Visible = true;
}
else
{
btnManage.Visible = false;
}
}
public System.Data.DataTable GetDataViewByState(RPDBatch.RPDBatchStatus state, bool QueryType)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@RPDBatchStatus", state),
new SqlParameter("@QueryType", QueryType)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_RPDBatch_View_By_Status", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Finish(string RPDBatchID, RPDBatch.RPDBatchStatus theStatus)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@RPDBatchID", RPDBatchID),
new SqlParameter("@RPDBatchStatus", (int)theStatus)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_RPDBatch_Finish", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void Load_List()
{
try
{
bindRPDBatch.DataSource = null;
Status = (RPDBatch.RPDBatchStatus)cmbStatus.SelectedValue;
gvRPDBatch.AutoGenerateColumns = false;
bindRPDBatch.DataSource = objRPDBatchDL.GetDataViewByState(Status, true);
gvRPDBatch.DataSource = bindRPDBatch;
bindRPDBatch.ResetBindings(true);
}
catch (Exception)
{
MessageBox.Show(this, "Error occured while loading RPD Batch", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}