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