protected void btnSearch_Click(object sender, EventArgs e) { if (txtNameSearch.Text == string.Empty) return; List<Tenant> shops = new List<Tenant>(); shops = new Tenant().SearchTenantByName(txtNameSearch.Text); RadGrid1.DataSource = shops; RadGrid1.DataBind(); }
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); } }
private void LoadGrid(int marketId) { try { List<Tenant> shops = new List<Tenant>(); DataTable dt = new Tenant().GetTenantWithDue(marketId); RadGrid1.DataSource = dt; RadGrid1.DataBind(); } catch (Exception ex) { Alert.Show("Error in method 'LoadLeaveDetailsGrid'. Error: " + ex.Message); } }
protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { try { if (e.CommandName == "btnSelect") { GridDataItem item = (GridDataItem) e.Item; int id = int.Parse(item["colId"].Text); if (id!=0) Response.Redirect("TenantInfo.aspx?id="+id.ToString()); } else if (e.CommandName == "btnDelete") { Alert.Confirm("Are you sure want to delete this record?", "hfConfirmation"); if (hfConfirmation.Value == "False") return; GridDataItem item = (GridDataItem)e.Item; int id = int.Parse(item["colId"].Text); int success = new Tenant().DeleteTenantById(id); if (success>0) this.LoadGrid(int.Parse(ddlMarket.SelectedValue)); } else if (e.CommandName == "btnYearlyReport") { GridDataItem item = (GridDataItem)e.Item; int id = int.Parse(item["colId"].Text); int shopId = int.Parse(item["colShopId"].Text); if (id != 0) Response.Redirect("yearlyReport.aspx?id=" + id.ToString() +"&shopid="+shopId.ToString()); } } catch (Exception ex) { Alert.Show("Error during leave grid event. Error: " + 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 Page_Load(object sender, EventArgs e) { 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) { tenantDetails = new List<TenantDetails>(); objTenant = new Tenant(); dtpContractDate.SelectedDate = DateTime.Today; this.LoadShopDropDown(0); this.LoadMarketDropDown(); this.LoadGridView(); isNewDetailEntry = true; isNewEntry = true; btnNext.Visible = false; btnPrev.Visible = false; if (Request.QueryString["id"] != null) { int id = int.Parse(Request.QueryString["id"].ToString()); if (id > 0) { ShowTenantDetails(id); isNewDetailEntry = false; isNewEntry = false; btnNext.Visible = true; btnPrev.Visible = true; } } } }
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); } }
protected void btnPrev_Click(object sender, EventArgs e) { if (lblId.Text == string.Empty) return; int tenantId = int.Parse(lblId.Text); int id = new Tenant().GetPreviousTenantId(tenantId); Response.Redirect("TenantInfo.aspx?id=" + id.ToString(), true); //if (id > 0) ShowTenantDetails(id); }