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;
}
}
}
}
