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