public static List <RezervareModel> GetAllRezervarationByUserId(int userId, string connectionString) { List <RezervareModel> loans = new List <RezervareModel>(); using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); string cmdText = "Select * from Rezervari where IdCititor = @id"; using (SqlCommand cmd = new SqlCommand(cmdText, con)) { cmd.Parameters.AddWithValue("id", userId); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { RezervareModel loan = new RezervareModel { IdRezerare = (int)reader["IdRezervare"], IdCititor = (int)reader["IdCititor"], IdCarte = (int)reader["IdCarte"], DataRezervare = (DateTime)reader["DataRezervare"], StatusRezervare = (int)reader["StatusRezervare"] }; loans.Add(loan); } } } } return(loans); }
public void Update(RezervareModel model) { using (var db = new LiteDatabase(@"C:\DataBase\HotelInvatare.db")) { var opinie = db.GetCollection <RezervareModel>("rezervare").Update(model); } }
// GET: Rezervari/Edit/5 public ActionResult Editeaza(int id) { RezervariRepository r = new RezervariRepository(); RezervareModel rezervare = r.GetById(id); ViewBag.TipCamere = TipCameraSelectie.Selectii(); return(View(rezervare)); }
public RezervareModel getByID(int id) { var services = db.Services.FirstOrDefault(service => service.ID == id); var rezervareModel = new RezervareModel { Name = services.Name }; return(rezervareModel); }
public void Add(RezervareModel rezervare) { using (var db = new LiteDatabase(@"C:\DataBase\HotelInvatare.db")) { var rezervari = db.GetCollection <RezervareModel>("rezervare"); rezervare.Id = rezervari.Count() + 1; rezervari.Insert(rezervare); } }
public ActionResult Editeaza(RezervareModel rezervare) { if (ModelState.IsValid) { CameraRepository c = new CameraRepository(); var camereGasite = c.CautaCamereDisponibile(rezervare.CheckIn, rezervare.CheckOut, rezervare.TipCamera); if (camereGasite > 0) { RezervariRepository r = new RezervariRepository(); r.Update(rezervare); return(RedirectToAction("Index")); } ModelState.AddModelError("TipCamera", "Nu mai este disponibilitate, verificati ce date sunt disponibile in rezervari"); } ViewBag.TipCamere = TipCameraSelectie.Selectii(); return(View(rezervare)); }
public ActionResult AdaugaRezervare(RezervareModel rezervare) { if (ModelState.IsValid) { CameraRepository c = new CameraRepository(); var camereGasite = c.CautaCamereDisponibile(rezervare.CheckIn, rezervare.CheckOut, rezervare.TipCamera); if (camereGasite > 0) { RezervariRepository r = new RezervariRepository(); r.Add(rezervare); return(RedirectToAction("Multumire")); } ModelState.AddModelError("TipCamera", "Nu avem disponibilitate, va rugam selectati o alta perioada sau alt tip de camera."); } ViewBag.TipCamere = TipCameraSelectie.Selectii(); return(View(rezervare)); }
public ActionResult Rezervare(RezervareModel model) { MailMessage mail = new MailMessage(); SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com"); mail.From = new MailAddress("*****@*****.**"); mail.To.Add(model.Email); mail.Subject = "Inscriere curs " + model.Name; mail.Body = model.UName + ", te-ai inscris cu succes la cursul de " + model.Name; System.Net.Mail.Attachment attachment; SmtpServer.Port = 587; SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "frompassword"); SmtpServer.EnableSsl = true; SmtpServer.Send(mail); return(RedirectToAction("Index", "Home")); }