public byte[] GetImageFromDataBase(string Id)
{
MonAn objMonAn = new MonAnDAO().getMonAnByID(Id);
byte[] cover = objMonAn.HinhAnh;
return(cover);
}
public JsonResult CreateFoodAjax(HttpPostedFileBase file, string tenmonan, int loaimonanID)
{
try
{
MonAnDAO objDAO = new MonAnDAO();
MonAn objMonAn = new MonAn();
objMonAn.MaMonAn = XuLy.NextID(objDAO.getLastID(), "MA");
objMonAn.TenMonAn = tenmonan;
int dataLength = (int)file.InputStream.Length;
byte[] _byteArr = new byte[dataLength];
file.InputStream.Read(_byteArr, 0, dataLength);
objMonAn.HinhAnh = _byteArr;
objMonAn.MaLoaiMonAn = loaimonanID.ToString();
int result = objDAO.insertMonAn(objMonAn);
if (result == 2)
{
return(Json(new { iserror = false, isExist = true }));
}
else
{
if (result == 1)
{
return(Json(new { iserror = false, isExist = false }));
}
}
return(Json(new { iserror = true, messageError = "Đã xảy ra lỗi khi thêm mới. Vui lòng kiểm tra lại!" }));
}
catch (Exception ex)
{
return(Json(new { iserror = true, messageError = ex.Message }));
}
}
public static bool SuaMonAn(MonAn monAn, List <string> listMaNguyenLieu, List <string> listSoLuongNL)
{
string listNguyenLieu = String.Join("|", listMaNguyenLieu);
string listSoLuong = String.Join("|", listSoLuongNL);
return(MonAnDAO.SuaMonAn(monAn, listNguyenLieu, listSoLuong));
}
protected void ddlSoKetQua_SelectedIndexChanged(object sender, EventArgs e)
{
PageNumber = 0;
int nResult = int.Parse(ddlSoKetQua.SelectedItem.Value);
Session["nResult"] = nResult;
yourvar = Session["q"].ToString();
nResultVar = nResult;
if (!hpAName.Enabled)
{
LoadData(nResult, MonAnDAO.LayDanhSachSapTheoTen(maDanhMucMonAn, true));
}
else if (!hpDName.Enabled)
{
LoadData(nResult, MonAnDAO.LayDanhSachSapTheoTen(maDanhMucMonAn, false));
}
else if (!hpAPrice.Enabled)
{
LoadData(nResult, MonAnDAO.LayDanhSachSapTheoGia(maDanhMucMonAn, true));
}
else if (!hpDPrice.Enabled)
{
LoadData(nResult, MonAnDAO.LayDanhSachSapTheoGia(maDanhMucMonAn, false));
}
}
public void rptPages_ItemCommand(object source, RepeaterCommandEventArgs e)
{
PageNumber = Convert.ToInt32(e.CommandArgument) - 1;
int nResult = int.Parse(ddlSoKetQua.SelectedItem.Value);
LoadData(nResult, MonAnDAO.LayDanhSachSapTheoTen(maDanhMucMonAn, true));
}
// GET: Category
public ActionResult CategoryFood(int pageSize = 6, int pageIndex = 0)
{
List <MonAn> listMonAn = new MonAnDAO().getListMonAn();
listMonAn = listMonAn.Skip(pageSize * pageIndex).Take(pageSize).ToList();
return(PartialView("CategoryFood", listMonAn));
}
protected void Button1_Click(object sender, EventArgs e)
{
//Xử lý khi người đặt món
TextBox t = (sender as Button).Parent.Controls[3] as TextBox;
HiddenField h = (sender as Button).Parent.Controls[9] as HiddenField;
int SoLuongMon = int.Parse(t.Text);
MONAN m = MonAnDAO.TimMon(int.Parse(h.Value));
if (Session["ChiTietPhieu"] != null)
{
ChiTietPhieus = (List <CHITIETPHIEU>)Session["ChiTietPhieu"];
}
else
{
ChiTietPhieus = new List <CHITIETPHIEU>();
}
//Tăng số lượng nếu đã có
bool bAddNew = true;
foreach (CHITIETPHIEU c in ChiTietPhieus)
{
if (c.MONAN.TenMonAn == m.TenMonAn)
{
c.SoLuong += SoLuongMon;
bAddNew = false;
break;
}
}
//Thêm món vào phiếu
if (bAddNew == true)
{
ChiTietPhieus.Add(new CHITIETPHIEU {
MONAN = m, SoLuong = SoLuongMon
});
}
//Tính tổng tiền
Label l = GridView1.Parent.Controls[3] as Label;
double TongTien = double.Parse(l.Text, NumberStyles.Number) + m.Gia.Value * SoLuongMon;
l.Text = TongTien.ToString("0,000");
//Gán phiếu lại cho session
Session["ChiTietPhieu"] = ChiTietPhieus;
bind();
if (TongTien == 0)
{
hpHoanTatDatMon.Visible = false;
}
else
{
hpHoanTatDatMon.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
MONAN mon = new MONAN();
if (!Page.IsPostBack)
{
if (Request.QueryString["id"] != null)
{
req = int.Parse(Request.QueryString["id"]);
}
//req = 1;
List <MONAN> dsMon = new List <MONAN>();
mon = MonAnDAO.TimMon(req);
dsMon.Add(mon);
dsBl = BinhLuanDAO.LayDanhSach(req);
if (isClick == false)
{
dsBl.Reverse();
LinkButton1.Enabled = false;
LinkButton1.ForeColor = Color.Black;
LinkButton1.ControlStyle.Font.Bold = true;
}
else
{
LinkButton2.Enabled = false;
LinkButton2.ForeColor = Color.Black;
LinkButton2.ControlStyle.Font.Bold = true;
}
yourvar = dsBl.Count;
//Response.Write("dem");
PagedDataSource pgitems = new PagedDataSource();
PagedDataSource pgitems1 = new PagedDataSource();
DataView dv = new DataView();
pgitems.DataSource = dsMon;
pgitems.AllowPaging = true;
pgitems1.DataSource = dsBl;
pgitems1.AllowPaging = true;
rptItems.DataSource = pgitems;
rptItems.DataBind();
rptItems2.DataSource = pgitems1;
rptItems2.DataBind();
}
}
protected void DatMon_Click(object sender, EventArgs e)
{
List <CHITIETPHIEU> ChiTietPhieus;
//Xử lý khi người đặt món
TextBox t = (sender as Button).Parent.Controls[1] as TextBox;
HiddenField h = (sender as Button).Parent.Controls[5] as HiddenField;
int SoLuongMon = int.Parse(t.Text);
MONAN m = MonAnDAO.TimMon(int.Parse(h.Value));
if (Session["ChiTietPhieu"] != null)
{
ChiTietPhieus = (List <CHITIETPHIEU>)Session["ChiTietPhieu"];
}
else
{
ChiTietPhieus = new List <CHITIETPHIEU>();
}
//Tăng số lượng nếu đã có
bool bAddNew = true;
foreach (CHITIETPHIEU c in ChiTietPhieus)
{
if (c.MONAN.TenMonAn == m.TenMonAn)
{
c.SoLuong += SoLuongMon;
bAddNew = false;
break;
}
}
//Thêm món vào phiếu
if (bAddNew == true)
{
ChiTietPhieus.Add(new CHITIETPHIEU {
MONAN = m, SoLuong = SoLuongMon
});
}
//Gán phiếu lại cho session
Session["ChiTietPhieu"] = ChiTietPhieus;
}
public static List <MonAn> XemMonAn(string tenMonAn, int loaiMonAn, int pageNumber, int pageSize, uint donGia = 0)
{
return(MonAnDAO.XemMonAn(tenMonAn, loaiMonAn, pageNumber, pageSize, donGia));
}
public static List <MonAn> XemMonAn(string tenMonAn, int loaiMonAn, uint donGia = 0)
{
return(MonAnDAO.XemMonAn(tenMonAn, loaiMonAn, donGia));
}
public static bool CapNhatMonAn(MonAn monAn, List <string> listMaNguyenLieu)
{
string listNguyenLieu = String.Join("|", listMaNguyenLieu);
return(MonAnDAO.CapNhatMonAn(monAn, listNguyenLieu));
}
public static ArrayList layDanhSachNguyenLieuTheoMonAn(MonAnDTO monAn)
{
return(MonAnDAO.layDanhSachNguyenLieuTheoMonAn(monAn));
}
public int ThemMonAn(MonAnDTO monan, String strTag)
{
MonAnDAO monanDAO = new MonAnDAO();
return(monanDAO.ThemMonAn(monan, strTag));
}
public static List <NguyenLieuMADataSource> XemNguyenLieuMonAn(string maMonAn)
{
return(MonAnDAO.XemNguyenLieuMonAn(maMonAn));
}
public static int DemMonAn(string tenMonAn, string loaiMonAn, uint donGia = 0)
{
return(MonAnDAO.DemMonAn(tenMonAn, loaiMonAn, donGia));
}
public void rptPages_ItemCommand(object source, RepeaterCommandEventArgs e)
{
PageNumber = Convert.ToInt32(e.CommandArgument) - 1;
LoadData(int.Parse(ddlSoKetQua.SelectedItem.Value), MonAnDAO.LayDanhSach(4));
}
public static List <LoaiMon> XemLoaiMon()
{
return(MonAnDAO.XemLoaiMon());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string req = string.Empty;
if (Request.QueryString["s"] != null)
{
req = Request.QueryString["s"].ToString();
}
if (req == "aname")
{
LoadData(int.Parse(Session["nResult"].ToString()), MonAnDAO.LayDanhSachSapTheoTen(maDanhMucMonAn, true));
hpAName.Enabled = false;
hpAName.ControlStyle.Font.Bold = true;
hpAName.ForeColor = Color.Black;
hpDName.Enabled = true;
hpAPrice.Enabled = true;
hpDPrice.Enabled = true;
}
else if (req == "dname")
{
LoadData(int.Parse(Session["nResult"].ToString()), MonAnDAO.LayDanhSachSapTheoTen(maDanhMucMonAn, false));
hpAName.Enabled = true;
hpDName.Enabled = false;
hpDName.ControlStyle.Font.Bold = true;
hpDName.ForeColor = Color.Black;
hpAPrice.Enabled = true;
hpDPrice.Enabled = true;
}
else if (req == "aprice")
{
LoadData(int.Parse(Session["nResult"].ToString()), MonAnDAO.LayDanhSachSapTheoGia(maDanhMucMonAn, true));
hpAName.Enabled = true;
hpDName.Enabled = true;
hpAPrice.Enabled = false;
hpAPrice.ControlStyle.Font.Bold = true;
hpAPrice.ForeColor = Color.Black;
hpDPrice.Enabled = true;
}
else if (req == "dprice")
{
LoadData(int.Parse(Session["nResult"].ToString()), MonAnDAO.LayDanhSachSapTheoGia(maDanhMucMonAn, false));
hpAName.Enabled = true;
hpDName.Enabled = true;
hpAPrice.Enabled = true;
hpDPrice.Enabled = false;
hpDPrice.ControlStyle.Font.Bold = true;
hpDPrice.ForeColor = Color.Black;
}
else
{
LoadData(int.Parse(Session["nResult"].ToString()), MonAnDAO.LayDanhSachSapTheoTen(maDanhMucMonAn, true));
hpAName.Enabled = false;
hpAName.ControlStyle.Font.Bold = true;
hpAName.ForeColor = Color.Black;
hpDName.Enabled = true;
hpAPrice.Enabled = true;
hpDPrice.Enabled = true;
}
ddlSoKetQua.SelectedValue = Session["nResult"].ToString();
bind();
TinhTongTien();
}
}
public static List <MonAnDataSource> XemMonAnDataSource(string tenMonAn, int loaiMonAn, int pageNumber, int pageSize)
{
return(MonAnDAO.XemMonAnDataSource(tenMonAn, loaiMonAn, pageNumber, pageSize));
}
public MonAnDTO[] DanhSachMonAn()
{
MonAnDAO monanDAO = new MonAnDAO();
return(monanDAO.DanhSachMonAn());
}
