private void updateDataBase(int rowNumber)
{
string connectionString = ConfigurationManager.ConnectionStrings["DbOrdersConnectionString"].ToString();
MapDbOrdersDataContext dataContext = new MapDbOrdersDataContext(connectionString);
int invoiceID = dataContext.Invoices.Where(x => x.Code == (string)Session["code"]).Select(y => y.InvoiceID).First();
//var record = dataContext.InvoiceLines.Where(x => x.InvoiceID == invoiceID &&
// x.DateOfEvent == Convert.ToDateTime(GvOrders.Rows[rowNumber].Cells[0]) &&
// x.Row == Convert.ToInt32(GvOrders.Rows[rowNumber].Cells[2]) &&
// x.Number == Convert.ToInt32(GvOrders.Rows[rowNumber].Cells[3]) &&
// x.Title == GvOrders.Rows[rowNumber].Cells[1].ToString()).First();
if (Convert.ToDateTime(orders.Rows[rowNumber][0]).AddDays(10) < DateTime.Now)
{
var record = dataContext.InvoiceLines.Where(x => x.InvoiceID == invoiceID &&
x.DateOfEvent == Convert.ToDateTime(orders.Rows[rowNumber][0]) &&
x.Row == Convert.ToInt32(orders.Rows[rowNumber][2]) &&
x.Number == Convert.ToInt32(orders.Rows[rowNumber][3]) &&
x.Title == orders.Rows[rowNumber][1].ToString()).First();
switch (record.Organizer)
{
case "Ballet":
WsBallet.Service1 wsBallet = new WsBallet.Service1();
string result = wsBallet.CancelReservation(Convert.ToDateTime(orders.Rows[rowNumber][0]),
orders.Rows[rowNumber][1].ToString(),
Convert.ToInt32(orders.Rows[rowNumber][2]),
Convert.ToInt32(orders.Rows[rowNumber][3]));
// Maybe some information occured any problems...?
break;
case "Opera":
WsOpera.Service1 wsOpera = new WsOpera.Service1();
string result2 = wsOpera.CancelReservation(Convert.ToDateTime(orders.Rows[rowNumber][0]),
orders.Rows[rowNumber][1].ToString(),
Convert.ToInt32(orders.Rows[rowNumber][2]),
Convert.ToInt32(orders.Rows[rowNumber][3]));
// Maybe some information occured any problems...?
// Mark certain seat as available.
break;
case "Theatre":
WsSmallTheatre.Service1 wsTheatre = new WsSmallTheatre.Service1();
string result3 = wsTheatre.CancelReservation(Convert.ToDateTime(orders.Rows[rowNumber][0]),
orders.Rows[rowNumber][1].ToString(),
Convert.ToInt32(orders.Rows[rowNumber][2]),
Convert.ToInt32(orders.Rows[rowNumber][3]));
// Maybe some information occured any problems...?
break;
}
dataContext.InvoiceLines.DeleteOnSubmit(record);
dataContext.SubmitChanges();
Response.Redirect("CancelOrder.aspx");
}
else
{
LbInfo.Text = "This reservation cannot be canceled.";
LbInfo.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["buying"] != null)
{
Session["ShoppingCart"] = null;
}
DateTime date;
if (Session["date"] == null)
{
date = DateTime.Now;
Session["date"] = date;
}
else
date = Convert.ToDateTime(Session["date"]);
LbHeader.Text = "Entertainments in " + date.ToString("MMMM");
WsBallet.Service1 wsBallet = new WsBallet.Service1();
WsOpera.Service1 wsOpera = new WsOpera.Service1();
WsSmallTheatre.Service1 wsTheatre = new WsSmallTheatre.Service1();
DataRow singleEvent;
DataTable DtSchedule = new DataTable();
DtSchedule.Columns.Add("Org");
DtSchedule.Columns.Add("Title");
DtSchedule.Columns.Add("Date", System.Type.GetType("System.DateTime"));
DtSchedule.Columns.Add("Runtime", System.Type.GetType("System.Int32"));
DtSchedule.Columns.Add("OpenSeats", System.Type.GetType("System.Int32"));
var scheduleBallet = wsBallet.GetScheduleForAMonth(date);
if (scheduleBallet != null)
{
for (int i = 0; i < scheduleBallet.Length / 4; i++)
{
int y = i * 4;
singleEvent = DtSchedule.NewRow();
singleEvent[0] = "Ballet";
singleEvent[1] = scheduleBallet[y];
singleEvent[2] = Convert.ToDateTime(scheduleBallet[y + 1]);
singleEvent[3] = Convert.ToInt32(scheduleBallet[y + 2]);
singleEvent[4] = Convert.ToInt32(scheduleBallet[y + 3]);
DtSchedule.Rows.Add(singleEvent);
}
}
var scheduleOpera = wsOpera.GetScheduleForAMonth(date);
if (scheduleOpera != null)
{
for (int i = 0; i < scheduleOpera.Length / 4; i++)
{
int y = i * 4;
singleEvent = DtSchedule.NewRow();
singleEvent[0] = "Opera";
singleEvent[1] = scheduleOpera[y];
singleEvent[2] = Convert.ToDateTime(scheduleOpera[y + 1]);
singleEvent[3] = Convert.ToInt32(scheduleOpera[y + 2]);
singleEvent[4] = Convert.ToInt32(scheduleOpera[y + 3]);
DtSchedule.Rows.Add(singleEvent);
}
}
var scheduleTheatre = wsTheatre.GetScheduleForAMonth(date);
if (scheduleTheatre != null)
{
for (int i = 0; i < scheduleTheatre.Length / 4; i++)
{
int y = i * 4;
singleEvent = DtSchedule.NewRow();
singleEvent[0] = "Theatre";
singleEvent[1] = scheduleTheatre[y];
singleEvent[2] = Convert.ToDateTime(scheduleTheatre[y + 1]);
singleEvent[3] = Convert.ToInt32(scheduleTheatre[y + 2]);
singleEvent[4] = Convert.ToInt32(scheduleTheatre[y + 3]);
DtSchedule.Rows.Add(singleEvent);
}
}
DataTable EarliestEvents = Get3EarliestEvents(DtSchedule);
GvEntertainments.DataSource = EarliestEvents;
GvEntertainments.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["buying"] != null)
{
Session["ShoppingCart"] = null;
}
DateTime date;
if (Session["date"] == null)
{
date = DateTime.Now;
Session["date"] = date;
}
else
{
if (Session["stage"] != null)
{
if (Session["stage"].Equals("Ballet"))
date = Convert.ToDateTime(Session["date"]);
else
{
date = DateTime.Now;
Session["date"] = date;
}
}
else
{
date = DateTime.Now;
Session["date"] = date;
}
}
LbHeader.Text = "Repertoire for the ballet in " + date.ToString("MMMM");
WsBallet.Service1 wsBallet = new WsBallet.Service1();
WsOpera.Service1 wsOpera = new WsOpera.Service1();
WsSmallTheatre.Service1 wsTheatre = new WsSmallTheatre.Service1();
DataRow singleEvent;
DataTable DtSchedule = new DataTable();
DtSchedule.Columns.Add("Title");
DtSchedule.Columns.Add("Date", System.Type.GetType("System.DateTime"));
DtSchedule.Columns.Add("Runtime", System.Type.GetType("System.Int32"));
DtSchedule.Columns.Add("OpenSeats", System.Type.GetType("System.Int32"));
var scheduleBallet = wsBallet.GetScheduleForAMonth(date);
if (scheduleBallet != null)
{
for (int i = 0; i < scheduleBallet.Length / 4; i++)
{
int y = i * 4;
singleEvent = DtSchedule.NewRow();
singleEvent[0] = scheduleBallet[y];
singleEvent[1] = Convert.ToDateTime(scheduleBallet[y + 1]);
singleEvent[2] = Convert.ToInt32(scheduleBallet[y + 2]);
singleEvent[3] = Convert.ToInt32(scheduleBallet[y + 3]);
DtSchedule.Rows.Add(singleEvent);
}
}
GvEntBallet.DataSource = DtSchedule;
GvEntBallet.DataBind();
}