private void button1_Click(object sender, EventArgs e)
{
if (textBox3.Text != textBox4.Text)
{
MessageBox.Show("Confirmare parola esuata!");
return;
}
UserModel utilizatorNou = new UserModel
{
TipUtilizator = radioButton1.Checked == true ? 1 : 0,
NumePenume = textBox1.Text,
Email = textBox2.Text,
Parola = CriptareParola.Criptare(textBox3.Text)
};
SqlDataAcces.InregistreazaUtilizator(utilizatorNou);
utilizatorNou.ID = SqlDataAcces.GetUserIDByEmail(utilizatorNou.Email);
if (pictureBox2.Image != null)
{
string filePath = "Resurse\\Imagini\\utilizatori\\" + utilizatorNou.ID.ToString() + ".jpeg";
Bitmap imagine = new Bitmap(pictureBox2.Image);
imagine.Save(filePath, ImageFormat.Jpeg);
}
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox4.Text == textBox5.Text)
{
UtilizatorModel utilizator = new UtilizatorModel
{
email = textBox1.Text,
nume = textBox2.Text,
prenume = textBox3.Text,
parola = textBox4.Text
};
try
{
SqlDataAcces.Registrare(SqlDataAcces.ConnectionString, utilizator);
utilizator = SqlDataAcces.Logare(SqlDataAcces.ConnectionString, textBox1.Text, textBox4.Text);
MessageBox.Show("Inregistrare cu succes!");
this.Close();
this.Visible = false;
(Owner as FreeBookHome).Autentificat(utilizator);
}
catch (Exception)
{
MessageBox.Show("Email-ul este deja utilizat!");
}
}
else
{
MessageBox.Show("Confirmare parola nu corespunde");
}
}
public ManagerController(IOptions <ConnectionConfig> connectionConfig)
{
var connection = connectionConfig.Value;
string connectionString = connection.Thuis;
_testing = new SqlDataAcces(connectionString);
}
public static void Salvare(string connectionString, List <Point> porturi)
{
List <string> numePorturi = SqlDataAcces.NumePorturi;
SqlDataAcces.ClearDB(connectionString, "Porturi");
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
string cmdText = "Insert into Porturi ( Nume_port, Pozitie_X, Pozitie_Y) values (@nume, @x, @y);";
int index = 0;
foreach (Point item in porturi)
{
using (SqlCommand cmd = new SqlCommand(cmdText, con))
{
cmd.Parameters.AddWithValue("nume", numePorturi[index]);
cmd.Parameters.AddWithValue("x", item.X);
cmd.Parameters.AddWithValue("y", item.Y);
cmd.ExecuteNonQuery();
}
index++;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
string email = textBox1.Text;
string parola = CriptareParola.Criptare(textBox2.Text);
if (String.IsNullOrWhiteSpace(email) || String.IsNullOrWhiteSpace(parola))
{
MessageBox.Show("Introduceti datele.");
return;
}
UserModel utilizator = SqlDataAcces.Autentificare(email, parola);
if (utilizator.Parola == parola)
{
var page = Singleton <BibliotecarBiblioteca> .Instance;
page.Utilizator = utilizator;
page.Show();
this.Hide();
}
else
{
MessageBox.Show("Email sau parola gresita!");
}
}
private void InitializareItemi()
{
items = new List <ItemModel>();
List <ItemModel> tempItems = SqlDataAcces.GetAllItems(SqlDataAcces.ConnectionString);
List <ItemModel> itemTip1 = tempItems.Where(x => x.TipItem == 1).ToList();
List <ItemModel> itemTip2 = tempItems.Where(x => x.TipItem == 2).ToList();
List <ItemModel> itemTip3 = tempItems.Where(x => x.TipItem == 3).ToList();
List <ItemModel> itemTip4 = tempItems.Where(x => x.TipItem == 4).ToList();
Random r = new Random();
items.Add(itemTip1[r.Next(0, itemTip1.Count() - 1)]);
items.Add(itemTip2[r.Next(0, itemTip2.Count() - 1)]);
items.Add(itemTip3[r.Next(0, itemTip3.Count() - 1)]);
items.Add(itemTip4[r.Next(0, itemTip4.Count() - 1)]);
items.Add(itemTip1.Find(x => !items.Contains(x)));
items.Add(itemTip2.Find(x => !items.Contains(x)));
items.Add(itemTip3.Find(x => !items.Contains(x)));
items.Add(itemTip4.Find(x => !items.Contains(x)));
items.Add(itemTip1.Find(x => !items.Contains(x)));
foreach (ItemModel item in items)
{
CreateNewItemPage(item);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (button1.Text == "Start test")
{
button1.Text = "Finializare";
InitializareItemi();
button1.Enabled = false;
button2.Enabled = true;
}
else
{
button1.Enabled = false;
SqlDataAcces.SalvareNota(SqlDataAcces.ConnectionString, UserLoged.IDUtilizator, int.Parse(label2.Text));
RaportForm raport = new RaportForm();
foreach (ResponModel item in raspunsuri)
{
raport.AddRow(item.RaspunsUtilizator, item.RaspunsCorect);
}
raport.ShowDialog();
}
}
public List <ProductModel> GetProducts()
{
SqlDataAcces sql = new SqlDataAcces();
var output = sql.LoadData <ProductModel, dynamic>("[dbo].[spProducts_GetAll]", new { }, "RMDatabase");
return(output);
}
public ProductModel GetProductById(int productId)
{
SqlDataAcces sql = new SqlDataAcces();
var output = sql.LoadData <ProductModel, dynamic>("[dbo].[spProducts_GetById]", new { id = productId }, "RMDatabase").FirstOrDefault();
return(output);
}
public static void RegisterUser(string Id, string FirstName, string LastName, string EmailAdress, int PhoneNumber)
{
SqlDataAcces sql = new SqlDataAcces();
var p = new { user_id = Id, first_name = FirstName, last_name = LastName, email_adress = EmailAdress, phone_number = PhoneNumber };
sql.SaveData("dbo.spInsertNewUser", p, "VTFData");
}
public VizualizareCroaziera(List <int> listaPorturi)
{
InitializeComponent();
porturiCroaziera = SqlDataAcces.GetListaPorturi(listaPorturi);
InitiateMap();
}
private void InitializareImprumuturiTable()
{
progressBar1.Value = 3;
try
{
table.Clear();
}
catch { }
imprumuturi = SqlDataAcces.GetImprumuturiUtilizator(utilizator);
imprumuturi = imprumuturi.OrderByDescending(x => x.DataImprumut).ToList();
List <int> expirate = new List <int>();
table = new DataTable();
table.Columns.Add("Index");
table.Columns.Add("Titlu");
table.Columns.Add("Autor");
table.Columns.Add("DataImprumut");
table.Columns.Add("DataDisponibiliate");
//table.DefaultView.Sort = "DataImprumut ASC";
for (int i = 0; i < imprumuturi.Count; i++)
{
DataRow newRow = table.NewRow();
int index = i + 1;
newRow[0] = index;
newRow[1] = imprumuturi[i].Titlu;
newRow[2] = imprumuturi[i].Autor;
newRow[3] = imprumuturi[i].DataImprumut;
newRow[4] = imprumuturi[i].DataDisponibilitate;
table.Rows.Add(newRow);
if (imprumuturi[i].DataDisponibilitate < DateTime.Now)
{
expirate.Add(index);
}
}
dataGridView2.DataSource = table;
dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
for (int i = 0; i < dataGridView2.Rows.Count - 1; i++)
{
if (expirate.Contains(Int32.Parse((string)dataGridView2.Rows[i].Cells[0].Value)))
{
dataGridView2.Rows[i].DefaultCellStyle.BackColor = Color.Red;
}
else
{
dataGridView2.Rows[i].DefaultCellStyle.BackColor = Color.Green;
progressBar1.Value--;
}
}
label3.Text = progressBar1.Value.ToString() + " / 3 ";
}
public List <UserModel> GetUserById(string Id)
{
SqlDataAcces sql = new SqlDataAcces();
var p = new { user_id = Id };
var output = sql.LoadData <UserModel, dynamic>("dbo.spUserLookup", p, "VTFData");
return(output);
}
public List <EventModel> GetEventsByMonth(EventLookupModel eventLookup)
{
SqlDataAcces sql = new SqlDataAcces();
var p = new { month = eventLookup.date, status = eventLookup.status };
var output = sql.LoadData <EventModel, dynamic>("dbo.spEventsLookup", p, "VTFData");
return(output);
}
public List <UserModel> GetUserById(string id)
{
SqlDataAcces sql = new SqlDataAcces();
var p = new
{
Id = id
};
var output = sql.LoadData <UserModel, dynamic>("[dbo].[spUserLookUp]", p, "RMDatabase");
return(output);
}
private void button2_Click(object sender, EventArgs e)
{
UtilizatorModel utilizator = SqlDataAcces.Logare(SqlDataAcces.ConnectionString, textBox1.Text, textBox4.Text);
if (utilizator.email == textBox1.Text)
{
this.Close();
this.Visible = false;
(Owner as FreeBookHome).Autentificat(utilizator);
}
else
{
MessageBox.Show("Eroare autentificare!");
}
}
private void InitializeCarnet()
{
List <MarkModel> note = SqlDataAcces.GetAllMarks(SqlDataAcces.ConnectionString, UserLoged);
dataGridView1.Columns.Clear();
DataTable newTable = new DataTable();
newTable.Columns.Add("Nota", typeof(int));
newTable.Columns.Add("Data", typeof(DateTime));
foreach (MarkModel item in note)
{
DataRow newRow = newTable.NewRow();
newRow["Nota"] = item.Nota;
newRow["Data"] = item.Data;
newTable.Rows.Add(newRow);
}
dataGridView1.DataSource = newTable;
}
private void InitializareCartiChart()
{
List <string> carti = SqlDataAcces.GetCartiCitite().OrderBy(x => x).ToList();
var celeMaiCitieCarti = carti.GroupBy(x => x).OrderByDescending(x => x.Count()).Take(4).ToList();
chart2.Series.Clear();
Series series = new Series("Carti populare");
series.ChartType = SeriesChartType.Pie;
foreach (var item in celeMaiCitieCarti)
{
series.Points.AddXY(item.First(), item.Count());
}
chart2.Series.Add(series);
chart2.Series[0].IsValueShownAsLabel = true;
}
public BibliotecarBiblioteca()
{
InitializeComponent();
utilizatori = SqlDataAcces.GetAllUsers();
InitiateAfisareCititori(utilizatori);
AddCollumnButton();
timer = new Timer();
timer.Interval = 1000;
timer.Tick += Timer_Tick;
timer.Start();
textBox3.Enabled = textBox4.Enabled = false;
textBox3.PasswordChar = textBox4.PasswordChar = '*';
button1.Enabled = false;
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox4.Text == textBox5.Text)
{
UserModel utilizator = new UserModel
{
Parola = textBox4.Text,
Nume = textBox1.Text,
Prenume = textBox2.Text,
Adresa = textBox3.Text,
Email = textBox6.Text
};
SqlDataAcces.RegistrareUtilizator(utilizator);
}
else
{
MessageBox.Show("Confirmare parola a esuat!");
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
DataGridView dgv = (DataGridView)sender;
if (dgv.Columns[e.ColumnIndex] is DataGridViewColumn)
{
int nrCartiImprumutate = SqlDataAcces.VerificaImprumuturi(utilizator);
if (nrCartiImprumutate < 3)
{
int idCarte = Int32.Parse((string)dgv.Rows[e.RowIndex].Cells["id_carte"].Value);
SqlDataAcces.ImprumutaCarte(idCarte, utilizator);
//dgv.Rows[e.RowIndex].Cells[1].Style.BackColor = Color.Green;
dgv.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Green;
}
else
{
MessageBox.Show("Aveti deja imprumutate 3 carti in ultimele 30 de zile.");
}
}
}
private void InitializareUtilizatoriTable()
{
chart1.Series.Clear();
Series serie = new Series();
serie.Name = "Luna";
//serie.XValueType = typeof(string);
DateTime an = dateTimePicker1.Value.AddDays(1 - dateTimePicker1.Value.DayOfYear);
var imprumuturiAn = SqlDataAcces.GetImprumuturiAn(an, an.AddYears(1)).Select(x => x.DataImprumut).OrderBy(x => x).Select(x => x.ToString("MMM")).ToList();
var stats = imprumuturiAn.GroupBy(x => x).ToList();
DateTime temp = DateTime.Now.AddDays(1 - DateTime.Now.DayOfYear);
for (int i = 0; i < 11; i++)
{
string data = temp.ToString("MMM");
serie.Points.AddXY(data, 0);
temp = temp.AddMonths(1);
}
foreach (var item in stats)
{
serie.Points.AddXY(item.First(), item.Count());
}
chart1.Series.Add(serie);
chart1.ChartAreas[0].AxisX.Interval = 1;
chart1.Series[0].IsValueShownAsLabel = true;
//chart1.ChartAreas[0].AxisX.LabelStyle.Format = "MMM";
chart1.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
chart1.ChartAreas[0].AxisX.MinorGrid.Enabled = false;
chart1.ChartAreas[0].AxisY.MajorGrid.Enabled = false;
chart1.ChartAreas[0].AxisY.MinorGrid.Enabled = false;
}
private void InitializeChart()
{
List <MarkModel> note = SqlDataAcces.GetAllMarks(SqlDataAcces.ConnectionString, this.UserLoged);
note = note.OrderBy(x => x.Data).ToList();
Series serie = new Series();
serie.ChartType = SeriesChartType.Line;
foreach (MarkModel nota in note)
{
serie.Points.AddXY(nota.Data, nota.Nota);
}
chart1.Series.Clear();
chart1.Series.Add(serie);
chart1.Series[0].XValueType = ChartValueType.DateTime;
chart1.Series[0].Name = "Nota";
chart1.ChartAreas[0].AxisX.LabelStyle.Format = "dd.MM.yyyy";
//chart1.ChartAreas[0].AxisX.Interval = 1;
chart1.ChartAreas[0].AxisX.IntervalType = DateTimeIntervalType.Days;
DateTime maxDate = note.Max(x => x.Data);
DateTime minDate = note.Min(x => x.Data);
chart1.ChartAreas[0].AxisX.Maximum = maxDate.ToOADate();
chart1.ChartAreas[0].AxisX.Minimum = minDate.ToOADate();
Series notaMedie = new Series();
notaMedie.ChartType = SeriesChartType.Line;
notaMedie.Points.AddXY(minDate, MarkModel.NotaMedie);
notaMedie.Points.AddXY(maxDate, MarkModel.NotaMedie);
chart1.Series.Add(notaMedie);
chart1.Series[1].Name = "Media clasei";
}
private void button1_Click(object sender, EventArgs e)
{
int nrPasageri = 0;
try
{
nrPasageri = (int)dataGridView1.Rows[selectedRow].Cells["Nr_Pasageri"].Value;
}
catch
{
MessageBox.Show("Introduceti un nr. valid de pasageri!");
return;
}
int idCroaziera = (int)dataGridView1.Rows[selectedRow].Cells["ID_Croaziera"].Value;
DateTime dataStart;
DateTime dataFinal;
try
{
dataStart = (DateTime)dataGridView1.Rows[selectedRow].Cells["Data_Start"].Value;
dataFinal = (DateTime)dataGridView1.Rows[selectedRow].Cells["Data_Final"].Value;
}
catch
{
MessageBox.Show("Selectati o data valida !");
return;
}
SqlDataAcces.UpdateCroaziera(idCroaziera, nrPasageri, dataStart, dataFinal);
List <int> listaPorturi = ((string)dataGridView1.Rows[selectedRow].Cells["Lista_Porturi"].Value).ToString().Split(',').Select(x => Int32.Parse(x)).ToList();
VizualizareCroaziera page = new VizualizareCroaziera(listaPorturi);
page.Show();
}
public void SaveSale(SaleModel saleInfo, string userId)
{
// TODO: Make this SOLID/DRY/Better
List <SaleDetailDbModel> saleDetails = new List <SaleDetailDbModel>();
ProductData product = new ProductData();
var taxRate = ConfigHelper.GetTaxRate();
foreach (var item in saleInfo.SaleDetails)
{
var detail = new SaleDetailDbModel
{
ProductId = item.ProductId,
Quantity = item.Quantity,
};
//TODO: Additional SaleDetail information
var productInfo = product.GetProductById(detail.ProductId);
if (productInfo == null)
{
throw new Exception($"The Id of {detail.ProductId} could not be found in the database!");
}
detail.PurchasePrice = productInfo.RetailPrice * detail.Quantity;
if (productInfo.IsTaxable)
{
detail.Tax = (detail.PurchasePrice * taxRate) / 100;
}
saleDetails.Add(detail);
}
//SaleDbModel to save to database
SaleDbModel sale = new SaleDbModel
{
SubTotal = saleDetails.Sum(x => x.PurchasePrice),
Tax = saleDetails.Sum(x => x.Tax),
CashierId = userId,
};
sale.Total = sale.SubTotal + sale.Tax;
//Save Sales record
SqlDataAcces sql = new SqlDataAcces();
sql.SaveData("dbo.spSales_Insert", sale, "RMDatabase");
//Get the ID from Sales table
sale.Id = sql.LoadData <int, dynamic>("dbo.spSales_Latest",
new { CashierId = sale.CashierId, SaleDate = sale.SaleDate },
"RMDatabase").FirstOrDefault();
//Finish filling Sales database model for insertion
foreach (var item in saleDetails)
{
item.SaleId = sale.Id;
//Save SaleDetails records.
//If SaveData is being called too much (eg: 1000 calls/time), you can create table parameter and pass all values in 1 table.
sql.SaveData("dbo.spSaleDetails_Insert", item, "RMDatabase");
}
}
