public static Theme ThemeChoseMenu()
{
do
{
try
{
TableDataService <Theme> dataServiceForThemes = new TableDataService <Theme>();
var themes = dataServiceForThemes.GetAll();
Console.WriteLine("Chose news theme");
for (int i = 0; i < themes.Count; i++)
{
Console.WriteLine($"{i + 1} {themes[i].Name}");
}
int themeIndex;
if (int.TryParse(Console.ReadLine().Trim(), out themeIndex))
{
return(themes[themeIndex - 1]);
}
throw new ArgumentException("Number was wrote incorrect");
}
catch (ArgumentException exception)
{
Console.WriteLine(exception.Message);
}
} while (true);
}
public static bool Enter(User currentUser)
{
List <User> users;
using (TableDataService <User> dataService = new TableDataService <User>())
{
users = dataService.GetAll();
}
string login = SetInformation.SetLogin();
string password = SetInformation.SetPassword();
foreach (User user in users)
{
if (user.Login == login && user.Password == password)
{
currentUser.Id = user.Id;
currentUser.Login = user.Login;
currentUser.Password = user.Password;
currentUser.Phone = user.Phone;
currentUser.Email = user.Email;
return(true);
}
}
return(false);
}
public Form1()
{
InitializeComponent();
dataGridView1.Columns.Add("Id", "Id");
dataGridView1.Columns.Add("Login", "Login");
dataGridView1.Columns.Add("Password", "Password");
dataGridView1.Columns.Add("Address", "Address");
dataGridView1.Columns.Add("PhoneNumber", "PhoneNumber");
dataGridView1.Columns.Add("IsAdmin", "IsAdmin");
using (TableDataService <User> dataService = new TableDataService <User>())
{
var users = dataService.GetAll();
List <string> usersLogin = new List <string>();
for (int i = 0; i < users.Count; i++)
{
usersLogin.Add(users[i].Login);
}
listBox1.DataSource = usersLogin;
}
}
private void AdminFilter()
{
if (checkBox1.Checked)
{
listBox1.Items.Clear();
using (TableDataService <User> dataService = new TableDataService <User>())
{
var users = dataService.GetAll();
for (int i = 0; i < users.Count; i++)
{
if (users[i].IsAdmin)
{
listBox1.Items.Add(users[i].Login);
}
}
}
}
else
{
listBox1.Items.Clear();
using (TableDataService <User> dataService = new TableDataService <User>())
{
var users = dataService.GetAll();
for (int i = 0; i < users.Count; i++)
{
listBox1.Items.Add(users[i].Login);
}
}
}
}
public static int SetGroup()
{
do
{
try
{
Console.WriteLine("Выберите группу:");
TableDataService <Group> dataService = new TableDataService <Group>();
dataService.GetAll().ForEach(f => Console.WriteLine($"{f.Id}) {f.Name}"));
int groupId;
if (int.TryParse(Console.ReadLine().Trim(), out groupId))
{
return(groupId);
}
throw new ArgumentException("Число было введено неверно");
}
catch (ArgumentException exception)
{
Console.WriteLine(exception.Message);
}
} while (true);
}
public static void UpdateStreet(Guid streetId, StreetProperties property)
{
if (streetId != Guid.Empty)
{
switch (property)
{
case StreetProperties.Name:
string newName = SetInformations.SetName();
using (var dataService = new TableDataService <Street>())
{
var chosenStreet = dataService.GetAll().Where(street => street.Id == streetId).SingleOrDefault();
dataService.DeleteById(streetId);
chosenStreet.Name = newName;
dataService.Add(chosenStreet);
}
break;
case StreetProperties.CityId:
Guid newCityId = SetInformations.SetCityId();
if (newCityId != Guid.Empty)
{
using (var dataService = new TableDataService <Street>())
{
var chosenStreet = dataService.GetAll().Where(street => street.Id == streetId).SingleOrDefault();
dataService.DeleteById(streetId);
chosenStreet.CityId = newCityId;
dataService.Add(chosenStreet);
}
}
break;
}
}
}
private void button2_Click(object sender, EventArgs e)
{
int selectedItemIndex = listBox1.SelectedIndex;
if (selectedItemIndex >= 0)
{
using (TableDataService <User> dataService = new TableDataService <User>())
{
var dataSet = new DataSet("ShopDb");
var dataAdapter = dataService.GetDataAdapter();
dataAdapter.Fill(dataSet, "Users");
var usersTable = dataSet.Tables["Users"];
var row = usersTable.Rows[selectedItemIndex];
row.BeginEdit();
row.Delete();
row.EndEdit();
dataAdapter.Update(dataSet, "Users");
listBox1.Items.RemoveAt(selectedItemIndex);
dataGridView1.Rows.Clear();
}
}
}
private void listBox1_DoubleClick(object sender, EventArgs e)
{
UserEditFrom userEditFrom;
string selectedItem = listBox1.SelectedItem?.ToString();
if (selectedItem != null)
{
dataGridView1.Rows.Clear();
using (TableDataService <User> dataService = new TableDataService <User>())
{
var users = dataService.GetAll();
for (int i = 0; i < users.Count; i++)
{
if (users[i].Login == selectedItem)
{
userEditFrom = new UserEditFrom(users[i]);
if (userEditFrom.ShowDialog(this) == DialogResult.Cancel)
{
AdminFilter();
}
}
}
}
}
}
public static void DeleteCity()
{
Guid cityId = SetInformations.SetCityId();
using (var dataService = new TableDataService <City>())
{
dataService.DeleteById(cityId);
}
}
public static void DeleteStreet()
{
Guid streetId = SetInformations.SetStreetId();
using (var dataService = new TableDataService <Street>())
{
dataService.DeleteById(streetId);
}
}
public static void ShowAllStudents()
{
TableDataService <Student> dataServiceForStudent = new TableDataService <Student>();
TableDataService <Group> dataServiceForGroup = new TableDataService <Group>();
var students = dataServiceForStudent.GetAll();
var groups = dataServiceForGroup.GetAll();
students.ForEach(f => Console.WriteLine($"{groups.Where(group => group.Id == f.Id)}"));
}
private void button1_Click(object sender, EventArgs e)
{
string tableName = comboBox1.SelectedItem as string;
switch (tableName)
{
case "Buyers":
dataGridView1.Columns.Add("", "Id");
dataGridView1.Columns.Add("", "Name");
dataGridView1.Columns.Add("", "Surname");
using (TableDataService <Buyer> dataService = new TableDataService <Buyer>())
{
var buyers = dataService.GetAll();
foreach (Buyer buyer in buyers)
{
dataGridView1.Rows.Add(buyer.Id, buyer.Name, buyer.Surname);
}
}
break;
case "Sales":
dataGridView1.Columns.Add("", "Id");
dataGridView1.Columns.Add("", "BuyerId");
dataGridView1.Columns.Add("", "SellerId");
dataGridView1.Columns.Add("", "TransactionAmount");
dataGridView1.Columns.Add("", "TransactionDate");
using (TableDataService <Sale> dataService = new TableDataService <Sale>())
{
var sales = dataService.GetAll();
foreach (Sale sale in sales)
{
dataGridView1.Rows.Add(sale.Id, sale.BuyerId, sale.SellerId, sale.TransactionAmount, sale.TransactionDate);
}
}
break;
case "Sellers":
dataGridView1.Columns.Add("", "Id");
dataGridView1.Columns.Add("", "Name");
dataGridView1.Columns.Add("", "Surname");
using (TableDataService <Seller> dataService = new TableDataService <Seller>())
{
var sellers = dataService.GetAll();
foreach (Seller seller in sellers)
{
dataGridView1.Rows.Add(seller.Id, seller.Name, seller.Surname);
}
}
break;
}
}
public static void AddCountry()
{
Country newCountry = new Country()
{
Name = SetInformations.SetName()
};
using (var dataService = new TableDataService <Country>())
{
if (!dataService.GetAll().Any(country => country.Name.ToLower() == newCountry.Name.ToLower()))
{
dataService.Add(newCountry);
}
}
}
private void listBox1_Click(object sender, EventArgs e)
{
int selectedItemIndex = listBox1.SelectedIndex;
if (selectedItemIndex >= 0)
{
dataGridView1.Rows.Clear();
using (TableDataService <User> dataService = new TableDataService <User>())
{
var users = dataService.GetAll();
dataGridView1.Rows.Add(users[selectedItemIndex].Id, users[selectedItemIndex].Login, users[selectedItemIndex].Password, users[selectedItemIndex].Address, users[selectedItemIndex].PhoneNumber, users[selectedItemIndex].IsAdmin);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
User newUser = new User();
if (CheckData.IsLoginCorrect(textBox1.Text))
{
newUser.Login = textBox1.Text;
}
else
{
throw new ArgumentException("Логин был введен неверно");
}
if (CheckData.IsPasswordCorrect(textBox2.Text))
{
newUser.Password = textBox2.Text;
}
else
{
throw new ArgumentException("Пароль был введен неверно");
}
if (CheckData.IsPhoneNumberCorrect(textBox4.Text))
{
newUser.PhoneNumber = textBox4.Text;
}
else
{
throw new ArgumentException("Номер телефона был введен неверно");
}
newUser.IsAdmin = checkBox1.Checked;
newUser.Address = textBox3.Text;
using (TableDataService <User> dataService = new TableDataService <User>())
{
dataService.Add(newUser);
this.Close();
}
}
catch (ArgumentException exception)
{
MessageBox.Show(this, exception.Message, "Error");
}
}
static void Main(string[] args)
{
Student student = new Student()
{
FirstName = "hdhc",
GroupId = 1,
LastName = "hidhn",
MiddleName = "jojd"
};
TableDataService <Student> tableDataService = new TableDataService <Student>();
tableDataService.Add(student);
tableDataService.DeleteById(22);
tableDataService.UpdateStudent(21, StudentProperties.FirstName, "Alisher");
}
public static Guid SetCountryId()
{
do
{
try
{
using (var dataService = new TableDataService <Country>())
{
var countries = dataService.GetAll();
if (countries.Count != Constants.NULL)
{
Console.WriteLine("Выберите страну:");
for (int i = 0; i < countries.Count; i++)
{
Console.WriteLine($"{i + 1} {countries[i].Name}");
}
}
else
{
throw new ArgumentNullException("Добавьте хоть одну страну");
}
}
int countryIndex;
if (int.TryParse(Console.ReadLine().Trim(), out countryIndex))
{
using (var dataService = new TableDataService <Country>())
{
return(dataService.GetAll()[countryIndex - 1].Id);
}
}
throw new ArgumentException("Число было введено неверно");
}
catch (ArgumentNullException exception)
{
Console.WriteLine(exception.Message);
return(Guid.Empty);
}
catch (ArgumentException exception)
{
Console.WriteLine(exception.Message);
}
} while (true);
}
static bool IsUserHave(User newUser)
{
using (TableDataService <User> tableService = new TableDataService <User>())
{
var data = tableService.GetAll();
foreach (User user in data)
{
if (user.Login == newUser.Login || user.Email == newUser.Email || user.Phone == newUser.Phone)
{
return(false);
}
}
return(true);
}
}
public static CommentAuthor CreateCommentAuthorAndSave()
{
CommentAuthor newCommentAuthor = new CommentAuthor()
{
Name = SetInformation.SetName()
};
TableDataService <CommentAuthor> dataService = new TableDataService <CommentAuthor>();
if (dataService.GetAll().All(commentAuthor => commentAuthor.Name != newCommentAuthor.Name))
{
dataService.Add(newCommentAuthor);
return(newCommentAuthor);
}
throw new Exception("This comment author already exists");
}
public static NewsAuthor CreateNewsAuthorAndSave()
{
NewsAuthor newNewsAuthor = new NewsAuthor()
{
Name = SetInformation.SetName()
};
TableDataService <NewsAuthor> dataService = new TableDataService <NewsAuthor>();
if (dataService.GetAll().All(newsAuthor => newsAuthor.Name != newNewsAuthor.Name))
{
dataService.Add(newNewsAuthor);
return(newNewsAuthor);
}
throw new Exception("This news author already exists");
}
public static Theme CreateThemeAndSave()
{
Theme newTheme = new Theme()
{
Name = SetInformation.SetName()
};
TableDataService <Theme> dataService = new TableDataService <Theme>();
if (dataService.GetAll().All(theme => theme.Name != newTheme.Name))
{
dataService.Add(newTheme);
return(newTheme);
}
throw new Exception("This theme already exists");
}
public static void UpdateCity(Guid cityId, CityProperties property)
{
if (cityId != Guid.Empty)
{
switch (property)
{
case CityProperties.Name:
string newName = SetInformations.SetName();
using (var dataService = new TableDataService <City>())
{
var chosenCity = dataService.GetAll().Where(city => city.Id == cityId).SingleOrDefault();
dataService.DeleteById(cityId);
chosenCity.Name = newName;
dataService.Add(chosenCity);
}
break;
case CityProperties.Population:
int newPopulation = SetInformations.SetPopulation();
using (var dataService = new TableDataService <City>())
{
var chosenCity = dataService.GetAll().Where(city => city.Id == cityId).SingleOrDefault();
dataService.DeleteById(cityId);
chosenCity.Population = newPopulation;
dataService.Add(chosenCity);
}
break;
case CityProperties.CountryId:
Guid newCountryId = SetInformations.SetCountryId();
if (newCountryId != Guid.Empty)
{
using (var dataService = new TableDataService <City>())
{
var chosenCity = dataService.GetAll().Where(city => city.Id == cityId).SingleOrDefault();
dataService.DeleteById(cityId);
chosenCity.CountryId = newCountryId;
dataService.Add(chosenCity);
}
}
break;
}
}
}
public static Room ChoseRoom(int hotelId)
{
try
{
List <Room> rooms;
using (TableDataService <Room> dataService = new TableDataService <Room>())
{
rooms = dataService.GetAll();
}
Console.WriteLine("Выберите комнату, если ее нет нажмите ESC\n" +
"=========================================\n");
for (int i = 0; i < rooms.Count; i++)
{
if (rooms[i].HotelId == hotelId)
{
Console.WriteLine($"{rooms[i].Id}) {rooms[i].Number} : {rooms[i].PricePerDay} to day");
}
}
int roomId;
if (int.TryParse(Console.ReadLine().Trim(), out roomId))
{
for (int i = 0; i < rooms.Count; i++)
{
if (rooms[i].HotelId == hotelId && rooms[i].Id == roomId)
{
return(rooms[i]);
}
}
}
throw new ArgumentException("Такой комнаты нет");
}
catch (ArgumentException exception)
{
Console.WriteLine(exception.Message);
return(ChoseRoom(hotelId));
}
}
public static void AddStreet()
{
Street newStreet = new Street()
{
Name = SetInformations.SetName(),
CityId = SetInformations.SetCityId()
};
using (var dataService = new TableDataService <Street>())
{
if (newStreet.Id == Guid.Empty)
{
if (!dataService.GetAll().Any(street => street.Name.ToLower() == newStreet.Name.ToLower() && street.CityId == newStreet.CityId))
{
dataService.Add(newStreet);
}
}
}
}
public static void UpdateCountry(Guid countryId, CountryProperties property)
{
if (countryId != Guid.Empty)
{
switch (property)
{
case CountryProperties.Name:
string newName = SetInformations.SetName();
using (var dataService = new TableDataService <Country>())
{
var chosenCountry = dataService.GetAll().Where(country => country.Id == countryId).SingleOrDefault();
dataService.DeleteById(countryId);
chosenCountry.Name = newName;
dataService.Add(chosenCountry);
}
break;
}
}
}
public static void AddCity()
{
City newCity = new City()
{
Name = SetInformations.SetName(),
Population = SetInformations.SetPopulation(),
CountryId = SetInformations.SetCountryId()
};
using (var dataService = new TableDataService <City>())
{
if (newCity.Id != Guid.Empty)
{
if (!dataService.GetAll().Any(city => city.Name.ToLower() == newCity.Name.ToLower() && city.Population == newCity.Population && city.CountryId == newCity.CountryId))
{
dataService.Add(newCity);
}
}
}
}
public static Hotel.Models.Hotel ChoseHotel()
{
try
{
List <Hotel.Models.Hotel> hotels;
using (TableDataService <Hotel.Models.Hotel> dataService = new TableDataService <Hotel.Models.Hotel>())
{
hotels = dataService.GetAll();
}
Console.WriteLine("Выберите отель\n" +
"=========================================\n");
for (int i = 0; i < hotels.Count; i++)
{
Console.WriteLine($"{hotels[i].Id}) {hotels[i].Name}");
}
int hotelId;
if (int.TryParse(Console.ReadLine().Trim(), out hotelId) && hotelId <= hotels.Count && hotelId >= 1)
{
for (int i = 0; i < hotels.Count; i++)
{
if (hotels[i].Id == hotelId)
{
return(hotels[i]);
}
}
}
throw new ArgumentException("Такого отеля нет");
}
catch (ArgumentException exception)
{
Console.WriteLine(exception.Message);
return(ChoseHotel());
}
}
private void button1_Click(object sender, EventArgs e)
{
var firstRow = dataGridView1.Rows[Constants.FIRST_ELEMENT];
using (TableDataService <User> dataService = new TableDataService <User>())
{
try
{
changedUser.Address = firstRow.Cells["Address"].Value.ToString();
if (CheckData.IsLoginCorrect(firstRow.Cells["Login"].Value.ToString()))
{
changedUser.Login = firstRow.Cells["Login"].Value.ToString();
}
if (CheckData.IsPasswordCorrect(firstRow.Cells["Password"].Value.ToString()))
{
changedUser.Password = firstRow.Cells["Password"].Value.ToString();
}
if (CheckData.IsPhoneNumberCorrect(firstRow.Cells["PhoneNumber"].Value.ToString()))
{
changedUser.PhoneNumber = firstRow.Cells["PhoneNumber"].Value.ToString();
}
if (CheckData.IsAdminCorrect(firstRow.Cells["IsAdmin"].Value.ToString()))
{
changedUser.IsAdmin = (bool)firstRow.Cells["IsAdmin"].Value;
}
dataService.DeleteById(changedUser.Id);
dataService.Add(changedUser);
this.Close();
}
catch (ArgumentException exception)
{
MessageBox.Show(this, exception.Message);
}
}
}
private void listBox1_Click(object sender, EventArgs e)
{
string selectedItem = listBox1.SelectedItem?.ToString();
if (selectedItem != null)
{
dataGridView1.Rows.Clear();
using (TableDataService <User> dataService = new TableDataService <User>())
{
var users = dataService.GetAll();
for (int i = 0; i < users.Count; i++)
{
if (users[i].Login == selectedItem)
{
dataGridView1.Rows.Add(users[i].Id, users[i].Login, users[i].Password.ToString().GetHashCode(), users[i].Address, users[i].PhoneNumber, users[i].IsAdmin);
}
}
}
}
}
public static User Registration()
{
List <User> users;
using (TableDataService <User> dataService = new TableDataService <User>())
{
users = dataService.GetAll();
}
User newUser = new User()
{
Login = SetInformation.SetLogin(),
Password = SetInformation.SetPassword(),
Email = SetInformation.SetEmail(),
Phone = SetInformation.SetPhoneNumber()
};
foreach (User user in users)
{
if (user.Login == newUser.Login || user.Phone == newUser.Phone)
{
throw new ArgumentException("Уже есть user с таким логином или телефоном");
}
}
ISender sender = GetSeneder.GetSender(Senders.TelegramSender);
sender.Open();
sender.Send("Чтобы получить код нужно написать боту 'Get code', затем введите его,\n" +
"если пропала ссылка перейдите по такому адресу: https://web.telegram.org/#/im?p=@StepCodeSendMessageBot");
CheckCode();
sender.Close();
return(newUser);
}
