Esempio n. 1
0
        public ActionResult Create(NhaCC model)
        {
            ThongBaoMvc thongbao;
            var         account = kiemtra.getUser(User.Identity.Name);
            var         MNCC    = db.NhaCCs.SingleOrDefault(s => s.MaNCC.Equals(model.MaNCC));

            model.MaCN = account.MaCN;
            try
            {
                db.NhaCCs.Add(model);
                db.SaveChanges();
                thongbao = new ThongBaoMvc {
                    CssClassName = "success", Message = "Thêm nhà cung cấp thành công."
                };
                TempData["ResultAction"] = thongbao;
                return(RedirectToAction("Index", "NhaCungCap"));
            }
            catch (Exception ex)
            {
                thongbao = new ThongBaoMvc {
                    CssClassName = "danger", Message = "Lỗi."
                };
                TempData["ResultAction"] = thongbao;
                log.Error("Lỗi thêm nhà cung cấp mới: " + ex.Message);
                return(View(model));
            }
        }
Esempio n. 2
0
        private NhaCC LayNCCDangChon()
        {
            NhaCC ncc = new NhaCC();

            ncc.MaNCC       = gvNhaCungCap.GetRowCellValue(CurRowIndex, "MaNCC").ToString();
            ncc.TenNCC      = gvNhaCungCap.GetRowCellValue(CurRowIndex, "TenNCC").ToString();
            ncc.ConQuanLy   = bool.Parse(gvNhaCungCap.GetRowCellValue(CurRowIndex, "ConQuanLy").ToString());
            ncc.KhuVuc      = gvNhaCungCap.GetRowCellValue(CurRowIndex, "KhuVuc").ToString();
            ncc.DiaChi      = gvNhaCungCap.GetRowCellValue(CurRowIndex, "DiaChi").ToString();
            ncc.MaSoThue    = gvNhaCungCap.GetRowCellValue(CurRowIndex, "MaSoThue").ToString();
            ncc.Fax         = gvNhaCungCap.GetRowCellValue(CurRowIndex, "Fax").ToString();
            ncc.DienThoai   = gvNhaCungCap.GetRowCellValue(CurRowIndex, "DienThoai").ToString();
            ncc.Mobile      = gvNhaCungCap.GetRowCellValue(CurRowIndex, "Mobile").ToString();
            ncc.Email       = gvNhaCungCap.GetRowCellValue(CurRowIndex, "Email").ToString();
            ncc.Website     = gvNhaCungCap.GetRowCellValue(CurRowIndex, "Website").ToString();
            ncc.TaiKhoan    = gvNhaCungCap.GetRowCellValue(CurRowIndex, "TaiKhoan").ToString();
            ncc.NganHang    = gvNhaCungCap.GetRowCellValue(CurRowIndex, "NganHang").ToString();
            ncc.GioiHanNo   = int.Parse(gvNhaCungCap.GetRowCellValue(CurRowIndex, "GioiHanNo").ToString());
            ncc.NoHienTai   = int.Parse(gvNhaCungCap.GetRowCellValue(CurRowIndex, "NoHienTai").ToString());
            ncc.ChietKhau   = int.Parse(gvNhaCungCap.GetRowCellValue(CurRowIndex, "ChietKhau").ToString());
            ncc.ChucVu      = gvNhaCungCap.GetRowCellValue(CurRowIndex, "ChucVu").ToString();
            ncc.NguoiLienHe = gvNhaCungCap.GetRowCellValue(CurRowIndex, "NguoiLienHe").ToString();

            return(ncc);
        }
Esempio n. 3
0
 public int Delete(NhaCC ncc)
 {
     if (Load_DAL("select * from NhaCC where MaNCC='" + ncc.MaNCC + "'").Rows.Count == 0)
     {
         return(2);
     }
     else if (Load_DAL("select * from PhieuNhap where MaNCC='" + ncc.MaNCC + "'").Rows.Count > 0)
     {
         return(3);
     }
     else
     {
         SqlCommand cmd = new SqlCommand("Delete_NCC", con);
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.Parameters.Add(new SqlParameter("@ma", ncc.MaNCC));
         try { if (con.State != ConnectionState.Open)
               {
                   con.Open();
               }
         } catch { return(-2); }
         try { cmd.ExecuteNonQuery(); return(1); } catch { return(0); } finally { if (con.State == ConnectionState.Open)
                                                                                  {
                                                                                      con.Close();
                                                                                  }
         }
     }
 }
