Beispiel #1
0
 private void btnThem_Click(object sender, EventArgs e)
 {
     if (db != null)
     {
         DanhBa danhBa = new DanhBa
         {
             Name        = txtHoTen.Text,
             PhoneNumber = txtSoDT.Text,
             Email       = txtEmail.Text,
             idStudent   = idStudent
         };
         DanhBaService.EditContact(danhBa, idDanhBa);
         if (MessageBox.Show("Cập nhật thành công", "Thông báo", MessageBoxButtons.OK) == DialogResult.OK)
         {
             this.Close();
         }
     }
     else
     {
         DanhBa danhBa = new DanhBa
         {
             ID          = Guid.NewGuid().ToString(),
             Name        = txtHoTen.Text,
             PhoneNumber = txtSoDT.Text,
             Email       = txtEmail.Text,
             idStudent   = idStudent
         };
         DanhBaService.addContact(danhBa);
         if (MessageBox.Show("Đã Thêm thành công", "Thông báo", MessageBoxButtons.OK) == DialogResult.OK)
         {
             this.Close();
         }
     }
 }
Beispiel #2
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         OpenFileDialog ofd = new OpenFileDialog()
         {
             Filter = "CSV|*.csv", ValidateNames = true, Multiselect = false
         };
         if (ofd.ShowDialog() == DialogResult.OK)
         {
             MessageBox.Show(ofd.FileName);
             String       path = ofd.FileName;
             StreamReader sr   = new StreamReader(ofd.FileName);
             while (sr.ReadLine() != null)
             {
                 String   line   = sr.ReadLine();
                 String[] arr    = line.Split(',');
                 DanhBa   danhBa = new DanhBa()
                 {
                     ID          = arr[0],
                     Name        = arr[1],
                     PhoneNumber = arr[2],
                     Email       = arr[3],
                     idStudent   = arr[4]
                 };
                 MessageBox.Show(danhBa.Name);
                 DanhBaService.addContact(danhBa);
             }
         }
     }
     catch
     {
     }
 }
Beispiel #3
0
        private void btnXoaLienLac_Click(object sender, EventArgs e)
        {
            string sdt = (string)dgvDanhBa.CurrentRow.Cells[2].Value;

            DanhBa.xoaDanhBaFromDB(sdt);

            refreshList();

            // string tenNhom = (string)dgvNhom.CurrentRow.Cells[0].Value;
            // string tenGoi = (string)dgvDanhBa.CurrentRow.Cells[0].Value;
            // string email = (string)dgvDanhBa.CurrentRow.Cells[1].Value;
            //string sdt = (string)dgvDanhBa.CurrentRow.Cells[2].Value;
            // string path = Application.StartupPath + @"/DATA/DanhBa.txt";
            // string[] lines = File.ReadAllLines(path);
            // File.WriteAllText(path, "");
            // for (int i = 0; i < lines.Length; i++)
            //  {
            //    string[] temp = lines[i].Split(new char[] { '#' });
            //    if (temp[0].Equals(tenNhom) && temp[1].Equals(tenGoi) && temp[2].Equals(email) && temp[3].Equals(sdt))
            //    {
            //   }
            //    else
            //   {
            //        File.AppendAllText(path, lines[i] + System.Environment.NewLine, Encoding.UTF8);
            //    }
            //}
        }
Beispiel #4
0
 private void txtSearch_KeyUp(object sender, KeyEventArgs e)
 {
     if (e.KeyCode == Keys.Enter)
     {
         string        key     = txtSearch.Text;
         string        tenNhom = (string)dgvNhom.CurrentCell.Value;
         List <DanhBa> list    = DanhBa.getDanhBaTheoNhom(tenNhom);
         List <DanhBa> rs      = new List <DanhBa>();
         for (int i = 0; i < list.Count; i++)
         {
             if (list.ElementAt(i).tenGoi.Equals(key) || list.ElementAt(i).email.Equals(key) || list.ElementAt(i).sdt.Equals(key))
             {
                 rs.Add(list.ElementAt(i));
             }
         }
         bdsDanhBa.DataSource = rs;
         dgvDanhBa.DataSource = bdsDanhBa;
     }
     if (txtSearch.Text.Equals(""))
     {
         string        tenNhom = (string)dgvNhom.CurrentCell.Value;
         List <DanhBa> list    = DanhBa.getDanhBaTheoNhom(tenNhom);
         bdsDanhBa.DataSource = list;
         dgvDanhBa.DataSource = bdsDanhBa;
     }
 }
