protected void Button1_Click(object sender, EventArgs e)
{
string movName = txtMovie.Text;
string sesName = txtSession.Text;
int sesDuration = Convert.ToInt32(txtDuration.Text);
CineKalyoncuDatabaseDataContext db = new CineKalyoncuDatabaseDataContext();
MOVIE d = new MOVIE();
MOVIE existingMovie = (from x in db.MOVIEs where x.Name == movName && x.Session_1 == sesName && x.Duration == sesDuration && x.Approve == true select x).SingleOrDefault();
if (existingMovie == null)
{
d.Name = movName;
d.Session_1 = sesName;
d.Duration = sesDuration;
d.Approve = true;
db.MOVIEs.InsertOnSubmit(d);
db.SubmitChanges();
lblMsg.Visible = true;
lblMsg.Text = "Movie Has Added Successfully";
}
else
{
lblMsg.Visible = true;
lblMsg.Text = "Movie Already Exist";
txtMovie.Text = "";
}
Session["MovieName"] = txtMovie.Text;
Session["Sesname"] = txtSession.Text;
Session["Duration"] = txtDuration.Text;
}
protected void Button1_Click(object sender, EventArgs e)
{
CineKalyoncuDatabaseDataContext db = new CineKalyoncuDatabaseDataContext();
string emailText = txtEmail.Text;
CUSTOMER existingUSER = (from x in db.CUSTOMERs where x.Email == emailText select x).SingleOrDefault();
if (existingUSER == null)
{
CUSTOMER us = new CUSTOMER();
us.Name = txtName.Text;
us.Surname = txtSurname.Text;
us.Email = txtEmail.Text;
us.Password = txtPassword.Text;
us.Approve = true;
db.CUSTOMERs.InsertOnSubmit(us);
db.SubmitChanges();
ErrorLabel.Visible = true;
ErrorLabel.Text = "Your Registered is Succesfully Created!";
ClearTextBoxes();
}
else
{
ErrorLabel.Visible = true;
ErrorLabel.Text = "Email already used!";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string email = txtEmail.Text;
string password = txtPassword.Text;
CineKalyoncuDatabaseDataContext db = new CineKalyoncuDatabaseDataContext();
CUSTOMER isCustomer = (from x in db.CUSTOMERs where x.Email == email && x.Password == password && x.Approve == true select x).SingleOrDefault();
if (isCustomer != null)
{
Session["EnteredCustomer"] = isCustomer;
Response.Redirect("CustomerHomePage.aspx");
}
WORKER isWorker = (from x in db.WORKERs where x.Email == email && x.Password == password && x.Approve == true select x).SingleOrDefault();
if (isWorker != null)
{
Session["EnteredWorker"] = isWorker;
Response.Redirect("WorkerHomepage.aspx");
}
else
{
lblMessage.Visible = true;
lblMessage.Text = "Please Check your Email or Password!";
}
}
protected void Page_Load(object sender, EventArgs e)
{
CineKalyoncuDatabaseDataContext db = new CineKalyoncuDatabaseDataContext();
ddlUsername.Items.Add("Select a Username...");
List <CUSTOMER> depCustomer = (from x in db.CUSTOMERs where x.Approve == true select x).ToList();
for (int i = 0; i < depCustomer.Count; i++)
{
ddlUsername.Items.Add(depCustomer[i].Name);
}
ddlUserSurname.Items.Add("Select a Surname...");
List <CUSTOMER> depCustomerSur = (from x in db.CUSTOMERs where x.Approve == true select x).ToList();
for (int i = 0; i < depCustomerSur.Count; i++)
{
ddlUserSurname.Items.Add(depCustomerSur[i].Surname);
}
ddlMovieName.Items.Add("Select a Movie...");
CineKalyoncuDatabaseDataContext cs = new CineKalyoncuDatabaseDataContext();
List <MOVIE> depMovie = (from x in cs.MOVIEs where x.Approve == true select x).ToList();
for (int i = 0; i < depMovie.Count; i++)
{
ddlMovieName.Items.Add(depMovie[i].Name);
}
ddlRoom.Items.Add("Select a Room...");
List <ROOM> depRoom = (from x in cs.ROOMs where x.Approve == true select x).ToList();
for (int i = 0; i < depRoom.Count; i++)
{
ddlRoom.Items.Add(depRoom[i].Name);
}
ddlChair.Items.Add("Select a Chair...");
List <CHAIR> depChair = (from x in cs.CHAIRs where x.Approve == true select x).ToList();
for (int i = 0; i < depChair.Count; i++)
{
ddlChair.Items.Add(depChair[i].Name);
}
ddlSession.Items.Add("Select a session..");
ddlSession.Items.Add("10.00-13.00");
ddlSession.Items.Add("13.00-16.00");
ddlSession.Items.Add("16.00-19.00");
ddlSession.Items.Add("19.00-22.00");
}
protected void Button1_Click(object sender, EventArgs e)
{
CineKalyoncuDatabaseDataContext db = new CineKalyoncuDatabaseDataContext();
// ddlMovie.Items.Clear();
// ddlSession.Items.Clear();
if (ddlMovie.SelectedIndex == 0 || ddlSession.SelectedIndex == 0)
{
lblMessage.Visible = true;
lblMessage.Text = "please choose";
}
else
{
CUSTOMER c = new CUSTOMER();
TICKET t = new TICKET();
t.Name = ddlMovie.SelectedValue;
t.Session = ddlSession.SelectedValue;
t.Person = txtTicket.Text;
t.Room = ddlRoom.SelectedValue;
t.Chair = ddlChair.SelectedValue;
int prc;
prc = Convert.ToInt32(txtTicket.Text) * 13;
db.TICKETs.InsertOnSubmit(t);
db.SubmitChanges();
lblMessage.Visible = true;
lblMessage.Text = "You take it successfully!";
lblMessagePrice.Visible = true;
lblMessagePrice.Text = prc.ToString() + "TL";
lblmessage1.Visible = true;
}
Session["Movie"] = ddlMovie.SelectedValue;
Session["Session"] = ddlSession.SelectedValue;
Session["Person"] = txtTicket.Text;
Session["Room"] = ddlRoom.SelectedValue;
Session["Chair"] = ddlChair.SelectedValue;
}
protected void Button1_Click(object sender, EventArgs e)
{
CineKalyoncuDatabaseDataContext db = new CineKalyoncuDatabaseDataContext();
// ddlMovie.Items.Clear();
// ddlSession.Items.Clear();
if (ddlMovieName.SelectedIndex == 0 || ddlSession.SelectedIndex == 0 || ddlUsername.SelectedIndex == 0 || ddlUserSurname.SelectedIndex == 0)
{
lblMessage.Visible = true;
lblMessage.Text = "Please Check!";
}
else
{
TICKET t = new TICKET();
t.Name = ddlMovieName.SelectedValue;
t.Session = ddlSession.SelectedValue;
t.Room = ddlRoom.SelectedValue;
t.Chair = ddlChair.SelectedValue;
t.Person = txtPrice.Text;
int prc;
prc = Convert.ToInt32(txtPrice.Text) * 13;
db.TICKETs.InsertOnSubmit(t);
db.SubmitChanges();
lblMessage.Visible = true;
lblMessage.Text = "You sell it successfully!";
}
Session["MOVIENAME"] = ddlMovieName.SelectedValue;
Session["SESSION"] = ddlSession.SelectedValue;
Session["PERSON"] = txtPrice.Text;
Session["USERNAME"] = ddlUsername.SelectedValue;
Session["USERSURNAME"] = ddlUserSurname.SelectedValue;
Session["ROOM"] = ddlRoom.SelectedValue;
Session["CHAIR"] = ddlChair.SelectedValue;
}
