Example #1
0
        protected void grvloaisanpham_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string ma = grvloaisanpham.Rows[e.RowIndex].Cells[1].Text;

            ProcessDatabase.deleteData("DELETE FROM LoaiSanPham WHERE MaLoaiSp='" + ma + "'");
            loadKH();
        }
Example #2
0
        protected void grvkhachhang_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string ma = grvkhachhang.Rows[e.RowIndex].Cells[1].Text;

            ProcessDatabase.deleteData("DELETE FROM KhachHang WHERE CustomerID='" + ma + "'");
            loadKH();
        }
Example #3
0
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string ma = grvhoadon.Rows[e.RowIndex].Cells[1].Text;

            ProcessDatabase.deleteData("DELETE FROM HoaDon WHERE MaHD='" + ma + "'");
            LoadHD();
        }
Example #4
0
        protected void grvloaisanpham_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            string ma       = grvloaisanpham.Rows[e.RowIndex].Cells[1].Text;
            string tenloai  = ((TextBox)grvloaisanpham.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
            string motaloai = ((TextBox)grvloaisanpham.Rows[e.RowIndex].Cells[3].Controls[0]).Text;

            ProcessDatabase.UpdateData("update LoaiSanPham set TenLoaiSp=N'" + tenloai + "', MotaLoaiSp=N'" + motaloai + "' where MaLoaiSp='" + ma + "'");
            grvloaisanpham.EditIndex = -1;
            loadKH();
        }
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            string ma = grvhoadonchitiet.Rows[e.RowIndex].Cells[1].Text;
            string sl = ((TextBox)grvhoadonchitiet.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
            string tt = ((TextBox)grvhoadonchitiet.Rows[e.RowIndex].Cells[4].Controls[0]).Text;
            string gg = ((TextBox)grvhoadonchitiet.Rows[e.RowIndex].Cells[5].Controls[0]).Text;

            ProcessDatabase.UpdateData("update ChiTietHoaDon set SoLuong='" + sl + "', ThanhTien='" + tt + "', MucGiamGia='" + gg + "'  where MaHD='" + ma + "'");

            grvhoadonchitiet.EditIndex = -1;
            loadHDCT();
        }
Example #6
0
 public void LoadHD()
 {
     try
     {
         DataTable temp = ProcessDatabase.getData("SELECT * FROM HoaDon");
         grvhoadon.DataSource = temp;
         grvhoadon.DataBind();
     }catch (Exception ex)
     {
         Response.Write(ex.Message);
     }
 }
Example #7
0
 private void loadKH()
 {
     try
     {
         DataTable temp = ProcessDatabase.getData("SELECT * FROM KhachHang");
         grvkhachhang.DataSource = temp;
         grvkhachhang.DataBind();
     }
     catch (Exception ex)
     {
         Response.Write(ex.Message);
     }
 }
Example #8
0
 private void loadKH()
 {
     try
     {
         DataTable temp = ProcessDatabase.getData("SELECT * FROM LoaiSanPham");
         grvloaisanpham.DataSource = temp;
         grvloaisanpham.DataBind();
     }
     catch (Exception ex)
     {
         Response.Write(ex.Message);
     }
 }