Beispiel #5
0
        private void btnEdit_Click(object sender, EventArgs e)
        {
            DanhBa         d       = bdsContact.Current as DanhBa;
            frmEditContact frmEdit = new frmEditContact(d, null, d.ID);

            frmEdit.ShowDialog();
            loadData();
        }
Beispiel #6
0
        private void dgvNhom_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            string        tenNhom = (string)dgvNhom.CurrentCell.Value;
            List <DanhBa> list    = DanhBa.getDanhBaTheoNhom(tenNhom);

            bdsDanhBa.DataSource = list;
            dgvDanhBa.DataSource = bdsDanhBa;
        }
Beispiel #7
0
        public static void EditContact(DanhBa danhBa, String id)
        {
            DanhBa dBa = db.danhBas.Where(e => e.ID.Equals(id)).FirstOrDefault();

            dBa.Name        = danhBa.Name;
            dBa.PhoneNumber = danhBa.PhoneNumber;
            dBa.Email       = danhBa.Email;
            db.SaveChanges();
        }
Beispiel #8
0
        private void Dvg1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            var nhom = (Nhom)bds1.Current;

            danhba = DanhBa.GetListFromFile(pathDataDanhBa, nhom.TenNhom);
            gridLienLac.AutoGenerateColumns = false;
            bds2.DataSource        = danhba;
            gridLienLac.DataSource = bds2;
        }
Beispiel #9
0
 private void frmDanhBaBuuDien_Load(object sender, EventArgs e)
 {
     try
     {
         List <DanhBaCongTy> listDBBuuDien = DanhBa.GetDanhBa_BuuDien_1();
         gridDanhBaBuuDien.DataSource = listDBBuuDien;
     }
     catch (Exception ex)
     {
         LogError.WriteLogError("frmDanhBaBuuDien_Load: ", ex);
     }
 }
        protected void LoadDataByID(string id)
        {
            DanhBa danhba = db.DanhBas.SingleOrDefault(x => x.masothue == masothue);

            if (danhba != null)
            {
                DateTime ngaycapcmnd, ngaycapmst, ngaysinh, ngaybatdaukd, ngaytinhthue;
                ngaycapcmnd  = DateTime.Now;
                ngaycapmst   = DateTime.Now;
                ngaysinh     = DateTime.Now;
                ngaybatdaukd = DateTime.Now;
                ngaytinhthue = DateTime.Now;
                if (danhba.ngaycapcmnd != null)
                {
                    ngaycapcmnd = (DateTime)danhba.ngaycapcmnd;
                }
                if (danhba.ngaycapmst != null)
                {
                    ngaycapmst = (DateTime)danhba.ngaycapmst;
                }
                if (danhba.ngaysinh != null)
                {
                    ngaysinh = (DateTime)danhba.ngaysinh;
                }
                if (danhba.ngaybatdaukd != null)
                {
                    ngaybatdaukd = (DateTime)danhba.ngaybatdaukd;
                }
                if (danhba.ngaytinhthue != null)
                {
                    ngaytinhthue = (DateTime)danhba.ngaytinhthue;
                }
                txtCMND.Text          = danhba.cmnd;
                txtDiaChi.Text        = danhba.diachiKD;
                txtHoTen.Text         = danhba.hoten;
                txtNgayCapCMND.Text   = ngaycapcmnd.ToString("dd/MM/yyyy");
                txtNgayCapMST.Text    = ngaycapmst.ToString("dd/MM/yyyy");
                txtNgaySinh.Text      = ngaysinh.ToString("dd/MM/yyyy");
                txtTenCuaHang.Text    = danhba.tencuahang;
                txtNghekinhDoanh.Text = danhba.nghekinhdoanh;
                txtNam.Text           = danhba.nam;
                txtVonKD.Text         = danhba.vonkd.ToString();
                txtNgayBatDauKD.Text  = ngaybatdaukd.ToString("dd/MM/yyyy");
                txtNgayTinhThue.Text  = ngaytinhthue.ToString("dd/MM/yyyy");
                txtSoDT.Text          = danhba.sodt;
                txtSoGP.Text          = danhba.sogp;
                txtEmail.Text         = danhba.email;
                txtGhiChu.Text        = danhba.ghichu;
                masothue = danhba.masothue;
                cboQuan.SelectedValue       = danhba.maduongpho.maquan.Value.ToString();
                cboMaDuongPho.SelectedValue = danhba.madp;
            }
        }
