public static List <LastDonationDate> getAllLastDonations() { List <LastDonationDate> lastDonations = new List <LastDonationDate>(); try { SqlCommand command = new SqlCommand("Select * from LastDonationDate"); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { LastDonationDate ld = new LastDonationDate(); ld.ID = reader["dID"].ToString(); ld.User = UsersDB.getUserbyID(reader["userId"].ToString()); ld.LastDonation = Convert.ToDateTime(reader["donationDate"]); ld.Type = reader["type"].ToString(); ld.Status = reader["status"].ToString(); lastDonations.Add(ld); } reader.Close(); } finally { connection.Close(); } return(lastDonations); }
public static int updateLastDonation(LastDonationDate ld) { int num = -1; try { SqlCommand command = new SqlCommand("update LastDonationDate set donationDate=@lastdonation, status=@status, type=@type where dId=@id"); command.Parameters.AddWithValue("@lastdonation", ld.LastDonation); command.Parameters.AddWithValue("@status", ld.Status); command.Parameters.AddWithValue("@type", ld.Type); command.Parameters.AddWithValue("@id", ld.ID); command.Connection = connection; connection.Open(); if (command.ExecuteNonQuery() > 0) { num = 1; } } finally { connection.Close(); } return(num); }
public static int insertLastDonation(LastDonationDate ld) { int num = -1; try { SqlCommand command = new SqlCommand("insert into LastDonationDate values(@userId, @donationDate, @type, @status)"); command.Parameters.AddWithValue("@userId", ld.User.UserId); command.Parameters.AddWithValue("@donationDate", ld.LastDonation); command.Parameters.AddWithValue("@type", ld.Type); command.Parameters.AddWithValue("@status", ld.Status); command.Connection = connection; connection.Open(); if (command.ExecuteNonQuery() > 0) { num = 1; } } finally { connection.Close(); } return(num); }
protected void btnSubmit_Click(object sender, EventArgs e) { List <Users> Userlist = UsersDB.getallUsers(); if (!CheckTerm.Checked) { cbTermVali.Visible = true; return; } else { cbTermVali.Visible = false; DateTime check = DateTime.Now.AddYears(-18); if (Convert.ToDateTime(tbxDOB.Text) > check) { lblDOB.Visible = true; return; } foreach (Users u in Userlist) { if (tbxNRIC.Text == u.nric) { lblNRIC.Visible = true; return; } else { lblNRIC.Visible = false; } } foreach (Users u in Userlist) { if (tbxEmail.Text == u.email) { lblEmail.Visible = true; return; } else { lblEmail.Visible = false; } } foreach (Users u in Userlist) { if (tbxUsername.Text == u.password) { lblUsername.Visible = true; return; } else { lblUsername.Visible = false; } } if (tbxHeight.Text == "") { theight = 0; } else { theight = Convert.ToInt32(tbxHeight.Text); } if (tbxWeight.Text == "") { tweight = 0; } else { tweight = Convert.ToInt32(tbxWeight.Text); } if (RadioMale.Checked) { tgender = "Male"; } else { tgender = "Female"; } if (RadioMSSingle.Checked) { Rstatus = "Single"; } else if (RadioMSWidowed.Checked) { Rstatus = "Widowed"; } else if (RadioMSDivorced.Checked) { Rstatus = "Divorced"; } else { Rstatus = "Married"; } if (ddllastDAsk.SelectedIndex == 0) { lblldAsk.Visible = true; Panel1.Visible = false; return; } else if (ddllastDAsk.SelectedIndex == 1) { if (Convert.ToDateTime(tbxlastDonate.Text) > System.DateTime.Now) { lbllastDonate.Visible = true; return; } else { lbllastDonate.Visible = false; lstDonate = Convert.ToDateTime(tbxlastDonate.Text); if (RadioBlood.Checked) { bloodgroup = "blood"; } else { bloodgroup = "platelet"; } } } else { lstDonate = System.DateTime.Now.AddYears(-10); bloodgroup = "blood"; } Users newuser = new Users(tbxEmail.Text, tbxName.Text, Convert.ToDateTime(tbxDOB.Text), tgender, Rstatus, theight, tweight, ddlBloodType.SelectedValue, tbxUsername.Text, tbxPassword.Text, Convert.ToInt32(tbxPhone.Text), tbxNRIC.Text, "null", 0, "null", "Allow", tbxAddress.Text, Convert.ToInt32(tbxZipcode.Text), ddlNationality.SelectedValue, "Default.png", "null", "Can Donate", "null", "null", "null"); int num = UsersDB.insertUser(newuser); if (num != -1) { Users newu = UsersDB.getUserbyEmail(tbxEmail.Text); LastDonationDate ldd = new LastDonationDate(newu, lstDonate, bloodgroup, "Not in transaction"); LastDonationDateDB.insertLastDonation(ldd); if (checkEmergencyContact.Checked) { Session["Username"] = tbxUsername.Text; Server.Transfer("AddationalRegister.aspx"); } else { lblOutput.Visible = true; lblOutput.Text = "Registeration Successful!"; string HomePageUrl = "Login.aspx"; Page.Header.Controls.Add(new LiteralControl(string.Format(@" <META http-equiv='REFRESH' content=3;url={0}> ", HomePageUrl))); } } else { lblOutput.Visible = true; lblOutput.Text = "User Cannot Register!"; return; } } }