public LoanDetailsView()
{
InitializeComponent();
LoanDetails data = new LoanDetails();
LoanDetails.ItemsSource = data.GetData();
DataContext = data;
}
private void Remove_Click(object sender, RoutedEventArgs e)
{
RemoveDialogView handle = new RemoveDialogView();
if (handle.ShowDialog() == true)
{
using (SqlConnection con = new SqlConnection(@Connection.ConnectionString))
{
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();
int isLogin = 0;
string query = "SELECT * From Stuff ";
SqlDataReader reader = conn.DataReader(query);
while (reader.Read())
{
stuff_name = (string)reader["Stuff_Name"];
stuff_pass = (string)reader["Stuff_Password"];
if (stuff_name.Equals(Login.GlobalStuffName) && stuff_pass.Equals(handle.GetPassword))
{
isLogin = 1;
break;
}
}
if (isLogin != 1)
{
MessageBox.Show("Wrong Password.Try again.\n", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation);
return;
}
using (SqlCommand command = new SqlCommand("DELETE FROM LoanDetails WHERE Security_Id = " + handle.FirstInput, con))
{
con.Open();
command.ExecuteNonQuery();
con.Close();
}
Id = Convert.ToInt32(handle.FirstInput);
dateTime = DateTime.Today;
string table = "Security Fund";
string type = "Removed";
string color = "Red";
EntryLog entry = new EntryLog();
entry.Add_Entry(table, type, Id, dateTime, color);
conn.CloseConnection();
LoanDetails data = new LoanDetails();
LoanDetails.ItemsSource = data.GetData();
DataContext = data;
}
}
}
protected void Save_Click(object sender, RoutedEventArgs e)
{
if (Daily.IsChecked == true)
{
method = "Daily";
}
else if (Weekly.IsChecked == true)
{
method = "Weekly";
}
else if (Monthly.IsChecked == true)
{
method = "Monthly";
}
if (method == "")
{
MessageBox.Show("Error!Select Collection method");
return;
}
if (CheckForError(AccountId) || CheckForError(Sector) || CheckForError(Amount) || CheckForError(ServiceCharge) || CheckForError(LifeTime) || CheckForError(Installment))
{
MessageBox.Show("Error!Check Input Again");
return;
}
Connection conn2 = new Connection();
string query2 = "SELECT * From [Member] where MemberId =" + AccountId.Text + " ";
conn2.OpenConection();
SqlDataReader reader2 = conn2.DataReader(query2);
while (!reader2.Read())
{
MessageBox.Show("Error!Account Id invalid");
return;
}
conn2.CloseConnection();
DateTime dtd = Convert.ToDateTime(SanctionDate.Text);
DateTime nextDate = dtd;
if (method == "Daily")
{
nextDate = nextDate.AddDays(1);
}
else if (method == "Weekly")
{
nextDate = nextDate.AddDays(7);
}
else if (method == "Monthly")
{
nextDate = nextDate.AddMonths(1);
}
if ((string)Save.Content == "Insert")
{
using (SqlConnection conn = new SqlConnection(@Connection.ConnectionString))
{
double charge = (Convert.ToDouble(Amount.Text) * Convert.ToDouble(ServiceCharge.Text)) / 100;
double total = Convert.ToDouble(Amount.Text) + charge;
SqlCommand CmdSql = new SqlCommand("INSERT INTO [LoanDetails] (LoanDetails_Account, LoanDetails_Sector, LoanDetails_Amount, LoanDetails_Service, LoanDetails_Sanction,LoanDetails_LastPaid,LoanDetails_NextDate,LoanDetails_Collection, LoanDetails_Lifetime, LoanDetails_Installment, LoanDetails_InstallmentAmount,LoanDetails_Total,LoanDetails_Balance) VALUES (@Account, @Sector, @Amount, @Service, @Sanction, @LastPaid,@NextDate, @Collection, @Lifetime, @Installment, @InstallmentAmount, @Total ,@Balance)", conn);
conn.Open();
CmdSql.Parameters.AddWithValue("@Account", AccountId.Text);
CmdSql.Parameters.AddWithValue("@Sector", Sector.Text);
CmdSql.Parameters.AddWithValue("@Amount", Amount.Text);
CmdSql.Parameters.AddWithValue("@Service", ServiceCharge.Text);
CmdSql.Parameters.AddWithValue("@Sanction", SanctionDate.Text);
CmdSql.Parameters.AddWithValue("@LastPaid", SanctionDate.Text);
CmdSql.Parameters.AddWithValue("@NextDate", nextDate);
CmdSql.Parameters.AddWithValue("@Lifetime", LifeTime.Text);
CmdSql.Parameters.AddWithValue("@Collection", method);
CmdSql.Parameters.AddWithValue("@Installment", Installment.Text);
CmdSql.Parameters.AddWithValue("@InstallmentAmount", total / Convert.ToDouble(Installment.Text));
CmdSql.Parameters.AddWithValue("@Total", total);
CmdSql.Parameters.AddWithValue("@Balance", total);
CmdSql.ExecuteNonQuery();
conn.Close();
//Inserting value in Entry table
Id = Convert.ToInt32(EntryNo.Text);
dateTime = DateTime.Today;
string table = "Loan Details";
string type = "Inserted";
string color = "Green";
EntryLog entry = new EntryLog();
entry.Add_Entry(table, type, Id, dateTime, color);
MessageBox.Show("Successfully Inserted");
}
}
else
{
using (SqlConnection conn = new SqlConnection(@Connection.ConnectionString))
{
double charge = (Convert.ToDouble(Amount.Text) * Convert.ToDouble(ServiceCharge.Text)) / 100;
double total = Convert.ToDouble(Amount.Text) + charge;
SqlCommand CmdSql = new SqlCommand("UPDATE [LoanDetails] SET LoanDetails_Account = @Account, LoanDetails_Sector=@Sector, LoanDetails_Amount=@Amount, LoanDetails_Service=@Service, LoanDetails_Sanction=@Sanction,LoanDetails_LastPaid=@LastPaid,LoanDetails_NextDate=@NextDate,LoanDetails_Collection=@Collection, LoanDetails_Lifetime=@LifeTime, LoanDetails_Installment=@Installment, LoanDetails_InstallmentAmount=@InstallmentAmount,LoanDetails_Total=@Total,LoanDetails_Balance=@Balance", conn);
conn.Open();
CmdSql.Parameters.AddWithValue("@Account", AccountId.Text);
CmdSql.Parameters.AddWithValue("@Sector", Sector.Text);
CmdSql.Parameters.AddWithValue("@Amount", Amount.Text);
CmdSql.Parameters.AddWithValue("@Service", ServiceCharge.Text);
CmdSql.Parameters.AddWithValue("@Sanction", SanctionDate.Text);
CmdSql.Parameters.AddWithValue("@LastPaid", SanctionDate.Text);
CmdSql.Parameters.AddWithValue("@NextDate", nextDate);
CmdSql.Parameters.AddWithValue("@Lifetime", LifeTime.Text);
CmdSql.Parameters.AddWithValue("@Collection", method);
CmdSql.Parameters.AddWithValue("@Installment", Installment.Text);
CmdSql.Parameters.AddWithValue("@InstallmentAmount", total / Convert.ToDouble(Installment.Text));
CmdSql.Parameters.AddWithValue("@Total", total);
CmdSql.Parameters.AddWithValue("@Balance", total);
CmdSql.ExecuteNonQuery();
conn.Close();
//Inserting value in Entry table
Id = Convert.ToInt32(EntryNo.Text);
dateTime = DateTime.Today;
string table = "Loan Details";
string type = "Update";
string color = "Blue";
EntryLog entry = new EntryLog();
entry.Add_Entry(table, type, Id, dateTime, color);
MessageBox.Show("Successfully Updated");
}
Save.Content = "Insert";
}
LoanDetails data = new LoanDetails();
LoanDetails.ItemsSource = data.GetData();
DataContext = data;
}