Beispiel #11
0
        private void btnRefresh_Click(object sender, EventArgs e)
        {
            List <Nhom> listNhom = Nhom.getNhom();

            bdsNhom.DataSource = listNhom;
            dgvNhom.DataSource = bdsNhom;
            string        tenNhom = (string)dgvNhom.CurrentCell.Value;
            List <DanhBa> list    = DanhBa.getDanhBaTheoNhom(tenNhom);

            bdsDanhBa.DataSource = list;
            dgvDanhBa.DataSource = bdsDanhBa;
        }
Beispiel #12
0
        public int Save(DanhBa danhBa)
        {
            const string storeName = "st_updateDanhBa";

            using (var conn = new AdoHelper())
            {
                SqlParameter[] objectParam = new SqlParameter[] {
                    new SqlParameter("@NoiDung", danhBa.NoiDung),
                    new SqlParameter("@UserName", danhBa.UserName),
                    new SqlParameter("@Id", danhBa.Id),
                };
                return(conn.ExecNonQueryProc(storeName, objectParam));
            }
        }
Beispiel #13
0
        private void dgvNhom_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            string tenNhom = (string)dgvNhom.CurrentCell.Value;

            if (tenNhom != null)
            {
                //Nhom nhom = Nhom.getNhomByName(tenNhom);
                Nhom nhom = Nhom.getNhomFromDBByName(tenNhom);
                //List<DanhBa> list = DanhBa.getDanhBaTheoNhom(nhom.maNhom);
                List <DanhBa> list = DanhBa.getDanhBaFromDBTheoNhom(nhom.maNhom);
                bdsDanhBa.DataSource = list;
                dgvDanhBa.DataSource = bdsDanhBa;
            }
        }
Beispiel #14
0
 public ActionResult Update(DanhBa danhba)
 {
     try
     {
         DanhBaBussinessService danhBaBussinessService = new DanhBaBussinessService();
         danhba.UserName = System.Web.HttpContext.Current.User.Identity.Name;
         danhBaBussinessService.CapNhatDanhBa(danhba);
         return(RedirectToAction("Index"));
     }
     catch
     {
         return(View());
     }
 }
Beispiel #15
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            var rs = MessageBox.Show("Bạn có muốn xóa không",
                                     "Thông báo",
                                     MessageBoxButtons.OKCancel,
                                     MessageBoxIcon.Warning);

            if (rs == DialogResult.OK)
            {
                DanhBa db = bdsContact.Current as DanhBa;
                DanhBaService.deleteContact(db.ID);
                bdsContact.RemoveCurrent();
                bdsContact.ResetBindings(true);
            }
        }
Beispiel #16
0
        public void refreshList()
        {
            //List<Nhom> listNhom = Nhom.getNhom();
            List <Nhom> listNhom = Nhom.getNhomFromDB();

            bdsNhom.DataSource = listNhom;
            dgvNhom.DataSource = bdsNhom;
            if (listNhom.Count > 0)
            {
                string tenNhom = (string)dgvNhom.CurrentCell.Value;
                //Nhom nhom = Nhom.getNhomByName(tenNhom);
                Nhom nhom = Nhom.getNhomFromDBByName(tenNhom);
                //List<DanhBa> list = DanhBa.getDanhBaTheoNhom(nhom.maNhom);
                List <DanhBa> list = DanhBa.getDanhBaFromDBTheoNhom(nhom.maNhom);
                bdsDanhBa.DataSource = list;
                dgvDanhBa.DataSource = bdsDanhBa;
            }
        }
Beispiel #17
0
 public frmEditContact(DanhBa danhBa, String idS, String id)
 {
     InitializeComponent();
     db        = danhBa;
     idDanhBa  = id;
     idStudent = idS;
     if (danhBa != null)
     {
         txtHoTen.Text = danhBa.Name;
         txtEmail.Text = danhBa.Email;
         txtSoDT.Text  = danhBa.PhoneNumber;
         this.Text     = "Cập nhật thông tin";
         btnThem.Text  = "Cập nhật";
     }
     else
     {
         this.Text    = "Thêm liên hệ";
         btnThem.Text = "Thêm mới";
     }
 }
