Exemple #1
0
        public ActionResult Delete(int id, FormCollection collection)
        {
            try
            {
                BilietasEditViewModel bilietas = bilietaiRepository.getBilietas(id);
                //       bool naudojama = false;

                //       if (modeliuRepository.getModelisCount(id)>0)
                //       {
                //           naudojama = true;
                //           ViewBag.naudojama = "Negalima pašalinti modelio, yra sukurtų automobilių su šiuo modeliu.";
                //           return View(modelis);
                //       }


                bilietaiRepository.deleteBilietas(id);



                return(RedirectToAction("Index"));
            }
            catch
            {
                return(View());
            }
        }
Exemple #2
0
        public ActionResult Create()
        {
            BilietasEditViewModel bilietas = new BilietasEditViewModel();

            PopulateSelections(bilietas);
            return(View(bilietas));
        }
Exemple #3
0
        public ActionResult Edit(int id)
        {
            BilietasEditViewModel bilietas = bilietaiRepository.getBilietas(id);

            PopulateSelections(bilietas);
            return(View(bilietas));
        }
Exemple #4
0
        public BilietasEditViewModel getBilietas(int id)
        {
            BilietasEditViewModel bilietas = new BilietasEditViewModel();

            string          conn            = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
            MySqlConnection mySqlConnection = new MySqlConnection(conn);
            string          sqlquery        = @"SELECT m.* 
                                FROM " + @"bilietai m WHERE m.bilieto_id=" + id;
            MySqlCommand    mySqlCommand    = new MySqlCommand(sqlquery, mySqlConnection);

            mySqlConnection.Open();
            MySqlDataAdapter mda = new MySqlDataAdapter(mySqlCommand);
            DataTable        dt  = new DataTable();

            mda.Fill(dt);
            mySqlConnection.Close();

            foreach (DataRow item in dt.Rows)
            {
                bilietas.id          = Convert.ToInt32(item["bilieto_id"]);
                bilietas.kaina       = Convert.ToInt32(item["kaina"]);
                bilietas.fk_klientas = Convert.ToInt32(item["fk_klientaikliento_id"]);
            }

            return(bilietas);
        }
Exemple #5
0
        public void PopulateSelections(BilietasEditViewModel bilietas)
        {
            var klientai = klientaiRepository.getKlientai();
            List <SelectListItem> selectListKlientai = new List <SelectListItem>();

            foreach (var item in klientai)
            {
                selectListKlientai.Add(new SelectListItem()
                {
                    Value = Convert.ToString(item.id), Text = (item.asmens_kodas + " " + item.vardas + " " + item.pavarde)
                });
            }

            bilietas.KlientasList = selectListKlientai;
        }
Exemple #6
0
        public bool updateBilietas(BilietasEditViewModel bilietas)
        {
            string          conn            = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
            MySqlConnection mySqlConnection = new MySqlConnection(conn);
            string          sqlquery        = @"UPDATE " + "bilietai a SET a.kaina=?kaina, a.fk_klientaikliento_id=?klientas WHERE a.bilieto_id=?id";
            MySqlCommand    mySqlCommand    = new MySqlCommand(sqlquery, mySqlConnection);

            mySqlCommand.Parameters.Add("?id", MySqlDbType.Int32).Value       = bilietas.id;
            mySqlCommand.Parameters.Add("?kaina", MySqlDbType.Int32).Value    = bilietas.kaina;
            mySqlCommand.Parameters.Add("?klientas", MySqlDbType.Int32).Value = bilietas.fk_klientas;
            mySqlConnection.Open();
            mySqlCommand.ExecuteNonQuery();
            mySqlConnection.Close();
            return(true);
        }
Exemple #7
0
        public bool addBilietas(BilietasEditViewModel bilietas)
        {
            string          conn            = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
            MySqlConnection mySqlConnection = new MySqlConnection(conn);
            string          sqlquery        = @"INSERT INTO " + "bilietai(bilieto_id,kaina,fk_klientaikliento_id)VALUES(?id,?kaina,?raktas)";
            MySqlCommand    mySqlCommand    = new MySqlCommand(sqlquery, mySqlConnection);

            mySqlCommand.Parameters.Add("?id", MySqlDbType.Int32).Value       = bilietas.id;
            mySqlCommand.Parameters.Add("?kaina", MySqlDbType.Int32).Value    = bilietas.kaina;
            mySqlCommand.Parameters.Add("?raktas", MySqlDbType.VarChar).Value = bilietas.fk_klientas;
            mySqlConnection.Open();
            mySqlCommand.ExecuteNonQuery();
            mySqlConnection.Close();
            return(true);
        }
Exemple #8
0
        public ActionResult Edit(int id, BilietasEditViewModel collection)
        {
            try
            {
                // TODO: Add update logic here
                if (ModelState.IsValid)
                {
                    bilietaiRepository.updateBilietas(collection);
                }

                return(RedirectToAction("Index"));
            }
            catch
            {
                PopulateSelections(collection);
                return(View(collection));
            }
        }
Exemple #9
0
        public ActionResult Create(BilietasEditViewModel collection)
        {
            try
            {
                // TODO: Add insert logic here
                if (ModelState.IsValid)
                {
                    collection.id = bilietaiRepository.getNewId();
                    bilietaiRepository.addBilietas(collection);
                }

                return(RedirectToAction("Index"));
            }
            catch
            {
                PopulateSelections(collection);
                return(View(collection));
            }
        }
Exemple #10
0
        public ActionResult Delete(int id)
        {
            BilietasEditViewModel bilietas = bilietaiRepository.getBilietas(id);

            return(View(bilietas));
        }