public int ThemCTThucDon(CTThucDonCaNhanDTO dto)
{
int Kq = 0;
Connect();
SqlCommand cmd = new SqlCommand("spThemCTThucDonCaNhan", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@mathucdoncanhan", SqlDbType.Int);
cmd.Parameters.Add("@mamon", SqlDbType.Int);
cmd.Parameters["@mathucdoncanhan"].Value = dto.Ma_thuc_don_ca_nhan;
cmd.Parameters["@mamon"].Value = dto.Ma_mon;
cmd.Parameters.Add("@mactthucdoncanhan", SqlDbType.Int);
cmd.Parameters["@mactthucdoncanhan"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
Disconnect();
Kq = int.Parse(cmd.Parameters["@mactthucdoncanhan"].Value.ToString());
}
catch (SqlException ex)
{
Disconnect();
return(Kq);
}
return(Kq);
}
public int ThemThucDon(ThucDonCaNhanDTO thucdon, String[] strDsMaMon)
{
int Kq = 0; // mã thực đơn
Connect();
SqlCommand cmd = new SqlCommand("spThemThucDonTuTao", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@tenthucdon", SqlDbType.NVarChar);
cmd.Parameters.Add("@hinhanh", SqlDbType.NVarChar);
cmd.Parameters.Add("@makhachhang", SqlDbType.Int);
cmd.Parameters.Add("@dongia", SqlDbType.Money);
cmd.Parameters["@tenthucdon"].Value = thucdon.Ten_thuc_don;
cmd.Parameters["@makhachhang"].Value = thucdon.Ma_khach_hang;
cmd.Parameters["@hinhanh"].Value = thucdon.Hinh_anh;
cmd.Parameters["@dongia"].Value = thucdon.Gia;
cmd.Parameters.Add("@mathucdoncanhan", SqlDbType.Int);
cmd.Parameters["@mathucdoncanhan"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
int mathucdon = int.Parse(cmd.Parameters["@mathucdoncanhan"].Value.ToString());
Kq = mathucdon;
Disconnect();
for (int i = 0; i < strDsMaMon.Length; ++i)
{
CTThucDonCaNhanDTO ctDto = new CTThucDonCaNhanDTO();
ctDto.Ma_thuc_don_ca_nhan = mathucdon;
ctDto.Ma_mon = int.Parse(strDsMaMon[i]);
CTThucDonCaNhanBUS ctBus = new CTThucDonCaNhanBUS();
ctBus.ThemCTThucDon(ctDto);
}
}
catch (SqlException ex)
{
Disconnect();
throw ex;
}
return(Kq);
}
public int ThemCTThucDon(CTThucDonCaNhanDTO dto)
{
return(dao.ThemCTThucDon(dto));
}