Beispiel #18
0
        private void btnXoaNhom_Click(object sender, EventArgs e)
        {
            string tenNhomXoa = (string)dgvNhom.CurrentCell.Value;
            string pathNhom   = Application.StartupPath + @"/DATA/Nhom.txt";
            string pathDanhBa = Application.StartupPath + @"/DATA/DanhBa.txt";

            string[] linesNhom   = File.ReadAllLines(pathNhom);
            string[] linesDanhBa = File.ReadAllLines(pathDanhBa);

            File.WriteAllText(pathNhom, "");
            File.WriteAllText(pathDanhBa, "");

            string newline = System.Environment.NewLine;

            for (int i = 0; i < linesNhom.Length; i++)
            {
                string[] temp = linesNhom[i].Split(new char[] { '#' });
                if (!temp[1].Equals(tenNhomXoa))
                {
                    File.AppendAllText(pathNhom, linesNhom[i] + newline, Encoding.Unicode);
                }
            }

            for (int i = 0; i < linesDanhBa.Length; i++)
            {
                string[] temp = linesDanhBa[i].Split(new char[] { '#' });
                if (!temp[0].Equals(tenNhomXoa))
                {
                    File.AppendAllText(pathDanhBa, linesDanhBa[i] + newline, Encoding.Unicode);
                }
            }
            List <Nhom> listNhom = Nhom.getNhom();

            bdsNhom.DataSource = listNhom;
            dgvNhom.DataSource = bdsNhom;
            string        tenNhom = (string)dgvNhom.CurrentCell.Value;
            List <DanhBa> list    = DanhBa.getDanhBaTheoNhom(tenNhom);

            bdsDanhBa.DataSource = list;
            dgvDanhBa.DataSource = bdsDanhBa;
        }
Beispiel #19
0
        private void btnXoaNhom_Click(object sender, EventArgs e)
        {
            string tenNhomXoa = (string)dgvNhom.CurrentCell.Value;

            var nhom = Nhom.getNhomFromDBByName(tenNhomXoa);

            DanhBa.xoaDanhBaByNhom(nhom.maNhom);
            Nhom.xoaNhomFromDBByName(tenNhomXoa);
            refreshList();
            //string pathNhom = Application.StartupPath + @"/DATA/Nhom.txt";
            //string pathDanhBa = Application.StartupPath + @"/DATA/DanhBa.txt";

            //string[] linesNhom = File.ReadAllLines(pathNhom);
            //string[] linesDanhBa = File.ReadAllLines(pathDanhBa);

            //File.WriteAllText(pathNhom, "");
            //File.WriteAllText(pathDanhBa, "");

            //string newline = System.Environment.NewLine;
            //for (int i = 0; i < linesNhom.Length; i++)
            //{
            //    string[] temp = linesNhom[i].Split(new char[] { '#' });
            //    if (!temp[1].Equals(tenNhomXoa))
            //    {
            //       File.AppendAllText(pathNhom, linesNhom[i] + newline, Encoding.Unicode);
            //   }
            //}

            //for (int i = 0; i < linesDanhBa.Length; i++)
            //// {
            //    string[] temp = linesDanhBa[i].Split(new char[] { '#' });
            //    if (!temp[0].Equals(tenNhomXoa))
            //    {
            //         File.AppendAllText(pathDanhBa, linesDanhBa[i] + newline, Encoding.Unicode);
            //     }
            // }
        }
        private void btnOK_Click(object sender, EventArgs e)
        {
            //string path = Application.StartupPath + @"/DATA/DanhBa.txt";
            string tenGoi  = txtTenGoi.Text;
            string tenNhom = txtNhom.Text;
            string email   = txtEmail.Text;
            string sdt     = txtSdt.Text;
            // string line = tenNhom + "#" + tenGoi + "#" + email + "#" + sdt + System.Environment.NewLine;
            //File.AppendAllText(path, line, Encoding.Unicode);
            Nhom   temp0 = Nhom.getNhomFromDBByName(tenNhom);
            DanhBa temp  = new DanhBa {
                tenGoi = tenGoi, maNhom = temp0.maNhom, email = email, sdt = sdt
            };
            bool check = DanhBa.themDanhBaToDB(temp);

            if (check)
            {
                this.Close();
            }
            else
            {
                MessageBox.Show(null, "Không thêm được nhóm", "Error", MessageBoxButtons.OK);
            }
        }
        protected void LoadDataByID(string id)
        {
            try
            {
                var      sobothue = db.SoBoThues.SingleOrDefault(x => x.idSoBoThue == int.Parse(id));
                DateTime dt       = new DateTime();
                txtIDKhaiThue.Text = sobothue.idKhaiThue.ToString();
                if (sobothue.NgayLapBo.ToString() != "")
                {
                    dt = DateTime.Parse(sobothue.NgayLapBo.ToString());
                }
                txtNgayLapBo.Text = dt.ToString("dd/MM/yyyy");
                int doanhthu   = sobothue.DoanhThuTinhThueGTGT ?? 0;
                int sotienGTGT = sobothue.SoTienGTGT1Thang ?? 0;
                int sotienTNCN = sobothue.SoTienTNCN1Thang ?? 0;
                txtGTGT.Text = doanhthu.ToString("#,##");
                txtTNCN.Text = doanhthu.ToString("#,##");

                //txtTyLeGTGT.Text = sobothue.TyLeTinhThueGTGT.ToString();
                //txtTyLeTNCN.Text = sobothue.TyLeTinhThueTNCN.ToString();
                txtSoTienGTGT.Text = sotienGTGT.ToString("#,##");
                txtSoTienTNCN.Text = sotienTNCN.ToString("#,##");
                KhaiThue kt = db.KhaiThues.SingleOrDefault(x => x.idKhaiThue == sobothue.idKhaiThue);
                if (kt != null)
                {
                    DanhBa danhba = db.DanhBas.SingleOrDefault(x => x.masothue == kt.masothue);
                    txtMST.Text   = danhba.masothue;
                    txtHoTen.Text = danhba.hoten;
                }
            }
            catch (Exception mess)
            {
                st.Append("$.notify('" + mess.Message + "',{className: 'error',globalPosition: 'bottom right'});");
                ClientScript.RegisterClientScriptBlock(this.GetType(), "", st.ToString(), true);
            }
        }
