public static int InsertUser(string firstname, string lastname, string birthday,
string phonenumber, string email, string gender, string city,
string street, string login, string type)
{
db = new Database();
db.Connect();
Address a = new Address(city, street);
AddressTable.Insert(a);
a.Id = AddressTable.SelectMaxId(db);
Person p = new Person(firstname, lastname, birthday, phonenumber, email, gender, a, a.Id);
PersonTable.Insert(p);
p.Id = PersonTable.SelectMaxId(db);
User u = new User(login, type, p, p.Id);
u.Id = UserTable.SelectMaxId(db);
int uAdded = UserTable.Insert(u, db);
db.Close();
return(uAdded);
}
private void button2_Click(object sender, EventArgs e)
{
if (DialogResult.Yes == MessageBox.Show("Do you really want to add this player?", "", MessageBoxButtons.YesNo))
{
Person p = new Person();
var tmp = PersonTable.Select();
try
{
p.Id = tmp.Count + 1;
p.First_Name = textBox1.Text;
p.Last_Name = textBox5.Text;
p.Birth_Date = Int32.Parse(textBox4.Text);
if (comboBoxRole.SelectedIndex == -1)
{
MessageBox.Show("ROLE MUST BE CHOSEN!\nClick on the role to chose it\nThe role name must be in blue in order to be chosen sucessfully\n", "", MessageBoxButtons.OK);
return;
}
p.Role = comboBoxRole.Items[comboBoxRole.SelectedIndex].ToString();
if (p.First_Name.Length > 30 || p.Last_Name.Length > 30 || p.Birth_Date > 2300 || p.Birth_Date < 1800)
{
throw new Exception();
}
}
catch (Exception)
{
MessageBox.Show("WRONG FORMAT OF INPUT!\nBoth name and last name can be max 30 chars long\nBirth year must be realistic\n", "", MessageBoxButtons.OK);
return;
}
if (comboBoxTeam.SelectedIndex == -1)
{
MessageBox.Show("TEAM NOT CHOSEN!\nClick on the team name to chose it\n", "", MessageBoxButtons.OK);
return;
}
Team t = new Team();
t.Id = comboBoxTeam.SelectedIndex + 1;
p.Team_Id = t;
if (comboBoxGame.SelectedIndex == -1)
{
MessageBox.Show("GAME NOT CHOSEN!\nClick on the game name to chose it\n", "", MessageBoxButtons.OK);
return;
}
Game g = new Game();
g.Id = comboBoxGame.SelectedIndex + 1;
p.Game_Id = g;
PersonTable.Insert(p);
this.Close();
}
}
static void Main(string[] args)
{
Database db = new Database();
db.Connect();
Address a1 = new Address("Žilina", "Fatranská 6");
Address a2 = new Address("Martin", "Martinská 6");
//AddressTable.Insert(a1, db);
//AddressTable.Insert(a2, db);
Person p1 = new Person(generateString(8), generateString(8), null, "+421" + generateString(9),
generateString(4) + "@email.com", "Muz", a1, a1.Id);
PersonTable.Insert(p1);
//Person p1 = new Person("Lukáš","Paučin","1996-06-19", "+)
/*
* Person p1 = new Person();
* p1.Id = 1;
* p1.FirstName = "Lukáš";
* p1.LastName = "Paučin";
* p1.BirthDay = null;
* p1.PhoneNumber = "+421521645";
* p1.Email = "*****@*****.**";
* p1.Gender = "Muz";
* p1.Address = a1;
* p1.AddressId = a1.Id;
*
* PersonTable.Insert(p1, db);
*/
db.Close();
}
private void Button_insert_Click(object sender, EventArgs e)
{
if (TextBox_name.Text == "" || textBox_Birth_city.Text == "" || textBoxTIN.Text == "" || textBoxSSN.Text == "" || textBoxAddress.Text == "" || textBoxROOM.Text == "")
{
MessageBox.Show("Az össszes mező kitöltése kötelező!");
}
else
{
string[] BirthDate = Convert.ToString(dateTime_BirthDate.Value).Split('.');
string[] check_in = Convert.ToString(dateTime_check_in.Value).Split('.');
string[] check_out = Convert.ToString(dateTime_check_out.Value).Split('.');
Person person = new Person(TextBox_name.Text, textBoxTIN.Text, textBoxSSN.Text, textBoxAddress.Text, BirthDate[0] + "-" + BirthDate[1] + "-" + BirthDate[2], textBox_Birth_city.Text, "F", check_out[0] + "-" + check_out[1] + "-" + check_out[2], check_in[0] + "-" + check_in[1] + "-" + check_in[2], int.Parse(textBoxROOM.Text));
manager_studentsTable.Insert(person);
Button_view_Click(sender, e);
TextBox_name.Clear();
textBox_Birth_city.Clear();
textBoxTIN.Clear();
textBoxSSN.Clear();
textBoxAddress.Clear();
textBoxROOM.Clear();
}
}
static void Main(string[] args)
{
Database db = new Database();
db.Connect();
/***1.1 Vloženie užívateľa***/
Address a1 = new Address("Bratislava", "Lomnická 9");
AddressTable.Insert(a1);
a1.Id = AddressTable.SelectMaxId(db);
Person p1 = new Person("Lukáš", "Náhodný", "1996-10-12", "+421" + RandomString("number", 9),
RandomString("word", 5) + "@email.com", "muz", a1, a1.Id);
PersonTable.Insert(p1);
p1.Id = PersonTable.SelectMaxId(db);
User u1 = new User((p1.LastName.Substring(0, 3) + RandomString("number", 4)).ToLower(),
"courier", p1, p1.Id);
UserTable.Insert(u1);
u1.Id = UserTable.SelectMaxId(db);
/***1.2 Aktualizácia užívateľa***/
p1.LastName = "Aktualizovaný";
PersonTable.Update(p1);
u1.Login = (p1.LastName.Substring(0, 3) + RandomString("number", 4)).ToLower();
UserTable.Update(u1);
/***1.3 Zrušenie užívateľa**/
//int UserToDelete = 15;
//UserTable.Delete(UserToDelete);
//PersonTable.Delete(UserToDelete);
//Console.WriteLine("User with ID " + UserToDelete + " has been deleted." );
//Console.WriteLine(" ");
List <Shipment> Shipments2 = ShipmentTable.SelectAllShipments(db);
foreach (var shipment in Shipments2)
{
Console.WriteLine(shipment.Id);
}
/*List<Shipment> ShipmentsD = ShipmentTable.SelectShipmentDetail(21,db);
*
* foreach (var shipment in ShipmentsD)
* {
* Console.WriteLine(shipment.Id.ToString() + shipment.Type + " " + shipment.Price + " " + shipment.DeliveryPrice + " " +
* shipment.Weight + " " + shipment.OrderTime + " " + shipment.DeliveryTime);
* }*/
/**1.4 Zoznam užívateľov**/
List <User> Users = UserTable.SelectUsers(db);
Console.WriteLine("(1.4)User list");
foreach (var user in Users)
{
Console.WriteLine(" " + user.Id + " " + user.Person.FullName + " " + user.Login + " " +
user.Type + " " + user.Person.Email + " " + user.Person.Address.City + "...");
}
Console.WriteLine(" ");
/***1.5 Detail užívateľa***/
User UserDetail = UserTable.SelectUser(p1.Id, db);
Console.WriteLine("(1.5)User detail with ID: " + p1.Id + " " + UserDetail.Person.FullName + " " +
UserDetail.Login + " " + UserDetail.Type + " " + UserDetail.Person.Address.City + "....");
Console.WriteLine(" ");
/***2.1 Zoznam neskoro doručených zásielok (podľa id kuriéra)***/
int CourierToCheckId = 3;
List <Shipment> LateShipments = ShipmentTable.SelectLateShipmentsByCourierId(CourierToCheckId, db);
Console.WriteLine("(2.1)Late shipments by courier id");
foreach (var shipment in LateShipments)
{
Console.WriteLine(" " + shipment.Id.ToString() + " with " + shipment.Delay.ToString() + " day(s) delay. " + "Delivered " +
shipment.Delivered + " instead of " + shipment.DeliveryTime);
}
Console.WriteLine(" ");
/***2.2 Ukončené zásielky***/
string StateToCheck = "zrusena zakaznikom"; /*vyzdvihnuta, nevyzdvihnuta*/
; List <Shipment> DoneShipments = ShipmentTable.SelectDoneShipmentsByState(StateToCheck, db);
Console.WriteLine("(2.2)Done shipments by state");
foreach (var shipment in DoneShipments)
{
Console.WriteLine(" " + shipment.Id + " done at " + shipment.DoneAt);
}
Console.WriteLine(" ");
/***2.3 Nedoručené zásielky***/
int IdOfCourierChecking = 5;
List <Shipment> NotDoneShipments = ShipmentTable.SelectNotDoneShipmentsByCourierId(IdOfCourierChecking, db);
Console.WriteLine("(2.3)My shipments to deliver");
foreach (var shipment in NotDoneShipments)
{
Console.WriteLine(" " + shipment.Id + " should be delivered at " + shipment.DeliveryTime +
" to " + shipment.Person.FullName);
}
Console.WriteLine(" ");
/***2.4 Počet jednotlivých zásielok pre ich stavy (u každého kuriéra)***/
List <User> ShipmentsByState = ShipmentTable.SelectShipmentsByState(db);
Console.WriteLine("(2.4)Shipment count by its state with courierID");
Console.WriteLine(" " + "Courier ID" + " Picked Not Picked Canceled On way");
foreach (var user in ShipmentsByState)
{
Console.WriteLine(" " + user.Id + " " + user.CourPicked + " " + user.CourNotPicked
+ " " + user.CourCanceled + " " + user.CourOnWay);
}
Console.WriteLine(" ");
/***2.5 Aktuálne meškajúce zásielky (kuriéra)***/
List <Shipment> CurrLateShipments = ShipmentTable.SelectCurrLateShipmentsByCourierId(7, db);
Console.WriteLine("(2.5)My currently late shipments");
foreach (var shipment in CurrLateShipments)
{
Console.WriteLine(" " + shipment.Id + " should be delivered " + shipment.Delay + " day(s) ago.");
}
Console.WriteLine(" ");
/***3.3 Vloženie novej zásielky a automatická aktualizácia cien a váhy***/
Console.WriteLine("(3.3)Adding new shipment...");
Person p2 = new Person("Neregistrovaný", "Užívateľ", "1996-10-12", "+421" + RandomString("number", 9),
RandomString("word", 5) + "@email.com", "muz", a1, a1.Id);
PersonTable.Insert(p2);
p2.Id = PersonTable.SelectMaxId(db);
string productIds = "4,5,6"; /* ID produtkov, ktoré si užívateľ vyberie v rozhraní*/;
String CreateAndUpdateResult = ShipmentTable.CreateAndUpdateShipment("Test funkcie 3.3.", p2.Id, 1, 4, 2, productIds, db);
Console.WriteLine(CreateAndUpdateResult);
Console.WriteLine(" ");
/***3.4 Automatická aktualizácia ceny doručenia pri oneskorenom doručení a upozornenie zákazníka o tejto udalosti***/
Console.WriteLine("(3.4)Updating shipment delivery prices and sending notifications...");
Console.WriteLine(ShipmentTable.LateShipNotificationAndUpdate("Ospravedlňujeme sa za meškanie vašej zásielky.", db));
Console.WriteLine(" ");
/***3.5 História a pohyb zásielky***/
String Updated = ShipmentTable.HistoryAndMovement(11122, "zrusena zakaznikom", 4, db);
Console.WriteLine("(3.5) " + Updated);
Console.ReadLine();
db.Close();
}
