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(); } }