Beispiel #22
0
 public bool Delete(DanhBa aggregate)
 {
     throw new NotImplementedException();
 }
Beispiel #23
0
 public void AddDanhBa(DanhBa danhba)
 {
     iDanhBa.ThemDanhBa(danhba);
 }
        public int CapNhatDanhBa(DanhBa danhBa)
        {
            DanhBaDataService danhBaData = new DanhBaDataService();

            return(danhBaData.Save(danhBa));
        }
Beispiel #25
0
        private void frmDanhBaBuuDien_Load(object sender, EventArgs e)
        {
            List <DanhBaCongTy> listDBBuuDien = DanhBa.GetDanhBa_BuuDien_1();

            dgv_DanhBaBuuDien.DataSource = listDBBuuDien;
        }
Beispiel #26
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            GridDataItem          item;
            List <SoLieuTuKhoBac> lstErr = new List <SoLieuTuKhoBac>();

            st.Clear();
            for (int i = 0; i < grid.Items.Count; i++)
            {
                item = (GridDataItem)grid.Items[i];
                CheckBox checkBox = (CheckBox)item["ClientSelectColumn"].Controls[0];
                if (checkBox.Checked == true)
                {
                    try
                    {
                        string masothue  = item["Mã số thuế"].Text.Trim();
                        string macbql    = item["Mã cán bộ"].Text.Trim();
                        double sotiennop = double.Parse(item["Số tiền theo VND"].Text.Trim());
                        string ngaynop   = item["Ngày nộp thuế"].Text.Trim();
                        string kythue    = item["Kỳ tính thuế5"].Text.Trim();
                        string tieumuc   = item["Tiểu mục"].Text.Trim();
                        string muc       = item["Mã mục"].Text.Trim();
                        DanhBa danhba    = db.DanhBas.SingleOrDefault(x => x.masothue == masothue);
                        if (danhba == null)
                        {
                            continue;
                        }
                        else
                        {
                            int?id = 0;
                            db.getKhaiThueGanNhat(danhba.masothue, ref id);
                            if (id != 0)
                            {
                                var sobo = db.SoBoThues.SingleOrDefault(x => x.idKhaiThue == id && x.NgayLapBo.Value.Month == DateTime.Now.Month);
                                if (sobo != null)
                                {
                                    //Kiểm tra nếu nộp thiếu tiền thuế thì trả về danh sách các hộ có số thu chưa đúng
                                    //Do chỉ có 2 trường hợp nộp đủ và không nộp
                                    if (int.Parse(tieumuc) == 1003 && muc == "1000")
                                    {
                                        if (sotiennop < sobo.SoTienTNCN1Thang)
                                        {
                                            lstErr.Add(new SoLieuTuKhoBac
                                            {
                                                masothue  = masothue,
                                                macbql    = macbql,
                                                SoTienNop = int.Parse(sotiennop.ToString()),
                                                NgayNop   = DateTime.Parse(ngaynop),
                                                KyThue    = kythue,
                                                tieumuc   = int.Parse(tieumuc),
                                                muc       = muc
                                            });
                                            continue;
                                        }
                                    }
                                    else if (int.Parse(tieumuc) == 1701 && muc == "1700")
                                    {
                                        if (sotiennop < sobo.SoTienGTGT1Thang)
                                        {
                                            lstErr.Add(new SoLieuTuKhoBac
                                            {
                                                masothue  = masothue,
                                                macbql    = macbql,
                                                SoTienNop = int.Parse(sotiennop.ToString()),
                                                NgayNop   = DateTime.Parse(ngaynop),
                                                KyThue    = kythue,
                                                tieumuc   = int.Parse(tieumuc),
                                                muc       = muc
                                            });
                                            continue;
                                        }
                                    }
                                    else
                                    {
                                        thuemonbai monbai = db.thuemonbais.SingleOrDefault(x => x.idKhaiThue == id);
                                        if (monbai != null && monbai.trangthai == false)
                                        {
                                            mucluc_MonBai mucluc_MB = db.mucluc_MonBais.SingleOrDefault(x => x.Bac == monbai.Bac);
                                            if (sotiennop < mucluc_MB.MucThue)
                                            {
                                                lstErr.Add(new SoLieuTuKhoBac
                                                {
                                                    masothue  = masothue,
                                                    macbql    = macbql,
                                                    SoTienNop = int.Parse(sotiennop.ToString()),
                                                    NgayNop   = DateTime.Parse(ngaynop),
                                                    KyThue    = kythue,
                                                    tieumuc   = int.Parse(tieumuc),
                                                    muc       = muc
                                                });
                                                continue;
                                            }
                                        }
                                    }
                                }
                                else
                                {
                                    st.Append("$.notify('Mã số thuế :" + masothue + " chưa lập sổ bộ tháng hiện tại',{className: 'error',globalPosition: 'bottom right'});");
                                    ClientScript.RegisterClientScriptBlock(this.GetType(), "", st.ToString(), true);
                                    continue;
                                }

                                db.Insert_SoLieuNopThue(masothue, macbql, sotiennop, ngaynop, kythue, tieumuc, muc);
                                if ((System.IO.File.Exists(txtFilepath.Text)))
                                {
                                    System.IO.File.Delete(txtFilepath.Text);
                                }

                                st.Append("$.notify('Thao tác thành công',{className: 'success',globalPosition: 'bottom right'});");
                                ClientScript.RegisterClientScriptBlock(this.GetType(), "", st.ToString(), true);
                            }
                        }
                    }
                    catch (Exception ms)
                    {
                        st.Append("$.notify('" + ms.Message + "',{className: 'error',globalPosition: 'bottom right'});");
                        ClientScript.RegisterClientScriptBlock(this.GetType(), "", st.ToString(), true);
                    }
                }
            }
            if (lstErr.Count > 0)
            {
                Export(lstErr);
            }
        }
