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