/// <summary>
/// Gets a count of rows in the UserProfile table.
/// </summary>
public static int GetCount(string q)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetReadConnectionString(), "UserProfile_hoadm01082015_GetCount", 1);
sph.DefineSqlParameter("@KeySearch", SqlDbType.NVarChar, 256, ParameterDirection.Input, q);
return Convert.ToInt32(sph.ExecuteScalar());
}
public static int GetCountByItemGuid(Guid catGuid, string q)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetReadConnectionString(), "doc_FileSystem_DN_GetCountByItemGuid", 2);
sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, catGuid);
sph.DefineSqlParameter("@KeySearch", SqlDbType.NVarChar, 256, ParameterDirection.Input, q);
return Convert.ToInt32(sph.ExecuteScalar());
}
/// <summary>
/// Inserts a row in the UserProfile table. Returns rows affected count.
/// </summary>
/// <returns>int</returns>
public static int Create(Users item)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "UserProfile_hoadm01082015_Insert", 8);
//sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, item.UserId);
sph.DefineSqlParameter("@UserName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.UserName);
sph.DefineSqlParameter("@AvatarExt", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.AvatarExt);
sph.DefineSqlParameter("@NgaySinh", SqlDbType.DateTime, ParameterDirection.Input, item.NgaySinh);
sph.DefineSqlParameter("@DienThoai", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.DienThoai);
sph.DefineSqlParameter("@DiaChi", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.DiaChi);
//sph.DefineSqlParameter("@Password", SqlDbType.NVarChar, 50, ParameterDirection.Input, item.Password);
sph.DefineSqlParameter("@CreatedUser", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.CreatedUser);
sph.DefineSqlParameter("@CreatedDate", SqlDbType.DateTime, ParameterDirection.Input, item.CreatedDate);
//sph.DefineSqlParameter("@UpdatedUser", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.UpdatedUser);
//sph.DefineSqlParameter("@UpdatedDate", SqlDbType.DateTime, ParameterDirection.Input, item.UpdatedDate);
sph.DefineSqlParameter("@FullName", SqlDbType.NVarChar, 25, ParameterDirection.Input, item.FullName);
int rowsAffected = Convert.ToInt32(sph.ExecuteScalar());
return rowsAffected;
}
public static int GetCount(Guid rootGuid, int isActive)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetReadConnectionString(), "cont_Catologies_ngocnv10052014_GetCount_2para", 2);
sph.DefineSqlParameter("@RootGuid", SqlDbType.NVarChar, 256, ParameterDirection.Input, rootGuid.ToString());
sph.DefineSqlParameter("@IsActive", SqlDbType.Int, ParameterDirection.Input, isActive);
return Convert.ToInt32(sph.ExecuteScalar());
}
internal static int GetMaxPositionByKindGuid(Guid Kindguid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetReadConnectionString(), "cont_Catologies_ngocnv10052014_SelectMaxPosition", 1);
sph.DefineSqlParameter("@KindCatologyGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, Kindguid);
return Convert.ToInt32(sph.ExecuteScalar());
}
internal static bool CheckExistUser(Catologie itemSP)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetReadConnectionString(), "cont_UserProfile_CheckExistUser", 1);
sph.DefineSqlParameter("@UserName", SqlDbType.NVarChar,256, ParameterDirection.Input, itemSP.Massv);
return Convert.ToInt32(sph.ExecuteScalar())>0;
}
internal static bool CheckExistByItemGuid(Guid itemguid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "doc_FileSystem_CheckExistByItemGuid", 1);
sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, itemguid);
int rowsAffected = Convert.ToInt32(sph.ExecuteScalar());
return (rowsAffected > 0);
}
/// <summary>
/// Chuong
/// </summary>
/// <param name="itemGuid"></param>
/// <returns></returns>
public static bool KiemTraTonTaiFileDinhKem(Guid itemGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetReadConnectionString(), "doc_FileSystem_KiemTraTonTaiFileDinhKem", 1);
sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, itemGuid);
int row = Convert.ToInt32(sph.ExecuteScalar());
return (row > 0);
}
