protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { string strMsg = string.Empty; if (e.CommandName == "cmdedit") { Response.Redirect("AmntAgainstGr.aspx?q=" + e.CommandArgument, true); } if (e.CommandName == "cmddelete") { Int64 UserIdno = Convert.ToInt64(Session["UserIdno"]); RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL(); Int32 intValue = obj.Delete(Convert.ToInt32(e.CommandArgument), UserIdno, ApplicationFunction.ConnectionString()); obj = null; if (intValue > 0) { this.BindGrid(); strMsg = "Record deleted successfully."; txtRcptNo.Focus(); } else { if (intValue == -1) { strMsg = "Record can not be deleted. It is in use."; } else { strMsg = "Record not deleted."; } } ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true); } }
protected void lnkbtnSearch_Click(object sender, EventArgs e) { try { RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL(); Int64 iPRTYIDNO = (ddlPartyName.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlPartyName.SelectedValue)); Int32 iFromcity = (ddlFromCity.SelectedIndex <= 0 ? 0 : Convert.ToInt32(ddlFromCity.SelectedValue)); string strGrFrm = ""; strGrFrm = "BK"; DataTable DsGrdetail = obj.SelectGRPaymentDetail("SelectGRPaymentDetail", Convert.ToInt32(ddldateRange.SelectedValue), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iPRTYIDNO, strGrFrm, iFromcity, ApplicationFunction.ConnectionString()); if ((DsGrdetail != null) && (DsGrdetail.Rows.Count > 0)) { grdGrdetals.DataSource = DsGrdetail; grdGrdetals.DataBind(); lnkbtnsubmit.Visible = true; lblTotalRecord.Text = "T. Record(s) : " + Convert.ToString(DsGrdetail.Rows.Count); } else { grdGrdetals.DataSource = null; grdGrdetals.DataBind(); lnkbtnsubmit.Visible = false; lblTotalRecord.Text = "T. Record(s) : 0"; } ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true); } catch (Exception Ex) { ApplicationFunction.ErrorLog(Ex.Message); } }
private void GetReceiptNo() { RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL(); Int64 max = obj.GetMaxNo(); obj = null; txtRcptNo.Text = Convert.ToInt64(max) <= 0 ? "1" : Convert.ToString(max); }
protected void lnkbtnsubmit_Click(object sender, EventArgs e) { try { if ((grdGrdetals != null) && (grdGrdetals.Rows.Count > 0)) { string strchkValue = string.Empty; string sAllItemIdnos = string.Empty; string strchkDetlValue = string.Empty; for (int count = 0; count < grdGrdetals.Rows.Count; count++) { CheckBox ChkGr = (CheckBox)grdGrdetals.Rows[count].FindControl("chkId"); if ((ChkGr != null) && (ChkGr.Checked == true)) { HiddenField hidGrIdno = (HiddenField)grdGrdetals.Rows[count].FindControl("hidGrIdno"); strchkDetlValue = strchkDetlValue + hidGrIdno.Value + ","; } } if (strchkDetlValue != "") { strchkDetlValue = strchkDetlValue.Substring(0, strchkDetlValue.Length - 1); } if (strchkDetlValue == "") { ShowMessageErr("Please check atleast one Gr."); ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true); } else { RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL(); string strSbillNo = String.Empty; DataTable dtRcptDetl = new DataTable(); DataRow Dr; dtRcptDetl = obj.SelectGRDetail(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), Convert.ToString(strchkDetlValue)); ViewState["dt"] = dtRcptDetl; BindGrid(); grdGrdetals.DataSource = null; grdGrdetals.DataBind(); } ddlRcptTyp.Focus(); } else { ShowMessageErr("Gr Details not found."); grdMain.DataSource = null; grdMain.DataBind(); ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true); } } catch (Exception Ex) { ApplicationFunction.ErrorLog(Ex.Message); } }
// string con = ConfigurationManager.ConnectionStrings["TransportMandiConnectionString"].ConnectionString; #endregion #region Page Load... protected void Page_Load(object sender, EventArgs e) { if (Request.UrlReferrer == null) { base.AutoRedirect(); } txtRcptNo.Attributes.Add("onkeypress", "return allowAlphabetAndNumer(event);"); txtGrDateto.Attributes.Add("onkeypress", "return notAllowAnything(event);"); txtGrDatefrom.Attributes.Add("onkeypress", "return notAllowAnything(event);"); if (!Page.IsPostBack) { this.BindDateRange(); ddldateRange.SelectedIndex = 0; ddldateRange_SelectedIndexChanged(null, null); this.BindCity(); RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL(); DateTime? dtfrom = null; DateTime? dtto = null; Int64 GrNo = Convert.ToInt64((txtRcptNo.Text) == "" ? "0" : txtRcptNo.Text); if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false) { dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDatefrom.Text)); } if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false) { dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDateto.Text)); } int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex != -1) ? "0" : drpCityFrom.SelectedValue); var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), GrNo, dtfrom, dtto, cityfrom); obj = null; if (lstGridData != null && lstGridData.Count > 0) { lblTotalRecord.Text = "Total Record (s): " + lstGridData.Count; } } }
private void BindGrid() { RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL(); DateTime? dtfrom = null; DateTime? dtto = null; Int64 GrNo = Convert.ToInt64((txtRcptNo.Text) == "" ? "0" : txtRcptNo.Text); if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false) { dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDatefrom.Text)); } if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false) { dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDateto.Text)); } int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex == 0) ? "0" : drpCityFrom.SelectedValue); var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), GrNo, dtfrom, dtto, cityfrom); obj = null; if (lstGridData != null && lstGridData.Count > 0) { DataTable dt = new DataTable(); dt.Columns.Add("SrNo", typeof(string)); dt.Columns.Add("RecpNo", typeof(string)); dt.Columns.Add("Date", typeof(string)); dt.Columns.Add("FromCity", typeof(string)); dt.Columns.Add("Party", typeof(string)); dt.Columns.Add("NetAmount", typeof(string)); double TNet = 0; double TAmnt = 0; for (int i = 0; i < lstGridData.Count; i++) { DataRow dr = dt.NewRow(); dr["SrNo"] = Convert.ToString(i + 1); dr["RecpNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Rcpt_No")); dr["Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Rcpt_date")).ToString("dd-MM-yyyy"); dr["FromCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "FromCity")); dr["Party"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Acnt_Name")); dr["NetAmount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")).ToString("N2"); dt.Rows.Add(dr); TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")); if (i == lstGridData.Count - 1) { DataRow drr = dt.NewRow(); drr["Party"] = "Total"; drr["NetAmount"] = (TNet).ToString("N2"); dt.Rows.Add(drr); lblNetTotalAmount.Text = TNet.ToString("N2"); } } if (dt != null && dt.Rows.Count > 0) { ViewState["Dt"] = dt; } // grdMain.DataSource = lstGridData; grdMain.DataBind(); lblTotalRecord.Text = "Total Record (s): " + lstGridData.Count; imgBtnExcel.Visible = true; int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1; int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1; lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString(); lblcontant.Visible = true; divpaging.Visible = true; } else { grdMain.DataSource = null; grdMain.DataBind(); lblTotalRecord.Text = "Total Record (s): 0 "; divpaging.Visible = false; imgBtnExcel.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { // con ApplicationFunction.ConnectionString() ;//ConfigurationManager.ConnectionStrings["TransportMandiConnectionString"].ConnectionString; if (Request.UrlReferrer == null) { base.AutoRedirect(); } if (!Page.IsPostBack) { if (base.CheckUserRights(intFormId) == false) { Response.Redirect("PermissionDenied.aspx"); } if (base.ADD == false) { lnkbtnSave.Visible = false; } if (base.View == false) { lblViewList.Visible = false; } this.BindReceiptType(); if (Convert.ToString(Session["Userclass"]) == "Admin") { this.BindCity(); } else { this.BindCity(Convert.ToInt64(Session["UserIdno"])); } this.BindDateRange(); this.BindPartName(); this.BindCustBank(); this.BindPartName(); ddldateRange.SelectedValue = Convert.ToString(base.UserDateRng); ddldateRange.SelectedIndex = 0; txtDateFrom.Attributes.Add("onkeypress", "return notAllowAnything(event);"); txtGRDate.Attributes.Add("onkeypress", "return notAllowAnything(event);"); txtDateTo.Attributes.Add("onkeypress", "return notAllowAnything(event);"); txtInstDate.Attributes.Add("onkeypress", "return notAllowAnything(event);"); txtDateFrom.Attributes.Add("onkeypress", "return notAllowAnything(event);"); txtRcptNo.Attributes.Add("onkeypress", "return allowOnlyNumber(event);"); ddldateRange_SelectedIndexChanged(null, null); RcvdAmntAgnstGRDAL objChlnBookingDAL = new RcvdAmntAgnstGRDAL(); tblUserPref obj = objChlnBookingDAL.selectUserPref(); // ddlFromCity.SelectedValue = Convert.ToString(obj.BaseCity_Idno); ddlFromCity.SelectedValue = Convert.ToString(base.UserFromCity); lnkimgSearch.Enabled = true; ddlRcptType_SelectedIndexChanged(null, null); GetRcptNo(Convert.ToInt32(ddldateRange.SelectedValue), Convert.ToInt32(ddlFromCity.SelectedValue)); ddlFromCity.Enabled = true; ddlFromCity_SelectedIndexChanged(null, null); if (Request.QueryString["q"] != null) { Populate(Convert.ToInt64(Request.QueryString["q"])); hidid.Value = Convert.ToString(Request.QueryString["q"]); lnkbtnPrint.Visible = true; lnkbtnNew.Visible = true; } else { lnkbtnPrint.Visible = false; lnkbtnNew.Visible = false; } } }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { //DtTemp = (DataTable)ViewState["dt"]; //BindGrid(); //if (DtTemp != null && DtTemp.Rows.Count <= 0) //{ // if (DtTemp.Rows.Count <= 0) // { // ShowMessage("Please enter details"); // return; // } //} if (Convert.ToDouble(txtNetAmnt.Text) <= 0) { ShowMessageErr("Net Amount Must be Greater Than Zero."); grdMain.Focus(); return; } if (grdMain.Rows.Count > 0) { DtTemp = CreateDt(); foreach (GridViewRow row in grdMain.Rows) { HiddenField hidGrIdno = (HiddenField)row.FindControl("hidGrIdno"); Label lblGrno = (Label)row.FindControl("lblGrno"); Label lblGrDate = (Label)row.FindControl("lblGrDate"); HiddenField hidRecivrIdno = (HiddenField)row.FindControl("hidRecivrIdno"); Label lblGrFrom = (Label)row.FindControl("lblGrFrom"); HiddenField hidToCityIdno = (HiddenField)row.FindControl("hidToCityIdno"); HiddenField hidFromCityIdno = (HiddenField)row.FindControl("hidFromCityIdno"); Label lblAmount = (Label)row.FindControl("lblAmount"); Label lblTotRecvd = (Label)row.FindControl("lblTotRecvd"); Label lblCurBal = (Label)row.FindControl("lblCurBal"); TextBox txtRcvdAmnt = (TextBox)row.FindControl("txtRcvdAmnt"); ApplicationFunction.DatatableAddRow(DtTemp, hidGrIdno.Value, lblGrno.Text, (ApplicationFunction.mmddyyyy(lblGrDate.Text)), hidRecivrIdno.Value, "BK", hidToCityIdno.Value, hidFromCityIdno.Value, lblAmount.Text, lblTotRecvd.Text, lblCurBal.Text, txtRcvdAmnt.Text); } RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL(); tblAmntRecvdGR_Head objRGH = new tblAmntRecvdGR_Head(); objRGH.Rcpt_No = Convert.ToInt64(txtRcptNo.Text); objRGH.BaseCity_Idno = Convert.ToInt64(ddlFromCity.SelectedValue); objRGH.FromCity_Idno = Convert.ToInt64(ddlFromCity.SelectedValue); objRGH.Rcpt_date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGRDate.Text)); objRGH.Party_IdNo = Convert.ToInt64(ddlPartyName.SelectedValue); objRGH.Inst_No = Convert.ToString(txtInstNo.Text); objRGH.Date_Added = System.DateTime.Now; objRGH.Date_Modified = null; objRGH.CustBank_Idno = Convert.ToInt32(ddlCustmerBank.SelectedValue); objRGH.RcptTyp_Idno = Convert.ToInt32(ddlRcptTyp.SelectedValue); objRGH.UserIdno = Convert.ToInt64(Session["UserIdno"]); if (txtInstDate.Text == "") { objRGH.Inst_Date = null; } else { objRGH.Inst_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInstDate.Text)); } objRGH.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text); objRGH.Remark = Convert.ToString(TxtRemark.Text); objRGH.status = true; objRGH.Year_IdNo = Convert.ToInt32(ddldateRange.SelectedValue); Int64 value = 0; using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { if (string.IsNullOrEmpty(hidid.Value) == true) { value = obj.Insert(objRGH, DtTemp); obj = null; } else { value = obj.Update(objRGH, Convert.ToInt32((Convert.ToString(hidid.Value) == "" ? 0 : Convert.ToInt32(hidid.Value))), DtTemp); obj = null; } if (value > 0) { if (this.PostIntoAccounts(Convert.ToDouble(txtNetAmnt.Text), value, "ARGR", 0, 0, 0, 0, 0, Convert.ToInt32(ddldateRange.SelectedValue)) == true) { if (string.IsNullOrEmpty(hidid.Value) == false) { if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false)) { ShowMessage("Record Update successfully"); this.Clear(); } else if (value == -1) { ShowMessageErr("Rcpt No Already Exist"); } else if (string.IsNullOrEmpty(hidid.Value) == false) { ShowMessageErr("Record Not Update"); } } else { if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true)) { ShowMessage("Record Saved successfully"); this.Clear(); } else if (value == -1) { ShowMessageErr("Rcpt No Already Exist"); } else if ((string.IsNullOrEmpty(hidid.Value) == true)) { ShowMessageErr("Record Not Saved successfully"); } } tScope.Complete(); } else { if (string.IsNullOrEmpty(hidpostingmsg.Value) == true) { if (string.IsNullOrEmpty(Convert.ToString(hidid.Value)) == false) { hidpostingmsg.Value = "Record(s) not updated."; } else { hidpostingmsg.Value = "Record(s) not saved."; } tScope.Dispose(); } tScope.Dispose(); ScriptManager.RegisterStartupScript(this, this.GetType(), "hwa", "PassMessageError('" + Convert.ToString(hidpostingmsg.Value) + "')", true); return; } } } } else { ShowMessageErr("Please Enter Detais"); return; } }