Пример #1
0
        public async Task <IActionResult> Create(
            [Bind("id,Klienti_id,Libra_id,Aktiv")] Rezervimi r)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    var huazimet = _context.Huazimi.Where(h => h.Klienti_id == r.Klienti_id && h.Aktiv == true).ToList();

                    foreach (Huazimi h in huazimet)
                    {
                        if (r.Libra_id == h.Libra_id)
                        {
                            return(RedirectToAction(nameof(Index)));
                        }
                    }

                    r.Aktiv      = true;
                    r.created_at = DateTime.Now;
                    _context.Rezervimi.Add(r);
                    await _context.SaveChangesAsync();

                    return(RedirectToAction(nameof(Index)));
                }
            }
            catch (DbUpdateException /* ex */)
            {
                //Log the error (uncomment ex variable name and write a log.
                ModelState.AddModelError("", "Unable to save changes. " +
                                         "Try again, and if the problem persists " +
                                         "see your system administrator.");
            }
            return(View(r));
        }
        public static bool CheckReservation(Rezervimi rezervimi)
        {
            bool message = false;

            try
            {
                using (SqlConnection con = new SqlConnection(Connection.ConnectionString))
                {
                    SqlCommand cmd = new SqlCommand("ufn_KontrolloDatat", con);
                    cmd.CommandType = System.Data.CommandType.Text;
                    cmd.CommandText = "select dbo.[ufn_KontrolloDatat](@FillimiRezervimit,@MbarimiRezervimit,@FushaID)";
                    cmd.Parameters.AddWithValue("@FillimiRezervimit", rezervimi.FillimiRezervimit);
                    cmd.Parameters.AddWithValue("@MbarimiRezervimit", rezervimi.MbarimiRezervimit);
                    cmd.Parameters.AddWithValue("@FushaID", rezervimi.Fusha.FushaID);

                    con.Open();
                    message = (bool)cmd.ExecuteScalar();
                    con.Close();
                }
                return(message);
            }
            catch (Exception)
            {
                throw;
            }
        }
 void Show()
 {
     try
     {
         rezervimi                = BussinessRezervimi.GetAllRezervimetByID(rezervimiid);
         lblShowR.Text           += rezervimi.RezervimiID.ToString();
         dtMbarimiRezervimit.Text = rezervimi.MbarimiRezervimit.ToString();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
        private void btnShto_Click(object sender, EventArgs e)
        {
            try
            {
                Rezervimi newRezervim = new Rezervimi();
                int       fushaid     = int.Parse(cmbFushat.SelectedValue.ToString());
                int       klientiid   = int.Parse(cmbKlientat.SelectedValue.ToString());
                DateTime  dt          = Convert.ToDateTime(dtDataeRezervimit.Value);
                DateTime  dtF         = Convert.ToDateTime(dtFillimiRezervimit.Value);
                DateTime  dtM         = Convert.ToDateTime(dtMbarimiRezervimit.Value);
                if (dtF.Date >= DateTime.Now && dtM.Date >= DateTime.Now)
                {
                    if (dtM.Hour > dtF.Hour)
                    {
                        newRezervim.User = Form1.useri;
                        Fusha fusha = new Fusha();
                        fusha.FushaID     = fushaid;
                        newRezervim.Fusha = fusha;

                        newRezervim.Klienti           = new Klienti();
                        newRezervim.Klienti.KlientiID = klientiid;
                        newRezervim.DataERezervimit   = DateTime.Now;
                        newRezervim.FillimiRezervimit = dtF;
                        newRezervim.MbarimiRezervimit = dtM;

                        if (BussinessRezervimi.CheckReservation(newRezervim) == true)
                        {
                            MessageBox.Show("U shtua nje rezervim i ri");
                            BussinessRezervimi.InsertRezervim(newRezervim);
                            this.Close();
                        }
                        else
                        {
                            MessageBox.Show("Ekziston rezervim ne kete kohe");
                        }
                    }
                    else
                    {
                        MessageBox.Show("Data e mbarimit duhet të jete më e madhe se data e fillimit");
                    }
                }
                else
                {
                    MessageBox.Show("Gabim në datë");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Пример #5
0
        public static void Initialize(LibrarymsContext context)
        {
            context.Database.EnsureCreated();

            //Look for any students.
            if (context.Libra.Any() || context.Klienti.Any() || context.Roles.Any())
            {
                return; // DB has been seeded
            }



            var lirbat = new Libra[]
            {
                new Libra {
                    Titulli = "When Harry Met Sally", Autori = "Filan Fisteku", E_Lire = true,
                }
            };

            foreach (Libra s in lirbat)
            {
                context.Libra.Add(s);
            }
            context.SaveChanges();

            var klientet = new Klienti[]
            {
                new Klienti {
                    Emri = "Leutrim Ahmeti", Email = "*****@*****.**", Aktiv = true, NumriTel = "044444444"
                },
            };

            foreach (Klienti k in klientet)
            {
                context.Klienti.Add(k);
            }
            context.SaveChanges();

            var rezervimi = new Rezervimi[]
            {
                new Rezervimi {
                    Klienti_id = 1, Libra_id = 2, Aktiv = true
                }
            };

            foreach (Rezervimi r in rezervimi)
            {
                context.Rezervimi.Add(r);
            }
            context.SaveChanges();
        }
Пример #6
0
 public ActionResult Rezervo(int?id)
 {
     if (Session["perdorues"] == null)
     {
         TempData["login"] = "******";
         return(RedirectToAction("LogIn", "Perdorues"));
     }
     else
     {
         Rezervimi Rezervofilm = new Rezervimi();
         Rezervofilm.filmi_salla = db.Filma_Salla.Where(x => x.Id_Filmi == id).ToList <Filma_Salla>();
         Rezervofilm.film        = db.Filmis.Where(x => x.Id_Filmi == id).FirstOrDefault();
         return(View(Rezervofilm));
     }
 }
Пример #7
0
        public ActionResult Rezervo(Rezervimi rezervimi, int?id)
        {
            try
            {
                if (id == null)
                {
                    return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
                }
                DateTime?orari          = rezervimi.orari;
                var      id_salla       = db.Filma_Salla.Where(x => x.Id_Filmi == id && x.Orari == orari).Select(x => x.Id_Salla).FirstOrDefault();
                var      id_filma_salla = db.Filma_Salla.Where(x => x.Id_Filmi == id && x.Id_Salla == id_salla).Select(x => x.Id_filmi_salla).FirstOrDefault();
                rezervimi.ID_Perdorues   = Convert.ToInt32(Session["perdorues"]);
                rezervimi.Id_filmi_salla = id_filma_salla;

                if (nr_vende(id_filma_salla) == nr_rezervime(id_filma_salla))
                {
                    TempData["msg1"] = "<script>alert('Full, nuk ka me vende te lira');</script>";

                    db.Filma_Salla.Where(p => p.Id_filmi_salla == id_filma_salla).ToList().ForEach(x => x.Salla.Statusi = "Fully booked");
                    db.SaveChanges();
                    return(RedirectToAction("Rezervo", "Filmis", new { id = id }));
                }
                else
                {
                    var v = db.Rezervimis.Where(x => x.Id_filmi_salla == id_filma_salla).Count();
                    rezervimi.vendi = v + 1;

                    if (ModelState.IsValid)
                    {
                        db.Rezervimis.Add(rezervimi);
                        db.SaveChanges();
                        TempData["rezsuccess"] = "<script>alert('U shtua me sukses!');</script>";
                    }

                    return(RedirectToAction("Rezervimet", "Perdorues", new { id = Session["perdorues"] }));
                }
            }
            catch (Exception ex)
            {
                logger.ErrorException("Error u gjend ne Filmi Controller, rezervo Action", ex);
                return(RedirectToAction("Rezervimet", "Perdorues", new { id = Session["perdorues"] }));
            }
        }
        public static void Edit(Rezervimi rezervim)
        {
            try
            {
                using (SqlConnection con = new SqlConnection(Connection.ConnectionString))
                {
                    SqlCommand cmd = new SqlCommand("sp_ShtyejRezervimin", con);
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    con.Open();
                    cmd.Parameters.AddWithValue("@RezervimiID", rezervim.RezervimiID);
                    cmd.Parameters.AddWithValue("@MbarimiRezervimit", rezervim.MbarimiRezervimit);

                    cmd.ExecuteNonQuery();
                    con.Close();
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
 public static void Insert(Rezervimi rezervim)
 {
     try
     {
         using (SqlConnection con = new SqlConnection(Connection.ConnectionString))
         {
             SqlCommand cmd = new SqlCommand("sp_ShtoRezervim", con);
             cmd.CommandType = System.Data.CommandType.StoredProcedure;
             con.Open();
             cmd.Parameters.AddWithValue("@UserID", rezervim.User.UserID);
             cmd.Parameters.AddWithValue("@FushaID", rezervim.Fusha.FushaID);
             cmd.Parameters.AddWithValue("@KlientiID", rezervim.Klienti.KlientiID);
             cmd.Parameters.AddWithValue("@DataRezervimit", rezervim.DataERezervimit);
             cmd.Parameters.AddWithValue("@FillimiRezervimit", rezervim.FillimiRezervimit);
             cmd.Parameters.AddWithValue("@MbarimiRezervimit", rezervim.MbarimiRezervimit);
             cmd.ExecuteNonQuery();
             con.Close();
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
 public static bool CheckReservation(Rezervimi rezervimi)
 {
     return(AccessRezervimi.CheckReservation(rezervimi));
 }
 public static void EditRezervim(Rezervimi rezervim)
 {
     AccessRezervimi.Edit(rezervim);
 }
 public static void InsertRezervim(Rezervimi rezervimi)
 {
     AccessRezervimi.Insert(rezervimi);
 }
        public static Rezervimi GetByID(int rezervimiID)
        {
            Rezervimi rezervim = null;

            try
            {
                using (SqlConnection con = new SqlConnection(Connection.ConnectionString))
                {
                    SqlCommand cmd = new SqlCommand("sp_GetAllRezervimetByID", con);
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@RezervimiID", rezervimiID);
                    con.Open();

                    using (SqlDataReader sqlr = cmd.ExecuteReader())
                    {
                        if (sqlr.HasRows)
                        {
                            rezervim = new Rezervimi();

                            while (sqlr.Read())
                            {
                                rezervim.RezervimiID              = int.Parse(sqlr["RezervimiID"].ToString());
                                rezervim.User                     = new User();
                                rezervim.User.UserID              = int.Parse(sqlr["UserID"].ToString());
                                rezervim.User.Emri                = sqlr["User_Emri"].ToString();
                                rezervim.User.Mbiemri             = sqlr["User_Mbiemri"].ToString();
                                rezervim.User.Email               = sqlr["Email"].ToString();
                                rezervim.User.Password            = sqlr["Password"].ToString();
                                rezervim.User.NrKontaktues        = sqlr["User_NrKontaktues"].ToString();
                                rezervim.User.DataLindjes         = Convert.ToDateTime(sqlr["DataELindjes"].ToString());
                                rezervim.User.Adresa              = sqlr["Adresa"].ToString();
                                rezervim.User.TipiUser            = new TipiUser();
                                rezervim.User.TipiUser.TipiID     = int.Parse(sqlr["TipiID"].ToString());
                                rezervim.User.TipiUser.Pershkrimi = sqlr["Pershkrimi"].ToString();
                                rezervim.Fusha                    = new Fusha();
                                rezervim.Fusha.FushaID            = int.Parse(sqlr["FushaID"].ToString());
                                rezervim.Fusha.FushaEMbuluar      = (sqlr["FushaEMbuluar"].ToString() == "1" ? true : false);
                                rezervim.Fusha.BariArtificial     = (sqlr["BariArtificial"].ToString() == "1" ? true : false);
                                rezervim.Fusha.Gjatesia           = sqlr["Gjatesia"].ToString();
                                rezervim.Fusha.Gjeresia           = sqlr["Gjeresia"].ToString();
                                rezervim.Fusha.CmimiFushes        = double.Parse(sqlr["CmimiIFushes"].ToString());
                                rezervim.Klienti                  = new Klienti();
                                rezervim.Klienti.KlientiID        = int.Parse(sqlr["KlientiID"].ToString());
                                rezervim.Klienti.Emri             = sqlr["Klient_Emri"].ToString();
                                rezervim.Klienti.Mbiemri          = sqlr["Klient_Mbiemri"].ToString();
                                rezervim.Klienti.NrKontaktues     = sqlr["Klient_NrKontaktues"].ToString();
                                rezervim.DataERezervimit          = Convert.ToDateTime(sqlr["DataERezervimit"].ToString());
                                rezervim.FillimiRezervimit        = Convert.ToDateTime(sqlr["FillimiRezervimit"].ToString());
                                rezervim.MbarimiRezervimit        = Convert.ToDateTime(sqlr["MbarimiRezervimit"].ToString());
                                rezervim.Pagesa                   = double.Parse(sqlr["Pagesa"].ToString());
                                rezervim.IsActive                 = bool.Parse(sqlr["IsActive"].ToString());
                            }
                        }
                    }
                    con.Close();
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(rezervim);
        }