private void addApmokejimas_Click(object sender, EventArgs e) { try { Apmokejimas ap = new Apmokejimas(); DateTime apData = DateTime.Parse(addApmokejimasApData.Text); ap.saskaitos_Nr = addApmokejimasSasNr.Text; ap.apmokejimo_Suma = int.Parse(addApmokejimasApmokSuma.Text); ap.nuomos_Nr = int.Parse(addApmokejimasNuomosNr.Text); ap.apmok_data = apData.Date; Apmokejimas inserted = apmokRep.InsertApmokejimas(ap); addApmokejimasApData.Clear(); addApmokejimasSasNr.Clear(); addApmokejimasApmokSuma.Clear(); addApmokejimasNuomosNr.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Succesfully inserted"); getApmokejimasDisplay(); }
public async Task <IActionResult> Edit(int id, [Bind("ApmokejimasId,Data,Suma,arApmoketas,KelioneId")] Apmokejimas apmokejimas) { if (id != apmokejimas.ApmokejimasId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(apmokejimas); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ApmokejimasExists(apmokejimas.ApmokejimasId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["KelioneId"] = new SelectList(_context.Kelione, "KelioneId", "KelioneId", apmokejimas.KelioneId); return(View(apmokejimas)); }
public async Task <IActionResult> Create([Bind("ApmokejimasId,Data,Suma,arApmoketas,KelioneId")] Apmokejimas apmokejimas) { if (ModelState.IsValid) { _context.Add(apmokejimas); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["KelioneId"] = new SelectList(_context.Kelione, "KelioneId", "KelioneId", apmokejimas.KelioneId); return(View(apmokejimas)); }
public async Task <IActionResult> Apmoketi(int?id) { var motyvuoti_DviratininkaiContext = _context.Kelione.Where(d => d.KelioneId == id).Include(k => k.Dviratis).Include(k => k.Klientas).First(); // var motyvuoti_DviratininkaiContext = _context.Apmokejimas.Where(a => a.KelioneId == id).Include(a => a.Kelione).ThenInclude(a => a.Dviratis).First(); var Apmokejimas = new Apmokejimas { arApmoketas = false, Data = motyvuoti_DviratininkaiContext.kelionesPabaiga, KelioneId = motyvuoti_DviratininkaiContext.KelioneId, Suma = float.Parse(motyvuoti_DviratininkaiContext.kelionesPabaiga.Subtract(motyvuoti_DviratininkaiContext.kelionesPradzia).Multiply(motyvuoti_DviratininkaiContext.Dviratis.nuomosKaina).TotalHours.ToString().Substring(0, 4).Replace(':', ',')), }; _context.Add(Apmokejimas); await _context.SaveChangesAsync(); return(View(motyvuoti_DviratininkaiContext)); }
private void deleteApmokejimas_Click(object sender, EventArgs e) { try { Apmokejimas gl = new Apmokejimas(); gl.apmok_Id = int.Parse(deleteApmokejimasApmokNr.Text); apmokRep.DeleteApmokejimas(gl); deleteApmokejimasApmokNr.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Deleted succesfully"); getApmokejimasDisplay(); }
//REGISTER STUDENT public Apmokejimas InsertApmokejimas(Apmokejimas apmokejimas)//provide transportas object when calling this function { try { bool nuomaYra = false; //setting new SqlConnection, providing connectionString cnn = new MySqlConnection(connectionString); cnn.Open();//open database //check if transportas exist MySqlCommand cmd = new MySqlCommand("Select * from nuoma where Nuomos_nr=@Nuomos_nr", cnn); cmd.Parameters.AddWithValue("@Nuomos_nr", apmokejimas.nuomos_Nr); MySqlDataReader dataReader = cmd.ExecuteReader();//sends SQLCommand.CommandText to the SQLCommand.Connection and builds SqlDataReader if ((dataReader.Read() == true)) { nuomaYra = true; } else { Console.WriteLine("Tiekejo nera. Galima pridet"); return(null); } dataReader.Close();//close data reader when it finishes work if (nuomaYra == true) { MySqlCommand cmd2 = new MySqlCommand("Insert into apmokejimas (Saskaitos_nr,Apmokejimo_suma,Nuomos_nr,Apmok_data) VALUES(@Saskaitos_nr,@Apmokejimo_suma,@Nuomos_nr,@Apmok_data)", cnn); cmd2.Parameters.AddWithValue("@Saskaitos_nr", apmokejimas.saskaitos_Nr); cmd2.Parameters.AddWithValue("@Apmokejimo_suma", apmokejimas.apmokejimo_Suma); cmd2.Parameters.AddWithValue("@Nuomos_nr", apmokejimas.nuomos_Nr); cmd2.Parameters.AddWithValue("@Apmok_data", apmokejimas.apmok_data); cmd2.ExecuteNonQuery(); cnn.Close(); } } catch (Exception exc) { Console.WriteLine(exc); } return(apmokejimas);//return }
public void UpdateApmokejimas(Apmokejimas apmokejimas) { try { //setting new SqlConnection, providing connectionString cnn = new MySqlConnection(connectionString); //check if user exist MySqlCommand cmd = new MySqlCommand("Update apmokejimas SET Apmok_data=@Apmok_data WHERE apmok_nr=@apmok_nr", cnn);//to check if username exist we have to select all items with username cmd.Parameters.AddWithValue("@Apmok_data", apmokejimas.apmok_data); cmd.Parameters.AddWithValue("@apmok_nr", apmokejimas.apmok_Id); cnn.Open(); cmd.ExecuteNonQuery(); cnn.Close(); } catch (Exception ex) { Console.WriteLine(ex); } }
public void DeleteApmokejimas(Apmokejimas apmokejima) { try { cnn = new MySqlConnection(connectionString); string newSql = ("Delete from apmokejimas where apmokejimas.apmok_nr=@id;"); cnn.Open(); //open connection. we use the Open method of the cnn variable to open a connection to the database. MySqlCommand cmd = new MySqlCommand(newSql, cnn); //select all from newTestTable cmd.Parameters.AddWithValue("@id", apmokejima.apmok_Id); cmd.ExecuteNonQuery(); //execute function cnn.Close(); } catch (Exception exc) { Console.WriteLine(exc); } }
private void updateApmokejimas_Click(object sender, EventArgs e) { try { Apmokejimas ap = new Apmokejimas(); DateTime apData = DateTime.Parse(updateApmokejimasApData.Text); ap.apmok_data = apData.Date; ap.apmok_Id = int.Parse(updateApmokejimasApmokNr.Text); apmokRep.UpdateApmokejimas(ap); updateApmokejimasApData.Clear(); updateApmokejimasApmokNr.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Succesfully updated"); getApmokejimasDisplay(); }