Esempio n. 4
0
 public int Insert(NhaCC ncc)
 {
     if (Load_DAL("select * from NhaCC where MaNCC='" + ncc.MaNCC + "'").Rows.Count > 0)
     {
         return(2);
     }
     else
     {
         SqlCommand cmd = new SqlCommand("Insert_NCC", con);
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.Parameters.Add(new SqlParameter("@ma", ncc.MaNCC));
         cmd.Parameters.Add(new SqlParameter("@ten", ncc.TenNCC));
         cmd.Parameters.Add(new SqlParameter("@dc", ncc.DiaChi));
         cmd.Parameters.Add(new SqlParameter("@dt", ncc.DT));
         cmd.Parameters.Add(new SqlParameter("@email", ncc.Email));
         try { if (con.State != ConnectionState.Open)
               {
                   con.Open();
               }
         } catch { return(-2); }
         try { cmd.ExecuteNonQuery(); return(1); } catch { return(0); } finally { if (con.State == ConnectionState.Open)
                                                                                  {
                                                                                      con.Close();
                                                                                  }
         }
     }
 }
Esempio n. 5
0
 private void btnLuu_Click(object sender, EventArgs e)
 {
     if (check == null)
     {
         NhaCC akh = new NhaCC()
         {
             MaNCC = txtMa.Text,
             Ten   = txtTen.Text,
             MoTa  = txtMoTa.Text,
             MaKV  = cbKhuVuc.EditValue.ToString()
         };
         if (BusNCC.ThemNhaCC(akh) > 0)
         {
             MessageBox.Show("Thêm thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
     }
     else
     {
         NhaCC akh = new NhaCC()
         {
             MaNCC = txtMa.Text,
             Ten   = txtTen.Text,
             MoTa  = txtMoTa.Text,
             MaKV  = cbKhuVuc.EditValue.ToString()
         };
         if (BusNCC.Update(akh) > 0)
         {
             MessageBox.Show("Cập nhật thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
     }
 }
Esempio n. 6
0
        public ActionResult DeleteConfirmed(string id)
        {
            NhaCC nhaCC = db.NhaCCs.Find(id);

            db.NhaCCs.Remove(nhaCC);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        private void BtnLuu_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(txtTenNCC.Text))
            {
                MessageBox.Show("Không được bỏ trống Tên Nhà Cung Cấp", "Hệ Thống", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else
            {
                NhaCC ncc = new NhaCC();
                ncc.MaNCC     = txtMaNCC.Text;
                ncc.KhuVuc    = lkueKhuVuc.EditValue.ToString();
                ncc.TenNCC    = txtTenNCC.Text;
                ncc.DiaChi    = txtDiaChi.Text;
                ncc.MaSoThue  = txtMaSoThue.Text;
                ncc.Fax       = txtFax.Text;
                ncc.DienThoai = txtDienThoai.Text;
                ncc.Mobile    = txtMobile.Text;
                ncc.Email     = txtEmail.Text;
                ncc.Website   = txtWebsite.Text;
                ncc.TaiKhoan  = txtTaiKhoan.Text;
                ncc.NganHang  = txtNganHang.Text;
                ncc.GioiHanNo = ceGioiHanNo.EditValue != null?int.Parse(ceGioiHanNo.EditValue.ToString()) : 0;

                ncc.NoHienTai = 0;
                ncc.ChietKhau = ceChietKhau.EditValue != null?int.Parse(ceChietKhau.EditValue.ToString()) : 0;

                ncc.ChucVu      = txtChucVu.Text;
                ncc.NguoiLienHe = txtNguoiLienHe.Text;
                ncc.ConQuanLy   = cbConQuanLy.Checked;

                if (isInsert == true)
                {
                    int kq = nv_ncc.ThemNCC(ncc);
                    if (kq >= 1)
                    {
                        ThemThanhCong();
                        MessageBox.Show("Thêm Nhà Cung Cấp thành công");
                    }
                    else
                    {
                        MessageBox.Show("Thêm thất bại");
                    }
                }
                else
                {
                    int kq = nv_ncc.CapNhatNCC(ncc);
                    if (kq >= 1)
                    {
                        CapNhatThanhCong();
                        MessageBox.Show("Cập nhật Nhà Cung Cấp thành công");
                    }
                    else
                    {
                        MessageBox.Show("Thất bại");
                    }
                }
            }
        }
Esempio n. 8
0
        public int ThemNhaCC(NhaCC kh)
        {
            string sql = string.Format("insert into [NhaCungCap] Values('{0}', N'{1}', N'{2}', '{3}')"
                                       , kh.MaNCC, kh.Ten, kh.MoTa, kh.MaKV);

            var rs = db.ExecuteSQL(sql);

            return(rs);
        }
Esempio n. 9
0
        public int Update(NhaCC ncc)
        {
            string sql =
                string.Format("Update NhaCungCap Set Ten='{0}',MoTa='{1}',MaKhuVuc='{2}' where MaNCC='{3}'"
                              , ncc.Ten, ncc.MoTa, ncc.MaKV, ncc.MaNCC);
            var rs = db.ExecuteSQL(sql);

            return(rs);
        }
Esempio n. 10
0
        public ActionResult DeleteConfirmed(int id)
        {
            NhaCC nhaCC = db.NhaCCs.FirstOrDefault(x => x.Ma == id && !x.Xoa);

            nhaCC.Xoa             = true;
            db.Entry(nhaCC).State = EntityState.Modified;
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Esempio n. 11
0
        private void btnThem_Click(object sender, EventArgs e)
        {
            MaNCC = Convert.ToInt32(txtMaNCC.Text);
            string TenNCC = txtTenNCC.Text;
            NhaCC  NhaCC  = new NhaCC(MaNCC, TenNCC);

            dtgNhaCC.DataSource    = NhaCCInsert;
            NhaCCInsert.DataSource = nhacc.NhaCC_Insert(NhaCC);
            LoadNhaCC();
        }
Esempio n. 12
0
 public ActionResult Edit([Bind(Include = "MaNCC,TenNCC,SDT")] NhaCC nhaCC)
 {
     if (ModelState.IsValid)
     {
         db.Entry(nhaCC).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(nhaCC));
 }
Esempio n. 13
0
 public int UpdateData(NhaCC NCC)
 {
     SqlParameter[] para =
     {
         new SqlParameter("MaNCC",  NCC.MaNCC),
         new SqlParameter("TenNCC", NCC.TenNCC),
         new SqlParameter("DiaChi", NCC.DiaChi),
         new SqlParameter("SDT",    NCC.SDT)
     };
     return(conn.ExcuteSQL("Sua_NhaCC", para));
 }
Esempio n. 14
0
 public ActionResult Create(NhaCC nhaCC /*[Bind(Include = "MaNCC,TenNCC,DiaChi,SDT,Email")]*/)
 {
     if (ModelState.IsValid)
     {
         nhaCC.MaNCC = autoID();
         db.NhaCCs.Add(nhaCC);
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View());
 }
Esempio n. 15
0
        public static void Them(NhaCC entity)
        {
            String sql = "INSERT INTO NhaCC( TenNhaCC) VALUES( @TenNhaCC)";
               SqlCommand Command = new SqlCommand(sql, DB.Connection);
               Command.Parameters.AddWithValue("@MaNhaCC", entity.MaNhaCC);
               Command.Parameters.AddWithValue("@TenNhaCC",entity.TenNhaCC);

               Command.Connection.Open();
               Command.ExecuteNonQuery();
               Command.Connection.Close();
        }
Esempio n. 16
0
        public ActionResult Create([Bind(Include = "MaNCC,TenNCC,SDT")] NhaCC nhaCC)
        {
            if (ModelState.IsValid)
            {
                db.NhaCCs.Add(nhaCC);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(nhaCC));
        }
Esempio n. 17
0
        private bool idHasExist(string id)
        {
            NhaCC temp = db.NhaCCs.Find(id);

            if (temp == null)
            {
                return(false);
            }

            return(true);
        }
Esempio n. 18
0
        public static void Sua(NhaCC entity)
        {
            String sql = "UPDATE NhaCC SET TenNhaCC = @TenNhaCC WHERE MaNhaCC = @MaNhaCC";
               SqlCommand Command = new SqlCommand(sql, DB.Connection);
               Command.Parameters.AddWithValue("@MaNhaCC", entity.MaNhaCC);
               Command.Parameters.AddWithValue("@TenNhaCC", entity.TenNhaCC);

               Command.Connection.Open();
               Command.ExecuteNonQuery();
               Command.Connection.Close();
        }
 public bool NhaCc_Update(NhaCC NhaCc)
 {
     try
     {
         string query  = " sp_NhaCc_Update '" + NhaCc.MaNCC + "', '" + NhaCc.TenNCC + "'";
         int    result = DataProvider.Instance.ExecuteNonQuery(query);
         return(true);
     }
     catch (Exception e)
     { }
     return(false);
 }
        public bool Update(NhaCC entity)
        {
            var NhaCC = db.NhaCCs.Find(entity.MaNCC);

            NhaCC.Ten    = entity.Ten;
            NhaCC.DiaChi = entity.DiaChi;
            NhaCC.SDT    = entity.SDT;
            NhaCC.Email  = entity.Email;

            db.SaveChanges();
            return(true);
        }
Esempio n. 21
0
        private void BtnSua_Click(object sender, EventArgs e)
        {
            if (CurRowIndex >= 0)
            {
                NhaCC ncc = LayNCCDangChon();

                frmThemNhaCungCap frmSua = new frmThemNhaCungCap(ncc);
                frmSua.CapNhatThanhCong += FillGridView;
                frmSua.CapNhatThanhCong += NhatKySua;
                frmSua.ShowDialog();
            }
        }
Esempio n. 22
0
        public static void Them(NhaCC entity)
        {
            String     sql     = "INSERT INTO NhaCC( TenNhaCC) VALUES( @TenNhaCC)";
            SqlCommand Command = new SqlCommand(sql, DB.Connection);

            Command.Parameters.AddWithValue("@MaNhaCC", entity.MaNhaCC);
            Command.Parameters.AddWithValue("@TenNhaCC", entity.TenNhaCC);

            Command.Connection.Open();
            Command.ExecuteNonQuery();
            Command.Connection.Close();
        }
Esempio n. 23
0
        public static void Sua(NhaCC entity)
        {
            String     sql     = "UPDATE NhaCC SET TenNhaCC = @TenNhaCC WHERE MaNhaCC = @MaNhaCC";
            SqlCommand Command = new SqlCommand(sql, DB.Connection);

            Command.Parameters.AddWithValue("@MaNhaCC", entity.MaNhaCC);
            Command.Parameters.AddWithValue("@TenNhaCC", entity.TenNhaCC);

            Command.Connection.Open();
            Command.ExecuteNonQuery();
            Command.Connection.Close();
        }
 public bool Insert(NhaCC entity)
 {
     if (!string.IsNullOrEmpty(entity.MaNCC))
     {
         db.NhaCCs.Add(entity);
         db.SaveChanges();
         return(true);
     }
     else
     {
         return(false);
     }
 }
Esempio n. 25
0
        // GET: NhaCCs/Delete/5
        public ActionResult Delete(string id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            NhaCC nhaCC = db.NhaCCs.Find(id);

            if (nhaCC == null)
            {
                return(HttpNotFound());
            }
            return(View(nhaCC));
        }
 public bool DeleteNhaCC(DTO_NhaCC a)
 {
     try
     {
         NhaCC delete = db.NhaCCs.Where(p => p.MaNCC.ToString().Equals(a.MaNCC)).SingleOrDefault();
         db.NhaCCs.DeleteOnSubmit(delete);
         db.SubmitChanges();
         return(true);
     }
     catch
     {
         return(false);
     }
 }
Esempio n. 27
0
        public ActionResult Edit(int id)
        {
            if (id == 0)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            NhaCC nhaCC = db.NhaCCs.FirstOrDefault(x => x.Ma == id && !x.Xoa);

            if (nhaCC == null)
            {
                return(HttpNotFound());
            }
            return(View(nhaCC));
        }
Esempio n. 28
0
        private void btnLuuKb_Click(object sender, EventArgs e)
        {
            if (KTLuu())
            {
                switch (TTLuu)
                {
                case 1:
                    _MaNCC = txtMaNCC.Text.Trim();
                    var ma = dataContext.NhaCCs.Where(p => p.MaCC == (_MaNCC)).ToList();
                    if (ma.Count > 0)
                    {
                        MessageBox.Show("Mã Nhà cung cấp đã có, vui lòng nhập mã khác");
                    }
                    else
                    {
                        NhaCC ncc = new NhaCC();
                        ncc.MaCC      = txtMaNCC.Text.Trim();
                        ncc.TenCC     = txtTenNCC.Text.Trim();
                        ncc.DiaChi    = txtDiaChi.Text.Trim();
                        ncc.DienThoai = txtDienThoai.Text.Trim();
                        ncc.NguoiCC   = txtNguoiCC.Text.Trim();
                        ncc.Status    = cboStatus.SelectedIndex;
                        dataContext.NhaCCs.Add(ncc);
                        dataContext.SaveChanges();
                        enableControl(false);
                        MessageBox.Show("Lưu thành công!");
                    }
                    break;

                case 2:
                    if (!string.IsNullOrEmpty(txtMaNCC.Text))
                    {
                        string maNCC  = txtMaNCC.Text.Trim();
                        NhaCC  nccsua = dataContext.NhaCCs.Single(p => p.MaCC == (maNCC));
                        nccsua.TenCC     = txtTenNCC.Text.Trim();
                        nccsua.DiaChi    = txtDiaChi.Text.Trim();
                        nccsua.DienThoai = txtDienThoai.Text;
                        nccsua.NguoiCC   = txtNguoiCC.Text.Trim();
                        nccsua.Status    = cboStatus.SelectedIndex;
                        dataContext.SaveChanges();
                        MessageBox.Show("Lưu thành công!");
                        enableControl(false);
                    }
                    break;
                }
                _lNCC = dataContext.NhaCCs.OrderBy(p => p.TenCC).ToList();
                grcNhaCC.DataSource = _lNCC.ToList();
            }
        }
Esempio n. 29
0
        public frmThemNCC(NhaCC ncc)
        {
            InitializeComponent();
            this.Text   = "Cập Nhật Nhà Cung Cấp";
            btnLuu.Text = "Cập Nhật";

            txtMa.Enabled = false;

            check = ncc.MaNCC;

            txtMa.Text    = ncc.MaNCC;
            txtTen.Text   = ncc.Ten;
            txtMoTa.Text  = ncc.MoTa;
            cbKhuVuc.Text = ncc.MaKV;
        }
Esempio n. 30
0
        private void Sua(object sender, EventArgs e)
        {
            NhaCC nh = new NhaCC()
            {
                MaNCC = gvNhaCungCap.GetRowCellValue(gvNhaCungCap.FocusedRowHandle, "Mã").ToString(),
                Ten   = gvNhaCungCap.GetRowCellValue(gvNhaCungCap.FocusedRowHandle, "Tên").ToString(),
                MoTa  = gvNhaCungCap.GetRowCellValue(gvNhaCungCap.FocusedRowHandle, "Mô Tả").ToString(),
                MaKV  = gvNhaCungCap.GetRowCellValue(gvNhaCungCap.FocusedRowHandle, "Tên khu vực").ToString(),
            };

            frmThemNCC tnh = new frmThemNCC(nh);

            tnh.ShowDialog();
            LoadData();
        }
Esempio n. 31
0
 // viết codde cho actions create(tạo mới thông tin một khách hàng)
 public ActionResult Create(NhaCC ncc)
 {
     //kiểm tra dữ liệu ở model
     if (ModelState.IsValid)
     {
         //khách hàng là dữ liệu của đối tượng khách hàng mà client gửi lên
         db.NhaCCs.Add(ncc);
         //Lưu thông tin thay đổi với database
         db.SaveChanges();
         // Điều hướng đến trang index nếu thực hiện thành công
         return(RedirectToAction("Index"));
     }
     // nếu trả về view nhập thông tin khách hàng
     return(View());
 }
Esempio n. 32
0
        public ActionResult Create([Bind(Include = "MaNCC,TenNCC,SoDienThoai")] NhaCC nhaCC)
        {
            if (ModelState.IsValid)
            {
                var ncc = new NhaCC();
                ncc.TenNCC      = nhaCC.TenNCC;
                ncc.SoDienThoai = nhaCC.SoDienThoai;

                db.NhaCCs.Add(nhaCC);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(nhaCC));
        }
Esempio n. 33
0
        public static List<NhaCC> TimTheoSql(String sql)
        {
            SqlCommand Command = new SqlCommand(sql, DB.Connection);

               Command.Connection.Open();
               SqlDataReader Reader = Command.ExecuteReader();
               var DSNCC = new List<NhaCC>();
               while (Reader.Read())
               {
               var NhaCC = new NhaCC
               {
                   MaNhaCC = Convert.ToString(Reader["MaNhaCC"]),
                   TenNhaCC = Convert.ToString(Reader["TenNhaCC"]),
               };
               DSNCC.Add(NhaCC);
               }
               Command.Connection.Close();
               return DSNCC;
        }
Esempio n. 34
0
        public static NhaCC Tim(String MaNhaCC)
        {
            String sql = "SELECT * FROM NhaCC WHERE MaNhaCC = @MaNhaCC";
               SqlCommand Command = new SqlCommand(sql, DB.Connection);

               Command.Parameters.AddWithValue("@MaNhaCC", MaNhaCC);

               Command.Connection.Open();
               SqlDataReader Reader = Command.ExecuteReader();
               if (Reader.Read())
               {
               var NhaCC = new NhaCC
               {
                   MaNhaCC = Convert.ToString(Reader["MaNhaCC"]),
                   TenNhaCC = Convert.ToString(Reader["TenNhaCC"]),

               };
               return NhaCC;
               }
               Command.Connection.Close();
               return null;
        }