protected void btnSave_Click(object sender, EventArgs e) { try { BusinessLayer.Subscription objSubscription = new BusinessLayer.Subscription(); Entity.Subscription subscription = new Entity.Subscription(); subscription.SubscriptionId = SubscriptionId; subscription.FinancialYearId = int.Parse(ddlYear.SelectedValue); subscription.MemberId = int.Parse(ddlMember.SelectedValue); subscription.Amount = decimal.Parse(txtAmount.Text); subscription.EntryDate = DateTime.Parse(txtEntryDate.Text); subscription.Narration = txtNarration.Text.Trim(); subscription.CreatedBy = Session["UserId"].ToString(); subscription.MRNo = txtMrNo.Text.Trim(); int i = objSubscription.Subscription_Save(subscription); if (i > 0) { LoadSubscriptionList(); ltrMsg.Text = "Saved successfully..."; //SendNewSubscriptionAlert(ddlYear.SelectedItem.ToString(), ddlMember.SelectedItem.ToString(), txtAmount.Text); ClearControls(); } else { ltrMsg.Text = "Sorry! can not save."; } } catch { ltrMsg.Text = "Sorry! can not save."; } }
protected void dgvSubscriptionList_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Ed") { SubscriptionId = Int64.Parse(e.CommandArgument.ToString()); BusinessLayer.Subscription objSubscription = new BusinessLayer.Subscription(); DataTable dt = new DataTable(); dt = objSubscription.Subscription_GetBySubscriptionId(SubscriptionId); ddlYear.SelectedValue = dt.Rows[0]["FinancialYearId_FK"].ToString(); ddlMember.SelectedValue = dt.Rows[0]["MemberId_FK"].ToString(); txtAmount.Text = dt.Rows[0]["Amount"].ToString(); txtEntryDate.Text = Convert.ToDateTime(dt.Rows[0]["EntryDate"].ToString()).ToString("dd MMM yyyy"); txtNarration.Text = dt.Rows[0]["Narration"].ToString(); txtMrNo.Text = dt.Rows[0]["MRNo"].ToString(); } else if (e.CommandName == "Del") { SubscriptionId = Int64.Parse(e.CommandArgument.ToString()); BusinessLayer.Subscription objSubscription = new BusinessLayer.Subscription(); int i = objSubscription.Subscription_Delete(SubscriptionId); if (i > 0) { LoadSubscriptionList(); ClearControls(); ltrMsg.Text = "Deleted successfully..."; } else { ltrMsg.Text = "Sorry! can not delete."; } } }
protected void LoadFinancialYear() { BusinessLayer.Subscription objSubscription = new BusinessLayer.Subscription(); DataTable dt = new DataTable(); dt = objSubscription.FinancialYear_GetAll(); if (dt != null) { ddlYear.DataSource = dt; ddlYear.DataTextField = "FinancialYear"; ddlYear.DataValueField = "FinancialYearId"; ddlYear.DataBind(); } }
protected void LoadFinancialYear() { BusinessLayer.Subscription objSubscription = new BusinessLayer.Subscription(); DataTable dt = new DataTable(); dt = objSubscription.FinancialYear_GetAll(); if (dt != null) { ddlYear.DataSource = dt; ddlYear.DataTextField = "FinancialYear"; ddlYear.DataValueField = "FinancialYearId"; ddlYear.DataBind(); } ListItem li = new ListItem("--SELECT--", "0"); ddlYear.Items.Insert(0, li); }
protected void LoadSubscriptionList() { BusinessLayer.Subscription objSubscription = new BusinessLayer.Subscription(); Entity.Subscription subscription = new Entity.Subscription(); DataTable dt = new DataTable(); subscription.MemberId = int.Parse(ddlMember.SelectedValue); subscription.FinancialYearId = 0; subscription.EntryDate = (!String.IsNullOrEmpty(txtTransactionFromDate.Text)) ? Convert.ToDateTime(txtTransactionFromDate.Text) : DateTime.MinValue; subscription.EntryDateTo = (!String.IsNullOrEmpty(txtTransactionToDate.Text)) ? Convert.ToDateTime(txtTransactionToDate.Text) : DateTime.MinValue; subscription.Status = Convert.ToInt32(ddlStatus.SelectedValue); subscription.MobileNo = ""; dt = objSubscription.Subscription_GetAll(subscription); if (dt != null) { dgvSubscriptionList.DataSource = dt; dgvSubscriptionList.DataBind(); } }
protected void ddlMember_SelectedIndexChanged(object sender, EventArgs e) { if (ddlMember.SelectedIndex == 0) { dgvSubscriptionList.DataBind(); } else { LoadSubscriptionList(); } BusinessLayer.Subscription objSubscription = new BusinessLayer.Subscription(); DataTable dt = new DataTable(); dt = objSubscription.GetMemberPaidAmount_byFinancialYear(int.Parse(ddlMember.SelectedValue), int.Parse(ddlYear.SelectedValue)); if (dt != null) { lblAmountPaid.Text = "Balance: " + dt.Rows[0]["Amount"].ToString(); } }
protected void LoadSubscriptionList() { BusinessLayer.Subscription objSubscription = new BusinessLayer.Subscription(); Entity.Subscription subscription = new Entity.Subscription(); DataTable dt = new DataTable(); subscription.MemberId = int.Parse(ddlMember.SelectedValue); subscription.FinancialYearId = int.Parse(ddlYear.SelectedValue); subscription.EntryDate = DateTime.MinValue; subscription.EntryDateTo = DateTime.MinValue; subscription.Status = Convert.ToInt32(ddlStatus.SelectedValue); subscription.MobileNo = txtMobNo.Text; subscription.BlockName = ddlBlock.SelectedItem.Text; subscription.Amount = (txtAmount.Text == "") ? 0 : Convert.ToDecimal(txtAmount.Text); dt = objSubscription.Subscription_GetAll(subscription); if (dt != null) { dgvSubscriptionList.DataSource = dt; dgvSubscriptionList.DataBind(); } }