Example #9
0
        protected void grvkhachhang_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            string ma       = grvkhachhang.Rows[e.RowIndex].Cells[1].Text;
            string ten      = ((TextBox)grvkhachhang.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
            string phone    = ((TextBox)grvkhachhang.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
            string address  = ((TextBox)grvkhachhang.Rows[e.RowIndex].Cells[4].Controls[0]).Text;
            string ngaysinh = ((TextBox)grvkhachhang.Rows[e.RowIndex].Cells[5].Controls[0]).Text;

            ProcessDatabase.UpdateData("update KhachHang set Ten=N'" + ten + "', DienThoai='" + phone + "', DiaChi=N'" + address + "', NgaySinh='" + ngaysinh + "'  where CustomerID='" + ma + "'");

            grvkhachhang.EditIndex = -1;
            loadKH();
        }
Example #10
0
 public void LoadSP()
 {
     try
     {
         DataTable tem = ProcessDatabase.getData("SELECT * FROM SanPham");
         grvsanpham.DataSource = tem;
         grvsanpham.DataBind();
     }
     catch (Exception ex)
     {
         Response.Write(ex.Message);
     }
 }
Example #11
0
 protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
 {
     if (maloaisanpham.Text == "" || tenloaisanpham.Text == "" || motaloaisanpham.Text == "")
     {
     }
     else
     {
         ProcessDatabase.addData("INSERT INTO LoaiSanPham (MaLoaiSp, TenLoaiSp, MotaLoaiSp) VALUES ('" + maloaisanpham.Text + "',N'" + tenloaisanpham.Text + "',N'" + motaloaisanpham.Text + "') ");
         loadKH();
         motaloaisanpham.Text = "";
         tenloaisanpham.Text  = "";
         maloaisanpham.Text   = "";
     }
 }
 protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
 {
     if (mahoadonlist.Text == "" || masanphamlist.Text == "" || soluong.Text == "" || tongtien.Text == "" || giamgia.Text == "")
     {
     }
     else
     {
         ProcessDatabase.addData("INSERT INTO ChiTietHoaDon (MaHD, MaSp, SoLuong, ThanhTien, MucGiamGia) VALUES ('" + mahoadonlist.Text + "','" + masanphamlist.Text + "','" + soluong.Text + "','" + tongtien.Text + "'," + giamgia.Text + ") ");
         loadHDCT();
         soluong.Text  = "";
         tongtien.Text = "";
         giamgia.Text  = "";
     }
 }
Example #13
0
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            string ma    = grvhoadon.Rows[e.RowIndex].Cells[1].Text;
            string makh  = ((TextBox)grvhoadon.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
            string ndh   = ((TextBox)grvhoadon.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
            string mst   = ((TextBox)grvhoadon.Rows[e.RowIndex].Cells[4].Controls[0]).Text;
            string ngh   = ((TextBox)grvhoadon.Rows[e.RowIndex].Cells[5].Controls[0]).Text;
            string noigh = ((TextBox)grvhoadon.Rows[e.RowIndex].Cells[6].Controls[0]).Text;

            ProcessDatabase.UpdateData("update HoaDon set CustomerID='" + makh + "', NgayDatHang='" + ndh + "', MaSoThue='" + mst + "', NgayGiaoHang='" + ngh + "', NoiGiaoHang=N'" + noigh + "'  where MaHD='" + ma + "'");

            grvhoadon.EditIndex = -1;
            LoadHD();
        }
Example #14
0
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            string ma              = grvsanpham.Rows[e.RowIndex].Cells[1].Text;
            string manhsx          = ((TextBox)grvsanpham.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
            string maloaisanpaham1 = ((TextBox)grvsanpham.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
            string tensanpham1     = ((TextBox)grvsanpham.Rows[e.RowIndex].Cells[4].Controls[0]).Text;
            string giasanpham1     = ((TextBox)grvsanpham.Rows[e.RowIndex].Cells[5].Controls[0]).Text;
            string motasanpham1    = ((TextBox)grvsanpham.Rows[e.RowIndex].Cells[6].Controls[0]).Text;
            string xuatxusanpham1  = ((TextBox)grvsanpham.Rows[e.RowIndex].Cells[7].Controls[0]).Text;

            ProcessDatabase.UpdateData("update SanPham set MaNhaSX=N'" + manhsx + "', MaLoaiSp='" + maloaisanpaham1 + "', TenSp=N'" + tensanpham1 + "', GiaSp='" + giasanpham1 + "', MotaSp=N'" + motasanpham1 + "', XuatXuSp=N'" + xuatxusanpham1 + "'  where MaSp='" + ma + "'");

            grvsanpham.EditIndex = -1;
            LoadSP();
        }
Example #15
0
 protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
 {
     if (masanpham.Text == "" || maloaisanpham.Text == "" || tensanpham.Text == "" || giasanpham.Text == "" || motasanpham.Text == "" || manhasanxuat.Text == "" || xuatsusanpham.Text == "")
     {
     }
     else
     {
         ProcessDatabase.addData("INSERT INTO SanPham (MaSp, MaNhaSX, MaLoaiSp, TenSp, GiaSp, MotaSp, XuatXuSp) VALUES ('" + masanpham.Text + "','" + manhasanxuat.Text + "','" + maloaisanpham.Text + "',N'" + tensanpham.Text + "'," + giasanpham.Text + ",N'" + motasanpham.Text + "',N'" + xuatsusanpham.Text + "') ");
         LoadSP();
         masanpham.Text     = "";
         manhasanxuat.Text  = "";
         tensanpham.Text    = "";
         giasanpham.Text    = "";
         motasanpham.Text   = "";
         xuatsusanpham.Text = "";
     }
 }
Example #16
0
 protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
 {
     if (makhachhang.Text == "" || tenkhachhang.Text == "" || sodienthoai.Text == "" || address.Text == "" || birthofyear.Text == "")
     {
     }
     else
     {
         DateTime ngaysinh1 = DateTime.Parse(birthofyear.Text);
         ProcessDatabase.addData("INSERT INTO KhachHang (CustomerID, Ten, DienThoai, DiaChi, NgaySinh) VALUES ('" + makhachhang.Text + "',N'" + tenkhachhang.Text + "','" + sodienthoai.Text + "',N'" + address.Text + "','" + ngaysinh1 + "') ");
         loadKH();
         makhachhang.Text  = "";
         tenkhachhang.Text = "";
         sodienthoai.Text  = "";
         address.Text      = "";
         birthofyear.Text  = "";
     }
 }
Example #17
0
 protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
 {
     if (mahoadon.Text == "" || makhachhanglist.Text == "" || ngaydathang.Text == "" || masothue.Text == "" || ngaygiaohang.Text == "" || noigiaohang.Text == "")
     {
     }
     else
     {
         DateTime ngaydh1 = DateTime.Parse(ngaydathang.Text);
         DateTime ngaygh1 = DateTime.Parse(ngaygiaohang.Text);
         ProcessDatabase.addData("INSERT INTO HoaDon (MaHD, CustomerID, NgayDatHang, MaSoThue, NgayGiaoHang, NoiGiaoHang) VALUES ('" + mahoadon.Text + "','" + makhachhanglist.Text + "','" + ngaydh1 + "','" + masothue.Text + "','" + ngaygh1 + "',N'" + noigiaohang.Text + "') ");
         LoadHD();
         mahoadon.Text     = "";
         ngaydathang.Text  = "";
         masothue.Text     = "";
         ngaygiaohang.Text = "";
         noigiaohang.Text  = "";
     }
 }