public void DeleteReserved(Date date)
{
var y = Login.tempSchedules.Where(pe => pe.SDate == date.date & pe.Meal_Id_Fk == date.meal & pe.Restaurant_Id_Fk == restaurant_id).Select(p => p.Id);
var ew = db.PoonehReservations.Where(p => y.Any(pp => p.Schedule_Id_Fk == pp) & p.Person_Id_Fk == p1.Id).Select(p => p).SingleOrDefault();
if (ew != null)
{
db.PoonehReservations.Remove(ew);
if (System.Net.NetworkInformation.NetworkInterface.GetIsNetworkAvailable())
{
db.SaveChanges();
}
else
{
Alarm frm = new Alarm();
frm.ShowDialog();
this.Close();
}
}
}
private void SetReserve(int food)
{
tableLayoutPanel1.Visible = false;
if (System.Net.NetworkInformation.NetworkInterface.GetIsNetworkAvailable())
{
var x1 = Schedules.ElementAt(0).Id;
var x2 = Schedules.ElementAt(1).Id;
var x3 = Schedules.ElementAt(2).Id;
t = null;
t = (from r in db.PoonehReservations
where r.Person_Id_Fk == _person.Id
where r.Schedule_Id_Fk == x1 || r.Schedule_Id_Fk == x2 || r.Schedule_Id_Fk == x3
select r).SingleOrDefault();
var tReserved = (from r in Form1.Reserved
where r.Schedule_Id_Fk == x1 || r.Schedule_Id_Fk == x2 || r.Schedule_Id_Fk == x3
select r).SingleOrDefault();
if(tReserved !=null)
{
tReserved.Tray_Id_Fk= Schedules.ElementAt(food).Tray_Id_Fk;
tReserved.Schedule_Id_Fk = Schedules.ElementAt(food).Id;
}
if (t != null)
{
t.Tray_Id_Fk = Schedules.ElementAt(food).Tray_Id_Fk;
t.Schedule_Id_Fk = Schedules.ElementAt(food).Id;
int tt = db.SaveChanges();
//MessageBox.Show("رزرو تغیر کرد");
if (loop)
{
j = j + 1;
if (j < AllDays.Count)
ReserveAllDay(AllDays.ElementAt(j));
else
this.Close();
}
else
{
this.Close();
}
}
else
{
PoonehReservation reserv = new PoonehReservation()
{
Tray_Id_Fk = Schedules.ElementAt(food).Tray_Id_Fk,
Person_Id_Fk = _person.Id,
Schedule_Id_Fk = Schedules.ElementAt(food).Id,
Company_Id_Fk = _person.Company_Id_Fk,
Unit_Id_Fk = _person.Unit_Id_Fk,
Restaurant_Id_Fk = Schedules.ElementAt(food).Restaurant_Id_Fk,
Meal_Id_Fk = Schedules.ElementAt(food).Meal_Id_Fk
};
db.PoonehReservations.Add(reserv);
int x = 0;
try
{
x = db.SaveChanges();
Form1.Reserved.Add(reserv);
}
catch (Exception)
{
Alarm frm = new Alarm();
frm.ShowDialog();
this.Close();
}
//int x = 1;
if (x != 0)
{
// MessageBox.Show("رزرو انجام شد");
if (loop)
{
j = j + 1;
if (j < AllDays.Count)
ReserveAllDay(AllDays.ElementAt(j));
else
this.Close();
}
else
{
this.Close();
}
}
else
{
MessageBox.Show("خطا در رزرو");
}
}
}
else
{
Alarm frm = new Alarm();
frm.ShowDialog();
this.Close();
}
}
