private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text == "" || textBox3.Text == "")
{
MessageBox.Show("Введите данные");
return;
}
Prodavets p = new Prodavets();
p.FullName = textBox1.Text;
p.Phone = textBox3.Text;
db.Prodavets.Add(p);
db.SaveChanges();
SystemUsers u = new SystemUsers();
u.IdProdavets = p.idprodavets;
u.Login = textBox2.Text;
u.Password = textBox4.Text;
db.SystemUsers.Add(u);
db.SaveChanges();
MessageBox.Show("Готово. Сохраните логин и пароль: " + u.Login + " " + u.Password);
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
this.Close();
}
}
public bool Register(string username, string password, int clear)
{
string hash = password + "a6s8d";
var konto = new DBKonto()
{
Login = username, Haslo = md5Hash.GetMD5Hash(hash), Salt = "a6s8d", Clear = clear, Class_Haslo = 1, Class = 1, Class_Login = 1, Class_salt = 1
};
ctx.Konto.Add(konto);
ctx.SaveChanges();
int?id = ctx.Konto.Where(c => c.Login.Equals(username)).First().ID;
var kl = new DBKlient()
{
Imie = username, Nazwisko = username, Adres = username + " 11", Class_Adres = 1, Class_Imie = 1, Class_Nazwisko = 1, Class = 1, ID_Konto = id
};
ctx.Klient.Add(kl);
DBPracownik p;
if (clear > 1)
{
p = new DBPracownik()
{
Imie = username, Nazwisko = username, Class_Imie = 1, Class_Nazwisko = 1, Class = 1, ID_Konto = id, Data_zaczecia = DateTime.Now, Class_Data_zaczecia = 1, Stanowisko = "Test", Class_Stanowisko = 1
};
ctx.Pracownik.Add(p);
}
ctx.SaveChanges();
return(true);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
var carNum = dataGridView1.SelectedCells[0].Value;
var id = (dataGridView2.SelectedCells[0].Value).ToString();
var clientId = db.Pokupatel.FirstOrDefault(x => x.FullName == id).idPocupatel;
AppData.Prodaji p = new AppData.Prodaji();
AppData.Prodaji p2 = new AppData.Prodaji();
p.SeleDate = DateTime.Now;
p.CarNum = carNum.ToString();
p.Seller = UserData.prodavets.idprodavets;
p.Buyer = clientId;
var car = db.har_avto.FirstOrDefault(x => x.CarNum == carNum.ToString());
car.Status = "Продан";
db.Prodaji.Add(p);
db.SaveChanges();
initCars();
MessageBox.Show("Автомобиль " + carNum.ToString() + " продан клиенту " + db.Pokupatel.FirstOrDefault(x => x.FullName == id).FullName);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
//[HttpPost]
//public string BuyBook(Order order)
//{
// order.Date = DateTime.Now;
// db.Orders.Add(order);
// db.SaveChanges();
// return "Спасибо," + order.Person + "за покупку!";
//}
public ActionResult BuyBook(int id)
{
Book b = db.Books.Find(id);
if (b != null)
{
var UserId = int.Parse(User.Identity.Name);
b.UserId = UserId;
db.SaveChanges();
db.Orders.Add(new Order {
UserId = UserId, BookId = b.Id, Date = DateTime.Now, BookName = b.Name
});
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public bool InsertarUsuario(TUsuario usuario)
{
bool result = false;
using (DataBaseModel context = new DataBaseModel())
{
context.TUsuario.Add(usuario);
context.SaveChanges();
}
return(result);
}
public void AddUser(User user)
{
using (DataBaseModel context = new DataBaseModel())
{
context.Set <UserDataModel>()
.Add(new UserDataModel()
{
Username = user.Username, Email = user.Email, Password = user.Password, FullName = user.Fullname
});
context.SaveChanges();
}
}
public static void ChangeSettings(int userId, SettingModel model)
{
using (var db = new DataBaseModel())
{
var user = db.Users.FirstOrDefault(u => u.Id == userId);
if (user.Password != model.Password)
{
throw new SettingsException("Password not match");
}
user.Password = model.NewPassword;
db.SaveChanges();
}
}
//TODO: for now this only saves the changed item to ItemDataModels table
//nothing is written for categorizations.
//Once categoraziation is sorted out need to add extra logic
public void UpdateItem(Item UpdatedItem)
{
using (DataBaseModel context = new DataBaseModel())
{
var itemToUpdate = context.Set <ItemDataModel>()
.FirstOrDefault(x => x.ItemId == UpdatedItem.ItemId);
//TODO: I believe this can be written in more SOLID style
//Using explicit/implicit type conversion operators
//Didn't have the time to research this
itemToUpdate.Name = UpdatedItem.Name;
itemToUpdate.Category = UpdatedItem.Category;
itemToUpdate.Price = UpdatedItem.Price;
context.SaveChanges();
}
}
public static void BuyBook(int UserId, int BookId)
{
using (var context = new DataBaseModel())
{
var order = new Order
{
BookId = BookId,
UserId = UserId,
Date = DateTime.Now
};
context.Orders.Add(order);
context.SaveChanges();
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
Regex r = new Regex(@"[АВЕКМНОРСТУХABEKMHOPCTYX]\d{3}[АВЕКМНОРСТУХABEKMHOPCTYX]{2}\d{2,3}$");
if (!r.IsMatch(textBox1.Text))
{
MessageBox.Show("Введите корректный номер авто");
return;
}
if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" ||
textBox5.Text == "" || textBox8.Text == "" || textBox9.Text == "" || textBox11.Text == "" ||
textBox6.Text == "" || textBox7.Text == "" || textBox10.Text == "")
{
MessageBox.Show("Введите все данные");
return;
}
har_avto a = new har_avto();
a.CarNum = textBox1.Text;
a.Price = Decimal.Parse(textBox2.Text);
a.Mileage = Convert.ToInt32(textBox3.Text);
a.Color = textBox4.Text;
a.Firm = textBox5.Text;
a.Model = textBox6.Text;
a.FuelType = textBox7.Text;
a.Power = Convert.ToInt32(textBox8.Text);
a.EngineVolume = Decimal.Parse(textBox9.Text);
a.Year = Convert.ToInt32(textBox10.Text);
a.Country = textBox11.Text;
a.Description = richTextBox1.Text;
a.CarImg = imgByte;
db.har_avto.Add(a);
db.SaveChanges();
this.DialogResult = DialogResult.OK;
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (CheckNames(LastName.Text, FirstName.Text, MiddleName.Text) & CheckEmail(Email.Text) & CheckPassword(Password.Text))
{
AutentnData data = new AutentnData()
{
Email = Email.Text, Password = Password.Text
};
db.UserInfoes.Add(new UserInfo
{
LName = LastName.Text,
FName = FirstName.Text,
MName = MiddleName.Text,
AutentnData = data
});
db.SaveChanges();
Hide();
}
}
public LoginSession CreateNewSession(User user)
{
using (DataBaseModel context = new DataBaseModel())
{
var userDataModel = context.Set <UserDataModel>()
.FirstOrDefault(x => x.Username == user.Username);
var loginSessionDataModel = context.Set <LoginSessionDataModel>()
.Add(new LoginSessionDataModel()
{
SessionID = Guid.NewGuid(),
User = userDataModel
});
context.SaveChanges();
return(new LoginSession()
{
SessionID = loginSessionDataModel.SessionID,
Username = userDataModel.Username
});
}
}
public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
User user = null;
using (var db = new DataBaseModel())
{
user = db.Users.FirstOrDefault(u => u.Name == model.Name);
}
if (user == null)
{
// создаем нового пользователя
using (var db = new DataBaseModel())
{
db.Users.Add(new User {
Name = model.Name, Email = model.Email, Password = model.Password
});
db.SaveChanges();
user = db.Users.Where(u => u.Name == model.Name && u.Password == model.Password).FirstOrDefault();
}
// если пользователь удачно добавлен в бд
if (user != null)
{
FormsAuthentication.SetAuthCookie(user.Id.ToString(), true);
return(RedirectToAction("Index", "Home"));
}
}
else
{
ModelState.AddModelError("", "Пользователь с таким логином уже существует");
}
}
return(View(model));
}
public int AddItems(IEnumerable <Item> items, Shop shop, string username)
{
using (DataBaseModel context = new DataBaseModel())
{
ShopDataModel shopDataModel = context.Set <ShopDataModel>()
.Select(x => x)
.Where(x => x.Name == shop.Name && x.Location == shop.Location)
.FirstOrDefault() ?? new ShopDataModel()
{
Location = shop.Location, Name = shop.Name
};
UserDataModel userDataModel = context.Set <UserDataModel>()
.Select(x => x).Where(x => x.Username == username).FirstOrDefault();
if (userDataModel == null)
{
throw new System.Exception(Properties.Resources.UserNotFound);
}
ReceiptDataModel receiptDataModel = new ReceiptDataModel()
{
Shop = shopDataModel, User = userDataModel, Total = 0
};
receiptDataModel.Items = new List <ItemDataModel>();
foreach (Item item in items)
{
receiptDataModel.Items.Add(new ItemDataModel()
{
Receipt = receiptDataModel, Price = item.Price, Name = item.Name, Category = item.Category
});
receiptDataModel.Total += item.Price;
}
context.Set <ReceiptDataModel>().Add(receiptDataModel);
context.SaveChanges();
return(receiptDataModel.ReceiptId);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "")
{
MessageBox.Show("Введите данные");
return;
}
Pokupatel p = new Pokupatel();
p.FullName = textBox1.Text;
p.Address = textBox2.Text;
p.Phone = textBox3.Text;
db.Pokupatel.Add(p);
db.SaveChanges();
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
this.Close();
}
}
public ActionResult newBook(NewBookModel model)
{
var UserId = int.Parse(User.Identity.Name);
if (ModelState.IsValid)
{
Book book = null;
//using (var db = new DataBaseModel())
//{
// book = db.Books.FirstOrDefault(u => u.Name == model.Name);
//}
//if (book == null)
//{
// создаем новую книгу
using (var db = new DataBaseModel())
{
db.Books.Add(new Book {
Name = model.Name, Autor = model.Autor, Price = model.Price, UserId = UserId
});
db.SaveChanges();
}
// если пользователь удачно добавлен в бд
//if (book != null)
//{
return(RedirectToAction("Buy", "Home"));
//}
//}
//else
//{
// ModelState.AddModelError("", "Такая книга уже существует");
//}
}
return(View(model));
}
