public T_Nguoidung_Chucnang GetOneFromT_UserMenuByID(Int32 UserMenu_ID)
{
try
{
return((T_Nguoidung_Chucnang)HPCDataProvider.Instance().GetObjectByID(UserMenu_ID.ToString(), "T_UserMenu", "UserMenu_ID"));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Sp_DuyetAnhDinhKem(string WhereCondition)
{
try
{
return(HPCDataProvider.Instance().GetStoreDataSet("Sp_DuyetAnhDinhKem", new string[] { "@Where" }, new object[] { WhereCondition }));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet ListPhotoOfNews(string _where)
{
try
{
return(HPCDataProvider.Instance().GetStoreDataSet("[Sp_ListPhotosTopForSelect]", new string[] { "@WhereCondition" }, new object[] { _where }));
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteFromT_Anh(int _Maanh)
{
try
{
HPCDataProvider.Instance().ExecStore("Sp_DeleteOneFromT_Anh", new string[] { "@Ma_Anh" }, new object[] { _Maanh });
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Sp_SelectTulieuanhDynamic(string WhereCondition, string order)
{
try
{
return(HPCDataProvider.Instance().GetStoreDataSet("Sp_SelectTuLieuAnh_Dynamic", new string[] { "@WhereCondition", "@OrderByExpression" }, new object[] { WhereCondition, order }));
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteFrom_T_Album_Photo(Int32 ID)
{
try
{
HPCDataProvider.Instance().ExecStore("[CMS_DeleteOneFromT_Album_Photo]", new string[] { "@Alb_Photo_ID" }, new object[] { ID });
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateStatus_AlbumPhoto(int Cat_Album_ID, int Status, int Creator, DateTime Date_Create)
{
try
{
HPCDataProvider.Instance().ExecStore("[CMS_UpdateStatus_AlbumPhoto]", new string[] { "@Alb_Photo_ID", "@Status", "@Creator", "@Date_Create" }, new object[] { Cat_Album_ID, Status, Creator, Date_Create });
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Check_Doituong(string MaDT, string TenDT)
{
try
{
return(HPCDataProvider.Instance().GetDataSet("T_Doituong", "Ten_Doituong, Ma_Doituong", " Ma_Doituong = N'" + MaDT + "' or Ten_Doituong = N'" + TenDT + "'"));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_TenDoiTuong(string _tenDT)
{
try
{
return(HPCDataProvider.Instance().GetDataSet("T_Doituong", "Ten_Doituong", " Ten_Doituong like '%" + _tenDT + "%' "));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet BindGridT_Nguoidung_Chucnang(int PageIndex, int PageSize, string WhereCondition)
{
try
{
return(HPCDataProvider.Instance().GetStoreDataSet("Sp_ListT_UserMenuDynamic", new string[] { "@PageIndex", "@PageSize", "@where" }, new object[] { PageIndex, PageSize, WhereCondition }));
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertT_Doituong_AnPham(string MaDT, int MaAnPham)
{
try
{
HPCDataProvider.Instance().ExecStore("Sp_InsertT_Doituong_Anpham", new string[] { "@MaDT", "@MaAnPham" }, new object[] { MaDT, MaAnPham });
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertT_Nguoidung_Chucnang(T_Nguoidung_Chucnang _T_UserMenu)
{
try
{
HPCDataProvider.Instance().InsertObject(_T_UserMenu);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateFromT_Nguoidung_ChucnangDynamic(string WhereCondition)
{
try
{
HPCDataProvider.Instance().ExecStore("Sp_UpdateT_UserMenuDynamic", new string[] { "@WhereCondition" }, new object[] { WhereCondition });
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteFromT_Nguoidung_ChucnangByID(Int32 UserMenu_ID)
{
try
{
HPCDataProvider.Instance().ExecStore("Sp_DeleteOneFromT_UserMenu", new string[] { "@UserMenu_ID" }, new object[] { UserMenu_ID });
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Bind_T_Album_PhotoDynamic(int PageIndex, int PageSize, string WhereCondition)
{
try
{
return(HPCDataProvider.Instance().GetStoreDataSet("[CMS_ListT_Album_PhotoDynamic]", new string[] { "@PageIndex", "@PageSize", "@where" }, new object[] { PageIndex, PageSize, WhereCondition }));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_STT(string _maDT)
{
try
{
return(HPCDataProvider.Instance().GetDataSet("T_Doituong", "STT", " Ma_Doituong like '%" + _maDT + "%' "));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Bind_T_Album_Photo(int CatID)
{
try
{
return(HPCDataProvider.Instance().GetStoreDataSet("[CMS_ListT_Album_Photo]", new string[] { "@CatID" }, new object[] { CatID }));
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertT_Doituong(T_Doituong _Obj)
{
try
{
return(HPCDataProvider.Instance().InsertObjectReturn(_Obj, "Sp_InsertT_Doituong"));
}
catch (Exception ex)
{
throw ex;
}
}
public void Insert_T_Album_Photo_From_T_Album_Photo(int Cat_Album_ID, int CopyFrom, int Lang_Id)
{
try
{
HPCDataProvider.Instance().ExecStore("[CMS_Insert_T_Album_Photo_From_T_Album_Photo]", new string[] { "@Alb_Photo_ID", "@CopyFrom", "@Lang_Id " }, new object[] { Cat_Album_ID, CopyFrom, Lang_Id });
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteOneFromT_Doituong(int _Id)
{
try
{
HPCDataProvider.Instance().ExecStore("Sp_DeleteOneFromT_Doituong", new string[] { "@ID" }, new object[] { _Id });
}
catch (Exception ex)
{
throw ex;
}
}
public T_Album_Photo GetOneFromT_Album_PhotoByID(Int32 _ID)
{
try
{
return((T_Album_Photo)HPCDataProvider.Instance().GetObjectByID(_ID.ToString(), "T_Album_Photo", "Alb_Photo_ID"));
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteOneFromT_Doituong_AnPham(int _Id, int _maanpham)
{
try
{
HPCDataProvider.Instance().ExecStore("Sp_DeleteOneFromT_Doituong_AnPham", new string[] { "@ID", "@Ma_Anpham" }, new object[] { _Id, _maanpham });
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateinfoT_Anh(string WhereCondition)
{
try
{
HPCDataProvider.Instance().ExecStore("Sp_UpdateT_AnhDynamic", new string[] { "@WhereCondition" }, new object[] { WhereCondition });
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdatePosition_Doituong(string MaDT, int MaAnpham, string cssLeft, string cssTop)
{
try
{
HPCDataProvider.Instance().ExecStore("Sp_UpdatePosition_DoiTuong", new string[] { "@Ma_Doituong", "@Ma_Anpham", "@CssLeft", "@CssTop" }, new object[] { MaDT, MaAnpham, cssLeft, cssTop });
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetListImageByTinbai(Int32 ID)
{
try
{
return(HPCDataProvider.Instance().GetStoreDataSet("Sp_GetListImageByTinbai", new string[] { "@Ma_TinBai" }, new object[] { ID }));
}
catch (Exception ex)
{
throw ex;
}
}
public T_Butdanh GetOneFrom_BDID(Double _ID)
{
try
{
return((T_Butdanh)HPCDataProvider.Instance().GetObjectByID(_ID.ToString(), "T_Butdanh", "BD_ID"));
}
catch (Exception ex)
{
throw ex;
}
}
public T_Anh GetOneFromT_AnhByID(Int32 ID)
{
try
{
return((T_Anh)HPCDataProvider.Instance().GetObjectByID(ID.ToString(), "T_Anh", "Ma_Anh"));
}
catch (Exception ex)
{
throw ex;
}
}
public void Copy_To_T_Album_Photo(int Cat_Album_ID, int Cat_Album_ID_New, int Lang_ID, DateTime DateModify, int UserModify)
{
try
{
HPCDataProvider.Instance().ExecStore("[CMS_Copy_T_Album_Photo]", new string[] { "@Cat_Album_ID", "@Cat_Album_ID_New", "@Lang_ID", "@DateModify", "@UserModify" }, new object[] { Cat_Album_ID, Cat_Album_ID_New, Lang_ID, DateModify, UserModify });
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertUpdateT_Anh(T_Anh _Obj)
{
try
{
return(HPCDataProvider.Instance().InsertObjectReturn(_Obj, "Sp_Insert_UpdateT_Anh"));
}
catch (Exception ex)
{
throw ex;
}
}
public void AutoInsertT_Layout_Sobao(int _masobao, int _maAnpham)
{
try
{
HPCDataProvider.Instance().ExecStore("[sp_AutoInsert_T_Layout_Sobao]", new string[] { "@Ma_SoBao", "@Ma_AnPham" }, new object[] { _masobao, _maAnpham });
}
catch (Exception ex)
{
throw ex;
}
}