protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Doctor d = (Doctor)Session["doctor"]; HelloLabel.Text = d.CDoctorName; Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS(); DataSet ds = webser.GetMedinceNameAndId(); List <ListItem> LI = GetAllData.getListItemsForDDL(ds, "Medicine"); foreach (ListItem l in LI) { MedicineNameDDL.Items.Add(l); } MedicineNameDDL.DataBind(); UserService us = new UserService(); ds = us.GetUserNameAndId(); LI = GetAllData.getListItemsForDDL(ds, "User"); foreach (ListItem l in LI) { UserNameDDL.Items.Add(l); } UserNameDDL.DataBind(); } }
protected void ShowNewMessageDoctorGrid_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "AnswerDoctor") { int rowNumber = Convert.ToInt32(e.CommandArgument); int MessageId = Convert.ToInt32(ShowNewMessageDoctorGrid.Rows[rowNumber].Cells[0].Text); Message m = GetAllData.GetAllDataFromMessageForAnswer(MessageId, "user"); m.CMessageDoctorId = ShowNewMessageDoctorGrid.Rows[rowNumber].Cells[1].Text; Session["newMessage"] = m; UserAnswerL.Visible = true; UserAnswerO.Visible = true; UserAnswerTB.Visible = true; UserAnswerTB.Text = ""; UndoMessageButton.Visible = true; ResetMessageButton.Visible = true; SendMessageButton.Visible = true; UserAnswerO.Text = ""; } if (e.CommandName == "DeleteDoctorMessage") { int rowNumber = Convert.ToInt32(e.CommandArgument); int MessageId = Convert.ToInt32(ShowNewMessageDoctorGrid.Rows[rowNumber].Cells[0].Text); MessageService ms = new MessageService(); ms.DeleteMessage(MessageId); ChooseNewMessage_SelectedIndexChanged(sender, e); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Manager m = (Manager)Session["manager"]; HelloLabel.Text = m.CManagerName; GetAllData.Appointment(); AppointmentService ap = new AppointmentService(); string whereclout = " WHERE DoctorId=ApointmentDoctorId and UserId=ApointmentUserId and HourNumber=ApointmentHour and ApointmentDay=DayId"; string order = ""; string tabels = "Apointment,Users,Hours,Doctors,Days"; string s = "SELECT ApointmentId,ApointmentDoctorId,ApointmentUserId,ApointmentHour,ApointmentDate,UserName,HourNumber,HourStartTime,HourEndTime,DoctorName,DayName FROM " + tabels; s += whereclout; DataSet ds = ap.GetApointmentAndSort(s, tabels, order); //check if the dayaset isnt empty, if so, put the data in the gridview if (ds.Tables[0].Rows.Count != 0) { ShowAppointment.Visible = true; ShowAppointment.DataSource = ds; ShowAppointment.DataBind(); } else { Response.Write("<script>alert('לא נמצאו תורים')</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { User u = (User)Session["user"]; HelloLabel.Text = u.CUserName; GetAllData.VacationsForDoctor(); GetAllData.Appointment(); AppointmentService appser = new AppointmentService(); string s = "", tables = "Apointment,Doctors,Speciality,Hours,Days"; s = "SELECT ApointmentId,ApointmentDate,ApointmentHour,DoctorName,HourStartTime,HourEndTime,SpecialityName,DayName FROM " + tables; s += " WHERE ApointmentHour=HourNumber and ApointmentDoctorId=DoctorId and SpecialityId=DoctorSpecailty and ApointmentDay=DayId and ApointmentUserId='" + u.CUserId + "'"; Session["s"] = s; Session["tabels"] = tables; DataSet ds = appser.GetApointmentAndSort(s, tables, ""); if (ds.Tables[0].Rows.Count != 0) { CloseApointment.Visible = true; SortDDL.Visible = true; ApointmentGrid.Visible = true; ApointmentGrid.DataSource = ds; ApointmentGrid.DataBind(); } else { Response.Write("<script>alert('לא נמצאו תורים')</script>"); } }
async void Init() { data = await Api.AllData(); if (data != null) { lblCases.Text = data.cases.ToString("n0"); lblDeath.Text = data.deaths.ToString("n0"); lblRecovered.Text = data.recovered.ToString("n0"); lblTodayCases.Text = data.todayCases.ToString("n0"); lblTodayDeath.Text = data.todayDeaths.ToString("n0"); lblActiveCases.Text = data.active.ToString("n0"); } countryList = await Api.GetCountryData(); if (countryList != null) { listView.ItemsSource = countryList.OrderByDescending(q => q.cases).Take(100); } AdmobControl admobControl = new AdmobControl() { AdUnitId = AppConstants.BannerId }; st_admob.Children.Add(admobControl); }
public static async Task <GetAllData> AllData() { GetAllData model = new GetAllData(); try { var stringJSON = await Task.Run(() => JsonConvert.SerializeObject(null)); JObject jsonData = await ApiQuery("v2/all", stringJSON); if (jsonData != null) // hata alınmamışsa { model.cases = jsonData["cases"].Value <double>(); model.todayCases = jsonData["todayCases"].Value <double>(); model.deaths = jsonData["deaths"].Value <double>(); model.todayDeaths = jsonData["todayDeaths"].Value <double>(); model.recovered = jsonData["recovered"].Value <double>(); model.active = jsonData["active"].Value <double>(); model.critical = jsonData["critical"].Value <double>(); model.casesPerOneMillion = jsonData["casesPerOneMillion"].Value <double>(); model.deathsPerOneMillion = jsonData["deathsPerOneMillion"].Value <double>(); model.tests = jsonData["tests"].Value <double>(); model.testsPerOneMillion = jsonData["testsPerOneMillion"].Value <double>(); model.affectedCountries = jsonData["affectedCountries"].Value <double>(); } } catch (Exception ex) { } return(model); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Doctor d = (Doctor)Session["doctor"]; HelloLabel.Text = d.CDoctorName; GetAllData.VacationsForDoctor(); GetAllData.Appointment(); } }
protected void Page_Load(object sender, EventArgs e) { //put the exit button in the menu // //EXIT BUTTON //the exit button will delete the user shopping bag(set the value to be null) //and doesnt change the current stock of the medicine. // //do a method that rrecives object, the session value of myShoppingbag will be an object //and a shopping bag variable. if (!Page.IsPostBack) { if (Session["myShoppingBag"] == null) { //create shopping list Session["myShoppingBag"] = new ShoppingBag(); } else { myShoppingBag = (ShoppingBag)Session["myShoppingBag"]; } if (Session["presList"] == null) { Session["presList"] = new List <DataSet>(); } else { presList = (List <DataSet>)Session["presList"]; } //put the catagorys and the producers in the DDL Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS(); DataSet pro = webser.GetProducer(), cat = webser.GetCatagory(); List <ListItem> proList = GetAllData.getListItemsForDDL(pro, "MedicineProducer"); List <ListItem> catList = GetAllData.getListItemsForDDL(cat, "MedicineCatagory"); foreach (ListItem l in proList) { ProducerDDL.Items.Add(l); } foreach (ListItem l in catList) { DropDownListMedicineCatagory.Items.Add(l); } } CheckoutButton.Visible = true; SeeShoppingBag.Visible = true; User u = (User)Session["user"]; if (u == null) { CheckoutButton.Visible = false; SeeShoppingBag.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { Doctor d = (Doctor)Session["doctor"]; HelloLabel.Text = d.CDoctorName; DoctorService docser = new DoctorService(); DataSet ds = docser.GetDoctorCityName(d.CDoctorId); ShowCity.Text = ds.Tables[0].Rows[0]["CityName"].ToString(); ShowId.Text = d.CDoctorId; ShowName.Text = d.CDoctorName; ShowGender.Text = d.CDoctorGender; ShowBirthday.Text = Convert.ToString(d.CDoctorBirthday); ShowSpecailty.Text = ds.Tables[0].Rows[0]["SpecialityName"].ToString(); ShowLice.Text = Convert.ToString(d.CDoctorLicense); ShowPassword.Text = d.CDoctorPassword; if (d.CDoctorIsOnVacation == true) { showVacation.Text = "כן"; } else { showVacation.Text = "לא"; } ShowPhone.Text = d.CDoctorPhone; ShowUni.Text = d.CDoctorUniversity; if (!Page.IsPostBack) { string cityname = "", specName = ""; int cityid; DataSet temp = docser.GetSpec(); UserService us = new UserService(); ds = us.GetCity(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { cityid = Convert.ToInt32(ds.Tables[0].Rows[i]["CityId"].ToString()) - 1; cityname = ds.Tables[0].Rows[i]["CityName"].ToString(); DropDownList1.Items.Insert(cityid, cityname); } for (int i = 0; i < temp.Tables[0].Rows.Count; i++) { cityid = Convert.ToInt32(temp.Tables[0].Rows[i]["SpecialityId"].ToString()) - 1; specName = temp.Tables[0].Rows[i]["SpecialityName"].ToString(); SpecDDL.Items.Insert(cityid, specName); } //check the vacation for the doctors GetAllData.VacationsForDoctor(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { UserService us = new UserService(); DataSet ds = us.GetCity(); List <ListItem> list = GetAllData.getListItemsForDDL(ds, "City"); int index = 0; foreach (ListItem l in list) { if (index != 1) { CityList.Items.Add(l); } index++; } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { User u = (User)Session["user"]; HelloLabel.Text = u.CUserName; DoctorService docser = new DoctorService(); DataSet ds = docser.GetSpecailty(); List <ListItem> list = GetAllData.getListItemsForDDL(ds, "Speciality"); SpecailtyDropDownList.Items.Clear(); foreach (ListItem l in list) { SpecailtyDropDownList.Items.Add(l); } SpecailtyDropDownList.DataBind(); GetAllData.VacationsForDoctor(); } }
protected void ShowMessageUserGrid_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e) { if (e.CommandName == "AnswerUser") { Label4.Visible = true; AnswerTB.Visible = true; ResetMessageAnswer.Visible = true; SendMessageAnswer.Visible = true; UndoMessageAnswer.Visible = true; Message m = new Message(); Manager man = (Manager)Session["manager"]; int rowNumber = Convert.ToInt32(e.CommandArgument); int MessageId = Convert.ToInt32(ShowMessageUserGrid.Rows[rowNumber].Cells[0].Text); m = GetAllData.GetAllDataFromMessageForAnswer(MessageId, "user"); m.CMessageManagerId = man.CManagerId; Session["newMessage"] = m; Session["adress"] = "user"; } }
protected void LoginSubmit_Click(object sender, EventArgs e) { UserService us1 = new UserService(); DataSet ds = us1.Login(LoginIdTB.Text, LoginPasswordTB.Text); if (ds.Tables[0].Rows.Count == 1) { Label6.Text = "התחברת בהצלחה"; UserService us = new UserService(); us.UpdateLastLoginDate(LoginIdTB.Text, DateTime.Now); User u = GetAllData.GetAllUserDataById(LoginIdTB.Text); Session["user"] = u; Response.Redirect("http://localhost:49675/Personal.aspx"); } else { DoctorService doc1 = new DoctorService(); DataSet ds1 = doc1.DoctorLogin(LoginIdTB.Text, LoginPasswordTB.Text); if (ds1.Tables[0].Rows.Count == 1) { Doctor d = GetAllData.GetAllDoctorDataById(LoginIdTB.Text); Session["doctor"] = d; Response.Redirect("http://localhost:49675/DoctorInfo.aspx"); Label6.Text = "התחברת בהצלחה"; } else { ManagerService ms = new ManagerService(); DataSet ds2 = ms.ManagerLogin(LoginIdTB.Text, LoginPasswordTB.Text); if (ds2.Tables[0].Rows.Count == 1) { Manager m = GetAllData.GetAllManagerDataById(LoginIdTB.Text); Session["manager"] = m; Response.Redirect("http://localhost:49675/ManagerHome.aspx"); } else { Label6.Text = "תעודת זהות או סיסמא אינם נכונים"; } } } }
protected void WhoDDL_SelectedIndexChanged(object sender, EventArgs e) { DoctorIdL.Visible = false; DoctorNameDropDownList.Visible = false; DataSet ds; List <ListItem> list = new List <ListItem>(); int x = WhoDDL.SelectedIndex; if (x == 0) { WhoValid.Text = "לא בחרת"; return; } else if (x == 1) { //doctor Session["adress"] = "doctor"; DoctorService docser = new DoctorService(); DoctorNameDropDownList.Items.Clear(); ds = docser.GetDoctorName(""); list = GetAllData.getListItemsForDDL(ds, "Doctor"); } else if (x == 2) { //manager Session["adress"] = "manager"; ManagerService ms = new ManagerService(); ds = ms.GetManager(); DoctorNameDropDownList.Items.Clear(); list = GetAllData.getListItemsForDDL(ds, "Manager"); } //add the listitems to the dropdown list foreach (ListItem l in list) { DoctorNameDropDownList.Items.Add(l); } DoctorNameDropDownList.DataBind(); DoctorNameDropDownList.Visible = true; DoctorIdL.Visible = true; }
protected void SpecailtyDropDownList_SelectedIndexChanged(object sender, EventArgs e) { /* * לעשות שאילתה שלפי הקטגוריה שנבחרה מציגה את הרופאים * לעשות feedback * לשמור בענן את הקטגוריה שנבחרה */ //init int docSpec = Convert.ToInt32(SpecailtyDropDownList.SelectedValue); string s = " where DoctorIsOnVacation=false and DoctorSpecailty=" + docSpec; DoctorService docser = new DoctorService(); DataSet ds = docser.GetDoctorName(s); if (ds.Tables[0].Rows.Count > 0) { DoctorDropDownList.Visible = true; Label4.Visible = true; List <ListItem> list = GetAllData.getListItemsForDDL(ds, "Doctor"); DoctorDropDownList.Items.Clear(); foreach (ListItem l in list) { DoctorDropDownList.Items.Add(l); } DoctorDropDownList.DataBind(); Session["Spec"] = docSpec; } else { SpecalityValid.Visible = true; AppHour.Visible = false; SubmitButton.Visible = false; ResetButton.Visible = false; DateTB.Visible = false; Label6.Visible = false; Response.Write("<script>alert('אין רופאים תחת התמחות זו')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Manager m = (Manager)Session["manager"]; HelloLabel.Text = m.CManagerName; GetAllData.VacationsForDoctor(); VacationService vs = new VacationService(); string whereclout = " WHERE DoctorId=VacationDoctorId and ManagerId=VacationManagerId"; DataSet ds = vs.SortVacation(whereclout); ShowVac.Visible = false; if (ds.Tables[0].Rows.Count != 0) { CloseVac.Visible = true; ShowVac.Visible = true; ShowVac.DataSource = ds; ShowVac.DataBind(); } else { Response.Write("<script>alert('לא נמצאו חופשות')</script>"); } } }
protected void ShowDataGridForDoctor_RowUpdating(object sender, System.Web.UI.WebControls.GridViewUpdateEventArgs e) { try { Vacation v = new Vacation(); //validation DateTime start = Convert.ToDateTime(((TextBox)(ShowDataGridForDoctor.Rows[e.RowIndex].Cells[9].FindControl("StartVac"))).Text); DateTime end = Convert.ToDateTime(((TextBox)(ShowDataGridForDoctor.Rows[e.RowIndex].Cells[9].FindControl("EndVac"))).Text); if (start == null || end == null) { Response.Write("<script>alert('בחירת תאריך לא תקינה')</script>"); return; } if (start < DateTime.Now || end < DateTime.Now || end < start) { Response.Write("<script>alert('בחירת תאריך לא תקינה')</script>"); return; } v.CVacationStartDate = start; v.CVacationEndDate = end; Manager m = (Manager)Session["manager"]; v.CVacationManagerId = m.CManagerId; v.CVacationDoctorId = ShowDataGridForDoctor.Rows[e.RowIndex].Cells[0].Text; VacationService vs = new VacationService(); vs.InsertVacation(v); GetAllData.VacationsForDoctor(); Response.Write("<script>alert('חופשה התקבלה')</script>"); ShowDataGridForDoctor.EditIndex = -1; ShowGrid_Click(sender, e); } catch { Response.Write("<script>alert('בחירת תאריך לא תקינה')</script>"); return; } }
protected void SubmitEdit_Click(object sender, EventArgs e) { NewSpecValid.Text = ""; NewCityValid.Text = ""; NewUniValid.Text = ""; NewPhoneValid.Text = ""; NewLiceValid.Text = ""; NewPasswordValid.Text = ""; int spec = SpecDDL.SelectedIndex, city = DropDownList1.SelectedIndex; if (!Validation.IsPasswordValid(NewPassword.Text)) { NewPasswordValid.Text = "סיסמא לא עונה על הדרישות"; } if (!Validation.IsPhoneValid(NewPhone.Text)) { NewPhoneValid.Text = "מספר טלפון לא תקין"; } //temp if (DropDownList1.SelectedIndex == 0) { NewCityValid.Text = "עיר לא תקינה"; } if (SpecDDL.SelectedIndex == 0) { NewSpecValid.Text = "התמחות לא תקינה"; } if (!Validation.IsHouseNumberValid(NewLice.Text)) { NewLiceValid.Text = "מספר שנים במקצוע לא תקין"; } if (!Validation.IsNameValid(NewUni.Text)) { NewUniValid.Text = "אוניברסיטה לא תקינה"; } if (NewUniValid.Text == "" && NewLiceValid.Text == "" && NewSpecValid.Text == "" && NewCityValid.Text == "" && NewPhoneValid.Text == "" && NewPasswordValid.Text == "") { //update all the data string s = "DoctorCity=" + (DropDownList1.SelectedIndex + 1) + ",DoctorSpecailty=" + (SpecDDL.SelectedIndex + 1) + ",DoctorLicense=" + Convert.ToInt32(NewLice.Text) + ",DoctorUniversity='" + NewUni.Text + "',DoctorPhone='" + NewPhone.Text + "',DoctorPassword='******'"; s = s + " WHERE DoctorId ='" + ShowId.Text + "'"; DoctorService docser = new DoctorService(); docser.UpdateDoctorInfo(s); NewLice.Visible = false; NewUni.Visible = false; SpecDDL.Visible = false; NewPhone.Visible = false; NewPassword.Visible = false; DropDownList1.Visible = false; NewLiceValid.Text = ""; NewCityValid.Text = ""; NewUniValid.Text = ""; NewPhoneValid.Text = ""; NewSpecValid.Text = ""; NewPasswordValid.Text = ""; SubmitEdit.Visible = false; Doctor d = GetAllData.GetAllDoctorDataById(ShowId.Text); Session["doctor"] = d; NewLice.Text = ""; NewUni.Text = ""; NewPassword.Text = ""; NewPhone.Text = ""; Page_Load(sender, e); EditInfo.Text = "ערוך"; System.Threading.Thread.Sleep(1000); } }
protected void SubmitEdit_Click(object sender, EventArgs e) { NewAdressValid.Text = ""; NewCityValid.Text = ""; NewEmailValid.Text = ""; NewPhoneValid.Text = ""; NewEmailValid.Text = ""; NewPasswordValid.Text = ""; int x = DropDownList1.SelectedIndex; if (!(x >= 0 && x < 8)) { NewCityValid.Text = "עיר לא תקינה"; } //add update for city when you send the index and ID of user if (!Validation.IsAdressValid(NewAdress.Text)) { NewAdressValid.Text = "כתובת לא תקינה"; } if (!Validation.IsHouseNumberValid(NewHouseNumber.Text)) { NewHouseNumberValid.Text = "מספר בית לא תקין"; } if (!Validation.IsPhoneValid(NewPhone.Text)) { NewPhoneValid.Text = "מספר טלפון לא תקין"; } if (!Validation.IsEMailValid(NewEmail.Text)) { NewEmailValid.Text = "אימייל לא תקין"; } if (!Validation.IsPasswordValid(NewPassword.Text)) { NewPasswordValid.Text = "סיסמא לא עונה על הדרישות"; } //temp if (DropDownList1.SelectedIndex == 0) { NewCityValid.Text = "עיר לא תקינה"; } if (NewCityValid.Text == "" && NewAdressValid.Text == "" && NewCityValid.Text == "" && NewEmailValid.Text == "" && NewPhoneValid.Text == "" && NewEmailValid.Text == "" && NewPasswordValid.Text == "") { UserService us1 = new UserService(); us1.UpdateUserCity(ShowId.Text, x + 1);//לבדוק האם צריך להוסיף + 1 us1.UpdateUserAdress(ShowId.Text, NewAdress.Text); us1.UpdateUserHouseNumber(ShowId.Text, Convert.ToInt32(NewHouseNumber.Text)); us1.UpdateUserPhone(ShowId.Text, NewPhone.Text); us1.UpdateUserEmail(ShowId.Text, NewEmail.Text); us1.UpdateUserPassword(ShowId.Text, NewPassword.Text); NewAdress.Visible = false; NewHouseNumber.Visible = false; NewEmail.Visible = false; NewPhone.Visible = false; NewPassword.Visible = false; DropDownList1.Visible = false; NewAdressValid.Text = ""; NewCityValid.Text = ""; NewEmailValid.Text = ""; NewPhoneValid.Text = ""; NewEmailValid.Text = ""; NewPasswordValid.Text = ""; SubmitEdit.Visible = false; User u = GetAllData.GetAllUserDataById(ShowId.Text); Session["user"] = u; NewAdress.Text = ""; NewHouseNumber.Text = ""; NewPassword.Text = ""; NewPhone.Text = ""; NewEmail.Text = ""; Page_Load(sender, e); EditInfo.Text = "ערוך"; System.Threading.Thread.Sleep(1000); } }
/// <summary> /// Creates a new role based data fetcher. /// </summary> /// <typeparam name="TData">The type of fetched data.</typeparam> /// <param name="getAll">A function used to fetch all data.</param> /// <param name="getManaged">A function used to fetch data managed by the specified manager.</param> /// <returns></returns> public static RoleBasedDataFetcher <TData> Create <TData>(GetAllData <TData> getAll, GetManagedData <TData> getManaged) { Contract.Requires(getAll != null); Contract.Requires(getManaged != null); return(new RoleBasedDataFetcher <TData>(getAll, getManaged)); }