public bool ThemChiTietPhieuThue(List <eThongTinPhieuThue> listTtPT, int idPhieuThue)
{
foreach (eThongTinPhieuThue item in listTtPT)
{
ChiTietPhieuThue ctpt = new ChiTietPhieuThue();
ctpt.IdChiTietPhieuThue = LayIdChiTietPhieuThueLonNhat() + 1;
ctpt.IdDia = item.IdDia;
ctpt.NgayTraDiaDuKien = item.NgayTraDiaDuKien;
ctpt.PhiThue = item.PhiThue;
ctpt.NgayTraDiaThucTe = null;
ctpt.PhiTre = item.PhiTreHan;
ctpt.TrangThaiNoPhiTre = false;
ctpt.TrangThaiTraPhiTre = false;
ctpt.IdPhieuThue = idPhieuThue;
db.ChiTietPhieuThues.InsertOnSubmit(ctpt);
db.SubmitChanges();
Dia dia = new Dia();
TieuDe td = new TieuDe();
dia = db.Dias.Where(a => a.IdDia == item.IdDia).SingleOrDefault();
td = db.TieuDes.SingleOrDefault(p => p.IdTieuDe == dia.IdTieuDe);
dia.TrangThaiThue = "duocthue";
td.SoLuongDiaCoSan = td.SoLuongDiaCoSan - 1;
db.SubmitChanges();
}
return(true);
}
private void bt_luu_Click(object sender, EventArgs e)//luu
{
if (isThem == true)
{
try
{
TieuDe td = new TieuDe();
//td.ThemTieuDe("Ad net", "ngu qua", "0235", "901", "16145255", ref error) ;
td.ThemTieuDe(this.tb_mtd.Text, this.tb_td.Text, this.tb_ntg.Text, this.tb_tlnc.Text, this.cbb_ql.Text, ref error);
MessageBox.Show(error.ToString());
Loaddata();
MessageBox.Show("Đã thêm");
}
catch (SqlException)
{
MessageBox.Show("Lỗi thêm");
}
}
else
{
try
{
TieuDe td = new TieuDe();
td.CapNhatTieuDe(this.tb_mtd.Text, this.tb_td.Text, this.tb_ntg.Text, this.tb_tlnc.Text, this.cbb_ql.Text, ref error);
Loaddata();
MessageBox.Show("Đã Cập Nhật!");
}
catch (SqlException)
{
MessageBox.Show("Lỗi khi sửa");
}
}
}
public int Delete(int idxoa)
{
var p = new TieuDe();
p = context.tieudes.First(x => x.id_TieuDe.Equals(idxoa));
context.tieudes.Remove(p);
return(context.SaveChanges());
}
public int Save(eTieuDe item)
{
TieuDe tam = new TieuDe();
tam.tenTieuDe = item.tenTieuDe;
tam.id_TheLoai = item.id_TheLoai;
tddal.Save(tam);
return(1);
}
public bool kiemtraTieuDeDaTonTai(string tenTieuDe)
{
TieuDe td = db.TieuDes.SingleOrDefault(p => p.TenTieuDe == tenTieuDe);
if (td != null)
{
return(true);
}
return(false);
}
int chisoTieuDe()
{
TieuDe pt = db.TieuDes.ToList().LastOrDefault();
if (pt != null)
{
return(Int32.Parse(pt.MaTieuDe.Substring(2)));
}
return(0);
}
public ActionResult EditTieuDe(TieuDe model, string url)
{
var db = DB.Entities;
// Add new
db.AttachTo("TieuDe", model);
db.ObjectStateManager.ChangeObjectState(model, System.Data.EntityState.Modified);
db.SaveChanges();
return(Redirect(url));
}
public eTieuDe Find(int id)
{
TieuDe t = tddal.Find(id);
eTieuDe e = new eTieuDe();
e.id_TieuDe = t.id_TieuDe;
e.tenTieuDe = t.tenTieuDe;
e.id_TheLoai = t.id_TheLoai;
return(e);
}
public eTieuDe FindTieuDeById(int id)
{
TieuDe d = pdtdal.FindTieuDeById(id);
eTieuDe tam = new eTieuDe();
tam.id_TieuDe = d.id_TieuDe;
tam.tenTieuDe = d.tenTieuDe;
tam.id_TheLoai = d.id_TheLoai;
return(tam);
}
public PhieuDatTruoc FindbyID(int id)
{
TieuDe c = context.tieudes.First(p => p.id_TieuDe == id);
PhieuDatTruoc td = new PhieuDatTruoc();
if (td.id_TieuDe == c.id_TieuDe)
{
return(td);
}
return(null);
}
public eTieuDe layTieuDeTheoMaTieuDe(string matd)
{
TieuDe td = db.TieuDes.Where(x => x.MaTieuDe.Equals(matd)).FirstOrDefault();
eTieuDe etd = new eTieuDe();
etd.MaTieuDe = td.MaTieuDe;
etd.MaLoaiDia = td.MaLoaiDia;
etd.TenTieuDe = td.TenTieuDe;
etd.NhaSanXuat = td.NhaSanXuat;
return(etd);
}
public TieuDe FindTieuDeById(int id)
{
PhieuDatTruoc c = context.phieudattruocs.First(p => p.id_TieuDe == id);
TieuDe td = new TieuDe();
if (td.id_TieuDe == c.id_TieuDe)
{
return(td);
}
return(null);
}
public void capnhatSoLuong(string idTieuDe)
{
TieuDe td = db.TieuDes.SingleOrDefault(p => p.IdTieuDe == idTieuDe);
int tongdia = db.Dias.Where(p => p.IdTieuDe == idTieuDe && p.TrangThaiXoa == false).Count();
int tongdiacosan = db.Dias.Where(p => p.IdTieuDe == idTieuDe && p.TrangThaiXoa == false && p.TrangThaiThue == "cosan").Count();
td.SoLuongDia = tongdia;
td.SoLuongDiaCoSan = tongdiacosan;
db.SubmitChanges();
}
public int Save(eTieuDe d)
{
TieuDe item = new TieuDe();
item.id_TieuDe = d.id_TieuDe;
item.tenTieuDe = d.tenTieuDe;
item.id_TheLoai = d.id_TheLoai;
tddal.Save(item);
return(1);
}
public int ThemTieuDe(eTieuDe them)
{
TieuDe td = new TieuDe();
td.MaTieuDe = sinhMaTieuDeTuSo(chisoTieuDe() + 1);
td.TenTieuDe = them.TenTieuDe;
td.NhaSanXuat = them.NhaSanXuat;
td.MaLoaiDia = them.MaLoaiDia;
db.TieuDes.InsertOnSubmit(td);
db.SubmitChanges();
return(1);
}
public int XoaTieuDe(string ma)
{
TieuDe td = db.TieuDes.Where(x => x.MaTieuDe.Equals(ma)).FirstOrDefault();
if (td != null)
{
db.TieuDes.DeleteOnSubmit(td);
db.SubmitChanges();
return(1);
}
return(0);
}
public bool capnhatTrangThaiXoa(string tenTieuDe, bool e)
{
TieuDe td = db.TieuDes.SingleOrDefault(p => p.TenTieuDe == tenTieuDe);
if (td != null)
{
td.TrangThaiXoa = e;
db.SubmitChanges();
return(true);
}
return(false);
}
public int ThemPhiTreHen(int id_DVD, double phi_tre_hen)
{
TieuDe tieu_de = context.tieudes.Where(x => x.id_TieuDe == id_DVD).FirstOrDefault();
TheLoai the_loai = context.theloais.Where(x => x.id_TheLoai == tieu_de.id_TheLoai).FirstOrDefault();
PhieuThueTra phieu = context.phieuthuetras.Where(x => x.ngayTra == null).FirstOrDefault();
if ((DateTime.Now - phieu.ngayThue).TotalDays >= the_loai.giaThue)
{
phieu.phiTreHan = phi_tre_hen;
context.SaveChanges();
}
return(1);
}
public bool themTieuDe(eTieuDe tieuDe)
{
TieuDe td = new TieuDe();
td.TieuDe1 = tieuDe.TieuDe;
td.SoLuongDia = 0;
td.GiaThue = tieuDe.GiaThue;
td.SoNgayDuocThue = tieuDe.SoNgayDuocThue;
td.LoaiDia = tieuDe.LoaiDia;
td.Deleted = false;
db.TieuDes.InsertOnSubmit(td);
db.SubmitChanges();
return(true);
}
public eTieuDe GetTieuDeByID(int id)
{
eTieuDe tam = new eTieuDe();
TieuDe item = tddal.Find(id);
if (item != null)
{
tam.id_TieuDe = item.id_TieuDe;
tam.tenTieuDe = item.tenTieuDe;
tam.id_TheLoai = item.id_TheLoai;
return(tam);
}
return(null);
}
public bool XoaTieuDe(eTieuDe etd)
{
TieuDe td = new TieuDe();
td = db.TieuDes.Where(a => a.IdTieuDe == etd.IdTieuDe).SingleOrDefault();
if (td != null)
{
td.TrangThaiXoa = etd.TrangThaiXoa;
db.SubmitChanges();
return(true);
}
return(false);
}
public bool SuaTieuDe(eTieuDe etd)
{
TieuDe td = new TieuDe();
td = db.TieuDes.Where(a => a.IdTieuDe == etd.IdTieuDe).SingleOrDefault();
if (td != null)
{
td.TenTieuDe = etd.TenTieuDe;
td.IdDanhMuc = etd.IdDanhMuc;
db.SubmitChanges();
return(true);
}
return(false);
}
private void button3_Click(object sender, EventArgs e)//xoa nhom
{
try
{
TieuDe td = new TieuDe();
td.XoaTieuDe(this.tb_mtd.Text, tb_ntg.Text, tb_tlnc.Text, ref error);
Loaddata();
MessageBox.Show("Đã xóa xong!");
}
catch (SqlException)
{
MessageBox.Show("Xảy ra lỗi trong khi xóa!");
}
}
public eTieuDe LayTieuDeTheoMa(string matieude)
{
TieuDe tieude = db.TieuDes.Where(x => x.MaTieuDe.Equals(matieude)).FirstOrDefault();
if (tieude != null)
{
eTieuDe eTieuDe = new eTieuDe();
eTieuDe.MaTieuDe = tieude.MaTieuDe;
eTieuDe.TenTieuDe = tieude.TenTieuDe;
eTieuDe.NhaSanXuat = tieude.NhaSanXuat;
eTieuDe.MaLoaiDia = tieude.MaLoaiDia;
return(eTieuDe);
}
return(null);
}
public bool deleteTieuDe(string id)
{
TieuDe khachHang = new TieuDe();
var temp = db.TieuDes.Where(kh => kh.MaTieuDe.Trim() == id).FirstOrDefault();
khachHang = (TieuDe)temp;
khachHang.Deleted = true;
try
{
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception("Lỗi không xoa được " + e.Message);
}
return(true);
}
public bool ThemTieuDe(eTieuDe etd)
{
TieuDe td = new TieuDe();
td.IdTieuDe = etd.IdTieuDe;
td.TenTieuDe = etd.TenTieuDe;
td.SoLuongDia = etd.SoLuongDia;
td.IdDanhMuc = etd.IdDanhMuc;
td.TrangThaiXoa = etd.TrangThaiXoa;
td.SoLuongDiaCoSan = etd.SoLuongDiaCoSan;
if (!db.TieuDes.Contains(td))
{
db.TieuDes.InsertOnSubmit(td);
db.SubmitChanges();
return(true);
}
return(false);
}
public bool SuaTrangThaiThueDia(string idDia)
{
Dia dia = new Dia();
dia = db.Dias.Where(a => a.IdDia == idDia).SingleOrDefault();
TieuDe td = new TieuDe();
td = db.TieuDes.SingleOrDefault(p => p.IdTieuDe == dia.IdTieuDe);
if (dia != null && td != null)
{
dia.TrangThaiThue = "cosan";
td.SoLuongDiaCoSan = td.SoLuongDiaCoSan + 1;
db.SubmitChanges();
return(true);
}
return(false);
}
public eTieuDe LayTieuDeTheoIDTieuDe(string idTieuDe)
{
eTieuDe td = new eTieuDe();
TieuDe tdd = db.TieuDes.SingleOrDefault(p => p.IdTieuDe == idTieuDe);
if (tdd != null)
{
td.IdTieuDe = tdd.IdTieuDe;
td.TenTieuDe = tdd.TenTieuDe;
td.IdDanhMuc = (int)tdd.IdDanhMuc;
td.SoLuongDia = (int)tdd.SoLuongDia;
td.SoLuongDiaCoSan = (int)tdd.SoLuongDiaCoSan;
tdd.TrangThaiXoa = tdd.TrangThaiXoa;
return(td);
}
return(null);
}
public eLoaiDia LayLoaiDiaTheoDia(eDia dia)
{
TieuDe td = db.TieuDes.Where(x => x.MaTieuDe.Equals(dia.Matieude)).FirstOrDefault();
if (td != null)
{
LoaiDia loai = db.LoaiDias.Where(x => x.MaLoaiDia.Equals(td.MaLoaiDia)).FirstOrDefault();
if (loai != null)
{
eLoaiDia eloai = new eLoaiDia();
eloai.maLoai = loai.MaLoaiDia;
eloai.tenLoai = loai.TenLoaiDia;
eloai.thoiGianThue = loai.ThoiGianThue;
eloai.giaThue = loai.GiaThue;
eloai.giaPhat = loai.GiaPhat;
return(eloai);
}
}
return(null);
}
public static TieuDe HienThiTieuDe(String bHienThi)
{
TieuDe tieude = new TieuDe();
String SQL = @"SELECT * FROM PB_ThamSo
WHERE bHienThi=@bHienThi";
SqlCommand cmd = new SqlCommand(SQL);
cmd.Parameters.AddWithValue("@bHienThi", bHienThi);
DataTable dt = Connection.GetDataTable(cmd);
if (dt.Rows.Count > 0)
{
tieude.sDong1 = dt.Rows[0]["sNoiDung"].ToString();
tieude.sDong2 = dt.Rows[1]["sNoiDung"].ToString();
tieude.sDong3 = dt.Rows[2]["sNoiDung"].ToString();
tieude.sDong4 = dt.Rows[3]["sNoiDung"].ToString();
tieude.sMauBaoCao = dt.Rows[4]["sNoiDung"].ToString();
}
return tieude;
}
public ActionResult TongHop(string fromDate, string endDate)
{
if (fromDate == null)
{
return(RedirectToAction("NewOrEdit", new { fromDate = fromDate, endDate = endDate }));
}
//DateTime start = DateTime.ParseExact(fromDate + " 12:00:00 AM", "MM/dd/yyyy HH:mm:ss tt", CultureInfo.InvariantCulture);
string[] arrFrom = fromDate.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries);
DateTime start = new DateTime(int.Parse(arrFrom[2]), int.Parse(arrFrom[1]), int.Parse(arrFrom[0]), 0, 0, 0);
DateTime end = start.AddDays(7).AddSeconds(-1);
string codedate = "" + start.Day + start.Month + start.Year;
ViewBag.CodeDate = codedate;
var db = DB.Entities;
if (db.TongHop.FirstOrDefault(m => m.Code == codedate) == null)
{
var tieude = new TieuDe()
{
Title = "LỊCH CÔNG TÁC TUẦN TỪ " + string.Format("{0:d/M}", start) + " ĐẾN " + string.Format("{0:d/M/yyyy}", end)
};
db.TieuDe.AddObject(tieude);
db.SaveChanges();
var listJob = db.JobRegister.Where(m => m.DateFrom >= start && m.DateFrom <= end).ToList();
for (int i = 0; i < 7; i++)
{
var tonghop = new TongHop()
{
FromDate = start, DayOfWeek = i, Code = codedate, TieuDeID = tieude.ID
};
db.TongHop.AddObject(tonghop);
db.SaveChanges();
foreach (var item in listJob)
{
if (((int)item.DateFrom.DayOfWeek + 6) % 7 != i)
{
continue;
}
var tonghopdetail = new TongHopDetail();
tonghopdetail.Time = item.DateFrom.TimeOfDay;
tonghopdetail.NoiDung = item.Content;
tonghopdetail.NguoiThucHien = item.NguoiThucHien;
tonghopdetail.TongHopID = tonghop.ID;
tonghopdetail.Location = item.Location;
tonghopdetail.Code = codedate;
db.TongHopDetail.AddObject(tonghopdetail);
item.Added = true;
db.ObjectStateManager.ChangeObjectState(item, System.Data.EntityState.Modified);
}
}
db.SaveChanges();
var listTH = db.TongHop.Where(m => m.Code == codedate).ToList();
ViewBag.ListTongHop = listTH;
return(RedirectToAction("NewOrEdit", new { fromDate = fromDate, endDate = endDate }));
}
else
{
ViewBag.IsEdit = true;
}
return(RedirectToAction("NewOrEdit", new { fromDate = fromDate, endDate = endDate }));
}
