public void UpdateNSXBUS(NhaSanXuat nsxToUpdate)
{
nsxDAO.UpdateNSXDAO(nsxToUpdate);
}
public static void EditNSX(NhaSanXuat a)
{
var db = new FashionShopConectionDB();
db.Update("NhaSanXuat", "idNSX", a);
}
public static void UpdateNSX(String id, NhaSanXuat nsx)
{
var db = new ShopOnlineConnectionDB();
db.Update(nsx, id);
}
public static void UpdateNSX(String id, NhaSanXuat NSX)
{
var sql = new MobileShopConnectionDB();
sql.Update(NSX, id);
}
// Xóa Nhà Sản Xuất
public ActionResult DeleteNhaSanXuat(int?id)
{
NhaSanXuat bv = db.NhaSanXuats.Find(id);
return(View(bv));
}
public void ThemMoi(NhaSanXuat item)
{
_nhaSanXuatRepository.Add(item);
}
public Boolean Update(NhaSanXuat sx)
{
return(db.ExcuteNonQuery("update NhaSanXuat set TenNSX=N'" + sx.TenNSX + "',Logo=N'" + sx.Logo + "' where MaNSX='" + sx.MaNSX + "'"));
}
public void SuaDuLieu(NhaSanXuat et)
{
cn.ThucThiCauLenhSql(@"UPDATE NHASANXUAT
SET Tennsanxuat =N'" + et.Tennsx1 + "', Quocgia =N'" + et.Quocgia1 + "', Dienthoai ='" + et.Dienthoai1 + "', Email ='" + et.Email1 + "' where Mansanxuat='" + et.Mansx1 + "'");
}
public void XoaDuLieu(NhaSanXuat et)
{
cn.ThucThiCauLenhSql(@"DELETE FROM NHASANXUAT WHERE Mansanxuat='" + et.Mansx1 + "'");
}
//
// GET: /NhaSanXuat/Delete/5
public ActionResult Delete(int id)
{
NhaSanXuat nhasanxuat = db.NhaSanXuats.Find(id);
return(View(nhasanxuat));
}
public void ThemDuLieu(NhaSanXuat et)
{
cn.ThucThiCauLenhSql(@"INSERT INTO NHASANXUAT (Mansanxuat,Tennsanxuat, Quocgia, Dienthoai, Email )
VALUES ('" + et.Mansx1 + "',N'" + et.Tennsx1 + "',N'" + et.Quocgia1 + "','" + et.Dienthoai1 + "','" + et.Email1 + "')");
}
//
// GET: /NhaSanXuat/Details/5
public ViewResult Details(int id)
{
NhaSanXuat nhasanxuat = db.NhaSanXuats.Find(id);
return(View(nhasanxuat));
}
/// <summary>
/// hàm thêm tác giả
/// </summary>
/// <param name="entity">NhaSanXuat</param>
/// <returns></returns>
public int InsertAuthor(NhaSanXuat entity)
{
db.NhaSanXuats.Add(entity);
db.SaveChanges();
return(entity.MaNSX);
}
//--------------Admin
public static void ThemNSX(NhaSanXuat nsx)
{
var db = new PetproShopConnectionDB();
db.Insert(nsx);
}
// GET: NhaSanXuat/Create
public ActionResult Create()
{
var model = new NhaSanXuat();
return(View(model));
}
// GET: Admin/LoaiSanPham
public ActionResult Index()
{
return(View(NhaSanXuat.DanhSachAdmin()));
}
public void CapNhat(NhaSanXuat item)
{
_nhaSanXuatRepository.Update(item);
}
// GET: Admin/LoaiSanPham/Edit/5
public ActionResult Edit(int id)
{
return(View(NhaSanXuat.ChitietAdmin(id)));
}
public Boolean Insert(NhaSanXuat sx)
{
return(db.ExcuteNonQuery("insert into NhaSanXuat values('" + sx.MaNSX + "',N'" + sx.TenNSX + "',N'" + sx.Logo + "')"));
}
public ActionResult XoaTamThoi(int id)
{
return(View(NhaSanXuat.ChitietAdmin(id)));
}
public static void ThemNSX(NhaSanXuat NSX)
{
var sql = new MobileShopConnectionDB();
sql.Insert(NSX);
}
public static void Them(NhaSanXuat sx)
{
var sql = new ShopOnlineConnectionDB();
sql.Insert(sx);
}
public ActionResult Create(NhaSanXuat model)
{
return(View());
}
public static void UpdateDS(NhaSanXuat sx)
{
var sql = new ShopOnlineConnectionDB();
sql.Update("NhaSanXuat", "Manhasanxuat", sx);
}
public static void SaveNSX(NhaSanXuat a)
{
var db = new FashionShopConectionDB();
db.Insert("NhaSanXuat", "idNSX", a);
}
public void AddNSX(NhaSanXuat nsx)
{
db.NhaSanXuat.Add(nsx);
db.SaveChanges();
}
//---------------- Admin
public static void ThemNSX(NhaSanXuat nsx)
{
var db = new ShopOnlineConnectionDB();
db.Insert(nsx);
}
// Loc Nha San Xuat
public List <NhaSanXuat> LocDanhSachNhaSx(NhaSanXuat nsx)
{
try
{
OpenConnection();
List <NhaSanXuat> nsxlist = new List <NhaSanXuat>();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = CommandType.Text;
SqlDataReader sqlReader = null;
DataTable dt = new DataTable();
if (nsx.Search == "Mã Sản Xuất")
{
sqlCommand.CommandText = "SELECT MASX FROM dbo.NHASX";
sqlCommand.Connection = conn;
sqlReader = sqlCommand.ExecuteReader();
dt.Load(sqlReader);
for (int i = 0; i < dt.Rows.Count; i++)
{
NhaSanXuat nsxs = new NhaSanXuat();
nsxs.MaSx = int.Parse(dt.Rows[i][0].ToString());
nsxlist.Add(nsxs);
}
}
else if (nsx.Search == "Tên Sản Xuất")
{
sqlCommand.CommandText = "SELECT TENSX FROM dbo.NHASX";
sqlCommand.Connection = conn;
sqlReader = sqlCommand.ExecuteReader();
dt.Load(sqlReader);
for (int i = 0; i < dt.Rows.Count; i++)
{
NhaSanXuat nsxs = new NhaSanXuat();
nsxs.TenSx = dt.Rows[i][0].ToString();
nsxlist.Add(nsxs);
}
}
else if (nsx.Search == "Quốc Gia")
{
sqlCommand.CommandText = "SELECT DISTINCT(QUOCGIA) FROM dbo.NHASX";
sqlCommand.Connection = conn;
sqlReader = sqlCommand.ExecuteReader();
dt.Load(sqlReader);
for (int i = 0; i < dt.Rows.Count; i++)
{
NhaSanXuat nsxs = new NhaSanXuat();
nsxs.QuocGia = dt.Rows[i][0].ToString();
nsxlist.Add(nsxs);
}
}
sqlReader.Close();
return(nsxlist);
}
catch
{
throw;
}
finally
{
CloseConnection();
}
}
protected override void Seed(Model1 context)
{
MatHang mh1 = new MatHang()
{
MaMatHang = 1, TenMatHang = "Dien tu"
};
MatHang mh2 = new MatHang()
{
MaMatHang = 2, TenMatHang = "Gia dung"
};
MatHang mh3 = new MatHang()
{
MaMatHang = 3, TenMatHang = "Xe may"
};
MatHang mh4 = new MatHang()
{
MaMatHang = 4, TenMatHang = "Dien thoai"
};
context.MatHangs.Add(mh1);
context.MatHangs.Add(mh2);
context.MatHangs.Add(mh3);
context.MatHangs.Add(mh4);
NhaSanXuat n1 = new NhaSanXuat()
{
TenNhaSanXuat = "Apple", MaNhaSanXuat = 1
};
NhaSanXuat n2 = new NhaSanXuat()
{
TenNhaSanXuat = "Honda", MaNhaSanXuat = 2
};
NhaSanXuat n3 = new NhaSanXuat()
{
TenNhaSanXuat = "Sunshine", MaNhaSanXuat = 3
};
NhaSanXuat n4 = new NhaSanXuat()
{
TenNhaSanXuat = "Samsung", MaNhaSanXuat = 4
};
context.NhaSanXuats.Add(n1);
context.NhaSanXuats.Add(n2);
context.NhaSanXuats.Add(n3);
context.NhaSanXuats.Add(n4);
SanPham sp1 = new SanPham()
{
MaSanPham = "DT1", TenSanPham = "Bong den", NgayNhapHang = DateTime.Parse("2020-12-30 12:49:18.400"), MaMatHang = mh2.MaMatHang, TinhTrang = true, MaNhaSanXuat = n3.MaNhaSanXuat
};
SanPham sp2 = new SanPham()
{
MaSanPham = "DT2", TenSanPham = "Bong den dien", NgayNhapHang = DateTime.Parse("2020-12-29 12:49:18.400"), MaMatHang = mh2.MaMatHang, TinhTrang = true, MaNhaSanXuat = n3.MaNhaSanXuat
};
SanPham sp3 = new SanPham()
{
MaSanPham = "HD1", TenSanPham = "Xe honda", NgayNhapHang = DateTime.Parse("2020-12-30 11:49:18.400"), MaMatHang = mh3.MaMatHang, TinhTrang = true, MaNhaSanXuat = n2.MaNhaSanXuat
};
SanPham sp4 = new SanPham()
{
MaSanPham = "IP1", TenSanPham = "IPhone 7 Plus", NgayNhapHang = DateTime.Parse("2020-11-30 10:49:18.400"), MaMatHang = mh4.MaMatHang, TinhTrang = false, MaNhaSanXuat = n1.MaNhaSanXuat
};
SanPham sp5 = new SanPham()
{
MaSanPham = "NRC1", TenSanPham = "Nuoc rua chen", NgayNhapHang = DateTime.Parse("2020-12-30 12:49:18.400"), MaMatHang = mh3.MaMatHang, TinhTrang = true, MaNhaSanXuat = n1.MaNhaSanXuat
};
SanPham sp6 = new SanPham()
{
MaSanPham = "SS1", TenSanPham = "Galaxy note 10", NgayNhapHang = DateTime.Parse("2019-12-30 12:49:18.400"), MaMatHang = mh4.MaMatHang, TinhTrang = false, MaNhaSanXuat = n4.MaNhaSanXuat
};
SanPham sp7 = new SanPham()
{
MaSanPham = "IP2", TenSanPham = "IPhone X", NgayNhapHang = DateTime.Parse("2020-12-30 12:30:18.400"), MaMatHang = mh4.MaMatHang, TinhTrang = true, MaNhaSanXuat = n1.MaNhaSanXuat
};
SanPham sp8 = new SanPham()
{
MaSanPham = "HD2", TenSanPham = "Honda cv5", NgayNhapHang = DateTime.Parse("2020-12-30 12:49:18.400"), MaMatHang = mh3.MaMatHang, TinhTrang = true, MaNhaSanXuat = n2.MaNhaSanXuat
};
context.SanPhams.Add(sp1);
context.SanPhams.Add(sp2);
context.SanPhams.Add(sp3);
context.SanPhams.Add(sp4);
context.SanPhams.Add(sp5);
context.SanPhams.Add(sp6);
context.SanPhams.Add(sp7);
context.SanPhams.Add(sp8);
context.SaveChanges();
}
public void AddNSXBUS(NhaSanXuat nsx)
{
nsxDAO.AddNSX(nsx);
}
