public ActionResult DeleteConfirmed(int id)
{
HangSP hangSP = db.HangSPs.Find(id);
db.HangSPs.Remove(hangSP);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MaHang,TenHang")] HangSP hangSP)
{
if (ModelState.IsValid)
{
db.Entry(hangSP).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hangSP));
}
public ActionResult Create([Bind(Include = "MaHang,TenHang")] HangSP hangSP)
{
if (ModelState.IsValid)
{
db.HangSPs.Add(hangSP);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hangSP));
}
public ActionResult Edit(int id, HangSP hsp)
{
try
{
// TODO: Add update logic here
NhaSanXuatBus.Sua(id, hsp);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(HangSP hsp)
{
try
{
// TODO: Add insert logic here
NhaSanXuatBus.Them(hsp);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, HangSP HangSP)
{
try
{
// TODO: Add update logic here
HangBus.Sua(HangSP);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(HangSP HangSP)
{
try
{
// TODO: Add insert logic here
HangBus.Them(HangSP);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// GET: HangSPs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HangSP hangSP = db.HangSPs.Find(id);
if (hangSP == null)
{
return(HttpNotFound());
}
return(View(hangSP));
}
private void btnSave_Click(object sender, EventArgs e)
{
switch (choose)
{
case 1:
{
if (txtNameBrand.Text == "")
{
MessageBox.Show("Please enter name of brand");
}
else if (txtNameBrand.Text != "")
{
var hsp = from u in db.HangSPs select u;
if (hsp.Count() == 0)
{
db.HSP_Ins("Hang0001", txtNameBrand.Text);
}
else
{
HangSP hspp = db.HangSPs.Where(s => s.tenHang.Equals(txtNameBrand.Text)).FirstOrDefault();
if (hspp != null)
{
MessageBox.Show("Alredy have this name");
}
else if (hspp == null)
{
var hsppp = hsp.OrderByDescending(s => s.maHang).FirstOrDefault();
int stt = Convert.ToInt32(hsppp.maHang.Substring(4)) + 1;
string id = "";
if (stt / 10 >= 100)
{
id = "Hang" + stt;
}
else if (stt / 10 >= 10 && stt / 10 < 100)
{
id = "Hang0" + stt;
}
else if (stt / 10 >= 1 && stt / 10 < 10)
{
id = "Hang00" + stt;
}
else if (stt / 10 == 0)
{
id = "Hang000" + stt;
}
db.HSP_Ins(id, txtNameBrand.Text);
//dgvHangSP.DataSource = db.HSP_Sel();
}
}
Uc_HangSP_Load(sender, e);
}
break;
}
case 2:
{
if (txtIDBrand.Text == "")
{
MessageBox.Show("Please enter the id to delete");
}
else
{
db.HSP_Del(txtIDBrand.Text);
Uc_HangSP_Load(sender, e);
}
break;
}
case 3:
{
if (txtIDBrand.Text == "" || txtNameBrand.Text == "")
{
MessageBox.Show("Please enter the id and name of brand");
}
else
{
HangSP hsp = db.HangSPs.Where(s => s.tenHang.Equals(txtNameBrand.Text)).FirstOrDefault();
if (hsp != null)
{
MessageBox.Show("Already have this name");
}
else
{
db.HSP_Up(txtIDBrand.Text, txtNameBrand.Text);
Uc_HangSP_Load(sender, e);
}
}
break;
}
}
}
public static void Sua(int id, HangSP hsp)
{
var db = new ShopDienThoaiConnectionDB();
db.Update <HangSP>("Set TenHang = @0, BiXoa=0 where MaLoai=@1", hsp.TenHang, id);
}
public static void Them(HangSP hsp)
{
var db = new ShopDienThoaiConnectionDB();
db.Insert(hsp);
}
