public ActionResult Themloai(FormCollection form)
{
var tenloai = form["tenloai"];
var danhmuc = form["danhmuc"];
var loai = data.LOAISPs.SingleOrDefault(x => x.TENLOAI == tenloai);
if (loai != null)
{
ViewBag.tenloai = "***Tên loại đã tồn tại!";
return(View());
}
else
{
LOAISP l = new LOAISP();
l.MALOAI = Capma_tudong("ML");
l.TENLOAI = tenloai;
l.MADM = danhmuc;
l.ACTIVE = true;
data.LOAISPs.InsertOnSubmit(l);
data.SubmitChanges();
Update_ma("ML");
ViewBag.thongbao = "Thêm mới loại thành công!";
}
return(View());
}
public string GetTenLSP(CHITIETDONHANG CTDH)
{
SANPHAM sp = cn.GetObject <SANPHAM>("api/SANPHAM/" + CTDH.SANPHAM_ID);
LOAISP lsp = cn.GetObject <LOAISP>("api/LOAISP/" + sp.LOAISP_ID);
return(lsp.TEN);
}
private void xoalsp(int malsp)
{
LOAISP lsp = new LOAISP();
LOAISPBUS lspbus = new LOAISPBUS();
SANPHAMBUS spbus = new SANPHAMBUS();
if (spbus.LSPExists(malsp))
{
DialogResult dialogResult = MessageBox.Show("Loại Phẩm Bạn Muốn Xóa Hiện có chứa Sản Phẩm. Nếu Bạn xóa Loại SP này, SP thuộc về LSP này sẽ mất đi." + "\n" + "Bạn chắc chắn muốn xóa chứ", "", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
lsp.ID = malsp;
spbus.DeleteAllWithLSP(malsp);
btn_laydulieu.PerformClick();
}
}
if (lspbus.Delete(lsp))
{
MessageBox.Show("Xóa Thành công!");
btn_laydulieu_lsp.PerformClick();
}
else
{
MessageBox.Show("Lỗi:" + GenericDataRepository <LOAISP> .error_message);
}
}
public ActionResult createLoaiSP(FormCollection frmCreate, LOAISP lsp)
{
lsp.TenLoai = frmCreate["TenLoaiSP"];
db.LOAISPs.Add(lsp);
db.SaveChanges();
return(RedirectToAction("createLoaiSP", "AdminCRUD"));
}
public ActionResult AddLoaiSP(LOAISP loai)
{
if (ModelState.IsValid)
{
var tenLoai = loai.TenLoai;
var check = db.LOAISPs.Where(x => x.TenLoai == tenLoai);
if (check.Count() == 0)
{
db.LOAISPs.Add(loai);
db.SaveChanges();
TempData["ThongBao"] = "Thêm loại sản phẩm thành công!";
return(View(loai));
}
else
{
TempData["ThongBao"] = "Tên loại sản phẩm đã tồn tại!";
return(View(loai));
}
}
else
{
TempData["ThongBao"] = "Thêm loại sản phẩm không thành công!";
}
return(View());
}
private void GetDSSPandLoaiSP()
{
data_dssp = new DataTable();
data_dssp.Columns.Add("Mã SP", typeof(int));
data_dssp.Columns.Add("Tên", typeof(string));
data_dssp.Columns.Add("Loại", typeof(int));
spbus = new SANPHAMBUS(); //Khoi tao SANPHAMBUS de goi ham duoi controller
List <SANPHAM> lst_sp = new List <SANPHAM>();
lst_sp = spbus.GetList();
foreach (SANPHAM sp in lst_sp)
{
data_dssp.Rows.Add(sp.ID, sp.TENSP, sp.IDLOAISP); // Add tung sanpham co trong DSSP vao data table
}
dsspgv_dh.DataSource = data_dssp; //gan du lieu cho data gridview cho dssp
dsspgv_dh.Columns["Loại"].Visible = false;
//==========================================================//
List <LOAISP> lst_lsp = new List <LOAISP>();
lst_lsp = lspbus.GetList();
LOAISP tatca = new LOAISP();
tatca.ID = 0;
tatca.TENLOAI = "Tất Cả";
lst_lsp.Add(tatca);
cbb_lsp_dh.DataSource = lst_lsp;
cbb_lsp_dh.DisplayMember = "TENLOAI";
cbb_lsp_dh.ValueMember = "ID";
cbb_lsp_dh.SelectedValue = 0;
}
public ActionResult EditLoai(LOAISP loai)
{
if (ModelState.IsValid)
{
// can phai lay sach tu csdl ra
var thisloai = db.LOAISPs.Single(n => n.MALOAI == loai.MALOAI);
//rui moi luu vao csdl
// ly do vi sao thi ko pit
UpdateModel(thisloai);
db.SubmitChanges();
}
return(RedirectToAction("LoaiSP"));
//if (ModelState.IsValid)
//{
// // can phai lay sach tu csdl ra
// var thisLoai = db.LOAISPs.Any((l => l.TENLOAI.Equals(loai.TENLOAI)));
// if (thisLoai)
// {
// ViewBag.Thongbao = "Tên loại đã tồn tại";
// return View(loai);
// }
// //rui moi luu vao csdl
// // ly do vi sao thi ko pit
// UpdateModel(loai);
// db.SubmitChanges();
//}
//return RedirectToAction("LoaiSP",new { page = 1 });
}
public ActionResult ChiTietLoaiSP(int id)
{
LOAISP model = KiemTraKhoaChinh(id);
ViewBag.SoLuongNV = db.LOAISPs.Count();
return(View(model));
}
public ActionResult themloai(LOAISP l)
{
ViewBag.MADM = new SelectList(db.DANHMUCs.OrderBy(n => n.MADM), "MADM", "TENDANHMUC");
db.LOAISPs.InsertOnSubmit(l);
db.SubmitChanges();
return(View());
}
public static LoaiSanPhamVM ConvertLoaiSP(LOAISP loaiSP)
{
LoaiSanPhamVM _loaiSP = new LoaiSanPhamVM();
_loaiSP.maLoaiSP = loaiSP.MALSP;
_loaiSP.tenLoaiSP = loaiSP.TENLSP;
return(_loaiSP);
}
public void themLoaiSP(string malsp, string tenlsp)
{
LOAISP insert = new LOAISP();
insert.MALSP = malsp;
insert.TENLSP = tenlsp;
ff.LOAISPs.InsertOnSubmit(insert);
ff.SubmitChanges();
}
public ActionResult DeleteLoai(int?id, string language)
{
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(language);
Thread.CurrentThread.CurrentUICulture = new CultureInfo(language);
LOAISP lsp = db.LOAISPs.Find(id);
return(View(lsp));
}
public void ThemLoaiSP(LoaiSP_DTO a)
{
LOAISP b = new LOAISP();
b.TenLoaiSP = a.TenLoaiSP;
b.MaDonViTinh = a.MaDonViTinh;
b.PhanTramLoiNhuan = a.PhanTramLoiNhuan;
DB.LOAISPs.InsertOnSubmit(b);
DB.SubmitChanges();
}
public ActionResult SPmenu(int id, int?page)
{
int pageSize = 16;
int pageNum = (page ?? 1);
var a = from tt in db.SANPHAMs where tt.MALOAI == id select tt;
LOAISP loai = db.LOAISPs.SingleOrDefault(N => N.MALOAI == id);
ViewBag.loai = loai.TENLOAI;
return(View(a.ToPagedList(pageNum, pageSize)));
}
public IHttpActionResult PostLOAISP(LOAISP lOAISP)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
lspDAO.InsertLOAISP(lOAISP);
return(CreatedAtRoute("DefaultApi", new { id = lOAISP.ID }, lOAISP));
}
public void suaLoaiSP(string malsp, string tenlsp)
{
LOAISP update = ff.LOAISPs.Where(t => t.MALSP == malsp).FirstOrDefault();
if (update != null)
{
update.TENLSP = tenlsp;
}
ff.SubmitChanges();
}
public void xoaLSP(string malsp)
{
LOAISP delete = ff.LOAISPs.Where(t => t.MALSP == malsp).FirstOrDefault();
if (delete != null)
{
ff.LOAISPs.DeleteOnSubmit(delete);
}
ff.SubmitChanges();
}
public ActionResult EditLoaiSP(int?maLoai)
{
LOAISP loai = db.LOAISPs.SingleOrDefault(x => x.MaLoai == maLoai);
if (loai == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(loai));
}
public IHttpActionResult GetLOAISP(int id)
{
LOAISP lOAISP = lspDAO.GetLSPbyId(id);
if (lOAISP == null)
{
return(NotFound());
}
return(Ok(lOAISP));
}
private void btnLuu_Click(object sender, EventArgs e)
{
LOAISP lsp1 = new LOAISP();
lsp1.HANGSX_ID = (int)cbHangSX.SelectedValue;
lsp1.TEN = txtTen.Text;
//lsp1.TRANGTHAI = "Đang bán";
lsp1.ANH = "/Resources/Image/" + System.IO.Path.GetFileName(picAnh.ImageLocation);
lsp1.MOTA = webMota.Document.InvokeScript("getValue").ToString();
int row = flag == 1 ? grViewLSP.RowCount : grViewLSP.FocusedRowHandle;
if (flag == 1)
{
try
{
lsp1.NGAYTAO = dateNgayTao.Value;
lsp1.TRANGTHAI = "Đang bán";
lspSAO.insertLOAISP(lsp1);
MessageBox.Show("Thêm thành công!");
}
catch
{
MessageBox.Show("Không thêm được!");
}
}
if (flag == 2)
{
try
{
lsp1.ID = lsp.ID;
lsp1.NGAYTAO = lsp.NGAYTAO;
lsp1.TRANGTHAI = lsp.TRANGTHAI;
lspSAO.updateLOAISP(lsp1);
MessageBox.Show("Update thành công!");
}
catch
{
MessageBox.Show("Không update được!");
}
}
string despath = @"E:\Projects\DEPLOY IIS\QuanCafeAPI IIS" + lsp1.ANH;
if (!File.Exists(despath))
{
File.Copy(picAnh.ImageLocation, despath);
}
grCtrlLSP.DataSource = lspSAO.getListLOAISP();
grViewLSP.FocusedRowHandle = row;
flag = 0;
txtTen.ReadOnly = false;
dateNgayTao.Enabled = true;
btnThem.Enabled = btnSua.Enabled = btnXoa.Enabled = true;
Hienthi();
}
public List <SANPHAM> laySPTheoLoai(string maLoai)
{
LOAISP loai = qlsp.LOAISPs.SingleOrDefault(t => t.MALSP == maLoai);
List <SANPHAM> lst = getALLByLoaiList(maLoai);
foreach (SANPHAM item in lst)
{
item.TENLSP = loai.TENLSP;
}
return(lst);
}
public ActionResult DeleteConfirmed(string id)
{
try
{
LOAISP lOAISP = db.LOAISPs.Find(id);
db.sp_XoaLSP(lOAISP.MALOAISP);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch { return(View()); }
}
public ActionResult Edit([Bind(Include = "MALOAI,TENLOAI,MACM,URLLOAISP")] LOAISP lOAISP)
{
if (ModelState.IsValid)
{
db.Entry(lOAISP).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MACM = new SelectList(db.CHUYENMUCs, "MACM", "TENCM", lOAISP.MACM);
return(View(lOAISP));
}
public ActionResult Create([Bind(Include = "MALOAI,TENLOAI,MACM,URLLOAISP")] LOAISP lOAISP)
{
if (ModelState.IsValid)
{
db.LOAISPs.Add(lOAISP);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MACM = new SelectList(db.CHUYENMUCs, "MACM", "TENCM", lOAISP.MACM);
return(View(lOAISP));
}
public ActionResult DeleteLoai(int id)
{
LOAISP loai = db.LOAISPs.SingleOrDefault(m => m.MALOAI == id);
ViewBag.MALOAI = loai.MALOAI;
if (loai == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(loai));
}
public void UpdateLOAISP(LOAISP lsp)
{
string query = "updateLOAISP";
string[] para = new string[7] {
"@id", "@ten", "@anh", "@mota", "@ngaytao", "@idhang", "@trangthai"
};
object[] value = new object[7] {
lsp.ID, lsp.TEN, lsp.ANH, lsp.MOTA, lsp.NGAYTAO, lsp.HANGSX_ID, lsp.TRANGTHAI
};
cn.Excute_Sql(query, CommandType.StoredProcedure, para, value);
}
public ActionResult EditLoai(int id)
{
// lay ra doi tuong sach theo ma
LOAISP loai = db.LOAISPs.SingleOrDefault(n => n.MALOAI == id);
if (loai == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(loai));
}
public void DeleteLOAISP(LOAISP lsp)
{
string query = "deleteLOAISP";
string[] para = new string[1] {
"@id"
};
object[] value = new object[1] {
lsp.ID
};
cn.Excute_Sql(query, CommandType.StoredProcedure, para, value);
}
private void Hienthi()
{
lsp = lspSAO.getLOAISPById((int)grViewLSP.GetFocusedRowCellValue("ID"));
cbHangSX.SelectedValue = lsp.HANGSX_ID;
txtTen.Text = lsp.TEN;
dateNgayTao.Value = lsp.NGAYTAO;
string imagepath = @"E:\Projects\DEPLOY IIS\QuanCafeAPI IIS" + lsp.ANH;
picAnh.Image = Image.FromFile(imagepath);
picAnh.ImageLocation = imagepath;
webMota.Document.InvokeScript("setValue", new[] { lsp.MOTA });
}
public bool CreateLoaiSP(LOAISP model)
{
try
{
db.LOAISPs.InsertOnSubmit(model);
db.SubmitChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
