public void Login(string name, int id)
{
user = name;
idUser = id;
EntitiesAutomobiles automobiles = new EntitiesAutomobiles();
Users users = automobiles.Users.Where(x => x.idUser == idUser).FirstOrDefault();
nameToolStripMenuItem.Text = name;
menuStrip1.Visible = true;
btnSignin.Visible = false;
if (users.admin.Value)
{
addBtn.Visible = true;
iconButtonOrders.Visible = true;
iconButtonUsers.Visible = true;
iconRent.Visible = false;
}
else
{
addBtn.Visible = false;
iconButtonOrders.Visible = false;
iconButtonUsers.Visible = false;
iconRent.Visible = true;
}
}
private void iconButtonOrder_Click(object sender, EventArgs e)
{
EntitiesAutomobiles automobiles = new EntitiesAutomobiles();
Orders order = new Orders();
Users users = automobiles.Users.Where(x => x.idUser == idUser).FirstOrDefault();
Automobiles auto = automobiles.Automobiles.Where(x => x.idAuto == idAuto).FirstOrDefault();
order.idAuto = idAuto;
order.idUser = idUser;
order.dateOrder = DateTime.Now;
order.dateStart = dateTimeStart.Value;
order.dateFinish = dateTimeFinish.Value;
int n = 0;
n = (dateTimeFinish.Value - dateTimeStart.Value).Days + 1;
order.cost = automobiles.Automobiles.Where(z => z.idAuto == idAuto).Select(x => x.price).FirstOrDefault() * n;
bool add = false;
DateTime start = DateTime.Now, finish = DateTime.Now;
if (automobiles.Orders.Where(x => x.idAuto == idAuto).Count() == 0)
{
add = true;
}
foreach (Orders ord in automobiles.Orders.Where(x => x.idAuto == idAuto))
{
if ((order.dateStart.Value.Date >= ord.dateStart.Value.Date && order.dateStart.Value.Date <= ord.dateFinish.Value.Date) ||
(order.dateFinish.Value.Date >= ord.dateStart.Value.Date && order.dateFinish.Value.Date <= ord.dateFinish.Value.Date) ||
(ord.dateStart.Value.Date >= order.dateStart.Value.Date && ord.dateStart.Value.Date <= order.dateFinish.Value.Date) ||
(ord.dateFinish.Value.Date >= order.dateStart.Value.Date && ord.dateFinish.Value.Date <= order.dateFinish.Value.Date))
{
start = ord.dateStart.Value.Date;
finish = ord.dateFinish.Value.Date;
add = false;
break;
}
else
{
add = true;
}
}
if (add)
{
labelMessage.ForeColor = Color.GreenYellow;
labelMessage.Text = "Авто забронированно";
automobiles.Orders.Add(order);
}
else
{
labelMessage.ForeColor = Color.Red;
labelMessage.Text = "Автомобиль уже забронирован с " + start.Date.ToString() + " до " + finish.Date.ToString();
}
automobiles.SaveChanges();
}
public void LoadBd(string filtr)
{
listView1.LargeImageList = imageList1;
imageList1.Images.Clear();
listView1.Items.Clear();
// получаем все файлы
//List<string> files = Directory.GetFiles(".\\packages\\Foto", "*" + ".jpg").ToList();
imageList1.ImageSize = new Size(250, 250);
Brands brands = new Brands();
Images images = new Images();
//Automobiles auto = new Automobiles();
// перебор полученных файлов
int i = 0;
EntitiesAutomobiles entitiesAutomobiles = new EntitiesAutomobiles();
foreach (Automobiles auto in entitiesAutomobiles.Automobiles.Where(x => x.Models.classModel == filtr))
{
try
{
imageList1.Images.Add(Image.FromFile(auto.Images.
Where(x => x.idAuto == auto.idAuto)
.Select(x => x.image).FirstOrDefault()));
}
catch
{
MessageBox.Show(
"Файл не открывается",
"Сообщение",
MessageBoxButtons.OK,
MessageBoxIcon.Error,
MessageBoxDefaultButton.Button1);
continue;
}
// установка названия файла
ListViewItem lvi = new ListViewItem();
//lvi.Text = file.Remove(0, file.LastIndexOf('\\') + 1);
lvi.Tag = auto.idAuto;
lvi.Text = auto.Brands.nameBrand + " " + auto.Models.nameModel;
lvi.ImageIndex = i; // установка картинки для файла
i++;
// добавляем элемент в ListView
listView1.Items.Add(lvi);
}
}
private void btnReg_Click(object sender, EventArgs e)
{
Users user = new Users();
user.firstName = textFirstName.Text;
user.secondName = textSecondName.Text;
user.middleName = textMiddleName.Text;
user.email = textMail.Text;
user.login = textLogin.Text;
user.password = textPass.Text;
user.tel = textTel.Text;
user.numberDrivingLicense = textCard.Text;
user.admin = false;
EntitiesAutomobiles automobiles = new EntitiesAutomobiles();
automobiles.Users.Add(user);
automobiles.SaveChanges();
}
private void btnSignIn_Click(object sender, EventArgs e)
{
EntitiesAutomobiles automobiles = new EntitiesAutomobiles();
Users user = automobiles.Users.Where(x => x.login == textLogin.Text && x.password == textPass.Text).FirstOrDefault();
if (user != null)
{
string name = user.firstName + " " + user.secondName;
menu.Login(name, user.idUser);
InfoUser info = new InfoUser();
info.setIdUser(user.idUser);
info.setUserName(name);
this.Dispose();
}
else
{
label1.Visible = true;
}
}
public FormInfoAuto(int idauto, int iduser)
{
InitializeComponent();
automobiles = new EntitiesAutomobiles();
InfoUser info = new InfoUser();
idUser = info.getidUser();
Users user = automobiles.Users.Where(x => x.idUser == idUser).FirstOrDefault();
idAuto = idauto;
if (user.admin.Value)
{
iconButtonOrder.Visible = false;
btnIzm.Visible = true;
labelBrand.ReadOnly = false;
labelModel.ReadOnly = false;
labelYear.ReadOnly = false;
labelPrice.ReadOnly = false;
}
else
{
iconButton1.Visible = false;
iconButton2.Visible = false;
btnIzm.Visible = false;
labelBrand.ReadOnly = true;
labelModel.ReadOnly = true;
labelYear.ReadOnly = true;
labelPrice.ReadOnly = true;
}
auto = automobiles.Automobiles.Where(x => x.idAuto == idAuto).FirstOrDefault();
listView1.LargeImageList = imageList1;
imageList1.ImageSize = new Size(100, 100);
List <string> images = auto.Images.
Where(x => x.idAuto == auto.idAuto)
.Select(x => x.image).ToList();
int j = 0;
foreach (string el in images)
{
try
{
imageList1.Images.Add(Image.FromFile(el));
i++;
}
catch
{
MessageBox.Show(
"Файл не открывается",
"Сообщение",
MessageBoxButtons.OK,
MessageBoxIcon.Error,
MessageBoxDefaultButton.Button1);
}
// установка названия файла
ListViewItem lvi = new ListViewItem();
//lvi.Text = file.Remove(0, file.LastIndexOf('\\') + 1);
lvi.Tag = el;
lvi.ImageIndex = j; // установка картинки для файла
listView1.Items.Add(lvi);
j++;
}
labelBrand.Text = auto.Brands.nameBrand;
labelModel.Text = auto.Models.nameModel;
labelPrice.Text = auto.price.ToString();
labelYear.Text = auto.yearModel.ToString();
pictureBox1.Load(listView1.Items[0].Tag.ToString());
}
private void addBtn_Click(object sender, EventArgs e)
{
EntitiesAutomobiles automobiles = new EntitiesAutomobiles();
string brandN = textBrand.Text;
string modelN = textModel.Text;
string classN = textClass.Text;
string kppN = textKPP.Text;
Automobiles auto = new Automobiles();
auto.price = decimal.Parse(textPrice.Text);
auto.yearModel = Int32.Parse(textYear.Text);
if (brandN != "")
{
Brands brand = automobiles.Brands.Where(x => x.nameBrand == brandN).FirstOrDefault();
if (brand == null)
{
Brands newBrand = new Brands
{
nameBrand = brandN
};
automobiles.Brands.Add(newBrand);
automobiles.SaveChanges();
brand = automobiles.Brands.Where(x => x.nameBrand == brandN).FirstOrDefault();
auto.idBrand = brand.idBrand;
}
else
{
auto.idBrand = brand.idBrand;
}
}
if (modelN != "" && classN != "")
{
Models model = automobiles.Models.Where(x => x.nameModel == modelN && x.classModel == classN).FirstOrDefault();
if (model == null)
{
Models newModel = new Models
{
nameModel = modelN,
classModel = classN
};
automobiles.Models.Add(newModel);
automobiles.SaveChanges();
model = automobiles.Models.Where(x => x.nameModel == modelN && x.classModel == classN).FirstOrDefault();
auto.idModel = model.idModel;
}
else
{
auto.idModel = model.idModel;
}
}
if (kppN != "")
{
KPP kpp = automobiles.KPP.Where(x => x.nameKPP == kppN).FirstOrDefault();
if (kpp == null)
{
KPP newKpp = new KPP
{
nameKPP = kppN
};
automobiles.KPP.Add(newKpp);
automobiles.SaveChanges();
kpp = automobiles.KPP.Where(x => x.nameKPP == kppN).FirstOrDefault();
auto.idKPP = kpp.idKPP;
}
else
{
auto.idKPP = kpp.idKPP;
}
}
automobiles.Automobiles.Add(auto);
automobiles.SaveChanges();
SaveFoto();
auto = automobiles.Automobiles
.Where(x => x.Brands.nameBrand == brandN &&
x.Models.nameModel == modelN &&
x.Models.classModel == classN).FirstOrDefault();
foreach (ListViewItem lvi in listView1.Items)
{
string path = "packages\\Foto\\";
path += lvi.Text + ".jpg";
Images image = new Images();
image.idAuto = auto.idAuto;
image.image = path;
automobiles.Images.Add(image);
}
automobiles.SaveChanges();
}
