private void PopulateLease(int tenantID)
{
LeaseDA leaseDA = new LeaseDA();
DataTable leasesDT = leaseDA.GetLeaseByTenantID(tenantID);
DataGridViewLeases.Rows.Clear();
for (int i = 0; i <= leasesDT.Rows.Count - 1; i++)
{
DataGridViewRow row = new DataGridViewRow();
//DataRow dataRow = leasesDT.Rows[i];
row.CreateCells(DataGridViewLeases);
row.Cells[0].Value = Helper.GetNepaliNumber(i + 1);
row.Cells[1].Value = leasesDT.Rows[i][1];
row.Cells[2].Value = leasesDT.Rows[i][2];
row.Cells[3].Value = leasesDT.Rows[i][3];
row.Cells[4].Value = leasesDT.Rows[i][4];
row.Cells[5].Value = leasesDT.Rows[i][5];
row.Cells[6].Value = leasesDT.Rows[i][6];
row.Cells[7].Value = leasesDT.Rows[i][7];
// Store land_id as Tag
row.Tag = leasesDT.Rows[i][1];
DataGridViewLeases.Rows.Add(row);
}
}
private void DataGridViewLands_SelectionChanged(object sender, EventArgs e)
{
LeaseDA leaseDA = new LeaseDA();
DataGridViewRow selectedRow = DataGridViewLands.CurrentRow;
List <Tenant> tenants = leaseDA.GetCurrentTenantsByLandID(int.Parse(selectedRow.Tag.ToString()));
DataGridViewTenants.Rows.Clear();
int i = 0;
while (i < tenants.Count)
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(DataGridViewTenants);
row.Cells[0].Value = Helper.GetNepaliNumber(i + 1);
row.Cells[1].Value = tenants[i].Fullname;
row.Cells[2].Value = tenants[i].Address;
row.Cells[3].Value = tenants[i].MobileNumber;
row.Cells[4].Value = tenants[i].Father;
// Store land_id as Tag
row.Tag = tenants[i].TenantID.ToString();
DataGridViewTenants.Rows.Add(row);
i++;
}
}
private void ComboBoxLand_SelectedIndexChanged(object sender, EventArgs e)
{
// List only those tenants who are currently in lease contract
// not the ones who have transfered their ownership already.
LeaseDA leaseDA = new LeaseDA();
Land selectedLand = (Land)ComboBoxLand.SelectedItem;
List <Tenant> currentTenant = leaseDA.GetCurrentTenantsByLandID(selectedLand.LandID);
try
{
ComboBoxCurrentTenant.DataSource = currentTenant;
ComboBoxCurrentTenant.DisplayMember = "Fullname";
ComboBoxCurrentTenant.ValueMember = "TenantID";
LoadComboBoxNewTenant();
}
catch (Exception)
{
MessageForm messageForm = new MessageForm();
messageForm.MessageText = "ओहो! केही आन्तरिक त्रुटीको कारण मोहीको विवरण लोड गर्न सकिएन।";
messageForm.ShowDialog();
}
EnableDisableRadioButtons();
}
private void ComboBoxTenant_SelectedIndexChanged(object sender, EventArgs e)
{
LeaseDA leaseDA = new LeaseDA();
Tenant selectedTenant = (Tenant)ComboBoxTenant.SelectedItem;
List <LeaseLand> leaseLand = leaseDA.GetLeaseLandByTenantID(selectedTenant.TenantID);
ComboBoxLeaseLand.DataSource = leaseLand;
ComboBoxLeaseLand.DisplayMember = "LandInfo";
ComboBoxLeaseLand.ValueMember = "LeaseID";
}
private void PopulateLeasedLands()
{
try
{
// Retrieve the TenantID
DataGridViewRow selectedTenant = DataGridViewTenants.CurrentRow;
int tenantID = int.Parse(selectedTenant.Tag.ToString());
LeaseDA leaseDA = new LeaseDA();
List <LeaseLand> leasedLands = leaseDA.GetLeaseLandByTenantID(tenantID);
ListBoxLeasedLands.DataSource = leasedLands;
ListBoxLeasedLands.DisplayMember = "LandInfo";
ListBoxLeasedLands.ValueMember = "LeaseID";
}
catch (Exception)
{
MessageForm messageForm = new MessageForm();
messageForm.MessageText = "केहीको प्राविधिक कारणले गर्दा कार्य सम्पन्न गर्न सकिएन।";
messageForm.ShowDialog();
}
}
private void ButtonSave_Click(object sender, EventArgs e)
{
// Either register new tenant or transfer ownership from
// existing tenant to new tenant.
// If current tenant is empty, we must register new tenant
// otherwise we must transfer ownership.
LeaseDA leaseDA = new LeaseDA();
Land land = (Land)ComboBoxLand.SelectedItem;
Tenant newTenant = (Tenant)ComboBoxNewTenant.SelectedItem;
MessageForm messageForm;
bool result = false;
Lease newLease = new Lease();
newLease.LeaseLand = land;
newLease.LeaseTenant = newTenant;
newLease.LeaseFrom = TextBoxLeaseFrom.Text;
newLease.AnnualRent = TextBoxAnnualRent.Text;
newLease.Remarks = TextBoxRemarks.Text;
if (ComboBoxCurrentTenant.Items.Count > 0)
{
// Check the action and act accordingly
// Transfer tenant ownership
if (RadioButtonActionTransferRegistration.Checked)
{
// Check whether this is the case of self-transfer to one of the existing tenants
bool caseOfSelfTransfer = false;
foreach (var item in ComboBoxCurrentTenant.Items)
{
if (((Tenant)item).Fullname == newTenant.Fullname)
{
caseOfSelfTransfer = true;
break;
}
}
Tenant currentTenant = (Tenant)ComboBoxCurrentTenant.SelectedItem;
if (caseOfSelfTransfer)
{
result = leaseDA.SelfTransfer(currentTenant, newLease);
}
else
{
result = leaseDA.TransferLease(currentTenant, newLease);
}
if (result)
{
messageForm = new MessageForm();
messageForm.MessageText = "मोही हस्तान्तरणको विवरण सफलतापूर्वक सुरक्षित गरियो।";
messageForm.ShowDialog();
}
}
// Joint registration
if (RadioButtonActionJointRegistration.Checked)
{
// Check if this lease is already assigned
if (!leaseDA.IsDuplicateLease(newLease))
{
// Save new lease
try
{
result = leaseDA.SaveLease(newLease);
}
catch (Exception)
{
messageForm = new MessageForm();
messageForm.MessageText = "ओहो! केही आन्तरिक त्रुटीको कारण मोही दर्ताको विवरण सुरक्षित गर्न सकिएन।";
messageForm.ShowDialog();
}
if (result)
{
messageForm = new MessageForm();
messageForm.MessageText = "मोही दतार्को विवरण सफलतापूर्वक सुरक्षित गरियो।";
messageForm.ShowDialog();
}
// Clear fields for new entry
ClearFields();
}
else
{
// duplicate lease
messageForm = new MessageForm();
messageForm.MessageText = $"उक्त जग्गा पहिले नै {newTenant.Fullname}को नाममा दर्ता भइसकेको छ।";
messageForm.ShowDialog();
}
}
}
else
{
// Register new tenant
// Check if this lease is already assigned
if (!leaseDA.IsDuplicateLease(newLease))
{
// Save new lease
try
{
result = leaseDA.SaveLease(newLease);
}
catch (Exception)
{
messageForm = new MessageForm();
messageForm.MessageText = "ओहो! केही आन्तरिक त्रुटीको कारण मोही दर्ताको विवरण सुरक्षित गर्न सकिएन।";
messageForm.ShowDialog();
}
if (result)
{
messageForm = new MessageForm();
messageForm.MessageText = "मोही दतार्को विवरण सफलतापूर्वक सुरक्षित गरियो।";
messageForm.ShowDialog();
}
// Clear fields for new entry
ClearFields();
}
else
{
// duplicate lease
messageForm = new MessageForm();
messageForm.MessageText = $"उक्त जग्गा पहिले नै {newTenant.Fullname}को नाममा दर्ता भइसकेको छ।";
messageForm.ShowDialog();
}
}
}