Beispiel #27
0
 public static void addContact(DanhBa danhBa)
 {
     db.danhBas.Add(danhBa);
     db.SaveChanges();
 }
Beispiel #28
0
 public int Add(DanhBa aggregate)
 {
     throw new NotImplementedException();
 }
        /// <summary>
        /// Input : SoDienThoai
        /// Output
        ///     : KieuKhachHangGoiDen
        ///     : DiaChicuakhach hang
        ///  //Tim trong kho Khach VIP
        ///  Tim trong kho doi tac
        ///  Tim trong kho danh ba tam
        ///  Tim trong kho danh ba buu dien
        /// </summary>
        private string GetDiaChiGoiDen(string PhoneNumber, out KieuKhachHangGoiDen outKieuKhachHang, out string MaDoiTac)
        {
            if (StringTools.TrimSpace(PhoneNumber).Length <= 0)
            {
                outKieuKhachHang = KieuKhachHangGoiDen.KhachHangBinhThuong;
                MaDoiTac         = "";
                return(string.Empty);
            }

            string strDiaChiKhachAo = DanhBaKhachAo.GetDanhBa(DanhBa.GetSoDienThoaiToiThieu(PhoneNumber));

            if (strDiaChiKhachAo.Length > 0)
            {
                outKieuKhachHang = KieuKhachHangGoiDen.KhachHangKhongHieu;//khach ao
                MaDoiTac         = "";
                return(strDiaChiKhachAo);
            }

            // Tim kiem trong khach VIP (3_)
            DanhBaKhachQuen objKhachQuen = DanhBaKhachQuen.GetKhachQuen_Phones_Search(DanhBa.GetSoDienThoaiToiThieu(PhoneNumber));

            if (objKhachQuen != null && objKhachQuen.Name.Length > 0)
            {
                if (objKhachQuen.Type == 1)
                {
                    outKieuKhachHang = KieuKhachHangGoiDen.KhachHangVIP;
                }
                else if (objKhachQuen.Type > 1 && objKhachQuen.Rank == 1)
                {
                    outKieuKhachHang = KieuKhachHangGoiDen.KhachHangVang;
                }
                else if (objKhachQuen.Type > 1 && objKhachQuen.Rank == 2)
                {
                    outKieuKhachHang = KieuKhachHangGoiDen.KhachHangBac;
                }
                else
                {
                    outKieuKhachHang = KieuKhachHangGoiDen.KhachHangBinhThuong;
                }
                MaDoiTac = objKhachQuen.MaKH;

                return(String.Format("[{0}]{1}", objKhachQuen.Name, objKhachQuen.Address));
            }

            // Tim kiem trong DOI TAC (2_)
            DoiTac objDoiTac = DoiTac.GetDoiTacByOPhoneNumber(DanhBa.GetSoDienThoaiToiThieu(PhoneNumber));

            if (objDoiTac != null)
            {
                outKieuKhachHang = KieuKhachHangGoiDen.KhachHangMoiGioi;
                MaDoiTac         = objDoiTac.MaDoiTac;
                g_kinhdo         = objDoiTac.KinhDo;
                g_vido           = objDoiTac.ViDo;
                return(objDoiTac.Name + "-" + objDoiTac.Address);
            }

            //Tim kiem trong danh ba dien thoai cua rieng cong ty (1_)
            string strDiaChiCuocGoiGanNhat = GetDiaChiCuaCuocGoiGanNhatTrongNgay(DanhBa.GetSoDienThoaiToiThieu(PhoneNumber));

            if (strDiaChiCuocGoiGanNhat.Length > 0)
            {
                outKieuKhachHang = KieuKhachHangGoiDen.KhachHangBinhThuong;
                MaDoiTac         = "";
                return(strDiaChiCuocGoiGanNhat);
            }

            // tim kiem trong danh ba cong ty
            string strDiaChiDanhBaCongTy = DanhBaCongTy.GetDanhBa(DanhBa.GetSoDienThoaiToiThieu(PhoneNumber));

            if (strDiaChiDanhBaCongTy.Length > 0)
            {
                outKieuKhachHang = KieuKhachHangGoiDen.KhachHangBinhThuong;//khach ao
                MaDoiTac         = "";
                return(strDiaChiDanhBaCongTy);
            }

            //Tim kiem trong danh ba dien thoai (1_)
            outKieuKhachHang = KieuKhachHangGoiDen.KhachHangBinhThuong;
            MaDoiTac         = "";
            return(DanhBa.GetDanhBa(DanhBa.GetSoDienThoaiToiThieu(PhoneNumber)));
        }
