public static bool ApproveDakhila(ATTInvDakhila objDak)
{
try
{
return(DLLInvDakhila.ApproveDakhila(objDak));
}
catch (Exception ex)
{
throw(ex);
}
}
public static bool ApproveDakhila(ATTInvDakhila objDak)
{
string sp;
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.OAS);
OracleTransaction Tran = DBConn.BeginTransaction();
OracleParameter[] paramArray = new OracleParameter[8];
try
{
sp = "";
if (objDak.Action == "A")
{
sp = "sp_inv_app_direct_entry";
}
else if (objDak.Action == "E")
{
sp = "";
}
if (sp != "")
{
paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objDak.OrgID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":p_items_category_id", objDak.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":p_items_sub_category_id", objDak.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam(":p_items_id", objDak.ItemsID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam(":p_seq_no", objDak.DirectEntrySeq, OracleDbType.Int64, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":p_app_by", objDak.AppBy, OracleDbType.Int64, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":p_app_date", objDak.AppDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[7] = Utilities.GetOraParam(":p_app_yes_no", objDak.AppYesNo, OracleDbType.Varchar2, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray);
}
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw (ex);
}
finally
{
GetConn.CloseDbConn();
}
}
public static List <ATTInvDakhila> SrchDirectEntry(ATTInvSrchDakhila objSrchDak)
{
try
{
List <ATTInvDakhila> lst = new List <ATTInvDakhila>();
DataTable tbl = new DataTable();
tbl = DLLInvSrchDakhila.SrchDirectEntry(objSrchDak);
foreach (DataRow row in tbl.Rows)
{
ATTInvDakhila obj = new ATTInvDakhila();
obj.OrgID = int.Parse(row["ORG_ID"].ToString());
obj.ItemsCategoryID = int.Parse(row["ITEMS_CATEGORY_ID"].ToString());
obj.ItemsCategoryName = row["ITEMS_CATEGORY_NAME"].ToString();
obj.ItemsSubCategoryID = int.Parse(row["ITEMS_SUB_CATEGORY_ID"].ToString());
obj.ItemsSubCategoryName = row["ITEMS_SUB_CATEGORY_NAME"].ToString();
obj.ItemsID = int.Parse(row["ITEMS_ID"].ToString());
obj.ItemsName = row["ITEMS_NAME"].ToString();
obj.DirectEntrySeq = int.Parse(row["SEQ_NO"].ToString());
obj.DirectEntryDate = row["DIR_ENTRY_DATE"].ToString();
obj.DirectEntryType = row["DIR_ENTRY_TYPE"].ToString();
obj.DonationOrg = row["DON_ORGANIZATION"].ToString();
obj.UnitPrice = double.Parse(row["ITEMS_UNIT_PRICE"].ToString());
obj.Quantity = int.Parse(row["TOTAL_QUANTITY"].ToString());
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw (ex);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (Session["DECurrentDate"] != null && txtDakhilaDate_RDT.Text != "")
{
if (CompareDate(txtDakhilaDate_RDT.Text, Session["DECurrentDate"].ToString()))
{
List <ATTInvDakhila> lst = new List <ATTInvDakhila>();
if (Session["lstDak"] != null)
{
lst = (List <ATTInvDakhila>)Session["lstDak"];
}
bool flag = false;
if (grdDakhila.SelectedIndex > -1)
{
GridViewRow gvRow = grdDakhila.SelectedRow;
ATTInvDakhila objDak = lst.Find(delegate(ATTInvDakhila obj)
{
return((obj.ItemsCategoryID == int.Parse(gvRow.Cells[2].Text)) &&
(obj.ItemsSubCategoryID == int.Parse(gvRow.Cells[3].Text)) &&
(obj.ItemsID == int.Parse(gvRow.Cells[4].Text)));
}
);
if (objDak != null)
{
objDak.DirectEntryDate = txtDakhilaDate_RDT.Text;
if (chkDonation.Checked)
{
objDak.DirectEntryType = "A";
objDak.DonationOrg = txtDonOrg_rqd.Text;
}
else
{
objDak.DirectEntryType = "D";
objDak.DonationOrg = "";
}
objDak.UnitPrice = int.Parse(txtUnitPrice_rqd.Text);
objDak.Quantity = int.Parse(txtQty_rqd.Text);
if (txtJelaaKhataNo_rqd.Text != "")
{
objDak.JelaaKhataNo = txtJelaaKhataNo_rqd.Text;
}
else
{
objDak.JelaaKhataNo = "";
}
if (objDak.Action == "N" || objDak.Action == "E")
{
objDak.Action = "E";
}
else
{
objDak.Action = "A";
}
ClearControls();
ddlCategory_rqd.SelectedIndex = -1;
ddlSubCategory_rqd.SelectedIndex = -1;
ddlItems_rqd.SelectedIndex = -1;
ddlCategory_rqd.Enabled = true;
ddlSubCategory_rqd.Enabled = true;
ddlItems_rqd.Enabled = true;
grdDakhila.SelectedIndex = -1;
grdDakhila.DataSource = lst;
grdDakhila.DataBind();
}
flag = true;
}
else
{
flag = lst.Exists(delegate(ATTInvDakhila objDak)
{
return((objDak.ItemsCategoryID == int.Parse(ddlCategory_rqd.SelectedValue)) &&
(objDak.ItemsSubCategoryID == int.Parse(ddlSubCategory_rqd.SelectedValue)) &&
(objDak.ItemsID == int.Parse(ddlItems_rqd.SelectedValue)));
}
);
if (flag)
{
this.lblStatusMessageTitle.Text = "दाखिला ";
this.lblStatusMessage.Text = " यो सामान पहिले नै दाखिलाको निमित्त राख्नु भइसक्यो । कृपया अर्को सामान छान्नुहोस्।";
this.programmaticModalPopup.Show();
}
}
if (!flag)
{
ATTInvDakhila objDak = new ATTInvDakhila();
objDak.OrgID = orgID;
objDak.ItemsCategoryID = int.Parse(ddlCategory_rqd.SelectedValue.ToString());
objDak.ItemsCategoryName = ddlCategory_rqd.SelectedItem.ToString();
objDak.ItemsSubCategoryID = int.Parse(ddlSubCategory_rqd.SelectedValue.ToString());
objDak.ItemsSubCategoryName = ddlSubCategory_rqd.SelectedItem.ToString();
objDak.ItemsID = int.Parse(ddlItems_rqd.SelectedValue.ToString());
objDak.ItemsName = ddlItems_rqd.SelectedItem.ToString();
if (((List <ATTInvItems>)Session["DakhilaItems"]).Count > 0)
{
objDak.ItemsTypeID = ((List <ATTInvItems>)Session["DakhilaItems"])[ddlItems_rqd.SelectedIndex - 1].ItemsTypeID;
}
objDak.DirectEntryDate = txtDakhilaDate_RDT.Text;
if (chkDonation.Checked)
{
objDak.DirectEntryType = "A";
objDak.DonationOrg = txtDonOrg_rqd.Text;
}
else
{
objDak.DirectEntryType = "D";
objDak.DonationOrg = "";
}
if (txtJelaaKhataNo_rqd.Text != "")
{
objDak.JelaaKhataNo = txtJelaaKhataNo_rqd.Text;
}
objDak.UnitPrice = double.Parse(txtUnitPrice_rqd.Text.ToString());
objDak.Quantity = int.Parse(txtQty_rqd.Text.ToString());
if (objDak.Action == "N" || objDak.Action == "E")
{
objDak.Action = "E";
}
else
{
objDak.Action = "A";
}
//objDak.EntryBy = "sj";
objDak.EntryBy = entryBy;
lst.Add(objDak);
grdDakhila.DataSource = lst;
grdDakhila.DataBind();
}
Session["lstDak"] = lst;
ClearControls();
btnSubmit.Enabled = true;
}
else
{
this.lblStatusMessageTitle.Text = "दाखिला ";
this.lblStatusMessage.Text = "दाखिला मिति आजको मिति भन्दा पछिको मितिमा राख्न पाइदैन। त्यसैले अर्को दाखिला मिति राख्नुहोस् !!!";
this.programmaticModalPopup.Show();
return;
}
}
else
{
this.lblStatusMessageTitle.Text = "दाखिला ";
this.lblStatusMessage.Text = "कृपया मिति राख्नुहोस् !!!";
this.programmaticModalPopup.Show();
return;
}
}
catch (Exception ex)
{
this.lblStatusMessageTitle.Text = "Error Status";
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (Session["SrchDECurrentDate"] != null && txtApproveDate_URDT_appv.Text != "")
{
if (CompareDate(Session["SrchDECurrentDate"].ToString(), txtApproveDate_URDT_appv.Text))
{
List <ATTInvDakhila> lst = (List <ATTInvDakhila>)Session["srchedDakhila"];
int i = int.Parse(Session["DeApprvSelectedIndex"].ToString());
ATTInvDakhila objDak = new ATTInvDakhila();
objDak.OrgID = lst[i].OrgID;
objDak.ItemsCategoryID = lst[i].ItemsCategoryID;
objDak.ItemsSubCategoryID = lst[i].ItemsSubCategoryID;
objDak.ItemsID = lst[i].ItemsID;
objDak.DirectEntrySeq = lst[i].DirectEntrySeq;
if (chk_appv.Checked)
{
objDak.AppYesNo = "Y";
}
else
{
objDak.AppYesNo = "N";
}
if (txtApproveDate_URDT_appv.Text != "")
{
objDak.AppDate = txtApproveDate_URDT_appv.Text;
}
objDak.AppBy = loginID;
objDak.Action = "A";
if (BLLInvDakhila.ApproveDakhila(objDak))
{
//ClearControls();
if (Session["objSrchDakhila"] != null)
{
lblEntryCount.Text = "";
pnlApprove.Visible = false;
ATTInvSrchDakhila objSrchDakhila = (ATTInvSrchDakhila)Session["objSrchDakhila"];
LoadDirectEntry(objSrchDakhila);
}
else
{
ClearControls();
}
this.lblStatusMessageTitle.Text = "दाखिला प्रमाणीकरण";
this.lblStatusMessage.Text = "दाखिला प्रमाणीकरण सफलतापूर्वक भयो।";
this.programmaticModalPopup.Show();
}
else
{
this.lblStatusMessageTitle.Text = "दाखिला प्रमाणीकरण";
this.lblStatusMessage.Text = "दाखिला प्रमाणीकरण गर्दा वाधा उत्पन्न भयो।";
this.programmaticModalPopup.Show();
}
}
else
{
this.lblStatusMessageTitle.Text = "दाखिला प्रमाणीकरण ";
this.lblStatusMessage.Text = "दाखिला प्रमाणीकरण मिति नागीसक्यो !!! त्यसैले अर्को दाखिला प्रमाणीकरण मिति राख्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
}
else
{
this.lblStatusMessageTitle.Text = "दाखिला प्रमाणीकरण ";
this.lblStatusMessage.Text = "कृपया दाखिला प्रमाणीकरण राख्नुहोस् ।!!!";
this.programmaticModalPopup.Show();
return;
}
}
catch (Exception ex)
{
this.lblStatusMessageTitle.Text = "Error Status";
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
