public NV_DanhMucAnPham_ChiTiet GetById(int id)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_DanhMucAnPham_getByID", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@DanhMucID", SqlDbType.Int);
pID.Value = id;
myCommand.Parameters.Add(pID);
DataTable dt;
NV_DanhMucAnPham_ChiTiet model = new NV_DanhMucAnPham_ChiTiet();
myConnection.Open();
using (SqlDataAdapter mData = new SqlDataAdapter(myCommand))
{
dt = new DataTable();
mData.Fill(dt);
}
if (dt != null && dt.Rows.Count > 0)
{
model = new NV_DanhMucAnPham_ChiTiet(dt);
}
return(model);
}
}
}
public NV_DanhMucAnPham_ChiTiet GetByUrl(string url)
{
string sql = "select top 1 *,dbo.getUrl(DanhMucID,'DanhMucAnPham',null) as UrlFull from DanhMucAnPham where Url='" + url + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
NV_DanhMucAnPham_ChiTiet menu = new NV_DanhMucAnPham_ChiTiet();
if (dt != null && dt.Rows.Count > 0)
{
menu = new NV_DanhMucAnPham_ChiTiet(dt);
}
return(menu);
}
public bool them(NV_DanhMucAnPham_ChiTiet model, out int id)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_DanhMucAnPham_add", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@DanhMucID", SqlDbType.Int);
pID.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(pID);
SqlParameter pTenDanhMuc = new SqlParameter("@TenDanhMuc", SqlDbType.NVarChar, 500);
pTenDanhMuc.Value = model.TenDanhMuc;
myCommand.Parameters.Add(pTenDanhMuc);
SqlParameter pEngName = new SqlParameter("@EngName", SqlDbType.NVarChar, 500);
pEngName.Value = model.EngName;
myCommand.Parameters.Add(pEngName);
SqlParameter pUrl = new SqlParameter("@Url", SqlDbType.NVarChar, 500);
pUrl.Value = model.Url;
myCommand.Parameters.Add(pUrl);
id = 0;
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
id = (int)pID.Value;
return(true);
}
catch
{
return(false);
}
}
}
}
