void LoadWorkInspectionDetails()
{
try
{
if (ddlJudgeList.SelectedIndex > 0 && txtFiscalYear.Text != "")
{
ATTJudgeWorkInspection obj = BLLJudgeWorkInspection.GetJudgeWorkInspection(int.Parse(ddlJudgeList.SelectedValue), txtFiscalYear.Text);
if (obj != null)
{
txtInspection.Text = obj.InspEmpName.ToString();
txtInspection.Attributes.Add("InspectorID", obj.InspEmpID.ToString());
txtInspectionDate.Text = obj.InspectionDate.ToShortDateString();
List <ATTJudgeWorkInspectionDetails> list = obj.Details;
List <ATTJudgeWorkInspectionDetails> list1 = list.FindAll(delegate(ATTJudgeWorkInspectionDetails detail)
{
return(detail.InspectionCaseNo != null && detail.InspectionCaseNo != 0);
});
Session["WorkDetailsLst"] = list1;
grdWorkInspectionDetails.DataSource = list1;
grdWorkInspectionDetails.DataBind();
Session["AddEdit"] = "E";
btnSave.Visible = true;
btnCancel.Visible = true;
ddlJudgeList.Enabled = false;
txtFiscalYear.Enabled = false;
cpeDemo.Collapsed = true;
Panel3.Enabled = false;
}
else
{
grdWorkInspectionDetails.DataSource = null;
grdWorkInspectionDetails.DataBind();
Session["WorkDetailsLst"] = null;
Session["AddEdit"] = "A";
}
}
else
{
Session["AddEdit"] = "A";
}
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message.ToString();
this.programmaticModalPopup.Show();
}
}
public static bool SaveJudgeWorkInspection(ATTJudgeWorkInspection objWorkInspection)
{
try
{
return(DLLJudgeWorkInspection.SaveJudgeWorkInspection(objWorkInspection));
}
catch (System.Exception ex)
{
throw ex;
}
}
public static bool SaveJudgeWorkInspection(ATTJudgeWorkInspection objAtt)
{
string InsertUpdateSP = "";
OracleTransaction Tran;
if (objAtt.Action == "A")
{
InsertUpdateSP = "SP_ADD_JUDGE_WORK_INSPECTION";
}
else if (objAtt.Action == "E")
{
InsertUpdateSP = "SP_EDIT_JUDGE_WORK_INSPECTION";
}
OracleParameter[] ParamArray = new OracleParameter[5];
ParamArray[0] = FRAMEWORK.Utilities.GetOraParam(":P_EMP_ID", objAtt.EmployeeID, OracleDbType.Int64, ParameterDirection.Input);
ParamArray[1] = FRAMEWORK.Utilities.GetOraParam(":P_FISCAL_YEAR", objAtt.FiscalYear, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[2] = FRAMEWORK.Utilities.GetOraParam(":P_INSP_EMP_ID", objAtt.InspEmpID, OracleDbType.Int64, ParameterDirection.Input);
ParamArray[3] = FRAMEWORK.Utilities.GetOraParam(":P_INSP_DATE", objAtt.InspectionDate, OracleDbType.Date, ParameterDirection.Input);
ParamArray[4] = FRAMEWORK.Utilities.GetOraParam(":P_ENTRY_BY", objAtt.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.PMS);
Tran = DBConn.BeginTransaction();
try
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateSP, ParamArray);
DLLJudgeWorkInspectionDetails.SaveJudgeWorkInspectionDetails(objAtt.Details, Tran);
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
public static ATTJudgeWorkInspection GetJudgeWorkInspection(int?empID, string fiscalYear)
{
try
{
DataTable dt = DLLJudgeWorkInspection.GetJudgeWorkInspection(empID, fiscalYear);
if (dt.Rows.Count > 0)
{
ATTJudgeWorkInspection obj = new ATTJudgeWorkInspection(int.Parse(dt.Rows[0]["EMP_ID"].ToString()), int.Parse(dt.Rows[0]["INSP_EMP_ID"].ToString()), dt.Rows[0]["FISCAL_YEAR"].ToString(), DateTime.Parse(dt.Rows[0]["INSP_DATE"].ToString()), "");
obj.EmployeeName = dt.Rows[0]["JUDGEFULLNAME"].ToString();
obj.InspEmpName = dt.Rows[0]["INSPFULLNAME"].ToString();
obj.Details = BLLJudgeWorkInspectionDetails.GetJudgeWorkInspectionDetails(empID, fiscalYear);
return(obj);
}
return(null);
}
catch (System.Exception ex)
{
throw ex;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (grdWorkInspectionDetails.Rows.Count < 1)
{
return;
}
int i = 0;
string errmessage = "<P><b><U>! Attention </U></b></P>";
if (ddlJudgeList.SelectedIndex < 1)
{
i++; errmessage += i.ToString() + ") Select Judge <br />";
}
if (!txtInspection.HasAttributes || txtInspection.Text == "")
{
i++; errmessage += i.ToString() + ") Inspector Missing <br />";
}
if (txtInspectionDate.Text == "")
{
i++; errmessage += i.ToString() + ") Inspection Date Missing <br />";
}
else
{
try
{
DateTime dt = DateTime.Parse(txtInspectionDate.Text);
}
catch (Exception)
{
i++; errmessage += i.ToString() + ") Invalid Date <br />";
}
}
if (i > 0)
{
this.lblStatusMessage.Text = errmessage;
this.programmaticModalPopup.Show();
return;
}
InspectionListInsert = new List <ATTJudgeWorkInspectionDetails>();
int j = 0;
foreach (ATTJudgeWorkList work in (List <ATTJudgeWorkList>)Session["WorkList"])
{
if (j > 0)
{
ATTJudgeWorkInspectionDetails inspdet = new ATTJudgeWorkInspectionDetails();
inspdet.JwcID = int.Parse(work.JwcID.ToString());
inspdet.JwcName = work.JwcName;
inspdet.Action = (Session["AddEdit"].ToString() == "A" ? "A" : "");
inspdet.EmployeeID = int.Parse(ddlJudgeList.SelectedValue);
inspdet.EntryBy = entryBy;
inspdet.EntryOn = DateTime.Now;
inspdet.FiscalYear = txtFiscalYear.Text;
inspdet.InspectionCaseNo = null;
inspdet.IsReasonValid = null;
inspdet.NoDoneReason = "";
inspdet.NoOfCase = null;
inspdet.Remarks = "";
inspdet.WorkDone = false;
InspectionListInsert.Add(inspdet);
}
j++;
}
foreach (ATTJudgeWorkInspectionDetails inspDetails in (List <ATTJudgeWorkInspectionDetails>)Session["WorkDetailsLst"])
{
int k = InspectionListInsert.FindIndex(delegate(ATTJudgeWorkInspectionDetails detail)
{
return(detail.JwcID == inspDetails.JwcID);
});
InspectionListInsert[k] = inspDetails;
}
ATTJudgeWorkInspection workInspection = new ATTJudgeWorkInspection();
workInspection.EmployeeID = int.Parse(ddlJudgeList.SelectedValue);
workInspection.FiscalYear = txtFiscalYear.Text;
string st = txtInspection.Attributes["InspectorID"].ToString();
workInspection.InspEmpID = int.Parse(txtInspection.Attributes["InspectorID"].ToString());
workInspection.InspectionDate = DateTime.Parse(txtInspectionDate.Text);
workInspection.EntryBy = entryBy;
workInspection.Details = InspectionListInsert;
workInspection.Action = Session["AddEdit"].ToString();
if (BLLJudgeWorkInspection.SaveJudgeWorkInspection(workInspection))
{
ClearControls(true);
btnSave.Visible = true;
btnCancel.Visible = true;
this.lblStatusMessage.Text = "Information Saved.";
this.programmaticModalPopup.Show();
}
else
{
this.lblStatusMessage.Text = "Problem Saving Information .";
this.programmaticModalPopup.Show();
}
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message.ToString();
this.programmaticModalPopup.Show();
}
}
