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; }