private void Previous_button_Click(object sender, EventArgs e)
{
Donar_Profile dp = new Donar_Profile();
this.Hide();
dp.Show();
}
private void Donar_login_button_Click(object sender, EventArgs e)
{
string useremail = User_email_textbox.Text;
string userpassword = User_password_textBox.Text;
if (useremail.Equals(""))
{
MessageBox.Show("please enter your Email.");
}
else if (userpassword.Equals(""))
{
MessageBox.Show("please enter your Password.");
}
else
{
string query = "select * from Donars where Email = '" + useremail + "' AND Password = '******'";
objDBAccess.readDatathroughAdapter(query, dtUsers);
if (dtUsers.Rows.Count == 1)
{
id = dtUsers.Rows[0]["ID"].ToString();
name = dtUsers.Rows[0]["Name"].ToString();
email = dtUsers.Rows[0]["Email"].ToString();
password = dtUsers.Rows[0]["Password"].ToString();
phn_num = dtUsers.Rows[0]["Phone_number"].ToString();
dob = dtUsers.Rows[0]["Date_of_Birthday"].ToString();
age = dtUsers.Rows[0]["Age"].ToString();
occupation = dtUsers.Rows[0]["Occupation"].ToString();
gender = dtUsers.Rows[0]["Gender"].ToString();
address = dtUsers.Rows[0]["Address"].ToString();
fake_name = dtUsers.Rows[0]["Fake_name"].ToString();
current_balance = dtUsers.Rows[0]["Current_Balance"].ToString();
total_donated_amount = dtUsers.Rows[0]["Total_donated_amount"].ToString();
//MessageBox.Show("login Successfully");
objDBAccess.closeConn();
Donar_Profile hf = new Donar_Profile();
this.Hide();
hf.Show();
}
else
{
query = "select * from Receivers where Email = '" + useremail + "' AND Password = '******'";
objDBAccess.readDatathroughAdapter(query, dtUsers);
if (dtUsers.Rows.Count == 1)
{
id = dtUsers.Rows[0]["ID"].ToString();
name = dtUsers.Rows[0]["Name"].ToString();
email = dtUsers.Rows[0]["Email"].ToString();
password = dtUsers.Rows[0]["Password"].ToString();
phn_num = dtUsers.Rows[0]["Phone_number"].ToString();
dob = dtUsers.Rows[0]["Date_of_Birth"].ToString();
age = dtUsers.Rows[0]["Age"].ToString();
occupation = dtUsers.Rows[0]["Occupation"].ToString();
gender = dtUsers.Rows[0]["Gender"].ToString();
present_address = dtUsers.Rows[0]["Present_address"].ToString();
permanent_address = dtUsers.Rows[0]["Permanent_address"].ToString();
nid = dtUsers.Rows[0]["NID"].ToString();
marital_status = dtUsers.Rows[0]["Marital_status"].ToString();
religion = dtUsers.Rows[0]["Religion"].ToString();
reference_person_name = dtUsers.Rows[0]["Reference_person_name"].ToString();
reference_person_phn_number = dtUsers.Rows[0]["Reference_person_phone_number"].ToString();
organization_type = dtUsers.Rows[0]["Organization_type"].ToString();
//MessageBox.Show("login Successfully");
objDBAccess.closeConn();
Receiver_Profile_form rpf = new Receiver_Profile_form();
this.Hide();
rpf.Show();
}
else
{
MessageBox.Show("Invalid information. Provide correct email and password");
}
}
}
}
private void Donate_button_Click(object sender, EventArgs e)
{
if (Receiver_names_comboBox.Text.Equals(""))
{
MessageBox.Show("Please select a receiver.");
}
else
{
if (Double.Parse(need_amounts) == 0)
{
MessageBox.Show("This person's request has been full fill. Don't need more money");
}
else
{
if (Double.Parse(UserLogin.current_balance) > 0)
{
DialogResult dialogResult = MessageBox.Show("Do you want to donate it ?", "You have " + UserLogin.current_balance + " money stroed in your balance", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
/* this.Refresh();
* if (Double.Parse(need_amounts) == 0)
* {
* MessageBox.Show("This person's request has been full fill. Don't need more money");
*
* }
* else */
if (Double.Parse(need_amounts) >= Double.Parse(UserLogin.current_balance))
{
g_amount = Double.Parse(got_amounts) + Double.Parse(UserLogin.current_balance);
n_amount = (Double.Parse(need_amounts) - Double.Parse(UserLogin.current_balance));
cs_amount = Double.Parse(current_stored_amount) - Double.Parse(UserLogin.current_balance);
td_donation = Double.Parse(total_delivered_donation) + Double.Parse(UserLogin.current_balance);
donarUser_c_balance = 0.00;
}
else
{
g_amount = Double.Parse(got_amounts) + Double.Parse(need_amounts);
donarUser_c_balance = Double.Parse(UserLogin.current_balance) - Double.Parse(need_amounts);
cs_amount = Double.Parse(current_stored_amount) - Double.Parse(need_amounts);
td_donation = Double.Parse(total_delivered_donation) + Double.Parse(need_amounts);
n_amount = 0.00;
}
//MessageBox.Show(receiver_id);
string query11 = "UPDATE Receiver_requests SET Amount_need = '" + n_amount + "', Amount_got = '" + g_amount + "' WHERE rid = '" + receiver_id + "' ";
objDBAccess.readDatathroughAdapter(query11, dtUsers);
string query12 = "UPDATE System_account SET Total_delivered_donation = '" + td_donation + "', Current_stored_amount = '" + cs_amount + "' WHERE Account_name = 'SYSTEM'; ";
objDBAccess.readDatathroughAdapter(query12, dtUsers);
string query13 = "UPDATE Donars SET Current_Balance = '" + donarUser_c_balance + "' WHERE ID = '" + UserLogin.id + "'; ";
objDBAccess.readDatathroughAdapter(query13, dtUsers);
this.Refresh();
MessageBox.Show("Thanks for your donation, your donation transfer successfully.");
Donar_Profile dp = new Donar_Profile();
this.Hide();
dp.Refresh();
//dp.Show();
UserLogin l = new UserLogin();
l.Show();
}
else
{
MessageBox.Show("Thankyou for your service.");
}
}
else if (Double.Parse(UserLogin.current_balance) == 0)
{
Donar_Amount da = new Donar_Amount();
da.Show();
this.Hide();
}
else
{
MessageBox.Show("Somthing Error!!!");
}
}
}
}
private void Donar_amountConfirm_ok_button_Click(object sender, EventArgs e)
{
MessageBox.Show("You select " + Receiver_List.receiver_name + " for donation.");
double donated_amount = Double.Parse(Enter_amount_textBox.Text);
if (Double.Parse(Receiver_List.need_amounts) == 0)
{
MessageBox.Show("This person's request has been full fill. Don't need more money");
Receiver_List.cs_amount = Double.Parse(Receiver_List.current_stored_amount) + donated_amount;
Receiver_List.tr_donation = Double.Parse(Receiver_List.total_received_donation) + donated_amount;
Receiver_List.donarUser_c_balance = Double.Parse(UserLogin.current_balance) + donated_amount;
donar_total_donated_amount = Double.Parse(UserLogin.total_donated_amount) + donated_amount;
}
else if (Double.Parse(Receiver_List.need_amounts) >= donated_amount)
{
Receiver_List.g_amount = Double.Parse(Receiver_List.got_amounts) + donated_amount;
Receiver_List.n_amount = (Double.Parse(Receiver_List.need_amounts) - donated_amount);
Receiver_List.tr_donation = Double.Parse(Receiver_List.total_received_donation) + donated_amount;
Receiver_List.td_donation = Double.Parse(Receiver_List.total_delivered_donation) + donated_amount;
donar_total_donated_amount = Double.Parse(UserLogin.total_donated_amount) + donated_amount;
}
else
{
Receiver_List.g_amount = Double.Parse(Receiver_List.got_amounts) + Double.Parse(Receiver_List.need_amounts);
Receiver_List.donarUser_c_balance = Double.Parse(UserLogin.current_balance) + (donated_amount - Double.Parse(Receiver_List.need_amounts));
donar_total_donated_amount = Double.Parse(UserLogin.total_donated_amount) + donated_amount;
Receiver_List.cs_amount = Double.Parse(Receiver_List.current_stored_amount) + (donated_amount - Double.Parse(Receiver_List.need_amounts));
Receiver_List.td_donation = Double.Parse(Receiver_List.total_delivered_donation) + Double.Parse(Receiver_List.need_amounts);
Receiver_List.tr_donation = Double.Parse(Receiver_List.total_received_donation) + donated_amount;
Receiver_List.n_amount = 0.00;
}
string query21 = "UPDATE Receiver_requests SET Amount_need = '" + Receiver_List.n_amount + "', Amount_got = '" + Receiver_List.g_amount + "' WHERE rid = '" + Receiver_List.receiver_id + "' ";
objDBAccess.readDatathroughAdapter(query21, dtUsers);
string query22 = "UPDATE System_account SET Total_received_donation = '" + Receiver_List.tr_donation + "' , Total_delivered_donation = '" + Receiver_List.td_donation + "', Current_stored_amount = '" + Receiver_List.cs_amount + "' WHERE Account_name = 'SYSTEM'; ";
objDBAccess.readDatathroughAdapter(query22, dtUsers);
string query23 = "UPDATE Donars SET Total_donated_amount = '" + donar_total_donated_amount + "',Current_Balance = '" + Receiver_List.donarUser_c_balance + "' WHERE ID = '" + UserLogin.id + "'; ";
objDBAccess.readDatathroughAdapter(query23, dtUsers);
MessageBox.Show("Thanks for your donation, your donation transfer successfully.");
Donar_Profile dp = new Donar_Profile();
this.Hide();
dp.Refresh();
UserLogin l = new UserLogin();
l.Show();
//dp.Show();
}
