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 })); }