private void btnConfirm_Click(object sender, EventArgs e)
{
DB_contextDataContext db = new DB_contextDataContext();
this.code = this.txtConfirm.Text;
this.checkVerificationCode();
}
public void reloadAdminPage()
{
DB_contextDataContext db = new DB_contextDataContext();
this.DataGrid.DataSource = db.BloodInventories;
this.Show();
}
private void checkVerificationCode()
{
DB_contextDataContext db = new DB_contextDataContext();
UserLoginData logindataTable = db.UserLoginDatas.SingleOrDefault(x => x.username == this.LoggedUName);
UserAddr userAddresTab = db.UserAddrs.SingleOrDefault(x => x.userID == this.LoggedUName);
UserDtail userDetailsTable = db.UserDtails.SingleOrDefault(x => x.userID == this.LoggedUName);
BloodData userBloodTable = db.BloodDatas.SingleOrDefault(x => x.userID == this.LoggedUName);
if (logindataTable != null && userAddresTab != null && userDetailsTable != null && userBloodTable != null)
{
if (logindataTable.verfication == code)
{
logindataTable.confirmVerification = this.txtConfirm.Text;
userAddresTab.accountstatus = "activated";
userDetailsTable.accountstatus = "activated";
userBloodTable.accountstatus = "activated";
db.SubmitChanges();
this.userLoginForm.isChecked = true;
this.lableStatus.Text = "Account Activating.....";
Thread.Sleep(4000);
userHomePage userForm = new userHomePage();
userForm.showLoggedUser(LoggedUName);
this.Hide();
userForm.Show();
}
else
{
this.lableStatus.Text = "Invalid Code";
this.txtConfirm.Clear();
}
}
}
private bool checkEmailValidate()
{
DB_contextDataContext db = new DB_contextDataContext();
string requestedEmail = this.txtEmail.Text;
string userName = this.txtUserName.Text;
UserLoginData loginTab = db.UserLoginDatas.SingleOrDefault(x => x.email == requestedEmail && x.username != userName);
if (loginTab != null)
{
this.expType = 1;
return(false);
}
else
{
bool isEmail = Regex.IsMatch(requestedEmail, @"\A(?:[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?)\Z", RegexOptions.IgnoreCase);
if (isEmail)
{
this.lableValidation.Text = "";
return(true);
}
else
{
this.expType = 2;
this.lableValidation.Text = "Invalid Email Format";
this.txtEmail.Clear();
this.txtEmail.WaterMark = "*****@*****.**";
return(true);
}
}
}
private void delFromBloodDataTable()
{
DB_contextDataContext db = new DB_contextDataContext();
var pendingUsers = from userBloodTab in db.BloodDatas
where userBloodTab.accountstatus == "pending"
select userBloodTab;
db.BloodDatas.DeleteAllOnSubmit(pendingUsers);
db.SubmitChanges();
}
private void delFromUserDetailsTable()
{
DB_contextDataContext db = new DB_contextDataContext();
var pendingUsers = from usersDetaisTab in db.UserDtails
where usersDetaisTab.accountstatus == "pending"
select usersDetaisTab;
db.UserDtails.DeleteAllOnSubmit(pendingUsers);
db.SubmitChanges();
}
private void delFromUserLoginTable()
{
DB_contextDataContext db = new DB_contextDataContext();
//UserLoginData loginTable;
var pendingUsers = from userLoginTab in db.UserLoginDatas
where userLoginTab.confirmVerification == null
select userLoginTab;
db.UserLoginDatas.DeleteAllOnSubmit(pendingUsers);
db.SubmitChanges();
}
private void addToTempTable()
{
DB_contextDataContext db = new DB_contextDataContext();
UserTempData uTempData = new UserTempData();
uTempData.username = this.LoggedUName;
if (this.reqType.Equals("donate"))
{
uTempData.quantity = 1;
uTempData.requestType = "donate";
}
else
{
uTempData.quantity = int.Parse(this.txtBloodQuantity.Text.ToString());
uTempData.requestType = "request";
}
db.UserTempDatas.InsertOnSubmit(uTempData);
db.SubmitChanges();
MessageBox.Show("Requested For");
}
private void checkVerification()
{
DB_contextDataContext db = new DB_contextDataContext();
UserLoginData userTable = db.UserLoginDatas.SingleOrDefault(x => x.username == this.userBox.Text);
if (userTable != null)
{
EmailConformation confForm = new EmailConformation();
if (userTable.confirmVerification == null)
{
this.Hide();
confForm.trackUser(this.userBox.Text, this);
confForm.Show();
}
else
{
this.isChecked = true;
}
}
}
private void setFromDataBase()
{
DB_contextDataContext db = new DB_contextDataContext();
UserDtail userDetailTable = new UserDtail();
this.userAddressTable = db.UserAddrs.SingleOrDefault(x => x.userID == this.uName);
this.userBloodDataTable = db.BloodDatas.SingleOrDefault(x => x.userID == this.uName);
userDetailTable = db.UserDtails.SingleOrDefault(x => x.userID == this.uName);
if (this.userAddressTable != null && this.userBloodDataTable != null && userDetailTable != null)
{
this.txtFirstName.Text = this.userAddressTable.firstName;
this.txtLastName.Text = this.userAddressTable.lastName;
this.txtUserName.Text = this.userAddressTable.userID;
this.txtPhone.Text = this.userAddressTable.mobileNo;
this.txtEmail.Text = this.userAddressTable.email;
this.txtDistrict.Text = this.userAddressTable.district;
this.txtSubdistrict.Text = this.userAddressTable.subDistrict;
this.txtPostal.Text = this.userAddressTable.postalCode;
this.LableBlood.Text = this.userBloodDataTable.bloodGroup;
try
{
this.userPP.Image = Image.FromFile(userDetailTable.propicture);
}
catch (ArgumentNullException exp)
{
this.userPP.Image = Image.FromFile(@"F:\Programming\C#\C# Project Updated\BloodBankManagement\BloodBankManagement\images\default.jpg");
}
//this.userPP.SizeMode = PictureBoxSizeMode.StretchImage;
this.userPP.SizeMode = PictureBoxSizeMode.Zoom;
}
else
{
this.lableValidation.Text = "Problem To Load Database";
//MessageBox.Show("Problem To Load Database");
}
}
private void relode()
{
this.db = null;
this.db = new DB_contextDataContext();
this.DataGrid.DataSource = this.db.UserDtails;
}
