public static LTS.Reserve GetReserveItemByID(int?ReserveID) { LTS.Reserve reserve = new LTS.Reserve(); try { using (LTS.LTSBase access = new LTS.LTSDC()) { reserve = access.Reserve.Where(o => o.ResID == ReserveID).FirstOrDefault(); } } catch (Exception ex) { } return(reserve); }
public static int AddReserve(LTS.Reserve reserve) { int?ReserveID = -1; try { using (LTS.LTSBase access = new LTS.LTSDC()) { access.InsertReserve(reserve.CellNo, reserve.Email, reserve.IDno, reserve.Name, reserve.ResDate, reserve.StockID, reserve.Surname, ref ReserveID); } } catch (Exception ex) { } return(ReserveID.Value); }
public static bool UpdateReserve(LTS.Reserve reserve) { bool completed = false; try { using (LTS.LTSBase access = new LTS.LTSDC()) { access.UpdateReserve(reserve.CellNo, reserve.Email, reserve.IDno, reserve.Name, reserve.ResDate, reserve.StockID, reserve.Surname, reserve.ResID); completed = true; } } catch (Exception ex) { completed = false; } return(completed); }
private void button2_Click(object sender, EventArgs e) { label18.Visible = false; richTextBox1.Visible = false; if (Namep.Text == "" || surnameP.Text == "" || PID.Text == "" || cell.Text == "" || mail.Text == "") { label18.Visible = true; richTextBox1.Visible = true; } else { ///////////////////////CHECKS////////////////// bool isEmail = Regex.IsMatch(mail.Text, @"\A(?:[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?)\Z", RegexOptions.IgnoreCase); bool isCell = Regex.IsMatch(cell.Text, @"^(?:\+?1[-. ]?)?\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$"); bool name = Regex.IsMatch(Namep.Text, @"^[a-zA-Z ]+$"); bool sName = Regex.IsMatch(surnameP.Text, @"^[a-zA-Z ]+$"); IdentityNumber id = new IdentityNumber(PID.Text); bool IDVALID = id.IsValid; //////////////////////CHECKS////////////////// if (!isEmail || !isCell || !name || !sName || !IDVALID) { label18.Visible = true; richTextBox1.Visible = true; } else { int stockID; using (DataGridViewRow item = this.dataGridView1.SelectedRows[0]) { int i = item.Index; string oldVIN = dataGridView1.Rows[i].Cells[0].Value.ToString(); stockID = DAT.DataAccess.GetStock().Where(o => o.VIN == oldVIN).FirstOrDefault().StockID; } try { LTS.Reserve res = new LTS.Reserve(); res.ResID = DAT.DataAccess.GetReserve().Where(o => o.StockID == stockID).FirstOrDefault().ResID; res.StockID = stockID; res.Name = Namep.Text; res.Surname = surnameP.Text; res.IDno = PID.Text; res.CellNo = cell.Text; res.Email = mail.Text; res.ResDate = DAT.DataAccess.GetReserve().Where(o => o.StockID == stockID).FirstOrDefault().ResDate; bool updated = DAT.DataAccess.UpdateReserve(res); if (updated) { if (DialogResult.OK == MessageBox.Show("Reservation edited successfully!")) { ((Form1)this.Parent.Parent).ChangeView <ReserveA>(); } } else { if (DialogResult.OK == MessageBox.Show("Sorry something went wrong, the Reservation was not edited successfully!")) { ((Form1)this.Parent.Parent).ChangeView <ReserveA>(); } } } catch (Exception ex) { label18.Visible = true; richTextBox1.Visible = true; } } } }
private void button2_Click(object sender, EventArgs e) { label17.Visible = false; richTextBox1.Visible = false; if (VID.SelectedItem == null || email.Text == "" || cell.Text == "" || PID.Text == "" || Surname.Text == "" || Pname.Text == "") { label17.Visible = true; richTextBox1.Visible = true; } else { ///////////////////////CHECKS////////////////// bool isEmail = Regex.IsMatch(email.Text, @"\A(?:[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?)\Z", RegexOptions.IgnoreCase); bool isCell = Regex.IsMatch(cell.Text, @"^(?:\+?1[-. ]?)?\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$"); bool name = Regex.IsMatch(Pname.Text, @"^[a-zA-Z ]+$"); bool sName = Regex.IsMatch(Surname.Text, @"^[a-zA-Z ]+$"); IdentityNumber id = new IdentityNumber(PID.Text); bool IDVALID = id.IsValid; //////////////////////CHECKS////////////////// if (!isEmail || !isCell || !name || !sName || !IDVALID) { label17.Visible = true; richTextBox1.Visible = true; } else { LTS.Reserve r = new LTS.Reserve(); r.StockID = DAT.DataAccess.GetStock().Where(i => i.VIN == VID.SelectedItem.ToString()).FirstOrDefault().StockID; r.Name = Pname.Text; r.Surname = Surname.Text; r.IDno = PID.Text; r.CellNo = cell.Text; r.Email = email.Text; r.ResDate = DateTime.Now; int RID = DAT.DataAccess.AddReserve(r); int stockID; string status; string oldVIN = VID.SelectedItem.ToString(); stockID = DAT.DataAccess.GetStock().Where(i => i.VIN == VID.SelectedItem.ToString()).FirstOrDefault().StockID; try { LTS.Stock newStock = new LTS.Stock(); newStock.StockID = stockID; newStock.Make = DAT.DataAccess.GetStock().Where(i => i.StockID == stockID).FirstOrDefault().Make; newStock.Model = DAT.DataAccess.GetStock().Where(i => i.StockID == stockID).FirstOrDefault().Model; newStock.Price = DAT.DataAccess.GetStock().Where(i => i.StockID == stockID).FirstOrDefault().Price; newStock.VehicleStatus = "Reserved"; newStock.VehicleYear = DAT.DataAccess.GetStock().Where(i => i.StockID == stockID).FirstOrDefault().VehicleYear; newStock.VIN = DAT.DataAccess.GetStock().Where(i => i.StockID == stockID).FirstOrDefault().VIN; bool updated = DAT.DataAccess.UpdateStock(newStock); if (RID > 0 && updated == true) { if (DialogResult.OK == MessageBox.Show("The Reservation was made successfully!")) { ((Form1)this.Parent.Parent).ChangeView <Reserve1>(); } else { if (DialogResult.OK == MessageBox.Show("Sorry something went wrong, the Reservation was not made!")) { ((Form1)this.Parent.Parent).ChangeView <Reserve1>(); } } } } catch (Exception ex) { label17.Visible = true; richTextBox1.Visible = true; } } } }