private void ButtonSave_Click(object sender, EventArgs e) { LeasePaymentDA leasePaymentDA = new LeasePaymentDA(); Tenant selectedTenant = (Tenant)ComboBoxTenant.SelectedItem; LeaseLand leasedLand = (LeaseLand)ComboBoxLeaseLand.SelectedItem; RentYear rentYear = (RentYear)ComboBoxRentYear.SelectedItem; MessageForm messageForm = new MessageForm(); if (!leasePaymentDA.IsDuplicatePayment(leasedLand.LeaseID, rentYear.YearID)) { LeasePayment newLeasePayment = new LeasePayment(); newLeasePayment.LeaseID = leasedLand.LeaseID; newLeasePayment.YearID = rentYear.YearID; newLeasePayment.LeaseRent = TextBoxAnnualRent.Text; newLeasePayment.PaymentDate = TextBoxPaymentDate.Text; newLeasePayment.ReceiptNumber = TextBoxReceiptNumber.Text; newLeasePayment.Remarks = TextBoxRemarks.Text; bool success = leasePaymentDA.SaveLeasePayment(newLeasePayment); if (success) { messageForm.MessageText = $"उक्त जग्गाको {rentYear.TheRentYear} सालको ठेक्का बुझाएको अभिलेख सुरक्षित गरियो।"; } else { messageForm.MessageText = $"प्राविधिक कारणले गर्दा उक्त ठेक्का बुझाएको विवरण सुरक्षित गर्न सकिएन।"; } messageForm.ShowDialog(); } else { messageForm.MessageText = $"उक्त जग्गाको {rentYear.TheRentYear} सालको ठेक्का बुझाइसकेको छ।"; messageForm.ShowDialog(); } ClearFields(); }
public bool SaveLeasePayment(LeasePayment leasePayment) { bool result = false; using (SqlConnection sqlConn = new SqlConnection(GlobalConfig.ConnString())) { try { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = "SaveLeasePayment"; sqlCommand.Connection = sqlConn; sqlCommand.Parameters.AddWithValue("@LeaseID", leasePayment.LeaseID); sqlCommand.Parameters.AddWithValue("@YearID", leasePayment.YearID); sqlCommand.Parameters.AddWithValue("@LeaseRent", leasePayment.LeaseRent); sqlCommand.Parameters.AddWithValue("@PaymentDate", leasePayment.PaymentDate); sqlCommand.Parameters.AddWithValue("@ReceiptNumber", leasePayment.ReceiptNumber); sqlCommand.Parameters.AddWithValue("@Remarks", leasePayment.Remarks); sqlConn.Open(); int rowsAffected = sqlCommand.ExecuteNonQuery(); if (rowsAffected > 0) { result = true; } } catch (Exception) { throw new Exception("Error: SaveLeasePayment() method couldn't execute properly."); } } return(result); }