Beispiel #30
0
        /// <summary>
        /// Input : SoDienThoai
        /// Output
        ///     : KieuKhachHangGoiDen
        ///     : DiaChicuakhach hang
        ///  //Tim trong kho Khach VIP
        ///  Tim trong kho doi tac
        ///  Tim trong kho danh ba tam
        ///  Tim trong kho danh ba buu dien
        /// </summary>
        private string GetDiaChiGoiDen(string phoneNumber, out KieuKhachHangGoiDen outKieuKhachHang, out string outMaDoiTac)
        {
            try
            {
                if (StringTools.TrimSpace(phoneNumber).Length <= 0)
                {
                    outKieuKhachHang = KieuKhachHangGoiDen.KhachHangBinhThuong;
                    outMaDoiTac      = "";
                    return(string.Empty);
                }
                //// xu ly co tong dai
                //if (PhoneNumber[0].ToString() == "5")
                //{
                //    PhoneNumber = PhoneNumber.Substring(1, PhoneNumber.Length - 1);
                //}

                string strDiaChiKhachAo = DanhBaKhachAo.GetDanhBa(DanhBa.GetSoDienThoaiToiThieu(phoneNumber));

                if (strDiaChiKhachAo.Length > 0)
                {
                    outKieuKhachHang = KieuKhachHangGoiDen.KhachHangKhongHieu;//khach ao
                    outMaDoiTac      = "";
                    return(strDiaChiKhachAo);
                }

                // Tim kiem trong khach VIP (3_)
                DanhBaKhachQuen objKhachQuen = DanhBaKhachQuen.GetKhachQuen_Phones_Search(DanhBa.GetSoDienThoaiToiThieu(phoneNumber));

                if (objKhachQuen != null && objKhachQuen.Name.Length > 0)
                {
                    if (objKhachQuen.Type == 1)
                    {
                        outKieuKhachHang = KieuKhachHangGoiDen.KhachHangVIP;
                    }
                    else if (objKhachQuen.Type > 1 && objKhachQuen.Rank == 1)
                    {
                        outKieuKhachHang = KieuKhachHangGoiDen.KhachHangVang;
                    }
                    else if (objKhachQuen.Type > 1 && objKhachQuen.Rank == 2)
                    {
                        outKieuKhachHang = KieuKhachHangGoiDen.KhachHangBac;
                    }
                    else
                    {
                        outKieuKhachHang = KieuKhachHangGoiDen.KhachHangBinhThuong;
                    }
                    outMaDoiTac = objKhachQuen.MaKH;

                    return(String.Format("[{0}]{1}", objKhachQuen.Name, objKhachQuen.Address));
                }

                //Tim kiem trong DOI TAC (2)
                DoiTac objDoiTac = DoiTac.GetDoiTacByOPhoneNumber(DanhBa.GetSoDienThoaiToiThieu(phoneNumber));

                if (objDoiTac != null && objDoiTac.MaDoiTac.Length > 0)
                {
                    outKieuKhachHang = KieuKhachHangGoiDen.KhachHangMoiGioi;
                    outMaDoiTac      = objDoiTac.MaDoiTac;
                    return(objDoiTac.Address);
                }

                //Tim kiem trong danh ba dien thoai cua rieng cong ty (1)

                string strDiaChiCuocGoiGanNhat = GetDiaChiCuaCuocGoiGanNhatTrongNgay(DanhBa.GetSoDienThoaiToiThieu(phoneNumber));

                if (strDiaChiCuocGoiGanNhat.Length > 0)
                {
                    outKieuKhachHang = KieuKhachHangGoiDen.KhachHangBinhThuong;
                    outMaDoiTac      = "";
                    return(strDiaChiCuocGoiGanNhat);
                }

                //Tim kiem trong danh ba cong ty

                string strDiaChiDanhBaCongTy = DanhBaCongTy.GetDanhBa(DanhBa.GetSoDienThoaiToiThieu(phoneNumber));

                if (strDiaChiDanhBaCongTy.Length > 0)
                {
                    outKieuKhachHang = KieuKhachHangGoiDen.KhachHangBinhThuong;//khach ao
                    outMaDoiTac      = "";
                    return(strDiaChiDanhBaCongTy);
                }

                //Tim kiem trong danh ba dien thoai (1_)
                outKieuKhachHang = KieuKhachHangGoiDen.KhachHangBinhThuong;
                outMaDoiTac      = "";
                return(DanhBa.GetDanhBa(DanhBa.GetSoDienThoaiToiThieu(phoneNumber)));
            }
            catch
            {
                outKieuKhachHang = KieuKhachHangGoiDen.KhachHangKhongHieu;
                outMaDoiTac      = string.Empty;
                return(string.Empty);
            }
        }