private void LoadData() { MoneyReceiptsBLL mrBll = new MoneyReceiptsBLL(); DataTable dt = mrBll.GetInvoiceDetailForCrePayment(_InvoiceId, _jobid, _PaymentType); txtDate.Text = DateTime.Now.ToShortDateString(); txtJobNo.Text = dt.Rows[0]["JOBNO"].ToString(); txtJobDate.Text = Convert.ToDateTime(dt.Rows[0]["JOBDATE"].ToString()).ToString("dd/MM/yyyy"); txtInvoiceNo.Text = ""; txtInvoiceDate.Text = ""; if (_PaymentType == "C") { rdoPayment.SelectedValue = _PaymentType; ddlParty.SelectedValue = Convert.ToString(dt.Rows[0]["fk_CreditorID"]); ddlParty.Enabled = false; } //txtLocation.Text = dt.Rows[0]["LOCATION"].ToString(); //ddlExportImport.SelectedValue = dt.Rows[0]["EXPIMP"].ToString(); if (_PaymentType == "C") { txtInvoiceNo.Text = dt.Rows[0]["INVNO"].ToString(); txtInvoiceType.Text = dt.Rows[0]["DOCTYPE"].ToString(); txtInvoiceDate.Text = Convert.ToDateTime(dt.Rows[0]["INVDT"].ToString()).ToString("dd/MM/yyyy"); } //hdnInvDt.Value = Convert.ToDateTime(dt.Rows[0]["INVDT"].ToString()).ToString("MM/dd/yyyy"); txtInvoiceAmount.Text = dt.Rows[0]["INVAMT"].ToString(); txtPendingAmt.Text = dt.Rows[0]["PENDING"].ToString(); //hdnLocationID.Value = dt.Rows[0]["LOCID"].ToString(); //hdnNvoccId.Value = dt.Rows[0]["LINEID"].ToString(); }
private void DeleteMoneyReceipt(string mrNo) { MoneyReceiptsBLL mrBLL = new MoneyReceiptsBLL(); mrBLL.DeleteMoneyReceipts(mrNo); //UserBLL userBll = new UserBLL(); //userBll.DeleteUser(userId, _userId); //LoadUser(); ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('" + ResourceManager.GetStringWithoutName("ERR00010") + "');</script>", false); }
private void PopulateBillType() { List <InvoiceTypeEntity> lstLoc = new MoneyReceiptsBLL().GetInvoiceTypes(); ddlType.DataValueField = "InvoiceTypeId"; ddlType.DataTextField = "InvoiceTypeName"; ddlType.DataSource = lstLoc; ddlType.DataBind(); ddlType.Items.Insert(0, new ListItem(Constants.DROPDOWNLIST_DEFAULT_TEXT, Constants.DROPDOWNLIST_DEFAULT_VALUE)); }
private void SaveMoneyReceipts() { MoneyReceiptsBLL mrBll = new MoneyReceiptsBLL(); MoneyReceiptEntity moneyReceipt = new MoneyReceiptEntity(); //int returnVal = 0; moneyReceipt.InvoiceId = Convert.ToInt64(_InvoiceId); //moneyReceipt.LocationId = Convert.ToInt32(hdnLocationID.Value); //moneyReceipt.NvoccId = Convert.ToInt32(hdnNvoccId.Value); //moneyReceipt.ExportImport = Convert.ToChar(ddlExportImport.SelectedValue); moneyReceipt.MRDate = Convert.ToDateTime(txtDate.Text); moneyReceipt.ChequeNo = txtChqNo.Text; moneyReceipt.ChequeBank = txtBankName.Text.ToUpper(); moneyReceipt.CHA = rdoPayment.SelectedValue.ToString(); if (!string.IsNullOrEmpty(txtChqDate.Text)) { moneyReceipt.ChequeDate = Convert.ToDateTime(txtChqDate.Text); } if (!string.IsNullOrEmpty(txtCashAmt.Text)) { moneyReceipt.CashPayment = Convert.ToDecimal(txtCashAmt.Text); } if (!string.IsNullOrEmpty(txtChequeAmt.Text)) { moneyReceipt.ChequePayment = Convert.ToDecimal(txtChequeAmt.Text); } if (!string.IsNullOrEmpty(txtTDS.Text)) { moneyReceipt.TdsDeducted = Convert.ToDecimal(txtTDS.Text); } moneyReceipt.NvoccId = _jobid; moneyReceipt.CREID = ddlParty.SelectedValue.ToInt(); moneyReceipt.UserAddedId = _userId; moneyReceipt.UserEditedId = _userId; moneyReceipt.UserAddedOn = DateTime.Now.Date; moneyReceipt.UserEditedOn = DateTime.Now.Date; moneyReceipt.Status = true; switch (mrBll.SaveCrePayment(moneyReceipt)) { case 0: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00011"); break; case 1: Response.Redirect("~/Forwarding/Transaction/Dashboard.aspx?JobId=" + GeneralFunctions.EncryptQueryString(_jobid.ToString())); break; } }
private void RetriveParameters() { _userId = MoneyReceiptsBLL.GetLoggedInUserId(); //Get user permission. MoneyReceiptsBLL.GetUserPermission(out _canAdd, out _canEdit, out _canDelete, out _canView); if (!ReferenceEquals(Request.QueryString["invid"], null)) { Int32.TryParse(GeneralFunctions.DecryptQueryString(Request.QueryString["invid"].ToString()), out _InvoiceId); } }
private void LoadMoneyReceipt() { //List<MoneyReceiptEntity> moneyReceipts = new List<MoneyReceiptEntity>(); // MoneyReceiptEntity mr = new MoneyReceiptEntity(null); // MoneyReceiptEntity moneyReceipt1 = new MoneyReceiptEntity(null); // MoneyReceiptEntity moneyReceipt2 = new MoneyReceiptEntity(null); // MoneyReceiptEntity mr1 = new MoneyReceiptEntity(null); // mr1.BLNo = "XYZ"; // MoneyReceiptEntity moneyReceipt11 = new MoneyReceiptEntity(null); // moneyReceipt11.BLNo = "XYZ"; // MoneyReceiptEntity moneyReceipt22 = new MoneyReceiptEntity(null); // moneyReceipt22.MRNo = "TG"; // moneyReceipt22.BLNo = "XYZ"; // moneyReceipts.Add(mr); // moneyReceipts.Add(moneyReceipt1); // moneyReceipts.Add(moneyReceipt2); // moneyReceipts.Add(mr1); // moneyReceipts.Add(moneyReceipt11); // moneyReceipts.Add(moneyReceipt22); // moneyReceipts.Add(mr1); // moneyReceipts.Add(moneyReceipt11); // moneyReceipts.Add(moneyReceipt22); //GetMoneyReceiptsRearranged(moneyReceipts); // gvwMoneyReceipts.DataSource = GetMoneyReceiptsRearranged(moneyReceipts); // gvwMoneyReceipts.DataBind(); if (!ReferenceEquals(Session[Constants.SESSION_SEARCH_CRITERIA], null)) { SearchCriteria searchCriteria = (SearchCriteria)Session[Constants.SESSION_SEARCH_CRITERIA]; if (!ReferenceEquals(searchCriteria, null)) { BuildSearchCriteria(searchCriteria); MoneyReceiptsBLL mrBll = new MoneyReceiptsBLL(); gvwMoneyReceipts.PageIndex = searchCriteria.PageIndex; if (searchCriteria.PageSize > 0) { gvwMoneyReceipts.PageSize = searchCriteria.PageSize; } List <MoneyReceiptEntity> lstMRMaster = GetMoneyReceiptsRearranged(mrBll.GetMoneyReceipts(searchCriteria)); gvwMoneyReceipts.DataSource = lstMRMaster; gvwMoneyReceipts.DataBind(); Session["MROBJECT"] = lstMRMaster; } } }
//private void GetPartyValuesSetToDdl() //{ // //ddlParty.Items.Clear(); // //var creditorInvoice = new CreditorInvoiceBLL().GetCreditor((ISearchCriteria)null); // var creditorInvoice = new EstimateBLL().GetAllParty(0); // ddlParty.DataSource = creditorInvoice; // ddlParty.DataTextField = "PartyName"; // ddlParty.DataValueField = "pk_fwPartyID"; // ddlParty.DataBind(); // ddlParty.Items.Insert(0, new ListItem("--Select--", "0")); //} private void RetriveParameters() { _userId = MoneyReceiptsBLL.GetLoggedInUserId(); //Get user permission. MoneyReceiptsBLL.GetUserPermission(out _canAdd, out _canEdit, out _canDelete, out _canView); //if (!ReferenceEquals(Request.QueryString["invid"], null)) //{ if (Request.QueryString["AdvanceID"] != null) { Int32.TryParse(GeneralFunctions.DecryptQueryString(Request.QueryString["AdvanceID"].ToString()), out _AdvanceId); } Int32.TryParse(GeneralFunctions.DecryptQueryString(Request.QueryString["jobid"].ToString()), out _jobid); _PaymentType = GeneralFunctions.DecryptQueryString(Request.QueryString["paymenttype"].ToString()); //} }
private void LoadData() { MoneyReceiptsBLL mrBll = new MoneyReceiptsBLL(); int PartyId; DataTable dt; if (_AdvanceId == 0) { dt = mrBll.GetInvoiceDetailForAdvance(_AdvanceId, _jobid, _PaymentType); txtDate.Text = DateTime.Now.ToShortDateString(); txtJobNo.Text = dt.Rows[0]["JOBNO"].ToString(); txtJobDate.Text = Convert.ToDateTime(dt.Rows[0]["JOBDATE"].ToString()).ToString("dd/MM/yyyy"); hdnJobID.Value = dt.Rows[0]["pk_JobID"].ToString(); } else { dt = mrBll.GetAdvanceforEdit(_AdvanceId, _jobid, _PaymentType); txtChqNo.Text = dt.Rows[0]["ChequeNo"].ToString(); txtChqDate.Text = dt.Rows[0]["ChequeDate"].ToString().Split(' ')[0]; //ddlParty.SelectedValue = dt.Rows[0]["fk_PartyID"].ToString(); ddlPartyType.SelectedValue = dt.Rows[0]["fk_PartyTypeID"].ToString(); txtJobNo.Text = dt.Rows[0]["JobNo"].ToString(); txtChequeAmt.Text = dt.Rows[0]["ChequePayment"].ToString(); txtCashAmt.Text = dt.Rows[0]["CashPayment"].ToString(); txtBankName.Text = dt.Rows[0]["ChequeBank"].ToString(); txtMRNo.Text = dt.Rows[0]["pmtReference"].ToString(); PartyId = dt.Rows[0]["fk_PartyID"].ToInt(); txtDate.Text = dt.Rows[0]["pmtDate"].ToString().Split(' ')[0]; txtJobDate.Text = dt.Rows[0]["JobDate"].ToString().Split(' ')[0]; txtCurrentAmount.Text = (txtCashAmt.Text.ToDecimal() + txtChequeAmt.Text.ToDecimal()).ToString(); hdnJobID.Value = dt.Rows[0]["fk_JobID"].ToString(); GetPartyValuesSetToDdl(ddlPartyType.SelectedValue.ToInt()); ddlParty.SelectedValue = PartyId.ToString(); } //if (_PaymentType == "C") //{ // ddlParty.SelectedValue = Convert.ToString(dt.Rows[0]["fk_CreditorID"]); // ddlParty.Enabled = false; //} }
private void LoadData() { MoneyReceiptsBLL mrBll = new MoneyReceiptsBLL(); DataTable dt = mrBll.GetInvoiceDetailForMoneyReceipt(_InvoiceId); txtDate.Text = DateTime.Now.ToShortDateString(); txtBLNo.Text = dt.Rows[0]["BLNO"].ToString(); txtNvocc.Text = dt.Rows[0]["LINE"].ToString(); txtLocation.Text = dt.Rows[0]["LOCATION"].ToString(); ddlExportImport.SelectedValue = dt.Rows[0]["EXPIMP"].ToString(); txtInvoiceNo.Text = dt.Rows[0]["INVNO"].ToString(); txtInvoiceType.Text = dt.Rows[0]["DOCTYPE"].ToString(); txtInvoiceDate.Text = Convert.ToDateTime(dt.Rows[0]["INVDT"].ToString()).ToString("dd/MM/yyyy"); hdnInvDt.Value = Convert.ToDateTime(dt.Rows[0]["INVDT"].ToString()).ToString("MM/dd/yyyy"); txtInvoiceAmount.Text = dt.Rows[0]["INVAMT"].ToString(); txtPendingAmt.Text = dt.Rows[0]["PENDING"].ToString(); hdnLocationID.Value = dt.Rows[0]["LOCID"].ToString(); hdnNvoccId.Value = dt.Rows[0]["LINEID"].ToString(); // forwarding this field is used as Jobid }