public string TenTDGet([PexAssumeUnderTest] ThucDonDTO target)
{
string result = target.TenTD;
return(result);
// TODO: add assertions to method ThucDonDTOTest.TenTDGet(ThucDonDTO)
}
public static bool CapNhatThucDon(ThucDonDTO td)
{
string sql = string.Format("update ThucDon set MaLoai = {0}, TenThucDon = N'{1}', DonViTinh = N'{2}' where MaThucDon = {3}", td.MaLoai, td.TenTD, td.DonViTinh, td.MaTD);
bool kq = SqlDataAccessHelper.ExecuteNonQuery(sql);
return(kq);
}
public ThucDonDTO Constructor02(ThucDonDTO thucDon)
{
ThucDonDTO target = new ThucDonDTO(thucDon);
return(target);
// TODO: add assertions to method ThucDonDTOTest.Constructor02(ThucDonDTO)
}
public int MaTDGet([PexAssumeUnderTest] ThucDonDTO target)
{
int result = target.MaTD;
return(result);
// TODO: add assertions to method ThucDonDTOTest.MaTDGet(ThucDonDTO)
}
public ActionResult Delete(int?id)
{
if (KiemTraDangNhap() == false)
{
return(View("../Login/Index"));
}
// if (id == null)
// return RedirectToAction ("Index");
// ThucDon td = context.ThucDons.Find (id);
// if (td == null)
// return RedirectToAction ("Index");
// return View (td);
if (id == null)
{
return(RedirectToAction("Index"));
}
ThucDonDTO tdDTO = _services.GetMonAn(id.Value);
if (tdDTO == null)
{
return(RedirectToAction("Index"));
}
SaveThucDonDTO saveThucDonDTO = _mapper.Map <ThucDonDTO, SaveThucDonDTO>(tdDTO);
return(View(saveThucDonDTO));
}
public ThucDonDTO[] DSThucDonTheoTag(int matag)
{
Connect();
ThucDonDTO[] Kq;
SqlCommand cmd = new SqlCommand("spDanhSachThucDonTheoTag", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ma_tag", SqlDbType.Int);
cmd.Parameters["@ma_tag"].Value = matag;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable tab = new DataTable();
da.Fill(tab);
int n = tab.Rows.Count;
Kq = new ThucDonDTO[n];
for (int i = 0; i < n; ++i)
{
object thuc_don = GetDataFromDataRow(tab, i);
Kq[i] = (ThucDonDTO)thuc_don;
}
Disconnect();
return(Kq);
}
public ThucDonDTO[] DSMThucDonThuocLoaiThucDon(int maloaithucdon)
{
Connect();
ThucDonDTO[] Kq;
SqlCommand cmd = new SqlCommand("spLayDSThucDonCuaMotLoaiThucDonLa", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@maloaithucdon", SqlDbType.Int);
cmd.Parameters["@maloaithucdon"].Value = maloaithucdon;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable tab = new DataTable();
da.Fill(tab);
int n = tab.Rows.Count;
Kq = new ThucDonDTO[n];
for (int i = 0; i < n; ++i)
{
object mon_an = GetDataFromDataRow(tab, i);
Kq[i] = (ThucDonDTO)mon_an;
}
Disconnect();
return(Kq);
}
public bool CapNhatTD(ThucDonDTO thucdon)
{
string update = "UPDATE THUCDON "
+ "SET TENTHUCDON = @TENTHUCDON,"
+ " LOAITD = @LOAITD"
+ ",GIA = @GIA"
+ " , TINHTRANG = @TINHTRANG"
+ " WHERE MATD = @MATD";
//SqlParameter[] arrParams = new SqlParameter[7];
string gia = null;
foreach (char a in thucdon.GIA.ToString())
{
if (a.ToString() != "V" || a.ToString() != "N" || a.ToString() != "Đ")
{
gia += a;
}
}
List <SqlParameter> lsparams = new List <SqlParameter>();
lsparams.Add(new SqlParameter("@MATD", thucdon.MATD));
lsparams.Add(new SqlParameter("@TENTHUCDON", thucdon.TENTHUCDON));
lsparams.Add(new SqlParameter("@GIA", thucdon.GIA));
lsparams.Add(new SqlParameter("@LOAITD", thucdon.LOAITD));
lsparams.Add(new SqlParameter("@TINHTRANG", thucdon.TINHTRANG));
SqlConnection con = DataProvider.TaoKetNoi();
bool thucthi = DataProvider.ThucThi(update, lsparams.ToArray(), con);
return(thucthi);
}
//-> tránh nhập nhằng với hàm trên -> lấy thông tin thực đơn ko bao gồm chi tiết món :|
public ThucDonDTO LayThongTinTongQuatCuaThucDon(int ma)
{
ThucDonDTO Kq = new ThucDonDTO();
Connect();
SqlCommand cmd = new SqlCommand("spLayThongTinThucDon", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@mathucdon", SqlDbType.Int);
cmd.Parameters["@mathucdon"].Value = ma;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Kq.Ma_thuc_don = int.Parse(dr["MaThucDon"].ToString());
Kq.Ten_thuc_don = dr["TenThucDon"].ToString();
Kq.Ma_loai_thuc_don = int.Parse(dr["MaLoaiThucDon"].ToString());
Kq.Mo_ta = dr["MoTa"].ToString();
Kq.Hinh_anh_minh_hoa = dr["HinhAnhMinhHoa"].ToString();
Kq.Gia = decimal.Parse(dr["Gia"].ToString());
Kq.Diem_binh_chon = int.Parse(dr["DiemBinhChon"].ToString());
Kq.Trang_thai_hien_thi = bool.Parse(dr["TrangThaiHienThi"].ToString());
Kq.Tinh_trang = bool.Parse(dr["TinhTrang"].ToString());
}
Disconnect();
return(Kq);
}
public ThucDonDTO[] TimKiemThucDonTheoTen(string ten_thuc_don)
{
Connect();
ThucDonDTO[] Kq;
SqlCommand cmd = new SqlCommand("spTimKiemTheoTen", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ten", SqlDbType.NVarChar, 50);
cmd.Parameters["@ten"].Value = ten_thuc_don;
SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataTable tab = new DataTable();
DataSet dsThucDon = new DataSet();
da.Fill(dsThucDon, "THUC_DON");
int n = dsThucDon.Tables[1].Rows.Count;
Kq = new ThucDonDTO[n];
for (int i = 0; i < n; ++i)
{
object thuc_don = GetDataFromDataRow(dsThucDon.Tables[1], i);
Kq[i] = (ThucDonDTO)thuc_don;
}
Disconnect();
return(Kq);
}
public static bool ThemThucDon(ThucDonDTO td)
{
string sql = string.Format("insert into ThucDon values ({0}, {1}, '{2}', '{3}')", td.MaTD, td.MaLoai, td.TenTD, td.DonViTinh);
bool kq = SqlDataAccessHelper.ExecuteNonQuery(sql);
return(kq);
}
protected void LayDSThucDon()
{
ThucDonBUS ThucDonBUS = new ThucDonBUS();
ThucDonDTO[] DsThucDon = ThucDonBUS.DSThucDonThuocLoaiThucDon(int.Parse(Request["MaLoaiThucDon"].ToString()));
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < DsThucDon.Length; i++)
{
XL_THE Kq1 = new XL_THE("ThucDon");
ThucDonDTO ThucDon = DsThucDon[i];
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", ThucDon.Ma_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", ThucDon.Ten_thuc_don);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", ThucDon.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", ThucDon.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ma_loai_thuc_don", ThucDon.Ma_loai_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", ThucDon.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Trang_thai_hien_thi", ThucDon.Trang_thai_hien_thi.ToString());
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
private void btn_lamMoi_Click(object sender, EventArgs e)
{
TDhienhanh = null;
trThai = 1;
TrangThai();
Bind();
LoadData();
}
public void MaTDSet841()
{
ThucDonDTO s0 = new ThucDonDTO(0, 0, (string)null, (string)null);
this.MaTDSet(s0, 0);
Assert.IsNotNull((object)s0);
Assert.AreEqual <int>(0, s0.MaTD);
Assert.AreEqual <int>(0, s0.MaLoai);
Assert.AreEqual <string>((string)null, s0.TenTD);
Assert.AreEqual <string>((string)null, s0.DonViTinh);
}
public void Constructor02201()
{
ThucDonDTO thucDonDTO;
ThucDonDTO s0 = new ThucDonDTO(0, 0, (string)null, (string)null);
thucDonDTO = this.Constructor02(s0);
Assert.IsNotNull((object)thucDonDTO);
Assert.AreEqual <int>(0, thucDonDTO.MaTD);
Assert.AreEqual <int>(0, thucDonDTO.MaLoai);
Assert.AreEqual <string>((string)null, thucDonDTO.TenTD);
Assert.AreEqual <string>((string)null, thucDonDTO.DonViTinh);
}
private void Ghi_nhan_dat_hang()
{
ArrayList arr = new ArrayList();
int ma = int.Parse(Request["Ma"].ToString());
MonAnBUS monanBUS = new MonAnBUS();
if (Request["Loai"] == "0")
{
MonAnDTO MonAn = monanBUS.ChiTietMonAn(ma);
Item_online mon_an = new Item_online();
mon_an.Ma_item = MonAn.Ma_mon;
mon_an.Ten_item = MonAn.Ten_mon;
mon_an.Hinh_anh_minh_hoa = MonAn.Hinh_anh_minh_hoa;
mon_an.Gia = MonAn.Gia;
mon_an.Loai_item = 0;
mon_an.So_luong = int.Parse(Request["So_luong"].ToString());
Session["Item_online"] = mon_an;
}
else if (Request["Loai"] == "1")
{
ThucDonBUS thucdonBUS = new ThucDonBUS();
//ThucDonDTO ThucDon = thucdonBUS.ThongTinThucDon(ma);
ThucDonDTO thuc_don = thucdonBUS.ChiTietThucDon(ma);
Item_online mon_an = new Item_online();
mon_an.Ma_item = thuc_don.Ma_thuc_don;
mon_an.Ten_item = thuc_don.Ten_thuc_don;
mon_an.Hinh_anh_minh_hoa = thuc_don.Hinh_anh_minh_hoa;
mon_an.Gia = thuc_don.Gia;
mon_an.Loai_item = 1;
mon_an.So_luong = int.Parse(Request["So_luong"].ToString());
Session["Item_online"] = mon_an;
}
else
{
ThucDonCaNhanBUS thucdonBUS = new ThucDonCaNhanBUS();
//ThucDonDTO ThucDon = thucdonBUS.ThongTinThucDon(ma);
ThucDonCaNhanDTO thuc_don = thucdonBUS.ChiTietThucDonCaNhan(ma);
Item_online mon_an = new Item_online();
mon_an.Ma_item = thuc_don.Ma_thuc_don_ca_nhan;
mon_an.Ten_item = thuc_don.Ten_thuc_don;
mon_an.Hinh_anh_minh_hoa = thuc_don.Hinh_anh;
mon_an.Gia = thuc_don.Gia;
mon_an.Loai_item = 1;
mon_an.So_luong = int.Parse(Request["So_luong"].ToString());
Session["Item_online"] = mon_an;
}
}
public ThucDonDTO Constructor01(
int maNV,
int maLoai,
string tenTD,
string donViTinh
)
{
ThucDonDTO target = new ThucDonDTO(maNV, maLoai, tenTD, donViTinh);
return(target);
// TODO: add assertions to method ThucDonDTOTest.Constructor01(Int32, Int32, String, String)
}
public void DonViTinhGet977()
{
string s;
ThucDonDTO s0 = new ThucDonDTO(0, 0, (string)null, (string)null);
s = this.DonViTinhGet(s0);
Assert.AreEqual <string>((string)null, s);
Assert.IsNotNull((object)s0);
Assert.AreEqual <int>(0, s0.MaTD);
Assert.AreEqual <int>(0, s0.MaLoai);
Assert.AreEqual <string>((string)null, s0.TenTD);
Assert.AreEqual <string>((string)null, s0.DonViTinh);
}
public static List <ThucDonDTO> LayDSMaTDVaTenTDTheoMaLoai(int maLoai)
{
List <ThucDonDTO> ds = new List <ThucDonDTO>();
string sql = "select * from ThucDon where MaLoai = " + maLoai;
DataTable dt = SqlDataAccessHelper.ExecuteQuery(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
ThucDonDTO td = new ThucDonDTO();
td.MaTD = int.Parse(dt.Rows[i]["MaThucDon"].ToString());
td.TenTD = dt.Rows[i]["TenThucDon"].ToString();
ds.Add(td);
}
return(ds);
}
private void dgv_ThucDon_SelectionChanged(object sender, EventArgs e)
{
if (dgv_ThucDon.SelectedRows.Count > 0)
{
trThai = 1;
TrangThai();
btn_capNhat.Enabled = true;
TDhienhanh = (ThucDonDTO)dgv_ThucDon.SelectedRows[0].DataBoundItem; // dgv_ThucDon.CurrentRow
}
else
{
btn_capNhat.Enabled = false;
TDhienhanh = null;
}
Bind();
}
//Rút trích dữ liêu: select
public static List <ThucDonDTO> LayDSThucDon()
{
List <ThucDonDTO> _ds = new List <ThucDonDTO>();
string sql = "select * from ThucDon";
DataTable dt = SqlDataAccessHelper.ExecuteQuery(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
ThucDonDTO td = new ThucDonDTO();
td.MaTD = int.Parse(dt.Rows[i]["MaThucDon"].ToString());
td.MaLoai = int.Parse(dt.Rows[i]["MaLoai"].ToString());
td.TenTD = dt.Rows[i]["TenThucDon"].ToString();
td.DonViTinh = dt.Rows[i]["DonViTinh"].ToString();
_ds.Add(td);
}
return(_ds);
}
public ThucDonDTO[] TimKiemThucDonNangCao(string ten_thuc_don, int ma_loai_thuc_don, string tag, double gia_min, double gia_max)
{
Connect();
ThucDonDTO[] Kq;
SqlCommand cmd = new SqlCommand("spTimKiemNangCao", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ten", SqlDbType.NVarChar, 50);
cmd.Parameters["@ten"].Value = ten_thuc_don;
cmd.Parameters.Add("@ma_loai", SqlDbType.Int);
cmd.Parameters["@ma_loai"].Value = ma_loai_thuc_don;
cmd.Parameters.Add("@tag", SqlDbType.NVarChar, 50);
cmd.Parameters["@tag"].Value = tag;
cmd.Parameters.Add("@gia_min", SqlDbType.Money);
cmd.Parameters["@gia_min"].Value = gia_min;
cmd.Parameters.Add("@gia_max", SqlDbType.Money);
cmd.Parameters["@gia_max"].Value = gia_max;
SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataTable tab = new DataTable();
DataSet dsThucDon = new DataSet();
da.Fill(dsThucDon, "THUC_DON");
int n = dsThucDon.Tables[1].Rows.Count;
Kq = new ThucDonDTO[n];
for (int i = 0; i < n; ++i)
{
object thuc_don = GetDataFromDataRow(dsThucDon.Tables[1], i);
Kq[i] = (ThucDonDTO)thuc_don;
}
Disconnect();
return(Kq);
}
public List <ThucDonDTO> dsThucDon()
{
List <ThucDonDTO> ds = new List <ThucDonDTO>();
SqlConnection conn = DataProvider.TaoKetNoi();
SqlCommand com = new SqlCommand("select * from THUCDON ,LOAITD where THUCDON.LOAITD = LOAITD.MALOAITD and lOAITD.TINHTRANG = '1'", conn);
SqlDataReader sdr = com.ExecuteReader();
while (sdr.Read())
{
ThucDonDTO a = new ThucDonDTO()
{
MATD = sdr.GetString(0),
LOAITD = sdr.GetInt32(1),
TENTHUCDON = sdr.GetString(2),
GIA = sdr.GetDecimal(3).ToString("0,00 VNĐ"),
TINHTRANG = sdr.GetInt32(4)
};
ds.Add(a);
}
return(ds);
}
private void LayDSThucDon()
{
ThucDonYeuDauBUS tdydBus = new ThucDonYeuDauBUS();
ThucDonUaThich[] arr = tdydBus.LayDSThucDonYeuThich(int.Parse(Session["MaNguoiDung"].ToString()));
if (arr == null)
{
return;
}
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < arr.Length; i++)
{
XL_THE Kq1 = new XL_THE("ThucDon");
ThucDonUaThich ThucDonUT = (ThucDonUaThich)arr[i];
ThucDonDTO thucdon = thucdonbus.ChiTietThucDon(ThucDonUT.Ma_thuc_don);
//ThucDonDTO thucdon = thucdonbus.ChiTietThucDon((int)arr[i]);
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", thucdon.Ma_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", thucdon.Ten_thuc_don);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", thucdon.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", thucdon.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", thucdon.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Diem_binh_chon", thucdon.Diem_binh_chon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
private void DS_thuc_don_theo_tag()
{
TagThucDonBUS tagthucdonBUS = new TagThucDonBUS();
ThucDonDTO[] dsThucDon = tagthucdonBUS.DSThucDonTheoTag(int.Parse(Session["Tag"].ToString()));
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < dsThucDon.Length; i++)
{
XL_THE Kq1 = new XL_THE("ThucDon");
ThucDonDTO ThucDon = dsThucDon[i];
if (ThucDon.Trang_thai_hien_thi == false)
{
continue;
}
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", ThucDon.Ma_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", ThucDon.Ten_thuc_don);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", ThucDon.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", ThucDon.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ma_loai_thuc_don", ThucDon.Ma_loai_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", ThucDon.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Trang_thai_hien_thi", ThucDon.Trang_thai_hien_thi.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
private void Lay_danh_sach()
{
ThucDonBUS thucdonBUS = new ThucDonBUS();
ThucDonDTO[] DsThucDon = thucdonBUS.DanhSachThucDon();
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < DsThucDon.Length; i++)
{
XL_THE Kq1 = new XL_THE("ThucDon");
ThucDonDTO ThucDon = DsThucDon[i];
if (ThucDon.Trang_thai_hien_thi == false)
{
continue;
}
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", ThucDon.Ma_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", ThucDon.Ten_thuc_don);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", ThucDon.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", ThucDon.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ma_loai_thuc_don", ThucDon.Ma_loai_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", ThucDon.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Trang_thai_hien_thi", ThucDon.Trang_thai_hien_thi.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void ThemThucDon()
{
ThucDonDTO dto = new ThucDonDTO();
dto.Ten_thuc_don = XL_CHUOI.Nhap(Request, "ten");
dto.Ma_loai_thuc_don = int.Parse(XL_CHUOI.Nhap(Request, "maloai"));
dto.Mo_ta = XL_CHUOI.Nhap(Request, "mota");
dto.Hinh_anh_minh_hoa = XL_CHUOI.Nhap(Request, "hinhanh");
dto.Gia = decimal.Parse(XL_CHUOI.Nhap(Request, "gia"));
dto.Tinh_trang = bool.Parse(XL_CHUOI.Nhap(Request, "tinhtrang"));
dto.Trang_thai_hien_thi = bool.Parse(XL_CHUOI.Nhap(Request, "hienthi"));
String strTag = XL_CHUOI.Nhap(Request, "tag");
String strDsMaMonAn = XL_CHUOI.Nhap(Request, "dsmamonan");
String[] M = strDsMaMonAn.Split(new String[] { "-" }, StringSplitOptions.RemoveEmptyEntries);
ThucDonBUS bus = new ThucDonBUS();
int Kq = bus.ThemThucDon(dto, M, strTag);
XL_THE the = new XL_THE("goc");
XL_THUOC_TINH thuoc_tinh;
if (Kq != 0)
{
thuoc_tinh = new XL_THUOC_TINH("kq", "true");
}
else
{
thuoc_tinh = new XL_THUOC_TINH("kq", "false");
}
the.Danh_sach_thuoc_tinh.Add(thuoc_tinh);
string chuoi = the.Chuoi();
XL_CHUOI.XuatChuoi(Response, chuoi);
}
public void LayDSTenThucDon()
{
ThucDonBUS bus = new ThucDonBUS();
ThucDonDTO[] DsThucDon = bus.DanhSachThucDon();
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < DsThucDon.Length; i++)
{
XL_THE Kq1 = new XL_THE("ThucDon");
ThucDonDTO dto = DsThucDon[i];
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("MaThucDon", dto.Ma_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TenThucDon", dto.Ten_thuc_don);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
public List <ThucDonDTO> TraCuu(int x, int y)
{
string search = "SELECT * FROM THUCDON"
+ " WHERE MATD LIKE '%" + x + "%' and TINHTRANG LIKE '%" + y + "%' ";
SqlConnection con = DataProvider.TaoKetNoi();
List <ThucDonDTO> ds = new List <ThucDonDTO>();
SqlDataReader sdr = DataProvider.TruyVanDuLieu(search, con);
while (sdr.Read())
{
ThucDonDTO a = new ThucDonDTO();
a.MATD = sdr.GetString(0);
a.TENTHUCDON = sdr.GetString(1);
a.LOAITD = sdr.GetInt32(2);
a.GIA = sdr.GetDecimal(3).ToString("0,00 VNĐ");
a.TINHTRANG = sdr.GetInt32(4);
ds.Add(a);
}
sdr.Close();
con.Close();
return(ds);
}
public bool ThemTD(ThucDonDTO thucdon)
{
string insert = "INSERT INTO THUCDON"
+ " (MATD"
+ ", TENTHUCDON"
+ " , LOAITD"
+ " , GIA"
+ " , TINHTRANG)"
+ " VALUES"
+ "(@MATD,"
+ "@TENTHUCDON,"
+ "@LOAITD,"
+ "@GIA,"
+ "@TINHTRANG)";
string gia = null;
foreach (char a in thucdon.GIA.ToString())
{
if (a.ToString() != "V" || a.ToString() != "N" || a.ToString() != "Đ")
{
gia += a;
}
}
List <SqlParameter> lsparams = new List <SqlParameter>();
lsparams.Add(new SqlParameter("@MATD", thucdon.MATD));
lsparams.Add(new SqlParameter("@TENTHUCDON", thucdon.TENTHUCDON));
lsparams.Add(new SqlParameter("@GIA", thucdon.GIA));
lsparams.Add(new SqlParameter("@LOAITD", thucdon.LOAITD));
lsparams.Add(new SqlParameter("@TINHTRANG", thucdon.TINHTRANG));
SqlConnection con = DataProvider.TaoKetNoi();
bool thucthi = DataProvider.ThucThi(insert, lsparams.ToArray(), con);
return(thucthi);
}
