private void btnThemTKB_Click_1(object sender, EventArgs e)
{
try
{
LichDay ld = new LichDay();
ld.MaTKB = int.Parse(txbMaTKB.Text.ToString());
ld.MaLop = cbMalop_TKB.Text.Trim();
ld.MaGiaoVien = cbMaGV_TKB.Text.Trim();
ld.MaMonHoc = cbMaMonhoc_TKB.Text.Trim();
ld.MaHocKy = cbMaHocKy.Text.Trim();
ld.NamHoc = txbNamHoc.Text.Trim();
ld.Thu = int.Parse(txbThu.Text.ToString());
ld.Tiet_bd = int.Parse(txbTutiet.Text.ToString());
ld.Tiet_kt = int.Parse(txbDentiet.Text.ToString());
if (ld_bll.ThemLichDay(ld))
{
MessageBox.Show("Thêm thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Thêm không thành công!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Load_LichDay();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool ThemLichDay(LichDay ld)
{
OpenConnection();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into thoiKhoaBieu values(@maTKB,@lopma,@GVma, @monHocMa, @thu, @tu, @den, @namHoc,@hocKyMa)";
cmd.Connection = conn;
cmd.Parameters.Add("@maTKB", SqlDbType.Int).Value = ld.MaTKB;
cmd.Parameters.Add("@lopma", SqlDbType.VarChar).Value = ld.MaLop;
cmd.Parameters.Add("@GVma", SqlDbType.VarChar).Value = ld.MaGiaoVien;
cmd.Parameters.Add("@monHocMa", SqlDbType.VarChar).Value = ld.MaMonHoc;
cmd.Parameters.Add("@thu", SqlDbType.Int).Value = ld.Thu;
cmd.Parameters.Add("@tu", SqlDbType.Int).Value = ld.Tiet_bd;
cmd.Parameters.Add("@den", SqlDbType.Int).Value = ld.Tiet_kt;
cmd.Parameters.Add("@namHoc", SqlDbType.NVarChar).Value = ld.NamHoc;
cmd.Parameters.Add("@hocKyMa", SqlDbType.VarChar).Value = ld.MaHocKy;
int kq = cmd.ExecuteNonQuery();
if (kq > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool SuaLichDay(LichDay ld)
{
OpenConnection();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "update thoiKhoaBieu set lopma=@lopma, GVma=@GVma, monHocMa=@monHocMa, thu=@thu, tu=@tu, den=@den, namHoc=@namHoc, hocKyMa=@hocKyMa where maTKB=@maTKB";
cmd.Connection = conn;
cmd.Parameters.Add("@maTKB", SqlDbType.Int).Value = ld.MaTKB;
cmd.Parameters.Add("@lopma", SqlDbType.VarChar).Value = ld.MaLop;
cmd.Parameters.Add("@GVma", SqlDbType.VarChar).Value = ld.MaGiaoVien;
cmd.Parameters.Add("@monHocMa", SqlDbType.VarChar).Value = ld.MaMonHoc;
cmd.Parameters.Add("@thu", SqlDbType.Int).Value = ld.Thu;
cmd.Parameters.Add("@tu", SqlDbType.Int).Value = ld.Tiet_bd;
cmd.Parameters.Add("@den", SqlDbType.Int).Value = ld.Tiet_kt;
cmd.Parameters.Add("@namHoc", SqlDbType.NVarChar).Value = ld.NamHoc;
cmd.Parameters.Add("@hocKyMa", SqlDbType.VarChar).Value = ld.MaHocKy;
int kq = cmd.ExecuteNonQuery();
if (kq > 0)
{
return(true);
}
else
{
return(false);
}
}
public List <LichDay> ThongTinLichDay()
{
List <LichDay> ttLichDay = new List <LichDay>();
OpenConnection();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from thoiKhoaBieu";
cmd.Connection = conn;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
LichDay ld = new LichDay();
ld.MaTKB = reader.GetInt32(0);
ld.MaLop = reader.GetString(1);
ld.MaGiaoVien = reader.GetString(2);
ld.MaMonHoc = reader.GetString(3);
ld.Thu = reader.GetInt32(4);
ld.Tiet_bd = reader.GetInt32(5);
ld.Tiet_kt = reader.GetInt32(6);
ld.NamHoc = reader.GetString(7);
ld.MaHocKy = reader.GetString(8);
ttLichDay.Add(ld);
}
reader.Close();
return(ttLichDay);
}
public List <LichDay> TimKiemLichDay(int MaTKB)
{
List <LichDay> ttLichDay = new List <LichDay>();
OpenConnection();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from thoiKhoaBieu where MaTKB= @maTKB";
cmd.Connection = conn;
cmd.Parameters.Add("@maTKB", SqlDbType.Int).Value = MaTKB;
//cmd.Parameters.Add("@lopma", SqlDbType.VarChar).Value = MaLop;
//cmd.Parameters.Add("@GVMa", SqlDbType.VarChar).Value = MaGiaoVien;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
LichDay ld = new LichDay();
ld.MaTKB = reader.GetInt32(0);
ld.MaLop = reader.GetString(2);
ld.MaGiaoVien = reader.GetString(3);
ld.MaMonHoc = reader.GetString(3);
ld.Thu = reader.GetInt32(4);
ld.Tiet_bd = reader.GetInt32(5);
ld.Tiet_kt = reader.GetInt32(6);
ld.NamHoc = reader.GetString(7);
ld.MaHocKy = reader.GetString(8);
ttLichDay.Add(ld);
}
reader.Close();
return(ttLichDay);
}
public IHttpActionResult Update(UpdateLichDayModel model)
{
IHttpActionResult httpActionResult;
LichDay lichDay = db.LichDays.FirstOrDefault(x => x.Id == model.Id);
if (lichDay == null)
{
err.Add("Không tìm thấy");
}
if (model.TGBatDau.HasValue && model.TGBatDau < DateTime.Now)
{
err.Add("Thời gian bắt đầu phải lớn hơn ngày hiện tại");
}
if (model.TGKetThuc.HasValue && model.TGKetThuc < model.TGBatDau)
{
err.Add("Thời gian kết thúc phải lớn hơn bắt đầu");
}
if (err.errors.Count == 0)
{
lichDay.GiaoVien = db.GiaoViens.FirstOrDefault(x => x.Id == model.GvId) ?? db.GiaoViens.FirstOrDefault(x => x.Id == model.GvId);
lichDay.Lop = db.Lops.FirstOrDefault(x => x.Id == model.LopId) ?? db.Lops.FirstOrDefault(x => x.Id == model.LopId);
lichDay.TGBatDau = model.TGBatDau ?? model.TGBatDau;
lichDay.TgKetThuc = model.TGKetThuc ?? model.TGKetThuc;
db.Entry(lichDay).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
httpActionResult = Ok(new LichDayModel(lichDay));
}
else
{
httpActionResult = Ok(err);
}
return(httpActionResult);
}
public LichDayModel(LichDay lichDay)
{
Id = lichDay.Id;
TenGV = lichDay.GiaoVien.HoTen;
TenLop = lichDay.Lop.TenLop;
TGBatDau = lichDay.TGBatDau;
TGKetThuc = lichDay.TgKetThuc;
}
public IHttpActionResult Create(CreateLichDayModel model)
{
IHttpActionResult httpActionResult;
Lop lop = db.Lops.FirstOrDefault(x => x.Id == model.LopId);
if (lop == null)
{
err.Add("Lớp không tồn tại");
}
GiaoVien giaovien = db.GiaoViens.FirstOrDefault(x => x.Id == model.GvId);
if (giaovien == null)
{
err.Add("Giáo viên không tồn tại");
}
if (model.TGBatDau.HasValue && model.TGBatDau < DateTime.Now)
{
err.Add("Thời gian bắt đầu phải lớn hơn ngày hiện tại");
}
if (model.TGKetThuc.HasValue && model.TGKetThuc < model.TGBatDau)
{
err.Add("Thời gian kết thúc phải lớn hơn bắt đầu");
}
if (err.errors.Count == 0)
{
LichDay lichDay = new LichDay();
lichDay.GiaoVien = db.GiaoViens.FirstOrDefault(x => x.Id == model.GvId);
lichDay.Lop = db.Lops.FirstOrDefault(x => x.Id == model.LopId);
lichDay.TGBatDau = model.TGBatDau;
lichDay.TgKetThuc = model.TGKetThuc;
lichDay = db.LichDays.Add(lichDay);
db.SaveChanges();
LichDayModel viewmodel = new LichDayModel(lichDay);
httpActionResult = Ok(viewmodel);
}
else
{
httpActionResult = Ok(err);
}
return(httpActionResult);
}
public bool SuaLichDay(LichDay ld)
{
return(ld_dal.SuaLichDay(ld));
}
public bool ThemLichDay(LichDay ld)
{
return(ld_dal.ThemLichDay(ld));
}
