public string TenLoaiGet([PexAssumeUnderTest] LoaiThucDonDTO target)
{
string result = target.TenLoai;
return(result);
// TODO: add assertions to method LoaiThucDonDTOTest.TenLoaiGet(LoaiThucDonDTO)
}
public LoaiThucDonDTO[] DanhSachLoaiThucDonCon(int MaLTDCha)
{
LoaiThucDonDTO[] kq;
Connect();
SqlCommand cmd = new SqlCommand("spLayDSLoaiThucDonConTrucTiep", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@maloaithucdoncha", SqlDbType.Int);
cmd.Parameters["@maloaithucdoncha"].Value = MaLTDCha;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable tab = new DataTable();
da.Fill(tab);
int n = tab.Rows.Count;
kq = new LoaiThucDonDTO[n];
for (int i = 0; i < n; ++i)
{
object loaithucdon = GetDataFromDataRow(tab, i);
kq[i] = (LoaiThucDonDTO)loaithucdon;
}
Disconnect();
return(kq);
}
// Lấy dah sách loại thực đơn ở cấp cao nhất
public LoaiThucDonDTO[] LayDanhSachLoaiThucDonRoot()
{
LoaiThucDonDTO[] Kq;
Connect();
SqlCommand cmd = new SqlCommand("spLayDSLoaiThucDonCapRoot", cnn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
int i = 0;
int n = dt.Rows.Count;
Kq = new LoaiThucDonDTO[n];
for (i = 0; i < n; ++i)
{
object loaithucdon = GetDataFromDataRow(dt, i);
Kq[i] = (LoaiThucDonDTO)loaithucdon;
}
Disconnect();
return(Kq);
}
public int MaLoaiGet([PexAssumeUnderTest] LoaiThucDonDTO target)
{
int result = target.MaLoai;
return(result);
// TODO: add assertions to method LoaiThucDonDTOTest.MaLoaiGet(LoaiThucDonDTO)
}
public LoaiThucDonDTO Constructor02(LoaiThucDonDTO loai)
{
LoaiThucDonDTO target = new LoaiThucDonDTO(loai);
return(target);
// TODO: add assertions to method LoaiThucDonDTOTest.Constructor02(LoaiThucDonDTO)
}
//Lấy danh sách loại thực đơn con trực tiếp của một loại thực đơn
public LoaiThucDonDTO[] LayDanhSachLoaiThucDonConTrucTiep(int maloaithucdon)
{
LoaiThucDonDTO[] Kq;
Connect();
SqlCommand cmd = new SqlCommand("spLayDSLoaiThucDonConTrucTiep", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@maloaithucdoncha", SqlDbType.Int);
cmd.Parameters["@maloaithucdoncha"].Value = maloaithucdon;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
int i = 0;
int n = dt.Rows.Count;
Kq = new LoaiThucDonDTO[n];
for (i = 0; i < n; ++i)
{
object loaithucdon = GetDataFromDataRow(dt, i);
Kq[i] = (LoaiThucDonDTO)loaithucdon;
}
Disconnect();
return(Kq);
}
private void btn_lamMoi_Click(object sender, EventArgs e)
{
if (trThai != 2)
{
loaiTD = null;
Bind();
}
}
public void NhomSet737()
{
LoaiThucDonDTO s0 = new LoaiThucDonDTO(0, (string)null, (string)null);
this.NhomSet(s0, (string)null);
Assert.IsNotNull((object)s0);
Assert.AreEqual <int>(0, s0.MaLoai);
Assert.AreEqual <string>((string)null, s0.Nhom);
Assert.AreEqual <string>((string)null, s0.TenLoai);
}
public LoaiThucDonDTO Constructor01(
int maLoai,
string nhom,
string tenLoai
)
{
LoaiThucDonDTO target = new LoaiThucDonDTO(maLoai, nhom, tenLoai);
return(target);
// TODO: add assertions to method LoaiThucDonDTOTest.Constructor01(Int32, String, String)
}
public void Constructor02969()
{
LoaiThucDonDTO loaiThucDonDTO;
LoaiThucDonDTO s0 = new LoaiThucDonDTO(0, (string)null, (string)null);
loaiThucDonDTO = this.Constructor02(s0);
Assert.IsNotNull((object)loaiThucDonDTO);
Assert.AreEqual <int>(0, loaiThucDonDTO.MaLoai);
Assert.AreEqual <string>((string)null, loaiThucDonDTO.Nhom);
Assert.AreEqual <string>((string)null, loaiThucDonDTO.TenLoai);
}
public void TenLoaiGet175()
{
string s;
LoaiThucDonDTO s0 = new LoaiThucDonDTO(0, (string)null, (string)null);
s = this.TenLoaiGet(s0);
Assert.AreEqual <string>((string)null, s);
Assert.IsNotNull((object)s0);
Assert.AreEqual <int>(0, s0.MaLoai);
Assert.AreEqual <string>((string)null, s0.Nhom);
Assert.AreEqual <string>((string)null, s0.TenLoai);
}
protected void ChiTietLoaiThucDon()
{
LoaiThucDonBUS loaiThucDonBUS = new LoaiThucDonBUS();
LoaiThucDonDTO LoaiThucDon = loaiThucDonBUS.ChiTietLoaiThucDon(int.Parse(Request["MaLoaiThucDon"].ToString()));
XL_THE Kq1 = new XL_THE("loai_thuc_don");
Kq1.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("MaLoaiThucDon", LoaiThucDon.Ma_loai_thuc_don.ToString()));
Kq1.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("TenLoaiThucDon", LoaiThucDon.Ten_loai_thuc_don));
Kq1.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("MaLoaiThucDonCha", LoaiThucDon.Ma_loai_thuc_don_cha.ToString()));
Kq1.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("LaLoaiThucDonLa", LoaiThucDon.La_loai_thuc_don_la.ToString()));
XL_CHUOI.XuatXML(Response, Kq1.Chuoi());
}
//rút trích dữ liệu: select
public static List <LoaiThucDonDTO> LayDSLoaiThucDon()
{
List <LoaiThucDonDTO> _ds = new List <LoaiThucDonDTO>();
string sql = "select * from LoaiThucDon";
DataTable dt = SqlDataAccessHelper.ExecuteQuery(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
LoaiThucDonDTO loai = new LoaiThucDonDTO();
loai.MaLoai = int.Parse(dt.Rows[i]["MaLoai"].ToString());
loai.TenLoai = dt.Rows[i]["TenLoai"].ToString();
_ds.Add(loai);
}
return(_ds);
}
private void dgv_LoaiTD_SelectionChanged(object sender, EventArgs e)
{
if (dgv_LoaiTD.SelectedRows.Count > 0)
{
trThai = 1;
TrangThai();
btn_capNhat.Enabled = true;
loaiTD = (LoaiThucDonDTO)dgv_LoaiTD.SelectedRows[0].DataBoundItem; // dgvSinhVien.CurrentRow
}
else
{
btn_capNhat.Enabled = false;
loaiTD = null;
}
Bind();
}
private void btn_luu_Click(object sender, EventArgs e)
{
LoaiThucDonBUS a = new LoaiThucDonBUS();
if (trThai == 2)
{
LoaiThucDonDTO loai;
try
{
loai = new LoaiThucDonDTO()
{
MALOAITD = int.Parse(txt_MaLoai.Text),
TEN = txt_TenLoai.Text,
TINHTRANG = ckb_TinhTrang.Checked ? true : false
};
}
catch
{
MessageBox.Show("Thieu thong tin");
return;
}
bool kt = a.CapNhatLoai(loai);
if (!kt)
{
MessageBox.Show("Cập nhật thất bại");
}
else
{
FrmChinh frmmain = (FrmChinh)this.MdiParent;
frmmain.lsNDDTO = new LichSuNguoiDungDTO()
{
MAND = frmmain.nvDangNhap.MAND,
MANV = frmmain.nvDangNhap.MANV,
THOIGIAN = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyy HH:mm")),
SUKIEN = "Cập nhật loại thực đơn " + loaiTD.TEN + " => " + txt_TenLoai.Text
};
bool ktls = frmmain.lsNDBUS.ThemLichSuNguoiDung(frmmain.lsNDDTO);
MessageBox.Show("Cập nhật thành công!");
trThai = 1;
loaiTD = null;
}
}
TrangThai();
Bind();
LoadData();
}
public bool CapNhatLoai(LoaiThucDonDTO loai)
{
string update = "UPDATE LOAITD "
+ "SET TEN = @TEN,"
+ " TINHTRANG = @TINHTRANG"
+ " WHERE MALOAITD = @MALOAITD";
List <SqlParameter> lsparams = new List <SqlParameter>();
lsparams.Add(new SqlParameter("@TEN", loai.TEN));
lsparams.Add(new SqlParameter("@TINHTRANG", loai.TINHTRANG));
lsparams.Add(new SqlParameter("@MALOAITD", loai.MALOAITD));
SqlConnection con = DataProvider.TaoKetNoi();
bool thucthi = DataProvider.ThucThi(update, lsparams.ToArray(), con);
return(thucthi);
}
//string chuoiketnoi = @"Data Source =DESKTOP-20TAQ02\SQLEXPRESS;Initial Catalog = csdlDAKARAOKE;Integrated Sucurity = True;";
public List <LoaiThucDonDTO> dsLoaiTD()
{
List <LoaiThucDonDTO> ds = new List <LoaiThucDonDTO>();
SqlConnection conn = DataProvider.TaoKetNoi();
SqlCommand com = new SqlCommand("select * from LOAITD ", conn);
SqlDataReader sdr = com.ExecuteReader();
while (sdr.Read())
{
LoaiThucDonDTO a = new LoaiThucDonDTO()
{
MALOAITD = sdr.GetInt32(0),
TEN = sdr.GetString(1),
TINHTRANG = sdr.GetBoolean(2)
};
ds.Add(a);
}
return(ds);
}
public void MaLoaiSet([PexAssumeUnderTest] LoaiThucDonDTO target, int value)
{
target.MaLoai = value;
// TODO: add assertions to method LoaiThucDonDTOTest.MaLoaiSet(LoaiThucDonDTO, Int32)
}
public void TenLoaiSet([PexAssumeUnderTest] LoaiThucDonDTO target, string value)
{
target.TenLoai = value;
// TODO: add assertions to method LoaiThucDonDTOTest.TenLoaiSet(LoaiThucDonDTO, String)
}
void LayDanhSachThucDon()
{
// Xử lý request
int pageSize = 10;
if (Request["results"] != null)
{
pageSize = int.Parse((string)Request["results"]);
}
int pageNum = 1;
if (Request["startIndex"] != null)
{
pageNum = (int.Parse((string)Request["startIndex"]) / pageSize) + 1;
}
ThucDonBUS bus = new ThucDonBUS();
ThucDonDTO[] kq = bus.DanhSachThucDon(pageNum, pageSize);
LoaiThucDonBUS ltdBus = new LoaiThucDonBUS();
int tongSoThucDon = bus.TongSoThucDon();
XL_THE Kq = new XL_THE("DANH_SACH");
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("totalRecords", tongSoThucDon.ToString());
Kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
foreach (ThucDonDTO dto in kq)
{
XL_THE the = new XL_THE("ThucDon");
Thuoc_tinh = new XL_THUOC_TINH("MaThucDon", dto.Ma_thuc_don.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TenThucDon", dto.Ten_thuc_don);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
LoaiThucDonDTO ltdDto = ltdBus.ChiTietLoaiThucDon(dto.Ma_loai_thuc_don);
Thuoc_tinh = new XL_THUOC_TINH("LoaiThucDon", ltdDto.Ten_loai_thuc_don);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("MoTa", dto.Mo_ta);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("HinhAnhMinhHoa", dto.Hinh_anh_minh_hoa);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", dto.Gia.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TrangThaiHienThi", dto.Trang_thai_hien_thi ? "1" : "0");
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TinhTrang", dto.Tinh_trang ? "1" : "0");
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(the);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
public bool CapNhatLoai(LoaiThucDonDTO loai)
{
LoaiThucDonDAO a = new LoaiThucDonDAO();
return(a.CapNhatLoai(loai));
}
