protected void Page_Load(object sender, EventArgs e) { try { if (!IsValidSession()) { string str = Request.QueryString.ToString(); if (str == string.Empty) Response.Redirect("LogIn.aspx?refPage=default.aspx"); else Response.Redirect("LogIn.aspx?refPage=default.aspx?" + str); } if (!IsPostBack) { userId = 1; isNewEntry = true; this.Clear(); this.LoadMonthDropDown(); this.LoadMarketDropDown(); if (Request.QueryString["tid"] != null) { int tenantid = int.Parse(Request.QueryString["tid"].ToString()); if (tenantid > 0) { Tenant tenant= new Tenant().GetTenantById(tenantid); lblTenantId.Text = tenant.Id.ToString(); txtTenantName.Text = tenant.TenantName; txtTotalDue.Text = tenant.OutstandingAmount.ToString(); DataTable dtShop = new ShopeMapping().GetShopeMappingByTenantId(tenantid); if (dtShop.Rows.Count > 0) { ddlMarket.SelectedValue = dtShop.Rows[0]["MarketId"].ToString(); lblShopId.Text = dtShop.Rows[0]["ShopeId"].ToString(); txtShopNo.Text = new Shop().GetShopById(int.Parse(lblShopId.Text)).ShopNo; txtServiceCharge.Text = dtShop.Rows[0]["ServiceCharge"].ToString(); txtMonthlyRent.Text = dtShop.Rows[0]["MonthlyRent"].ToString(); txtMiscBill.Text = dtShop.Rows[0]["MiscBill"].ToString(); isNewEntry = true; } } } } } catch (Exception ex) { Alert.Show(ex.Message); } }
/// <summary> /// /// </summary> /// <param name="id"></param> private void ShowTenantDetails(int id) { Tenant tenant = new Tenant().GetTenantById(id); lblId.Text = tenant.Id.ToString(); txtName.Text = tenant.TenantName; txtAddress.Text = tenant.Address; txtContactNo.Text = tenant.ContactNo; txtFatherName.Text = tenant.FathersNames; tenantDetails = new List<TenantDetails>(); DataTable dtMapping = new ShopeMapping().GetShopeMappingByTenantId(tenant.Id); if (dtMapping.Rows.Count > 0) { foreach (DataRow row in dtMapping.Rows) { TenantDetails _tenantDetails = new TenantDetails(); _tenantDetails.Id = int.Parse(row["Id"].ToString()); _tenantDetails.marketId = int.Parse(row["marketId"].ToString()); _tenantDetails.marketName = row["marketName"].ToString(); this.LoadShopDropDown(_tenantDetails.marketId); _tenantDetails.ShopNo = row["shopNo"].ToString(); _tenantDetails.advance = (row["Advance"] == DBNull.Value) ? 0 : decimal.Parse(row["Advance"].ToString()); _tenantDetails.contractDate = DateTime.Parse(row["contractDate"].ToString()); _tenantDetails.contractValidYear = (row["ContractValidYear"] == DBNull.Value) ? 0 : int.Parse(row["ContractValidYear"].ToString()); _tenantDetails.monthlyRent = (row["monthlyRent"] == DBNull.Value) ? 0 : decimal.Parse(row["monthlyRent"].ToString()); _tenantDetails.previousDue = (row["PreviousDue"] == DBNull.Value) ? 0 : decimal.Parse(row["PreviousDue"].ToString()); _tenantDetails.serviceCharge = (row["serviceCharge"] == DBNull.Value) ? 0 : decimal.Parse(row["serviceCharge"].ToString()); _tenantDetails.shopId = int.Parse(row["shopeId"].ToString()); _tenantDetails.miscBill = (row["miscBill"] == DBNull.Value) ? 0 : decimal.Parse(row["miscBill"].ToString()); tenantDetails.Add(_tenantDetails); } if (tenantDetails.Count == 1) { TenantDetails details = tenantDetails[0]; ddlMarket.SelectedValue = details.marketId.ToString(); this.LoadShopDropDown(int.Parse(ddlMarket.SelectedValue)); ddlShop.SelectedValue = details.shopId.ToString(); txtMonthlyRent.Text = details.monthlyRent.ToString(); txtAdvance.Text = details.advance.ToString(); txtServiceCharge.Text = details.serviceCharge.ToString(); dtpContractDate.SelectedDate = details.contractDate; txtContractYear.Text = details.contractValidYear.ToString(); txtPrevDue.Text = details.previousDue.ToString(); txtMiscBill.Text = details.miscBill.ToString(); isNewDetailEntry = false; btnAddDetail.Visible = false; } else { btnAddDetail.Visible = true; } } else { tenantDetails.Add(new TenantDetails()); } this.LoadGridView(); }
protected void btnGenerate_Click(object sender, EventArgs e) { StringBuilder strSuccess=new StringBuilder(); StringBuilder strFailure = new StringBuilder(); strSuccess.Append("<strong>Success</strong><br>"); strFailure.Append("<strong>Failure</strong><br>"); try { if (ddlMarket.SelectedIndex <= 0) { Alert.Show("Please select a market first."); ddlMarket.Focus(); return; } int marketId = int.Parse(ddlMarket.SelectedValue); List<Shop> shopList = new Shop().GetAllShopByMarketId(marketId); BillMaster billMaster = new BillMaster(); BillDetail billDetail = new BillDetail(); foreach (ListItem li in cbListShops.Items) { if (!li.Selected) continue; int shopId = int.Parse(li.Value); Shop shop = shopList.Find(x => x.Id == shopId); try { #region process bill master data string monthYearText = ddlMonth.SelectedItem.Text; string monthYearVal = ddlMonth.SelectedValue; ShopeMapping shopeMapping = new ShopeMapping().GetAllShopeMappingByShopId(shop.Id); billMaster.BilGeneratelDate = DateTime.Parse(txtDate.Text); billMaster.BillMonth = monthYearText.Substring(5); billMaster.BillYear = int.Parse(monthYearText.Substring(0, 4)); billMaster.TenantId = shopeMapping.TenantId; billMaster.BillNo = billMaster.BillYear + "-" + monthYearVal.Substring(5) + "-" + shop.Id + "-" + shopeMapping.TenantId; billMaster.GenerateBy = 1; billMaster.ApprovedBy = 0; billMaster.TotalAmount = 0; billMaster.TotalPayment = 0; billMaster.LastPaymentDate = (DateTime) dtpLastDate.SelectedDate; string MonthVal = ddlMonth.SelectedValue.Substring(5); billMaster.BillMonthId = int.Parse(MonthVal); int success = 0; int billId = billMaster.CheckExistanceByBillNo(billMaster.BillNo); if (billId > 0) { if (!chkUpdateExisting.Checked) { strFailure.Append("Bill already generated for the shop: " + shop.ShopNo + "<br>"); continue; } billMaster.Id = billId; success = billMaster.UpdateBillMaster(); } else { success = billMaster.InsertBillMaster(); billMaster.Id = new BillMaster().GetLastId(); } #endregion #region process bill detail data if (success > 0) { billDetail = new BillDetail(); billDetail.BillMasterId = billMaster.Id; billDetail.MarketId = int.Parse(ddlMarket.SelectedValue); billDetail.ShopId = shop.Id; billDetail.MonthlyRent = shopeMapping.MonthlyRent; billDetail.ServiceCharge = shopeMapping.ServiceCharge; billDetail.MiscBills = shopeMapping.MiscBill; if (chkPrevDue.Checked) { DueInstallment installment = new DueInstallment().GetDueInstallmentByTenant(billMaster.TenantId); if (installment.Id != 0) { billDetail.PreviousDue = installment.InstallmentAmount; if (installment.DueAmount < installment.InstallmentAmount) billDetail.PreviousDue = installment.DueAmount; } else { if (billDetail.CheckBillExistenceByTenant(billMaster.TenantId, shop.Id) > 0) billDetail.PreviousDue = billDetail.GetLastDueTenantAndShopWise(billMaster.TenantId, shop.Id); else billDetail.PreviousDue = new ShopeMapping().GetAllShopeMappingByShopId(shop.Id).PreviousDue; } } else billDetail.PreviousDue = 0; billDetail.LateFee = Math.Round((shopeMapping.MonthlyRent*5)/100,0); billDetail.Payment = 0; billDetail.IsClosed = false; billDetail.ClosedBy = 0; if (billId > 0) { int billDetailId = billDetail.GetBillDetailIdByMasterId(billId); if (billDetailId > 0) { billDetail.Id = billDetailId; success = billDetail.UpdateBillDetail(); } else success = billDetail.InsertBillDetail(); } else success = billDetail.InsertBillDetail(); //update total amount in master table if (success > 0) { decimal totalAmount = (billDetail.MonthlyRent + billDetail.ServiceCharge + billDetail.MiscBills + billDetail.PreviousDue); billMaster.UpdateTotalAmount(billMaster.Id, totalAmount); strSuccess.Append("Bill generated for Shop: " + shop.ShopNo + "<br>"); } } #endregion } catch (Exception ex) { strFailure.Append("Bill generate failed for Shop " + shop.ShopNo + ". Error: " + ex.Message + "<br>"); continue; } } strFailure.Append("<br><br>"); ltrStatus.Text = strFailure.ToString() + strSuccess.ToString(); } catch (Exception ex) { Alert.Show(ex.Message); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (txtName.Text == string.Empty) { lblMessage.Text = "Please enter the tenant name."; txtName.Focus(); return; } //if (txtFatherName.Text == string.Empty) //{ // lblMessage.Text = "Please enter the tenant name."; // txtFatherName.Focus(); // return; //} Tenant obj = new Tenant(); obj.TenantName = txtName.Text; obj.FathersNames = txtFatherName.Text; obj.Address = txtAddress.Text; obj.ContactNo = txtContactNo.Text; obj.IsActive = true; obj.OutstandingAmount = 0; obj.NoOfShops = tenantDetails.Count; int success = 0; if (isNewEntry) { obj.Id = new Tenant().GetMaxTenantId(); obj.Id = obj.Id + 1; success = obj.InsertTenant(); } else { obj.Id = int.Parse(lblId.Text); success = obj.UpdateTenant(); } if (success == 1) { if (tenantDetails.Count == 1) { //convert unicode to decimal string strMonthlyRent = Encode.HtmlEncode(txtMonthlyRent.Text); decimal decMonthlyRent = 0; try { decMonthlyRent = decimal.Parse(strMonthlyRent); } catch (Exception ex) { Alert.Show("দয়া করে সার্ভিস চার্জ ফিল্ডে শুধুমাত্র নাম্বার প্রবেশ করুন।"); txtMonthlyRent.Focus(); return; } string strServcieCharge = Encode.HtmlEncode(txtServiceCharge.Text); decimal decServiceCharge = 0; try { decServiceCharge = decimal.Parse(strServcieCharge); } catch (Exception ex) { Alert.Show("দয়া করে সার্ভিস চার্জ ফিল্ডে শুধুমাত্র নাম্বার প্রবেশ করুন।"); txtServiceCharge.Focus(); return; } string strMiscBill = Encode.HtmlEncode(txtMiscBill.Text); decimal decMiscBill = 0; try { decMiscBill = decimal.Parse(strMiscBill); } catch (Exception ex) { Alert.Show("দয়া করে বিবিধ বিল ফিল্ডে শুধুমাত্র নাম্বার প্রবেশ করুন।"); txtMiscBill.Focus(); return; } string strAdvance = Encode.HtmlEncode(txtAdvance.Text); decimal decAdvance = 0; try { decAdvance = decimal.Parse(strAdvance); } catch (Exception ex) { Alert.Show("দয়া করে অগ্রিম ফিল্ডে শুধুমাত্র নাম্বার প্রবেশ করুন।"); txtAdvance.Focus(); return; } string strPrevDue = Encode.HtmlEncode(txtPrevDue.Text); decimal decPrevDue = 0; try { decPrevDue = decimal.Parse(strPrevDue); } catch (Exception ex) { Alert.Show("দয়া করে পূর্ববর্তী বকেয়া ফিল্ডে শুধুমাত্র নাম্বার প্রবেশ করুন।"); txtPrevDue.Focus(); return; } string strYear = Encode.HtmlEncode(txtContractYear.Text); int decYear = 0; try { decYear = int.Parse(strYear); } catch (Exception ex) { Alert.Show("দয়া করে চুক্তির মেয়াদ ফিল্ডে শুধুমাত্র নাম্বার প্রবেশ করুন।"); txtContractYear.Focus(); return; } TenantDetails objDetails = tenantDetails.Find(x => x.marketId == int.Parse(ddlMarket.SelectedValue) && x.shopId == int.Parse(ddlShop.SelectedValue)); if (objDetails.marketId == 0) objDetails = new TenantDetails(); else tenantDetails.Remove(objDetails); objDetails.marketId = int.Parse(ddlMarket.SelectedValue); objDetails.shopId = int.Parse(ddlShop.SelectedValue); objDetails.marketName = ddlMarket.Text; objDetails.ShopNo = ddlShop.SelectedText; objDetails.contractValidYear = decYear; objDetails.previousDue = decPrevDue; objDetails.monthlyRent = decMonthlyRent; objDetails.serviceCharge = decServiceCharge; objDetails.advance = decAdvance; objDetails.miscBill = decMiscBill; objDetails.contractDate = dtpContractDate.SelectedDate ?? DateTime.Today; if (tenantDetails.Count == 0 || tenantDetails[0].shopId == 0) tenantDetails = new List<TenantDetails>(); tenantDetails.Add(objDetails); } //obj = obj.GetTenantById(obj.Id); foreach (TenantDetails tenantDetail in tenantDetails) { ShopeMapping objMapping=new ShopeMapping(); objMapping.TenantId = obj.Id; objMapping.MarketId = tenantDetail.marketId; objMapping.ShopeId = tenantDetail.shopId; objMapping.MonthlyRent = tenantDetail.monthlyRent; objMapping.ServiceCharge = tenantDetail.serviceCharge; objMapping.Advance = tenantDetail.advance; objMapping.MiscBill = tenantDetail.miscBill; objMapping.ContractDate = (DateTime) tenantDetail.contractDate; objMapping.ContractValidYear = tenantDetail.contractValidYear; objMapping.PreviousDue = tenantDetail.previousDue; objMapping.Id = new ShopeMapping().GetId(objMapping.TenantId, objMapping.ShopeId); if (objMapping.Id == 0) success = objMapping.InsertShopeMapping(); else success = objMapping.UpdateShopeMapping(); if (success == 0) { lblMessage.Text ="The tenant information saved successfully, but failed to save shop mapping."; lblMessage.ForeColor = Color.Red; return; } } Alert.Show("Data saved successfully."); lblId.Text = obj.Id.ToString(); isNewEntry = false; } } catch (Exception ex) { Alert.Show(ex.Message); } }