public List <Disponibility> GetByProduct(long IDProduct) { List <Disponibility> results = new List <Disponibility>(); using (var context = new ProyectoMaestriaEntities()) { var result = context.Disponibility.Where(x => x.IDProduct == IDProduct); if (result != null) { foreach (var temp in result) { Disponibility temp1 = new Disponibility(); temp1.ID = temp.ID; temp1.IDProvider = temp.IDProvider; temp1.IDProduct = temp.IDProduct; temp1.Quantity = temp.Quantity; temp1.UnitValue = temp.UnitValue; temp1.ExpirationDate = temp.ExpirationDate; results.Add(temp1); } return(results); } else { return(results); } } }
private void Initialize(Reports report) { Oee oeeType; switch (report) { case Reports.DisponibilityList: case Reports.DisponibilityCurrent: oeeType = new Disponibility(); break; case Reports.VelocityList: oeeType = new Velocity(); break; case Reports.QualityList: oeeType = new Quality(); break; case Reports.AllView: oeeType = new AllView(); break; default: throw new NotImplementedException(); } tableName = oeeType.GetTableName; columnNames = oeeType.ColumnNames; }
public ActionResult DeleteConfirmed(int id) { Disponibility disponibility = sdis.GetById(id); //db.Disponibilities.Remove(disponibility); //db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "DisponibilityId,startTimeOfDisponibility,endTimeOfDisponibility,State")] Disponibility disponibility) { if (ModelState.IsValid) { //db.Entry(disponibility).State = EntityState.Modified; //db.SaveChanges(); return(RedirectToAction("Index")); } return(View(disponibility)); }
// GET: Disponibilities/Details/5 public ActionResult Details(int id) { Disponibility disponibility = sdis.GetById(id); if (disponibility == null) { return(HttpNotFound()); } return(View(disponibility)); }
public ActionResult Edit([Bind(Include = "IDDisponibility,typeDis,startDate,EndDate,IDinitials")] Disponibility disponibility) { if (ModelState.IsValid) { db.Entry(disponibility).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.IDinitials = new SelectList(db.WorkingDays, "IDinitials", "initials", disponibility.IDinitials); return(View(disponibility)); }
public ActionResult Create([Bind(Include = "DisponibilityId,startTimeOfDisponibility,endTimeOfDisponibility,State")] Disponibility disponibility) { if (ModelState.IsValid) { disponibility.doctor = sdis.GetDisponibilities(); sdis.Add(disponibility); sdis.Commit(); return(RedirectToAction("Index")); } return(View(disponibility)); }
// GET: Disponibilities/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Disponibility disponibility = db.disponibilities.Find(id); if (disponibility == null) { return(HttpNotFound()); } return(View(disponibility)); }
public string Insert(Disponibility disponibility) { int result; try { using (var context = new ProyectoMaestriaEntities()) { var repetido = context.Disponibility.SingleOrDefault(x => x.ID == disponibility.ID); if (repetido == null) { var std = new Disponibility() { // public Nullable<long> IDProvider { get; set; } //public long ID { get; set; } //public Nullable<long> IDProduct { get; set; } //public Nullable<int> Quantity { get; set; } //public Nullable<decimal> UnitValue { get; set; } //public Nullable<System.DateTime> ExpirationDate { get; set; } // ID = comedor.ID, IDProduct = disponibility.IDProduct, IDProvider = disponibility.IDProvider, Quantity = disponibility.Quantity, UnitValue = disponibility.UnitValue, ExpirationDate = disponibility.ExpirationDate }; context.Disponibility.Add(std); result = context.SaveChanges(); if (result == 0) { return("no se ha podido ingresar el registro"); } else { return(std.ID.ToString()); } } else { return("el registro ya se encuentra en la base de datos"); } } } catch (Exception e) { return(e.Message); } }
// GET: Disponibilities/Delete/5 public ActionResult Delete(int id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Disponibility disponibility = sdis.GetById(id); if (disponibility == null) { return(HttpNotFound()); } return(View(disponibility)); }
// GET: Disponibilities/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Disponibility disponibility = db.disponibilities.Find(id); if (disponibility == null) { return(HttpNotFound()); } ViewBag.IDinitials = new SelectList(db.WorkingDays, "IDinitials", "initials", disponibility.IDinitials); return(View(disponibility)); }
public ActionResult ViewDispo(String id) { IList <Disponibility> lcm = new List <Disponibility>(); foreach (var item in sd.geDispoByDoctorId(id)) { Disponibility cm = new Disponibility(); cm.Description = item.Description; cm.StartDate = item.StartDate; cm.EndDate = item.EndDate; cm.Doctor = item.Doctor; lcm.Add(cm); } return(Json(lcm)); }
public static List <Disponibility> plannningHours(List <DateTime> periods, int professionalId, TimeSpan startHour, TimeSpan endHour) { List <Disponibility> disponibilities = new List <Disponibility>(); foreach (var p in periods) { for (int i = startHour.Hours; i < endHour.Hours; i++) { var disponibility = new Disponibility { professionalId = professionalId, startHour = p + (new TimeSpan(i, 0, 0)), EndHour = p + (new TimeSpan(i + 1, 0, 0)), reserved = false, }; disponibilities.Add(disponibility); } } return(disponibilities); }
public string Update(Disponibility disponibility) { int modify = 0; try { using (var context = new ProyectoMaestriaEntities()) { var result = context.Disponibility.SingleOrDefault(b => b.ID == disponibility.ID); if (result != null) { result.IDProvider = disponibility.IDProvider; result.Quantity = disponibility.Quantity; result.UnitValue = disponibility.UnitValue; result.IDProduct = disponibility.IDProduct; result.ExpirationDate = disponibility.ExpirationDate; modify = context.SaveChanges(); if (modify == 0) { return("no se ha podido modificar el registro"); } else { return("se ha modificado el registro satisfactoriamente"); } } else { return("no se ha encontrado coincidencia en la base de datos"); } } } catch (Exception e) { return(e.Message); } }
static void Main(string[] args) { PiContext ctx = new PiContext(); /* User u = new User { Email = "*****@*****.**", * Password= "******", * adress = "1 rue de sfax", * UserName="******", * gender=Gender. * female, * lastName="Garouachi", * birthDate=DateTime.Now};*/ // ctx.Users.Add(u); // ctx.SaveChanges(); Disponibility dispo = new Disponibility { startTimeOfDisponibility = DateTime.Now, endTimeOfDisponibility = DateTime.Now }; List <Disponibility> disponibilities = new List <Disponibility>(); disponibilities.Add(dispo); Address DocAdd = new Address { country = "France", city = "paris", Street = "Montrouge" }; User doctor1 = new Doctor { firstName = "malek", lastName = "malek", PhoneNumber = "99574476", disponibilities = disponibilities, Email = "*****@*****.**", address = DocAdd }; User patient1 = new Patient { firstName = "malek1", lastName = "malek1", PhoneNumber = "99574476", Email = "*****@*****.**", address = DocAdd }; Appointment apointment = new Appointment { state = State.accepted, doctor = doctor1, patient = patient1, appointementDate = DateTime.Now, reason = "rassi youja3 fiya" }; }
public ActionResult Create(AppointmentModel AM, int id) { if (Global.appointmentToEditId == 0) { Doctor dr = sap.GetDoctor(Global.globalIdDoctor); User u = sap.GetCrrentUserById(User.Identity.GetUserId()); Disponibility d = sap.GetDisponibilityById(id); Appointment a = new Appointment() { appointementDate = d.startTimeOfDisponibility, reason = AM.appointement.reason, state = State.accepted, patient = u, doctor = dr }; sap.Add(a); sap.Commit(); var message = new MailMessage("*****@*****.**", dr.Email); //message.From=new MailAddress("*****@*****.**"); //message.From = new MailAddress("*****@*****.**"); message.Subject = "Nouveau rendez-vous"; message.Body = "Bonsoir Dr." + dr.firstName + " " + dr.lastName + " , je vous informe que je serais au rendez-vous pour le " + d.startTimeOfDisponibility + " Cordialement" + u.lastName + " " + u.firstName; System.Net.Mail.SmtpClient SC = new System.Net.Mail.SmtpClient("smtp.gmail.com"); SC.Port = 587; SC.DeliveryMethod = SmtpDeliveryMethod.Network; SC.UseDefaultCredentials = false; SC.Credentials = new NetworkCredential("*****@*****.**", "pidev-123456789"); SC.EnableSsl = true; SC.Timeout = 20000; message.Priority = MailPriority.High; try { SC.Send(message); } catch (Exception e) { Console.WriteLine(e.Message); Console.ReadKey(); } } else { Doctor dr = sap.GetDoctor(Global.globalIdDoctor); User u = sap.GetCrrentUserById(User.Identity.GetUserId()); Disponibility d = sap.GetDisponibilityById(id); Appointment a = sap.GetById(Global.appointmentToEditId); a.reason = AM.appointement.reason; a.appointementDate = d.startTimeOfDisponibility; sap.Update(a); sap.Commit(); var message = new MailMessage("*****@*****.**", dr.Email); //message.From=new MailAddress("*****@*****.**"); //message.From = new MailAddress("*****@*****.**"); message.Subject = "Nouveau rendez-vous"; message.Body = "Bonsoir Dr." + dr.firstName + " " + dr.lastName + " , je vous informe que mon rendez-vous est mis à jours pour le " + d.startTimeOfDisponibility + " Cordialement" + u.lastName + " " + u.firstName; System.Net.Mail.SmtpClient SC = new System.Net.Mail.SmtpClient("smtp.gmail.com"); SC.Port = 587; SC.DeliveryMethod = SmtpDeliveryMethod.Network; SC.UseDefaultCredentials = false; SC.Credentials = new NetworkCredential("*****@*****.**", "pidev-123456789"); SC.EnableSsl = true; SC.Timeout = 20000; message.Priority = MailPriority.High; try { SC.Send(message); } catch (Exception e) { Console.WriteLine(e.Message); Console.ReadKey(); } } Global.appointmentToEditId = 0; return(RedirectToAction("Index")); //var message = new MailMessage("*****@*****.**", "*****@*****.**"); ////message.From=new MailAddress("*****@*****.**"); ////message.From = new MailAddress("*****@*****.**"); //message.Subject = "Nouveau rendez-vous"; //message.Body = "Hello"; //System.Net.Mail.SmtpClient SC = new System.Net.Mail.SmtpClient("smtp.gmail.com"); //SC.Port = 587; //SC.DeliveryMethod = SmtpDeliveryMethod.Network; //SC.UseDefaultCredentials = false; //SC.Credentials = new NetworkCredential("*****@*****.**", "pidev-123456789"); //SC.EnableSsl = true; //SC.Timeout = 20000; //message.Priority = MailPriority.High; //try //{ // SC.Send(message); //} //catch (Exception e) //{ // Console.WriteLine(e.Message); // Console.ReadKey(); //} return(View()); }
public string Update(Disponibility product) { LogicBL logicBL = new LogicBL(); return(logicBL.UpdateDisponibility(product)); }
public string Insert(Disponibility disponibility) { LogicBL logicBL = new LogicBL(); return(logicBL.InsertDisponibility(disponibility)); }
public string Update(Disponibility code) { DisponibilityDAL comedordal = new DisponibilityDAL(); return(comedordal.Update(code)); }
public string Insert(Disponibility disponibility) { DisponibilityDAL comedordal = new DisponibilityDAL(); return(comedordal.Insert(disponibility)); }