private void Edit_Click(object sender, RoutedEventArgs e)
{
EditDialogView handle = new EditDialogView();
if (handle.ShowDialog() == true)
{
if (handle.FirstInput != handle.SecondInput)
{
MessageBox.Show("Entry No. did not match.Try again.\n", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation);
return;
}
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * From LoanCollection WHERE LoanCollection_Id = " + handle.FirstInput;
SqlDataReader reader = conn.DataReader(query);
if (reader == null)
{
return;
}
while (reader.Read())
{
EntryNo.Text = reader["LoanCollection_Id"].ToString();
Id = Convert.ToInt32(EntryNo.Text);
Collection.Text = reader["LoanCollection_Collection"].ToString();
InstallmentNo.Text = reader["LoanCollection_Installment"].ToString();
}
conn.CloseConnection();
Save.Content = "Update";
}
}
private void Edit_Click(object sender, RoutedEventArgs e)
{
EditDialogView handle = new EditDialogView();
if (handle.ShowDialog() == true)
{
if (handle.FirstInput != handle.SecondInput)
{
MessageBox.Show("Entry No. did not match.Try again.\n", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation);
return;
}
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * From FixedDepositLedger WHERE FixedEntryId = " + handle.FirstInput;
SqlDataReader reader = conn.DataReader(query);
if (reader == null)
{
return;
}
while (reader.Read())
{
EntryNo.Text = reader["FixedEntryId"].ToString();
Id = Convert.ToInt32(EntryNo.Text);
Date.SelectedDate = (DateTime)reader["FixedDate"];
Details.Text = (string)reader["FixedDetails"];
Deposit.Text = reader["FixedDeposit"].ToString();
Withdraw.Text = reader["FixedWithdraw"].ToString();
}
conn.CloseConnection();
Save.Content = "Update";
}
}
private void Edit_Click(object sender, RoutedEventArgs e)
{
EditDialogView handle = new EditDialogView();
if (handle.ShowDialog() == true)
{
if (handle.FirstInput != handle.SecondInput)
{
MessageBox.Show("Entry No. did not match.Try again.\n", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation);
return;
}
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * From CooperativeDevelopment WHERE Cooperative_Id = " + handle.FirstInput;
SqlDataReader reader = conn.DataReader(query);
if (reader == null)
{
return;
}
while (reader.Read())
{
EntryNo.Text = reader["Cooperative_Id"].ToString();
Id = Convert.ToInt32(EntryNo.Text);
Date.SelectedDate = (DateTime)reader["Cooperative_Date"];
Current.Text = reader["Cooperative_Current"].ToString();
Paid.Text = reader["Cooperative_Paid"].ToString();
}
conn.CloseConnection();
Save.Content = "Update";
}
}
private void Edit_Click(object sender, RoutedEventArgs e)
{
EditDialogView handle = new EditDialogView();
if (handle.ShowDialog() == true)
{
if (handle.FirstInput != handle.SecondInput)
{
MessageBox.Show("Entry No. did not match.Try again.\n", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation);
return;
}
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * From OfficeRent WHERE Office_Id = " + handle.FirstInput;
SqlDataReader reader = conn.DataReader(query);
if (reader == null)
{
return;
}
while (reader.Read())
{
EntryNo.Text = reader["Office_Id"].ToString();
Date.SelectedDate = (DateTime)reader["Office_Date"];
Month.Text = (string)reader["Office_Month"];
Advance.Text = reader["Office_Advance"].ToString();
Rent.Text = reader["Office_Rent"].ToString();
}
conn.CloseConnection();
Save.Content = "Update";
}
}
private void Edit_Click(object sender, RoutedEventArgs e)
{
EditDialogView handle = new EditDialogView();
handle.ChangeLabelForMember();
if (handle.ShowDialog() == true)
{
if (handle.FirstInput != handle.SecondInput)
{
MessageBox.Show("Member ID did not match.Try again.\n", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation);
return;
}
MonthlyDepositEntryView GDEntryObj = new MonthlyDepositEntryView();
GDEntryObj.SetForEdit(handle.FirstInput);
GDEntryObj.SaveMember.Content = "Update Account";
this.NavigationService.Navigate(GDEntryObj);
}
}
private void Edit_Click(object sender, RoutedEventArgs e)
{
EditDialogView handle = new EditDialogView();
handle.ChangeLabelForStuff();
if (handle.ShowDialog() == true)
{
if (handle.FirstInput != handle.SecondInput)
{
MessageBox.Show("Stuff ID did not match.Try again.\n", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation);
return;
}
StuffEntryView StfEntryObj = new StuffEntryView();
StfEntryObj.SetForEdit(handle.FirstInput);
StfEntryObj.SaveStuff.Content = "Update Stuff";
this.NavigationService.Navigate(StfEntryObj);
}
}
private void Edit_Click(object sender, RoutedEventArgs e)
{
EditDialogView handle = new EditDialogView();
if (handle.ShowDialog() == true)
{
if (handle.FirstInput != handle.SecondInput)
{
MessageBox.Show("Entry No. did not match.Try again.\n", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation);
return;
}
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * From LaonDetails WHERE LoanDetails_Id = " + handle.FirstInput;
SqlDataReader reader = conn.DataReader(query);
if (reader == null)
{
return;
}
while (reader.Read())
{
EntryNo.Text = reader["LoanDetails_Id"].ToString();
Id = Convert.ToInt32(EntryNo.Text);
AccountId.Text = (string)reader["LoanDetails_Account"];
Sector.Text = reader["LoanDetails_Sector"].ToString();
Amount.Text = reader["LoanDetails_Amount"].ToString();
ServiceCharge.Text = reader["LoanDetails_Service"].ToString();
SanctionDate.SelectedDate = (DateTime)reader["LoanDetails_Sanction"];
LifeTime.Text = reader["LoanDetails_Lifetime"].ToString();
Installment.Text = reader["LoanDetails_Installment"].ToString();
}
conn.CloseConnection();
Save.Content = "Update";
}
}
