public void LoadDirectEntry(ATTInvSrchDakhila objSrchDakhila)
{
try
{
List <ATTInvDakhila> lst = new List <ATTInvDakhila>();
lst = BLLInvSrchDakhila.SrchDirectEntry(objSrchDakhila);
if (lst.Count > 0)
{
grdDakhila.DataSource = lst;
grdDakhila.DataBind();
grdDakhila.SelectedIndex = -1;
Session["srchedDakhila"] = lst;
}
else
{
grdDakhila.DataSource = "";
grdDakhila.DataBind();
this.lblEntryCount.Text = "प्रमाणीकरणको निमित्त कुनै दाखिला भेटिएनन्..";
}
}
catch (Exception ex)
{
throw(ex);
}
}
public static DataTable SrchDirectEntry(ATTInvSrchDakhila objSrchDak)
{
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.OAS);
OracleTransaction Tran = DBConn.BeginTransaction();
try
{
string srchSQL = " SELECT * FROM vw_inv_Direct_Entry "
+ " WHERE 1=1 AND APP_YES_NO is null ";
List <OracleParameter> paramArray = new List <OracleParameter>();
if (objSrchDak.OrgID != null)
{
srchSQL = srchSQL + " AND ORG_ID =:ORG_ID ";
paramArray.Add(Utilities.GetOraParam(":ORG_ID", objSrchDak.OrgID, OracleDbType.Int64, ParameterDirection.Input));
}
if (objSrchDak.ItemsCategoryID != null)
{
srchSQL = srchSQL + " AND ITEMS_CATEGORY_ID =:ITEMS_CATEGORY_ID ";
paramArray.Add(Utilities.GetOraParam(":ITEMS_CATEGORY_ID", objSrchDak.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input));
}
if (objSrchDak.ItemsSubCategoryID != null)
{
srchSQL = srchSQL + " AND ITEMS_SUB_CATEGORY_ID =:ITEMS_SUB_CATEGORY_ID ";
paramArray.Add(Utilities.GetOraParam(":ITEMS_SUB_CATEGORY_ID", objSrchDak.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input));
}
if (objSrchDak.ItemsID != null)
{
srchSQL = srchSQL + " AND ITEMS_ID =:ITEMS_ID ";
paramArray.Add(Utilities.GetOraParam(":ITEMS_ID", objSrchDak.ItemsID, OracleDbType.Int64, ParameterDirection.Input));
}
if (objSrchDak.DirectEntryDate != "____/__/__")
{
srchSQL = srchSQL + " AND DIR_ENTRY_DATE =:DIR_ENTRY_DATE ";
paramArray.Add(Utilities.GetOraParam(":DIR_ENTRY_DATE", objSrchDak.DirectEntryDate, OracleDbType.Varchar2, ParameterDirection.Input));
}
return(SqlHelper.ExecuteDataset(CommandType.Text, srchSQL, Module.OAS, paramArray.ToArray()).Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
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 btnSearch_Click(object sender, EventArgs e)
{
try
{
pnlApprove.Visible = false;
ATTInvSrchDakhila objSrchDakhila = new ATTInvSrchDakhila();
objSrchDakhila.OrgID = orgID;
if (ddlCategory_rqd.SelectedIndex > 0)
{
objSrchDakhila.ItemsCategoryID = int.Parse(ddlCategory_rqd.SelectedValue);
}
if (ddlSubCategory_rqd.SelectedIndex > 0)
{
objSrchDakhila.ItemsSubCategoryID = int.Parse(ddlSubCategory_rqd.SelectedValue);
}
if (ddlItems_rqd.SelectedIndex > 0)
{
objSrchDakhila.ItemsID = int.Parse(ddlItems_rqd.SelectedValue);
}
if (txtDakhilaDate_RDT.Text != "")
{
objSrchDakhila.DirectEntryDate = txtDakhilaDate_RDT.Text;
}
Session["objSrchDakhila"] = objSrchDakhila;
LoadDirectEntry(objSrchDakhila);
}
catch (Exception ex)
{
throw (ex);
}
}
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();
}
}
