public void TestConstructorByList() { DateTime dateTime = new DateTime(2012, 1, 2); //List<Agenda> agendaList = new List<Agenda>(); Agendas agendas = new Agendas(); Agenda agenda1 = new Agenda(dateTime); agenda1.Title = "agenda1"; Agenda agenda2 = new Agenda(dateTime); agenda2.Title = "agenda2"; Agenda agenda3 = new Agenda(dateTime); agenda3.Title = "agenda3"; Agenda agenda4 = new Agenda(dateTime); agenda4.Title = "agenda4"; Agenda agenda5 = new Agenda(dateTime); agenda5.Title = "agenda5"; agendas.AddAgenda(agenda1); agendas.AddAgenda(agenda2); agendas.AddAgenda(agenda3); agendas.AddAgenda(agenda4); agendas.AddAgenda(agenda5); DayAgenda day = new DayAgenda(agendas, dateTime); Assert.AreEqual(5, day.Count); }
public static Agendas GetOne(Agendas monAgenda) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable resultat = new DataTable(); SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM Agendas " + " WHERE CodeVeto = @CodeVeto " + " AND DateRdv = @DateRdv " + " AND CodeAnimal = @CodeAnimal ;"; monParametre = new SqlParameter("@Agendas", monAgenda.CodeVeto); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@DateRdv", monAgenda.DateRDV); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@CodeAnimal", monAgenda.CodeAnimal); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(resultat); return(new Agendas(resultat.Rows[0])); } }
private void AgendaTel() { string salir; ArrayList Agenda = new ArrayList(); Agendas h = new Agendas(); for (int x = 0; ; x++) { Console.WriteLine("Digite el nombre"); h.Nombre = Console.ReadLine(); Console.WriteLine("Digite el numero de telefono"); h.telefono = Console.ReadLine(); Agenda.Add(h); Console.WriteLine("Si desea salir digite'salir' si no digite 'no'"); salir = Console.ReadLine(); if (salir == "salir" || salir == "Salir") { break; } } Console.WriteLine("Agenda"); foreach (Agendas datos in Agenda) { Console.WriteLine("Contactos:\n {0} {1} {2} {3}", "Nombre:", datos.Nombre, "Numero:", datos.telefono); } Console.ReadKey(); }
public static void Delete(Agendas monAgenda) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " DELETE FROM Agendas " + " WHERE CodeVeto = @CodeVeto " + " AND DateRdv = @DateRdv " + " AND CodeAnimal = @CodeAnimal "; monParametre = new SqlParameter("@CodeVeto", monAgenda.CodeVeto); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@DateRdv", monAgenda.DateRDV); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@CodeAnimal", monAgenda.CodeAnimal); cmd.Parameters.Add(monParametre); try { cmd.ExecuteScalar(); } catch (Exception) { throw new Exception("Echec de la suppression de la race"); } } }
// Init public EcranConsultation(Agendas pAgenda) { InitializeComponent(); _monAgenda = pAgenda; _monAnimal = monMgtAnimal.AfficherUneSeul(pAgenda.CodeAnimal.Value); _monVeto = MgtVeterinaires.getOneVeto(pAgenda.CodeVeto.Value); TXT_CodeAnimal.Text = _monAnimal.CodeAnimal.Value.ToString(); TXT_Couleur.Text = _monAnimal.Couleur; TXT_Espece.Text = _monAnimal.Race.Espece; TXT_NomAnimal.Text = _monAnimal.NomAnimal; TXT_Race.Text = _monAnimal.Race.Race; TXT_Sexe.Text = _monAnimal.Sexe.ToString(); TXT_Tatouage.Text = _monAnimal.Tatouage; DATE_Acte.Text = pAgenda.DateRDV.Value.ToString(); COMBO_Veto.DataSource = MgtVeterinaires.getAllVeto(); for (int i = 0; i < COMBO_Veto.Items.Count; i++) { if (((Veterinaires)COMBO_Veto.Items[i]).CodeVeto.Value == pAgenda.CodeVeto.Value) { COMBO_Veto.SelectedIndex = i; break; } } COMBO_TypeActe.DataSource = MgtBaremes.AffichierTout().Select(x => x.TypeActe).Distinct().ToList <string>(); ChangementCOMBO(true, false); }
public static void Ejercicio7_5() { int salir = 0; ArrayList Agenda = new ArrayList(); Agendas h = new Agendas(); for (int x = 0; ; x++) { Console.WriteLine("Ingrese el nombre"); h.Nombre = Console.ReadLine(); Console.WriteLine("Ingrese el numero de telefono"); h.telefono = Console.ReadLine(); Agenda.Add(h); Console.WriteLine("Si desea salir ingrese '0' si no ingrese '1'"); entrada = Console.ReadLine(); salir = Convert.ToInt32(entrada); if (salir == 0 || salir == 0) { break; } } foreach (Agendas datos in Agenda) { Console.WriteLine("Datos de la personas {0} {1}", datos.Nombre, datos.telefono); } Console.ReadKey(); }
public List <IElectronicDocument> GetMeetingDocuments(string relationName) { var documentList = new List <IElectronicDocument>(); var documents = new List <IElectronicDocument>(); documents.AddRange(Agendas.GetAll(a => Equals(a.Meeting, _obj)).ToList()); documents.AddRange(Sungero.Meetings.Minuteses.GetAll(m => Equals(m.Meeting, _obj)).ToList()); if (relationName == string.Empty) { foreach (var document in documents) { documentList.AddRange(document.Relations.GetRelated().Union(document.Relations.GetRelatedFrom()).Distinct().ToList()); } } else { foreach (var document in documents) { documentList.AddRange(document.Relations.GetRelated(relationName).Union(document.Relations.GetRelatedFrom(relationName)).Distinct().ToList()); } } documentList.AddRange(documents); documentList = documentList.Distinct().ToList(); return(documentList); }
private void Capitulo7Programa5() { string salir; ArrayList Agenda = new ArrayList(); Agendas h = new Agendas(); for (int x = 0; ; x++) { Console.WriteLine("Digite el nombre"); h.Nombre = Console.ReadLine(); Console.WriteLine("Digite el numero de telefono"); h.telefono = Console.ReadLine(); Agenda.Add(h); Console.WriteLine("Si desea salir digite'salir' si no digite 'no'"); salir = Console.ReadLine(); if (salir == "salir" || salir == "Salir") { break; } } foreach (Agendas datos in Agenda) { Console.WriteLine("Los datos son {0} {1}", datos.Nombre, datos.telefono); } }
public static List <Agendas> GetAllWithDetail() { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable maDataTable = new DataTable(); List <Agendas> listeAgendas = new List <Agendas>(); Agendas monAgenda; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM Agendas Ag " + " INNER JOIN Veterinaires V ON Ag.CodeVeto = V.CodeVeto " + " INNER JOIN Animaux An ON Ag.CodeAnimal = An.CodeAnimal " + " INNER JOIN Clients C ON An.CodeClient = C.CodeClient "; monAdapter.SelectCommand = cmd; monAdapter.Fill(maDataTable); foreach (DataRow unAgendas in maDataTable.Rows) { monAgenda = new Agendas(unAgendas); monAgenda.NomAnimal = unAgendas["NomAnimal"].ToString(); monAgenda.NomClient = unAgendas["NomClient"].ToString(); monAgenda.PrenomClient = unAgendas["PrenomClient"].ToString(); monAgenda.Race = unAgendas["Race"].ToString(); listeAgendas.Add(monAgenda); } return(listeAgendas); } }
public ActionResult DeleteConfirmed(int id) { Agendas agendas = db.Agendas.Find(id); db.Agendas.Remove(agendas); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <SingleAgenda> GetAgendaById(int id) { SingleAgenda li = new SingleAgenda(); try { Agendas agenda = await db.Agendas.FindAsync(id); if (agenda == null) { li.Status = false; li.Message = "404 Not Found"; return(li); } else { li.Status = true; li.Message = "Record you asked."; AgendasClass temp = new AgendasClass { ID = agenda.ID, Title = agenda.Title, DateTime = agenda.DateTime.ToString("dddd dd MMMM, yyyy") + " at " + agenda.DateTime.ToShortTimeString(), Description = agenda.Description, Users = db.AgendaUsers.Where(x => x.AgendasID == agenda.ID).Count() }; if (agenda.DateTime == DateTime.Now) { temp.Status = "Today"; temp.Color = "0xff38ad0d"; } else if (agenda.DateTime < DateTime.Now) { temp.Status = "Hosted"; temp.Color = "0xffb7b7b7"; } else { temp.Status = "Upcoming"; temp.Color = "0xfff47d08"; } li.Agenda = temp; li.Note = await db.Notes.Select(x => new { x.ID, x.Title, x.Description, x.AgendasID, MemberId = x.Peoples.ID, MemberImage = x.Peoples.Image, MemberName = x.Peoples.FullName, UserType = x.Peoples.Type, NoteStatus = x.Status }).FirstOrDefaultAsync(x => x.AgendasID == agenda.ID && x.NoteStatus.Equals("Public")); li.Secretary = db.Peoples.Where(x => x.Type.Equals("Secretary")).Select(x => new { x.ID, x.Image, x.FullName, x.Email }).ToList(); li.Members = db.AgendaUsers.Where(x => x.AgendasID == agenda.ID && x.Status == true).Take(4).Select(x => new { MemberId = x.Peoples.ID, MemberImage = x.Peoples.Image, MemberName = x.Peoples.FullName, MemberEmail = x.Peoples.Email }).ToList(); return(li); } } catch (Exception e) { li.Status = false; li.Message = e.InnerException.ToString(); return(li); } }
private async void OnAddButton(Agenda contact) { await App.Current.MainPage.DisplayAlert("Registro Exitoso", "El contacto ha sido agregado ", "OK"); await App.Current.MainPage.Navigation.PushAsync(new HomePage()); contact = new Agenda(Name, Number); Agendas.Add(contact); }
public List <IAgenda> GetOrCreateAgenda() { var agendaList = Agendas.GetAll(d => Equals(d.Meeting, _obj)).ToList(); if (!agendaList.Any() && Docflow.PublicFunctions.Module.Remote.IsModuleAvailableForCurrentUserByLicense(Sungero.Meetings.Constants.Module.MeetingsUIGuid)) { var agenda = Agendas.Create(); agenda.Meeting = _obj; agendaList.Add(agenda); } return(agendaList); }
private void BTN_Suppr_Click(object sender, EventArgs e) { Agendas monAgenda = new Agendas(); monAgenda.CodeAnimal = (Guid)dataGrid.CurrentRow.Cells["CodeAnimal"].Value; monAgenda.CodeVeto = (Guid)dataGrid.CurrentRow.Cells["CodeVeto"].Value; monAgenda.DateRDV = (DateTime)dataGrid.CurrentRow.Cells["DateRDV"].Value; MgtAgenda.Supprimer(monAgenda); ChargementDataGrid(); }
public ActionResult Edit([Bind(Include = "ID,Motivo,Descripcion,Cliente,Empleado,Fecha,Hora,Herramientas_Necesarias")] Agendas agendas) { if (ModelState.IsValid) { db.Entry(agendas).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Cliente = new SelectList(db.Clientes, "ID", "Nombre", agendas.Cliente); ViewBag.Empleado = new SelectList(db.Empleados, "ID", "Nombre", agendas.Empleado); return(View(agendas)); }
// GET: AgendasAdmin/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Agendas agendas = db.Agendas.Find(id); if (agendas == null) { return(HttpNotFound()); } return(View(agendas)); }
public object Convert(object value, Type targetType, object parameter, CultureInfo culture) { UserControl retValue; switch (value) { case PlaneMeetingViewModel pmvm: retValue = new PlaneMeeting(); break; case CreateMeetingViewModel cmvm: retValue = new CreateMeeting(); break; case FilterViewModel fvm: retValue = new Filter(); break; case RegistryViewModel rvm: retValue = new DecisionRegistry(); break; case IssuesViewModel ivm: retValue = new Issues(); break; case ModifyProtocolViewModel mpvm: retValue = new ModifyProtocol(); break; case AgendasViewModel avm: retValue = new Agendas(); break; case ModifyAgendaViewModel mavm: retValue = new ModifyAgenda(); break; case null: default: retValue = null; break; } if (retValue != null) { retValue.DataContext = value; } return(retValue); }
// Click private void BTN_Urgence_Click(object sender, EventArgs e) { Agendas monAgenda = new Agendas(); Clients monClient = (Clients)COMBO_Client.SelectedItem; Animaux monAnimal = (Animaux)COMBO_Animal.SelectedItem; Veterinaires monVeto = (Veterinaires)COMBO_Veto.SelectedItem; monAgenda.CodeAnimal = monAnimal.CodeAnimal; monAgenda.CodeVeto = monVeto.CodeVeto; monAgenda.DateRDV = DateTime.Now; MgtAgenda.Ajouter(monAgenda); ChargementDataGrid(); }
public bool add(Modelo prEntity) { try { Agenda Entity = (Agenda)prEntity; Agendas.Add(Entity); return(SaveChanges() > 0); } catch (Exception e) { return(false); } }
public ActionResult Create([Bind(Include = "ID,Motivo,Descripcion,Cliente,Empleado,Fecha,Hora,Herramientas_Necesarias")] Agendas agendas) { if (ModelState.IsValid) { int id = Convert.ToInt32(Session["ID"]); agendas.Cliente = id; db.Agendas.Add(agendas); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Cliente = new SelectList(db.Clientes, "ID", "Nombre", agendas.Cliente); ViewBag.Empleado = new SelectList(db.Empleados, "ID", "Nombre", agendas.Empleado); return(View(agendas)); }
// GET: AgendasAdmin/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Agendas agendas = db.Agendas.Find(id); if (agendas == null) { return(HttpNotFound()); } ViewBag.Cliente = new SelectList(db.Clientes, "ID", "Nombre", agendas.Cliente); ViewBag.Empleado = new SelectList(db.Empleados, "ID", "Nombre", agendas.Empleado); return(View(agendas)); }
public async Task <ResponseObject> PostAgendas(Agendas agendas) { ResponseObject temp = new ResponseObject(); try { if (!ModelState.IsValid) { temp.Status = false; temp.Message = "Model State is not valid."; return(temp); } db.Agendas.Add(agendas); await db.SaveChangesAsync(); var people = db.Peoples.Where(x => x.Type == "Member").Select(x => new { x.ID }).ToList(); foreach (var details in people) { try { AgendaUsers add = new AgendaUsers { AgendasID = agendas.ID, User = details.ID, Status = true }; db.AgendaUsers.Add(add); await db.SaveChangesAsync(); } catch (Exception) { } } temp.Status = true; temp.Message = "201 Created."; temp.Data = agendas; return(temp); } catch (Exception e) { temp.Status = false; temp.Message = e.InnerException.ToString(); return(temp); } }
public async Task <ResponseObject> PutAgendas(int id, Agendas agendas) { ResponseObject obj = new ResponseObject(); if (!ModelState.IsValid) { obj.Status = false; obj.Message = "Model state is not valid."; return(obj); } if (id != agendas.ID) { obj.Status = false; obj.Message = "404 Record Not Found."; return(obj); } db.Entry(agendas).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AgendasExists(id)) { obj.Status = false; obj.Message = "404 Record Not Found."; return(obj); } else { obj.Status = false; obj.Message = "There was an error.Try again later."; return(obj); } } obj.Status = true; obj.Message = "Record Successfully Updated"; obj.Data = agendas; return(obj); }
public static List <Agendas> GetAgendaWithParams(Guid pCodeVeto, DateTime pDateRDV) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable maDataTable = new DataTable(); List <Agendas> listeAgendas = new List <Agendas>(); Agendas monAgenda; SqlParameter monParametre; string maDteEnString = pDateRDV.ToShortDateString(); SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM Agendas Ag " + " INNER JOIN Veterinaires V ON Ag.CodeVeto = V.CodeVeto " + " INNER JOIN Animaux An ON Ag.CodeAnimal = An.CodeAnimal " + " INNER JOIN Clients C ON An.CodeClient = C.CodeClient " + " WHERE CONVERT (CHAR(10), Ag.DateRdv, 103) = @dateRDV " + " AND Ag.CodeVeto = @codeVeto " + " ORDER BY Ag.DateRdv"; monParametre = new SqlParameter("@dateRDV", maDteEnString); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@codeVeto", pCodeVeto); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(maDataTable); foreach (DataRow unAgendas in maDataTable.Rows) { monAgenda = new Agendas(unAgendas); monAgenda.NomAnimal = unAgendas["NomAnimal"].ToString(); monAgenda.NomClient = unAgendas["NomClient"].ToString(); monAgenda.PrenomClient = unAgendas["PrenomClient"].ToString(); monAgenda.Race = unAgendas["Race"].ToString(); listeAgendas.Add(monAgenda); } return(listeAgendas); } }
public bool update(Modelo prEntity) { try { Agenda Entity = (Agenda)prEntity; Agenda lAgenda = Agendas.Find(Entity.agendaid); if (lAgenda != null && lAgenda != Entity) { lAgenda.Update(Entity); } return(SaveChanges() > 0); } catch (Exception e) { return(false); } }
public ActionResult Index() { string queryBuscaAgenda = @"select * from PSNAL.dbo.tbl_agenda where UsuarioResponsavelId = @UsuarioResponsavelId"; Agendas agenda = new Agendas() { UsuarioResponsavelId = CurrentUser.id.ToString() }; agenda = Select(queryBuscaAgenda, agenda); Unificador unificador = new Unificador(); unificador.User = CurrentUser; unificador.agenda = agenda; unificador.Exercises = new Exercises(); unificador.Food = new Food(); unificador.ExercisesList = new List <Exercises>(); unificador.FoodList = new List <Food>(); unificador.UserList = new List <Usuario>(); return(View(unificador)); }
public ActionResult Editar() { Unificador unificador = new Unificador(); string queryBuscaAgenda = @"select * from PSNAL.dbo.tbl_agenda where UsuarioResponsavelId = @UsuarioResponsavelId"; Agendas agenda = new Agendas() { UsuarioResponsavelId = CurrentUser.id.ToString() }; agenda = Select(queryBuscaAgenda, agenda); string queryBuscaDieta = @"select top 10 * from PSNAL.dbo.v_dietafood"; List <DietaFoodVm> listaDieta = Selectlist(queryBuscaDieta, new DietaFoodVm()); List <SelectListItem> selectlist = new List <SelectListItem>(); foreach (var p in listaDieta) { selectlist.Add(new SelectListItem { Text = p.dietaNome, Value = p.dietaNome }); } ViewBag.ListaDieta = selectlist; List <SelectListItem> selectlist2 = new List <SelectListItem>(); string queryBuscaSet = @"select top 10 * from PSNAL.dbo.v_set_exercicio"; List <SetExercicioVm> listaSet = Selectlist(queryBuscaSet, new SetExercicioVm()); foreach (var p in listaSet) { selectlist2.Add(new SelectListItem { Text = p.setNome, Value = p.setNome }); } ViewBag.ListaSet = selectlist2; unificador.User = CurrentUser; unificador.agenda = agenda; return(View(unificador)); }
/// <summary> /// Ajoute un rendez vous /// </summary> /// <param name="veto"></param> /// <param name="animal"></param> /// <param name="dateRdv"></param> /// <returns></returns> /// <exception cref="Exception"></exception> public Agenda Ajouter(Veterinaire veto, Animal animal, DateTime dateRdv) { try { if (default(Agenda) != Agendas.Find(ag => ag.DateRdv == dateRdv && ag.Veto == veto)) { throw new Exception("Ce veterinaire a deja un rendez vous a cette date!!!"); } if (default(Agenda) != Agendas.Find(ag => ag.DateRdv == dateRdv && ag.Animal == animal)) { throw new Exception("Cet animal a deja un rendez vous a cette date!!!"); } Agenda agenda = new Agenda(veto, animal, dateRdv); Database.Instance.insert(agenda); this.Agendas.Add(agenda); return(agenda); } catch (Exception e) { throw e; } }
private void BTN_Valider_Click(object sender, EventArgs e) { Clients monClient = (Clients)COMBO_Client.SelectedItem; Animaux monAnimal = (Animaux)COMBO_Animal.SelectedItem; Veterinaires monVeto = (Veterinaires)COMBO_Veto.SelectedItem; Agendas monAgenda = new Agendas(); monAgenda.CodeAnimal = monAnimal.CodeAnimal; monAgenda.CodeVeto = monVeto.CodeVeto; try { monAgenda.DateRDV = new DateTime(DATE_RendezVous.Value.Year, DATE_RendezVous.Value.Month, DATE_RendezVous.Value.Day, (int)COMBO_Heure.SelectedValue, (int)COMBO_Minutes.SelectedValue, 0); } catch (Exception ex) { throw new Exception("Problème lors du passage de la date concernant l'ajout d'un RDV en urgence :\n" + ex.Message); } MgtAgenda.Ajouter(monAgenda); ChargementDataGrid(); }
public void TestLoadAgendaList() { Agenda agenda1 = new Agenda(new DateTime(2012, 1, 1)); agenda1.Title = "agenda1"; Agenda agenda2 = new Agenda(new DateTime(2012, 1, 2)); agenda2.Title = "agenda2"; Agenda agenda3 = new Agenda(new DateTime(2012, 1, 3)); agenda3.Title = "agenda3"; Agenda agenda4 = new Agenda(new DateTime(2012, 1, 4)); agenda4.Title = "agenda4"; Agenda agenda5 = new Agenda(new DateTime(2012, 1, 5)); agenda5.Title = "agenda5"; _agendas.AddAgenda(agenda1); _agendas.AddAgenda(agenda2); _agendas.AddAgenda(agenda3); _agendas.AddAgenda(agenda4); _agendas.AddAgenda(agenda5); _agendas.SaveAgendaList().ContinueWith((T) => { _agendas = new Agendas(); Assert.AreEqual(0, _agendas.Count); _agendas.LoadAgendaList(); Assert.AreEqual(5, _agendas.Count); }).ContinueWith((T) => { _agendas.SaveAgendaList().ContinueWith((X) => { _agendas = new Agendas(); Assert.AreEqual(0, _agendas.Count); _agendas.LoadAgendaList(); Assert.AreEqual(5, _agendas.Count); }); }); }