public AddEdit_ShowForm(SHOWBOOK obj, int TheatreID)
{
InitializeComponent();
if (obj == null)
{
sHOWBOOKBindingSource.DataSource = new SHOWBOOK();
}
else
{
sHOWBOOKBindingSource.DataSource = obj;
model = obj;
model.ThreatreID = TheatreID;
model = db.SHOWBOOKs.Where(x => x.ThreatreID == model.ThreatreID).FirstOrDefault();
// model = db.SHOWBOOKs.Where(y => y.Date == model.Date).FirstOrDefault();
comboBoxTheatreName.Text = obj.TheatreName;
comboBoxMovieName.Text = obj.MovieName;
textBoxHallNo.Text = obj.Hall.ToString();
textBoxPlatinumseats.Text = obj.PlatinumSeat.ToString();
textBoxGoldseats.Text = obj.GoldSeat.ToString();
textBoxSilverseats.Text = obj.SilverSeat.ToString();
buttonSave.Text = "Update";
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
if (buttonSave.Text == "Save")
{
TheatreID = Regex.Match(textBoxTheatreID.Text, @"\d+").Value;
MovieID = Regex.Match(textBoxMovieID.Text, @"\d+").Value;
dateTime = Convert.ToString(TimePicker.Text);
model.MovieName = textBoxMovieName.Text.Trim();
model.TheatreName = textBoxTheatreName.Text.Trim();
model.ThreatreID = Convert.ToInt32(TheatreID.Trim());
model.MovieID = Convert.ToInt32(MovieID.Trim());
model.Hall = Convert.ToInt32(textBoxHallNo.Text.Trim());
model.PlatinumSeat = Convert.ToInt32(textBoxPlatinumseats.Text.Trim());
model.GoldSeat = Convert.ToInt32(textBoxGoldseats.Text.Trim());
model.SilverSeat = Convert.ToInt32(textBoxSilverseats.Text.Trim());
model.Date = Convert.ToDateTime(datePicker.Text.Trim());
model.Time = TimeSpan.Parse(dateTime);
using (DBEntities db = new DBEntities())
{
db.SHOWBOOKs.Add(model);
db.SaveChanges();
}
MessageBox.Show("Your Show details are submitted");
}
else
{
model = db.SHOWBOOKs.Where(x => x.ThreatreID == model.ThreatreID).FirstOrDefault();
// model = db.SHOWBOOKs.Where(y => y.Date == model.Date).FirstOrDefault();
TheatreID = Regex.Match(textBoxTheatreID.Text, @"\d+").Value;
MovieID = Regex.Match(textBoxMovieID.Text, @"\d+").Value;
// dateTime = Convert.ToString(TimePicker.Text);
model.MovieName = comboBoxMovieName.Text.Trim();
model.TheatreName = comboBoxTheatreName.Text.Trim();
model.ThreatreID = Convert.ToInt32(TheatreID.Trim());
model.MovieID = Convert.ToInt32(MovieID.Trim());
model.Hall = Convert.ToInt32(textBoxHallNo.Text.Trim());
model.PlatinumSeat = Convert.ToInt32(textBoxPlatinumseats.Text.Trim());
model.GoldSeat = Convert.ToInt32(textBoxGoldseats.Text.Trim());
model.SilverSeat = Convert.ToInt32(textBoxSilverseats.Text.Trim());
// model.Date = Convert.ToDateTime(datePicker.Text.Trim());
//model.Time = TimeSpan.Parse(dateTime);
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Your SHOW details are Updated");
}
}
private void comboBoxDate_SelectionChangeCommitted(object sender, EventArgs e)
{
SHOWBOOK obj = comboBoxDate.SelectedItem as SHOWBOOK;
if (obj != null)
{
using (DBEntities db = new DBEntities())
{
sHOWBOOKBindingSource.DataSource = db.SHOWBOOKs.Where(p => p.Date == obj.Date).ToList();
}
}
}
private void comboBoxMovie_SelectionChangeCommitted(object sender, EventArgs e)
{
SHOWBOOK obj = comboBoxMovie.SelectedItem as SHOWBOOK;
if (obj != null)
{
using (DBEntities db = new DBEntities())
{
mOVIEBindingSource.DataSource = db.Movies.Where(p => p.MID == obj.MovieID).ToList();
}
}
}
private void MovieUserControl_Load(object sender, EventArgs e)
{
using (DBEntities db = new DBEntities())
{
sHOWBOOKBindingSource.DataSource = db.SHOWBOOKs.ToList();
SHOWBOOK obj = comboBoxMovie.SelectedItem as SHOWBOOK;
if (obj != null)
{
mOVIEBindingSource.DataSource = db.Movies.Where(p => p.MID == obj.MovieID).ToList();
}
}
using (DBEntities db = new DBEntities())
{
sHOWBOOKBindingSource.DataSource = db.SHOWBOOKs.ToList();
SHOWBOOK obj = comboBoxDate.SelectedItem as SHOWBOOK;
if (obj != null)
{
sHOWBOOKBindingSource.DataSource = db.SHOWBOOKs.Where(p => p.Date == obj.Date).ToList();
}
}
}
