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"); } }