public static void selectMuaGiai(string MaMuaGiai, out MUAGIAI muagiai) { SqlConnection conn = DatabaseManager.Instance.getConnection(); string queryString = "SELECT TenMuaGiai, TrangThai FROM MUAGIAI WHERE MaMuaGiai = @MaMuaGiai"; SqlCommand command = new SqlCommand(queryString); muagiai = new MUAGIAI() { MaMuaGiai = MaMuaGiai, TenMuaGiai = "", TrangThai = 0, }; try { command.Parameters.AddWithValue("@MaMuaGiai", MaMuaGiai); command.Connection = conn; SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { muagiai.TenMuaGiai = reader.GetString(0); muagiai.TrangThai = reader.GetInt32(1); } reader.Close(); } catch (SqlException SQLex) { throw SQLex; } catch (Exception ex) { throw ex; } }
public static void updateMuaGiai(MUAGIAI muagiai) { SqlConnection conn = DatabaseManager.Instance.getConnection(); string queryString = "UPDATE MUAGIAI SET TenMuaGiai = @TenMuaGiai, TrangThai = @TrangThai WHERE MaMuaGiai = @MaMuaGiai"; SqlCommand command = new SqlCommand(queryString); try { command.Parameters.AddWithValue("@TenMuaGiai", muagiai.TenMuaGiai); command.Parameters.AddWithValue("@TrangThai", muagiai.TrangThai); command.Parameters.AddWithValue("@MaMuaGiai", muagiai.MaMuaGiai); command.Connection = conn; int res = command.ExecuteNonQuery(); if (res == 0) { throw new Exception(); } } catch (SqlException SQLex) { throw SQLex; } catch (Exception ex) { throw ex; } }
public static string queryMaMuaGiai(MUAGIAI muagiai) { SqlConnection conn = DatabaseManager.Instance.getConnection(); string queryString = "SELECT MaMuaGiai FROM MUAGIAI WHERE TenMuaGiai = @TenMuaGiai AND TrangThai = @TrangThai"; SqlCommand command = new SqlCommand(queryString); string result = ""; try { command.Parameters.AddWithValue("@TenMuaGiai", muagiai.TenMuaGiai); command.Parameters.AddWithValue("@TrangThai", muagiai.TrangThai); command.Connection = conn; SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { result = reader.GetString(0); } reader.Close(); } catch (SqlException SQLex) { throw SQLex; } catch (Exception ex) { throw ex; } return(result); }
public static void createMuaGiai(MUAGIAI muagiai) { SqlConnection conn = DatabaseManager.Instance.getConnection(); string queryString = "INSERT INTO MUAGIAI Values (NEWID(), @TenMuaGiai, @TrangThai)"; SqlCommand command = new SqlCommand(queryString); try { command.Parameters.AddWithValue("@TenMuaGiai", muagiai.TenMuaGiai); command.Parameters.AddWithValue("@TrangThai", 0); command.Connection = conn; int res = command.ExecuteNonQuery(); if (res == 0) { throw new Exception(); } } catch (SqlException SQLex) { throw SQLex; } catch (Exception ex) { throw ex; } }
public ActionResult DeleteConfirmed(string id) { MUAGIAI mUAGIAI = db.MUAGIAIs.Find(id); db.MUAGIAIs.Remove(mUAGIAI); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "MaMua,TenMua,NgayBatDau,NgayKetThuc,MaTS,MaTTUT")] MUAGIAI mUAGIAI) { if (ModelState.IsValid) { db.Entry(mUAGIAI).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaTS = new SelectList(db.THAMSOes, "MaTS", "MaTS", mUAGIAI.MaTS); return(View(mUAGIAI)); }
// GET: MuaGiai/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MUAGIAI mUAGIAI = db.MUAGIAIs.Find(id); if (mUAGIAI == null) { return(HttpNotFound()); } return(View(mUAGIAI)); }
// GET: MuaGiai/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MUAGIAI mUAGIAI = db.MUAGIAIs.Find(id); if (mUAGIAI == null) { return(HttpNotFound()); } ViewBag.MaTS = new SelectList(db.THAMSOes, "MaTS", "MaTS", mUAGIAI.MaTS); return(View(mUAGIAI)); }
private void KhoiTaoMuaGiaiButton_Click(object sender, EventArgs e) { //call data access try { MUAGIAI muagiai = new MUAGIAI() { TenMuaGiai = tenMuaGiaTextBox.Text, TrangThai = 0, }; Database.MuaGiai_DAO.createMuaGiai(muagiai); string new_MaMuaGiai = Database.MuaGiai_DAO.queryMaMuaGiai(muagiai); DIEUKIEN dk = new DIEUKIEN() { MaMuaGiai = new_MaMuaGiai, SoCauThuToiThieu = 11, SoCauThuToiDa = 40, TuoiToiDa = 40, TuoiToiThieu = 18, SoLanThayNguoiToiDa = 3, SoCauThuNuocNgoaiToiDa = 3, DiemSoHoa = 1, DiemSoThang = 3, DiemSoThua = 0 }; Database.DieuKien_DAO.createDIEUKIEN(dk); THUTUUUTIEN thutu = new THUTUUUTIEN() { ChiSoUuTien = 1, MaMuaGiai = new_MaMuaGiai, TenLoaiUuTien = "Điểm", }; Database.ThuTuUuTien_DAO.createThuTuUuTien(thutu); THUTUUUTIEN thutu2 = new THUTUUUTIEN() { ChiSoUuTien = 2, MaMuaGiai = new_MaMuaGiai, TenLoaiUuTien = "Hiệu Số", }; Database.ThuTuUuTien_DAO.createThuTuUuTien(thutu2); THUTUUUTIEN thutu3 = new THUTUUUTIEN() { ChiSoUuTien = 3, MaMuaGiai = new_MaMuaGiai, TenLoaiUuTien = "Số Bàn Sân Khách", }; Database.ThuTuUuTien_DAO.createThuTuUuTien(thutu3); THUTUUUTIEN thutu4 = new THUTUUUTIEN() { ChiSoUuTien = 4, MaMuaGiai = new_MaMuaGiai, TenLoaiUuTien = "Kết Quả Đối Đầu", }; Database.ThuTuUuTien_DAO.createThuTuUuTien(thutu4); } catch (Exception ex) { MessageBox.Show(ex.Message, "Lỗi xảy ra"); } // Kiểm tra điền đầy đủ thông tin chưa? Nếu đầy đủ thì sẽ tiến thẳng tới màn hình if (ValidateChildren(ValidationConstraints.Enabled)) { FirstScreen form = new FirstScreen(); this.Hide(); form.ShowDialog(); } }