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