protected void gvNCC_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
nhacungcap ncc = new nhacungcap();
int MNCC = int.Parse(gvNCC.Rows[e.RowIndex].Cells[0].Text);
ado.xoa_NhaCungCap(MNCC);
Response.Write("<script>alert('Xóa thành công!');</script>");
loadNCC();
}
public ActionResult Suanhacungcap(int id)
{
nhacungcap thuonghieu = db.nhacungcaps.SingleOrDefault(n => n.MaNCC == id);
if (thuonghieu == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(thuonghieu));
}
protected void gvNCC_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
int MNCC = int.Parse(gvNCC.DataKeys[e.NewSelectedIndex].Value.ToString());
nhacungcap nhacc = new nhacungcap();
nhacc = ado.laynhacungcap(MNCC);
txtMNCC.Text = nhacc.MNCC1.ToString();
TenNCC.Text = nhacc.TenNCC1.ToString();
txtDiaChiNCC.Text = nhacc.DiaChiNCC1.ToString();
txtSDTNCC.Text = nhacc.SDTNCC1.ToString();
}
public ActionResult Xoanhacungcap(int id)
{
nhacungcap nhacungcap = db.nhacungcaps.SingleOrDefault(n => n.MaNCC == id);
ViewBag.MaNCC = nhacungcap.MaNCC;
if (nhacungcap == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(nhacungcap));
}
// xem nhà cung cấp
public List <nhacungcap> XemNhaCC()
{
List <nhacungcap> list = new List <nhacungcap>();
string query = "select ma, ten, diachi,sodienthoai, email from nhacungcap";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
nhacungcap ncc = new nhacungcap(item);
list.Add(ncc);
}
return(list);
}
// tìm kiếm nhà cung cấp
public List <nhacungcap> SearchNhaCC(string ma, string ten)
{
List <nhacungcap> list = new List <nhacungcap>();
string query = string.Format("select * from nhacungcap mh where mh.ma like N'%{0}%' and mh.ten like N'%{1}%' ", ma, ten);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow i in data.Rows)
{
nhacungcap mh = new nhacungcap(i);
list.Add(mh);
}
return(list);
}
public ActionResult Xacnhanxoanhacungcap(int id)
{
nhacungcap nhacungcap = db.nhacungcaps.SingleOrDefault(n => n.MaNCC == id);
ViewBag.MaTH = nhacungcap.MaNCC;
if (nhacungcap == null)
{
Response.StatusCode = 404;
return(null);
}
db.nhacungcaps.DeleteOnSubmit(nhacungcap);
db.SubmitChanges();
return(RedirectToAction("Nhacungcap"));
}
public ActionResult Suanhacungcap(nhacungcap thuonghieu, HttpPostedFileBase anhSanPham)
{
//var filename = Path.GetFileName(fileupload.FileName);
//var path = Path.Combine(Server.MapPath("~/images/"), filename);
//db.SubmitChanges();
//db.THUONGHIEUs.InsertOnSubmit(thuonghieu);
nhacungcap Thuonghieu = db.nhacungcaps.Single(p => p.MaNCC == thuonghieu.MaNCC);
Thuonghieu.TenNCC = thuonghieu.TenNCC;
Thuonghieu.Diachi = thuonghieu.Diachi;
Thuonghieu.DienThoai = thuonghieu.DienThoai;
db.SubmitChanges();
return(RedirectToAction("Nhacungcap"));
}
protected void btnthem_Click(object sender, EventArgs e)
{
if (TenNCC.Text == "" || txtSDTNCC.Text == "" || txtDiaChiNCC.Text == "")
{
Response.Write("<script>alert('Chưa nhập đủ thông tin!');</script>");
}
else
{
nhacungcap ncc = new nhacungcap();
//ncc.MNCC1 = int.Parse(txtMNCC.Text);
ncc.TenNCC1 = TenNCC.Text.ToString();
ncc.DiaChiNCC1 = txtDiaChiNCC.Text.ToString();
ncc.SDTNCC1 = txtSDTNCC.Text.ToString();
ado.them_NhaCungCap(ncc);
loadNCC();
Response.Write("<script>alert('Thêm nhà cung cấp thành công!');</script>");
}
}
public nhacungcap laynhacungcap(int MNCC)
{
string qry = "select * from NhaCungCap where MNCC=" + MNCC;
using (SqlConnection connect = new SqlConnection(connectionString))
{
connect.Open();
SqlCommand cmd = new SqlCommand(qry, connect);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
nhacungcap a = new nhacungcap();
a.MNCC1 = reader.GetInt32(0);
a.TenNCC1 = reader.GetString(1);
a.DiaChiNCC1 = reader.GetString(2);
a.SDTNCC1 = reader.GetString(3);
cmd.Dispose();
reader.Dispose();
connect.Close();
return(a);
}
}
private List <nhacungcap> GetData()
{
List <nhacungcap> lst = new List <nhacungcap>();
string loi = "";
for (int i = 1; i < c1FlexGrid1.Rows.Count; i++)
{
if (c1FlexGrid1[i, "TT"].ToString().Equals("0") == false)
{
try
{
loi = "";
nhacungcap _obj = new nhacungcap();
if (c1FlexGrid1[i, "ten"].ToString().Trim().Equals("") == true || c1FlexGrid1[i, "ten"] == null)
{
loi = "Tên nhà cung cấp không được để trắng.";
c1FlexGrid1.SetUserData(i, "ten", loi);
c1FlexGrid1.Rows[i].Style = cserror;
}
_obj.diachi = c1FlexGrid1[i, "diachi"].ToString();
_obj.dienthoai = c1FlexGrid1[i, "dienthoai"].ToString();
_obj.ghichu = c1FlexGrid1[i, "ghichu"].ToString();
if (c1FlexGrid1[i, "TT"].ToString().Equals("1") == true)
{
_obj.id = Guid.NewGuid().ToString(); c1FlexGrid1[i, "id"] = _obj.id.Trim();
}
if (c1FlexGrid1[i, "TT"].ToString().Equals("2") == true)
{
_obj.id = c1FlexGrid1[i, "id"].ToString();
}
_obj.ten = c1FlexGrid1[i, "ten"].ToString();
_obj.daxoa = 0;
lst.Add(_obj);
}
catch { }
}
}
return(lst);
}
private void HienThiTTPhieuNhap()
{
tblphieunhapkho objpn = new tblphieunhapkho();
tblphieunhapkhoBL ctrpn = new tblphieunhapkhoBL();
objpn = ctrpn.GetByID(sidpn);
try{
nhacungcap objnhacc = new nhacungcap();
nhacungcapBL ctrnhacc = new nhacungcapBL();
objnhacc = ctrnhacc.GetByID(objpn.id_nguoicap.Trim());
lbDiaChi.Text = objnhacc.diachi;
lbDienThoai.Text = objnhacc.dienthoai;
lbNgayXuat.Text = objpn.ngaytao.ToString("dd/MM/yyyy HH:mm:ss");
lbTenKH.Text = objnhacc.ten;
}
catch {
lbDiaChi.Text = "-/-";
lbDienThoai.Text = "-/-";
lbNgayXuat.Text = "-/-";
lbTenKH.Text = "-/-";
}
}
private void cbNhaCC_SelectedIndexChanged(object sender, EventArgs e)
{
tblphieunhapkhoBL ctrpn = new tblphieunhapkhoBL();
string sidnhacc = "";
try { sidnhacc = cbNhaCC.SelectedValue.ToString().Trim(); }
catch { }
nhacungcap obj = new nhacungcap();
nhacungcapBL ctr = new nhacungcapBL();
obj = ctr.GetByID(sidnhacc);
try
{
try
{
txtNoToaTruoc.Text = ctrpn.GetTienConNo(sidnhacc, dpkNgayNhap.Value).ToString("N0", CultureInfo.InvariantCulture);
}
catch { txtNoToaTruoc.Text = "0"; }
txtDiaChi.Text = obj.diachi;
txtDienThoai.Text = obj.dienthoai.Trim();
double tongtien = 0;
try { tongtien = Convert.ToDouble(txtTongTien.Text); }
catch { }
double tienconno = 0;
try { tienconno = Convert.ToDouble(txtNoToaTruoc.Text); }
catch { }
double tientt = 0;
try { tientt = Convert.ToDouble(txtTienThanhToan.Text); }
catch { }
double chietkhau = 0;
try { chietkhau = Convert.ToDouble(txtChietKhau.Text); }
catch { }
txtConNo.Text = ((tienconno + tongtien) - (tientt + chietkhau)).ToString("N0", CultureInfo.InvariantCulture);
}
catch
{
txtDiaChi.Text = "";
txtDienThoai.Text = "";
txtTongTien.Text = "0";
}
}
public static bool CreateNhaCC(nhacungcap cc)
{
try
{
using (SieuThiDBDataContext db = new SieuThiDBDataContext())
{
var cc1 = new nhacungcap();
cc1.tennhacungcap = cc.tennhacungcap;
cc1.ma = cc.ma;
cc1.diachi = cc.diachi;
cc1.sodienthoai = cc.sodienthoai;
cc1.masothue = cc.masothue;
cc1.fax = cc.fax;
db.nhacungcaps.InsertOnSubmit(cc1);
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static bool UpdateNhaCC(nhacungcap _cc)
{
try
{
using (var db = new SieuThiDBDataContext())
{
var cc = db.nhacungcaps.Single(x => x.ma == _cc.ma);
cc.tennhacungcap = _cc.tennhacungcap;
cc.ma = _cc.ma;
cc.diachi = _cc.diachi;
cc.sodienthoai = _cc.sodienthoai;
cc.masothue = _cc.masothue;
cc.fax = _cc.fax;
db.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
private void button3_Click(object sender, EventArgs e)
{
NHACUNGCAPDAL cmd = new NHACUNGCAPDAL();
nhacungcap data = new nhacungcap();
data.mancc = txtma.Text;
data.tenncc = txtten.Text;
data.diachi = txtdiachi.Text;
data.dienthoai = txtsdt.Text;
bool kt = cmd.nhacungcap_delete(data);
if (kt == false)
{
MessageBox.Show("Loi");
}
else
{
MessageBox.Show("Xóa thành công");
}
Load_Data("select * from NHACUNGCAP");
}
/// <summary>
/// Cập nhật dữ liệu vào bảng: nhacungcap
/// </summary>
/// <param name="obj">objnhacungcap</param>
/// <returns>Trả về trắng: Cập nhật thành công; Trả về khác trắng: Cập nhật không thành công</returns>
public string Update(nhacungcap objnhacungcap)
{
return(objnhacungcapDA.Update(objnhacungcap));
}
/// <summary>
/// Thêm mới dữ liệu vào bảng: nhacungcap
/// </summary>
/// <param name="obj">objnhacungcap</param>
/// <returns>Trả về trắng: Thêm mới thành công; Trả về khác trắng: Thêm mới không thành công</returns>
public string Insert(nhacungcap objnhacungcap)
{
return(objnhacungcapDA.Insert(objnhacungcap));
}
public nhacungcapBL()
{
objnhacungcapDA = new nhacungcap();
}
public bool them_NhaCungCap(nhacungcap ncc)
{
string qry = "insert into NhaCungCap(TenNCC, DiaChiNCC, SDTNCC) values(N'" + ncc.TenNCC1 + "', N'" + ncc.DiaChiNCC1 + "', N'" + ncc.SDTNCC1 + "')";
return(Insert_Update_Delete(qry));
}
public bool update_NhaCungCap(nhacungcap ncc)
{
string qry = "update NhaCungCap set TenNCC = N'" + ncc.TenNCC1 + "' ,DiaChiNCC = N'" + ncc.DiaChiNCC1 + "', SDTNCC = N'" + ncc.SDTNCC1 + "' where MNCC='" + ncc.MNCC1 + "'";
return(Insert_Update_Delete(qry));
}
private void Save()
{
string temploi = "";
string loi = "";
nhacungcapBL _ctr = new nhacungcapBL();
List <nhacungcap> lst = new List <nhacungcap>();
lst = GetData();
if (lst != null)
{
for (int i = 0; i < lst.Count; i++)
{
loi = "";
nhacungcap _obj = new nhacungcap();
try { _obj = _ctr.GetByID(lst[i].id); }
catch { }
if (_obj == null)
{
try { loi = c1FlexGrid1.GetUserData(c1FlexGrid1.FindRow(lst[i].id.ToString().Trim(), 1, c1FlexGrid1.Cols["id"].Index, true, true, true), "ten").ToString().Trim(); }
catch { }
if (loi.Equals("") == true)
{
loi = _ctr.Insert(lst[i]);
if (loi.Equals("") == false)
{
c1FlexGrid1.Rows[c1FlexGrid1.FindRow(lst[i].id.ToString().Trim(), 1, c1FlexGrid1.Cols["id"].Index, true, true, true)].Style = cserror;
}
else
{
_ctrlog.Append(Data.use, "Thêm mới nhà cung cấp: " + lst[i].ten.Trim());
}
}
else
{
c1FlexGrid1.Rows[c1FlexGrid1.FindRow(lst[i].id.ToString().Trim(), 1, c1FlexGrid1.Cols["id"].Index, true, true, true)].Style = cserror;
}
if (loi.Trim().Equals("") == false)
{
temploi = loi;
}
}
else
{
try { loi = c1FlexGrid1.GetUserData(c1FlexGrid1.FindRow(lst[i].id.ToString().Trim(), 1, c1FlexGrid1.Cols["id"].Index, true, true, true), "ten").ToString().Trim(); }
catch { }
if (loi.Equals("") == true)
{
loi = _ctr.Update(lst[i]);
if (loi.Equals("") == false)
{
c1FlexGrid1.SetUserData(c1FlexGrid1.FindRow(lst[i].id.ToString().Trim(), 1, c1FlexGrid1.Cols["id"].Index, true, true, true), "ten", loi);
c1FlexGrid1.Rows[c1FlexGrid1.FindRow(lst[i].id.ToString().Trim(), 1, c1FlexGrid1.Cols["id"].Index, true, true, true)].Style = cserror;
}
else
{
_ctrlog.Append(Data.use, "Cập nhật thông tin nhà cung cấp: " + lst[i].ten.Trim());
}
}
else
{
c1FlexGrid1.SetUserData(c1FlexGrid1.FindRow(lst[i].id.ToString().Trim(), 1, c1FlexGrid1.Cols["id"].Index, true, true, true), "ten", loi);
c1FlexGrid1.Rows[c1FlexGrid1.FindRow(lst[i].id.ToString().Trim(), 1, c1FlexGrid1.Cols["id"].Index, true, true, true)].Style = cserror;
}
if (loi.Trim().Equals("") == false)
{
temploi = loi;
}
}
}
}
if (temploi.Trim().Equals("") == true)
{
HienThiDS();
MessageBox.Show("Cập nhật dữ liệu thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Cập nhật dữ liệu không thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ActionResult Themmoinhacungcap(nhacungcap nhacungcap)
{
db.nhacungcaps.InsertOnSubmit(nhacungcap);
db.SubmitChanges();
return(RedirectToAction("Nhacungcap"));
}
