Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
 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");
         }
     }
 }
Exemplo n.º 3
0
        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());
        }
Exemplo n.º 4
0
        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);
        }
Exemplo n.º 7
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));
        }
Exemplo n.º 8
0
        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);
        }
Exemplo n.º 9
0
        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);
        }
Exemplo n.º 10
0
        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);
        }
Exemplo n.º 12
0
        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();
        }
Exemplo n.º 14
0
        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);
        }
Exemplo n.º 18
0
        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);
        }
Exemplo n.º 19
0
        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);
        }
Exemplo n.º 20
0
        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);
        }
Exemplo n.º 23
0
        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);
        }
Exemplo n.º 25
0
        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);
        }
Exemplo n.º 27
0
        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);
        }
Exemplo n.º 29
0
        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);
        }
Exemplo n.º 30
0
 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;
 }
Exemplo n.º 31
0
        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 }));
        }