public static async void LogIn(bool IsEnter) { if (IsEnter) { DataAlreadyLoaded?.Invoke(); Storage.DataLoaded = true; } else { if (Current.Properties.TryGetValue("user", out object id)) { try { ResultObj result = await Task.Run(() => Users.GetInfoAboutUser((int)id)); Storage.User = result.User; Storage.User.AddPhoto(Photo.Get(Storage.User.Id).Image); ResultObj blood = BloodData.Get(result.User.Id); Storage.User.AddBloodGroup(blood.BloodGroup); Storage.User.AddRFactor(blood.RFactor); DataAlreadyLoaded?.Invoke(); Storage.DataLoaded = true; } catch (System.Exception ex) { string str = ex.Message; Current.MainPage = new NavigationPage(new EnterPage()); } } } }
private void insertUserBloodDataTable() { if (this.userAddressTable != null) { try { this.userBloodTable = new BloodData(); this.userBloodTable.userID = this.txtboxUserName.Text; this.userBloodTable.bloodGroup = this.bloodGroup; this.userBloodTable.month = 0; this.userBloodTable.date = null; this.userBloodTable.donated = 0; this.userBloodTable.requested = 0; if (this.bloodReportStatus) { this.userBloodTable.bloodReport = 1; } else { this.userBloodTable.bloodReport = 0; } this.userBloodTable.accountstatus = "pending"; db.BloodDatas.InsertOnSubmit(this.userBloodTable); db.SubmitChanges(); }catch (SqlException ex) { MessageBox.Show("BloodDataTable Not Created"); } } else { MessageBox.Show("Address Table Is Must Be Created First"); } }
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(); } } }
public async void ShowAuthor(int id) { try { if (id != Storage.User.Id) { Storage.Friend = Users.GetInfoAboutUser(id).User; Storage.Friend.AddPhoto(Photo.Get(id).Image); ResultObj result = BloodData.Get(id); Storage.Friend.AddBloodGroup(result.BloodGroup); Storage.Friend.AddRFactor(result.RFactor); Storage.IsUserNow = false; } else { Storage.IsUserNow = true; } await Navigation.PushModalAsync(new Profile()); Storage.Friend = null; System.GC.Collect(); } catch (System.Exception ex) { await DisplayAlert("Ошибка", ex.Message, "OK"); } }
private void deleteBloodData() { BloodData bloodDataTable = db.BloodDatas.SingleOrDefault(x => x.userID == this.uName); if (bloodDataTable != null) { db.BloodDatas.DeleteOnSubmit(bloodDataTable); //db.SubmitChanges(); } }
private void btnSubmit_Click(object sender, EventArgs e) { if (this.reqType.Equals("donate")) { BloodData bloodDataTable = db.BloodDatas.SingleOrDefault(x => x.userID == this.LoggedUName); //UserDtail userDetailTable = db.UserDtails.SingleOrDefault(x => x.userID == this.LoggedUName); if (bloodDataTable != null) { if (bloodDataTable.bloodReport == 1) //checking blood report pos or neg { this.bloodGroup = bloodDataTable.bloodGroup; if (this.checkLastGivenDate()) { this.addToTempTable(); //this.addToBloodInventory(); } else { MessageBox.Show("U can not donate before 3 months"); this.LableStatus.Text = "Last Donated : " + bloodDataTable.date; // } } else { this.LableStatus.Text = "You Can Not Donate,Your Blood Report is negetive"; } } } else if (this.reqType.Equals("request")) { if (!string.IsNullOrEmpty(this.txtBloodQuantity.Text)) { int userRequested = int.Parse(this.txtBloodQuantity.Text); if (userRequested >= 0 && userRequested <= this.bloodQuantity) { this.addToTempTable(); //this.updateBloodQuantity(userRequested); } else { MessageBox.Show("Blood Unavailable"); } this.LableStatus.Text = this.bloodGroup + " : " + this.bloodQuantity; } } else { } }
private bool updateBloodData() { BloodData bloodData = db.BloodDatas.SingleOrDefault(x => x.userID == this.uName); if (bloodData != null) { bloodData.userID = this.txtUserName.Text; db.SubmitChanges(); return(true); } else { return(false); } }
private void addToBloodInventory() //only for donation { BloodData bdataTable = db.BloodDatas.SingleOrDefault(x => x.userID == this.LoggedUName); BloodInventory bloodTable = db.BloodInventories.SingleOrDefault(x => x.bloodgroup == this.bloodGroup); if (bloodTable != null && bdataTable != null) { this.date = DateTime.Now; bloodTable.bloodquantity += 1; bdataTable.donated += 1; bdataTable.date = date.ToString(); bdataTable.month = int.Parse(date.Month.ToString()); db.SubmitChanges(); this.addToHistory(1); this.LableStatus.Text = bloodTable.bloodgroup + " : Blood Donated " + bloodTable.bloodquantity.ToString(); } }
public async void ConfirmButton_Clicked(object sender, EventArgs e) { if (CodeEntry.Text != Storage.ConfirmCode) { await DisplayAlert("Ошибка", "Неверный код!\nПопробуйте ещё раз", "OK"); } else { activityIndicator.Start(); string res = "", res1 = ""; if (Storage.IsEntering) { Storage.User = Storage.temporaryData; Storage.IsEntering = false; App.Current.Properties.Clear(); App.Current.Properties.Add("user", Storage.User.Id); App.LogIn(true); await Navigation.PushAsync(new MainPage()); return; } else { res = await Task.Run(() => Registration.Add(Storage.temporaryData)); res1 = await Task.Run(() => BloodData.Push(Storage.temporaryData.Id, Storage.temporaryData.BloodGroup, Storage.temporaryData.RFactor)); } activityIndicator.Stop(); if (res == "OK" && res1 == "OK") { await Navigation.PopToRootAsync(); } else if (res == "OK") { await DisplayAlert("Предупреждение", "Возможно данные крови не были добавлены", "OK"); await Navigation.PopToRootAsync(); } else { await DisplayAlert("Ошибка", "Некорректные данные или проблемы с интернетом", "OK"); } } }
public BloodData getBlood(String Blood_Code) { BloodData Blood_data = new BloodData(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From BLOOD Where BLOOD_CODE='" + Blood_Code + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { Blood_data.Blood_Code = rowData["BLOOD_CODE"].ToString(); Blood_data.Blood_Name = rowData["BLOOD_NAME"].ToString(); } return(Blood_data); }
public async void SaveButton_Clicked(object sender, EventArgs e) { if (CheckData()) { Client client = CreateUser(); string str = Registration.Change(client); string mess = BloodData.Push(client.Id, client.BloodGroup, client.RFactor); if (str == "OK" && mess == "OK") { Storage.User = client; await Navigation.PopModalAsync(); } else { await DisplayAlert("Ошибка", "Некорректные данные или проблемы с интернетом", "OK"); } } }
public List <BloodData> getBlood() { List <BloodData> Blood_data = new List <BloodData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From BLOOD Order By BLOOD_CODE"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { BloodData Blood = new BloodData(); Blood.Blood_Code = rowData["BLOOD_CODE"].ToString(); Blood.Blood_Name = rowData["BLOOD_NAME"].ToString(); Blood_data.Add(Blood); } return(Blood_data); }
private void lastDonated() { BloodData bdataTable = db.BloodDatas.SingleOrDefault(x => x.userID == this.LoggedUName); if (bdataTable != null) { if (bdataTable.date != null && bdataTable.donated > 0) { this.LableStatus.Text = "Last Donated : " + bdataTable.date; } else { this.LableStatus.Text = "Never Donated Before"; } } else { MessageBox.Show("BloodData Table Error"); } }
private void updateBloodQuantity(int uReqQuantity) //only for request blood { BloodData bDataTable = db.BloodDatas.SingleOrDefault(x => x.userID == this.LoggedUName); BloodInventory bloodInvTable = db.BloodInventories.SingleOrDefault(x => x.bloodgroup == this.bloodGroup); if (bloodInvTable != null && bDataTable != null) { this.bloodQuantity -= uReqQuantity; //i was here bloodInvTable.bloodquantity = this.bloodQuantity; //db.SubmitChanges(); bDataTable.requested += int.Parse(this.txtBloodQuantity.Text.ToString()); //it was not updating db.SubmitChanges(); this.addToHistory(uReqQuantity); MessageBox.Show("Request Accepted" + bDataTable.requested.ToString()); } else { MessageBox.Show("DB not Updated"); } }
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 bool checkLastGivenDate() { BloodData bdataTable = db.BloodDatas.SingleOrDefault(x => x.userID == this.LoggedUName); if (bdataTable != null) { int Lastmonth = bdataTable.month ?? default(int); int currmonth = int.Parse(DateTime.Now.Month.ToString()); int monthDuration = currmonth - Lastmonth; if (monthDuration >= 3) { this.btnSubmit.Enabled = true; return(true); } else { return(false); } } else { return(false); } }
private async void ResultList_ItemTapped(object sender, ItemTappedEventArgs e) { try { ResultList.IsEnabled = false; if (e.Item != null) { UserModel userView = (UserModel)e.Item; int id = userView.ModeID; if (id != -1) { if (id != Storage.User.Id) { Storage.Friend = Users.GetInfoAboutUser(id).User; Storage.Friend.AddPhoto(Photo.Get(id).Image); ResultObj result = BloodData.Get(id); Storage.Friend.AddBloodGroup(result.BloodGroup); Storage.Friend.AddRFactor(result.RFactor); Storage.IsUserNow = false; } else { Storage.IsUserNow = true; } await Navigation.PushAsync(new Profile()); } } ((ListView)sender).SelectedItem = null; ResultList.IsEnabled = true; System.GC.Collect(); } catch (System.Exception ex) { await DisplayAlert("Error", ex.Message, "OK"); } }
private async void EnterButton_Clicked(object sender, EventArgs e) { try { EnterButton.IsEnabled = false; IsBusy = true; if (!IsCheck) { EnterButton.Text = "Войти"; CheckParams(); Password.PlaceholderColor = Color.LightGray; Password.IsVisible = true; IsCheck = true; } else { if (CrossConnectivity.Current.IsConnected) { if (CheckParams()) { ResultObj result = await Task.Run(() => DonorPlusLib.Login.CheckLogin(Login.Text.Trim(), Password.Text)); if (result.ErrorMessage == "OK") { Storage.User = result.User; Storage.User.AddPhoto(Photo.Get(result.User.Id).Image); ResultObj blood = BloodData.Get(result.User.Id); Storage.User.AddBloodGroup(blood.BloodGroup); Storage.User.AddRFactor(blood.RFactor); if (Storage.IsMailsAvaliable) { SendEmailAsync(Storage.User.Email).GetAwaiter(); } App.Current.Properties.Clear(); App.Current.Properties.Add("user", result.User.Id); if (Navigation.NavigationStack.Count == 1) { App.Current.MainPage = new NavigationPage(new MainPage()); } else { await Navigation.PushModalAsync(new MainPage()); } App.LogIn(true); } else { IsBusy = false; await DisplayAlert("Ошибка", "Некорректные данные или проблемы с интернетом", "ОК"); } } } else { await DisplayAlert("Интернет отсутствует", "Подключите интернет", "ОК"); } } IsBusy = false; EnterButton.IsEnabled = true; } catch (Exception ex) { await DisplayAlert("Ошибка", $"{ex.Message}", "OK"); EnterButton_Clicked(sender, e); } }