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);
}
