public static bool SaveBenchFormation(ATTBenchFormation objBenchFormation)
{
string InsertUpdateSQL = "SP_ADD_BENCH_FORMATION";
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":P_ORG_ID", objBenchFormation.OrgID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_BENCH_TYPE_ID", objBenchFormation.BenchTypeID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_BENCH_NO", objBenchFormation.BenchNo, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_FROM_DATE", objBenchFormation.FromDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_SEQ_NO", objBenchFormation.SeqNo, OracleDbType.Int64, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam(":P_TO_DATE", objBenchFormation.ToDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objBenchFormation.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction();
try
{
SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray());
int seqNo = int.Parse(paramArray[4].Value.ToString());
DLLBenchJudge.SaveBenchJudge(objBenchFormation.LstBenchJudge, Tran, seqNo);
Tran.Commit();
return(true);
}
catch (OracleException oex)
{
PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
public static DataTable GetJudgeList(ATTBenchFormation objBenchFormation)
{
string SelectSql = "SP_GET_BENCH_JUDGE";
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":P_ORG_ID", objBenchFormation.OrgID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_BENCH_TYPE_ID", objBenchFormation.BenchTypeID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_BENCH_NO", objBenchFormation.BenchNo, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_FROM_DATE", objBenchFormation.FromDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_SEQ_NO", objBenchFormation.SeqNo, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_RC", null, OracleDbType.RefCursor, ParameterDirection.Output));
try
{
DataSet ds = SqlHelper.ExecuteDataset(CommandType.StoredProcedure, SelectSql, Module.CMS, paramArray.ToArray());
return((DataTable)ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (DDLBench_RQD.SelectedIndex == -1)
{
lblStatusMessage.Text = "Please Select Bench first";
programmaticModalPopup.Show();
return;
}
if (DDLBenchType_RQD.SelectedIndex == -1)
{
lblStatusMessage.Text = "Please Select Bench Type first";
programmaticModalPopup.Show();
return;
}
if (txtFromDate.Text == "____/__/__")
{
lblStatusMessage.Text = "Please Enter From Date first";
programmaticModalPopup.Show();
return;
}
if (txtBJFromDate.Text == "___/__/__")
{
lblStatusMessage.Text = "Please Enter From Date for Judge first";
programmaticModalPopup.Show();
return;
}
ATTBenchFormation attBF = new ATTBenchFormation();
attBF.OrgID = orgID;
attBF.BenchNo = int.Parse(DDLBench_RQD.SelectedValue);
attBF.BenchTypeID = int.Parse(DDLBenchType_RQD.SelectedValue);
attBF.FromDate = txtFromDate.Text.Trim();
attBF.EntryBy = strUser;
List <ATTOrganisationBenchType> lstOBT = (List <ATTOrganisationBenchType>)Session["OrgBenchType"];
int intFlag = 0;
foreach (GridViewRow row in grdJudge.Rows)
{
if (lstOBT[intFlag].Cardinality == 1 && intFlag > 0)
{
lblStatusMessage.Text = "Only one judge can assign for bench type of cardinality one";
programmaticModalPopup.Show();
return;
}
CheckBox cbSelect = (CheckBox)row.Cells[0].FindControl("chkSelect");
if (cbSelect.Checked == true)
{
ATTBenchJudge attBJ = new ATTBenchJudge();
attBJ.OrgID = orgID;
attBJ.BenchNo = int.Parse(DDLBench_RQD.SelectedValue);
attBJ.BenchTypeID = int.Parse(DDLBenchType_RQD.SelectedValue);
attBJ.FromDate = txtFromDate.Text.Trim();
attBJ.BJFromDate = txtBJFromDate.Text.Trim();
attBJ.JudgeID = int.Parse(row.Cells[1].Text.ToString());
attBJ.EntryBy = strUser;
attBF.LstBenchJudge.Add(attBJ);
intFlag++;
}
}
if (BLLBenchFormation.SaveBenchFormation(attBF))
{
ClearControls();
lblStatusMessage.Text = "Successfully Saved";
programmaticModalPopup.Show();
}
}
