/// <summary>
/// Deletes a row from the doc_FileSystem table. Returns true if row deleted.
/// </summary>
/// <param name="fileSystemGuid"> fileSystemGuid </param>
/// <returns>bool</returns>
public static bool Delete(
Guid fileSystemGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "doc_FileSystem_Delete", 1);
sph.DefineSqlParameter("@FileSystemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, fileSystemGuid);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
/// <summary>
/// Deletes a row from the UserProfile table. Returns true if row deleted.
/// </summary>
/// <param name="userGuid"> userGuid </param>
/// <returns>bool</returns>
public static bool Delete(
int userID)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "UserProfile_hoadm01082015_Delete", 1);
sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, userID);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
/// <summary>
/// Deletes a row from the cont_Catologies table. Returns true if row deleted.
/// </summary>
/// <param name="catologyGuid"> catologyGuid </param>
/// <returns>bool</returns>
public static bool Delete(
Guid catologyGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "cont_Catologies_ngocnv10052014_Delete", 1);
sph.DefineSqlParameter("@CatologyGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, catologyGuid);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
/// <summary>
/// Deletes a row from the gv_MonHoc table. Returns true if row deleted.
/// </summary>
/// <param name="monHocGuid"> monHocGuid </param>
/// <returns>bool</returns>
public bool Delete(
Guid monHocGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "gv_MonHoc_Chuongtv01082015_Delete", 1);
sph.DefineSqlParameter("@MonHocGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, monHocGuid);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
/// <summary>
/// Deletes a row from the gv_BuoiGiangDay table. Returns true if row deleted.
/// </summary>
/// <param name="buoiGiangGuid"> buoiGiangGuid </param>
/// <returns>bool</returns>
public bool Delete(
Guid buoiGiangGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "gv_BuoiGiangDay_Delete", 1);
sph.DefineSqlParameter("@BuoiGiangGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, buoiGiangGuid);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
/// <summary>
/// Inserts a row in the gv_GiangVien table. Returns rows affected count.
/// </summary>
/// <returns>int</returns>
public int Create(GiangVien item)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "gv_GiangVien_Insert", 3);
sph.DefineSqlParameter("@GiangVienGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.GiangVienGuid);
sph.DefineSqlParameter("@GiangvienName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.GiangvienName);
sph.DefineSqlParameter("@GiangVienID", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.GiangVienID);
int rowsAffected = sph.ExecuteNonQuery();
return rowsAffected;
}
/// <summary>
/// Inserts a row in the gv_MonHoc table. Returns rows affected count.
/// </summary>
/// <returns>int</returns>
public int Create(MonHoc item)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "gv_MonHoc_Chuongtv31072015_Insert", 5);
sph.DefineSqlParameter("@MonHocGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.MonHocGuid);
sph.DefineSqlParameter("@MonHocName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.MonHocName);
sph.DefineSqlParameter("@MonHocID", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.MonHocID);
sph.DefineSqlParameter("@Userid", SqlDbType.Int, ParameterDirection.Input, item.Userid);
sph.DefineSqlParameter("@SoBuoiGiangDay", SqlDbType.Int, ParameterDirection.Input, item.SoBuoiGiangDay);
int rowsAffected = sph.ExecuteNonQuery();
return rowsAffected;
}
/// <summary>
/// Inserts a row in the gv_BuoiGiangDay table. Returns rows affected count.
/// </summary>
/// <returns>int</returns>
public int Create(BuoiGiangDay item)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "gv_BuoiGiangDay_Insert", 4);
sph.DefineSqlParameter("@BuoiGiangGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.BuoiGiangGuid);
sph.DefineSqlParameter("@BuoiGiangID", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.BuoiGiangID);
sph.DefineSqlParameter("@BuoiGiangName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.BuoiGiangName);
sph.DefineSqlParameter("@MonHocGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.MonHocGuid);
int rowsAffected = sph.ExecuteNonQuery();
return rowsAffected;
}
/// <summary>
/// Inserts a row in the cont_Catologies table. Returns rows affected count.
/// </summary>
/// <returns>int</returns>
public static int Create(Catologie item)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "cont_Catologies_ngocnv10052014_Insert", 10);
sph.DefineSqlParameter("@CatologyGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.CatologyGuid);
sph.DefineSqlParameter("@CatologyName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.CatologyName);
sph.DefineSqlParameter("@Description", SqlDbType.NVarChar, 500, ParameterDirection.Input, item.Description);
sph.DefineSqlParameter("@KindCatologyGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.KindCatologyGuid);
sph.DefineSqlParameter("@KindCatologyName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.KindCatologyName);
sph.DefineSqlParameter("@IsActive", SqlDbType.Bit, ParameterDirection.Input, item.IsActive);
sph.DefineSqlParameter("@Position", SqlDbType.Int, ParameterDirection.Input, item.Position);
sph.DefineSqlParameter("@ListStringToSort", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.ListStringToSort);
sph.DefineSqlParameter("@UserName", SqlDbType.NVarChar,256, ParameterDirection.Input, item.Massv);
sph.DefineSqlParameter("@IsNotDelete", SqlDbType.Bit, ParameterDirection.Input, item.IsNotDelete);
int rowsAffected = sph.ExecuteNonQuery();
return rowsAffected;
}
/// <summary>
/// Inserts a row in the doc_FileSystem table. Returns rows affected count.
/// </summary>
/// <returns>int</returns>
public static int Create(FileSystem item)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "doc_FileSystem_Insert", 10);
sph.DefineSqlParameter("@FileSystemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.FileSystemGuid);
sph.DefineSqlParameter("@FileSystemID", SqlDbType.NVarChar, 25, ParameterDirection.Input, item.FileSystemID);
sph.DefineSqlParameter("@FileType", SqlDbType.NVarChar, 25, ParameterDirection.Input, item.FileType);
sph.DefineSqlParameter("@FileSize", SqlDbType.Decimal, ParameterDirection.Input, item.FileSize);
sph.DefineSqlParameter("@ClientFileName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.ClientFileName);
sph.DefineSqlParameter("@ServerFileName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.ServerFileName);
sph.DefineSqlParameter("@TableName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.TableName);
sph.DefineSqlParameter("@UpdatedDate", SqlDbType.DateTime, ParameterDirection.Input, item.UpdatedDate);
sph.DefineSqlParameter("@UpdatedUser", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.UpdatedUser);
sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.ItemGuid);
int rowsAffected = sph.ExecuteNonQuery();
return rowsAffected;
}
internal static bool DeleteByItemGuid(Guid itemGuid, string tablename)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetReadConnectionString(), "doc_FileSystem_Nam_DeleteByItemGuidAndTableName", 2);
sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, itemGuid);
sph.DefineSqlParameter("@TableName", SqlDbType.NVarChar,256, ParameterDirection.Input, tablename);
int row = sph.ExecuteNonQuery();
return (row > 0);
}
internal bool ThemTaiLieuVaoCapDienTu(Guid fileguid, int userlogin)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "gv_MonHoc_Chuongtv01082015_ThemTaiLieuVaoCapDienTu", 2);
sph.DefineSqlParameter("@UseridLogin", SqlDbType.Int, ParameterDirection.Input, userlogin);
sph.DefineSqlParameter("@FileSystemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, fileguid);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
internal static bool ResetPass(int userID, string p)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "UserProfile_hoadm01082015_ResetPass", 1);
sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, userID);
sph.DefineSqlParameter("@Text", SqlDbType.NVarChar, 50, ParameterDirection.Input, p);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
//tsandtm add save file thumbnail
internal static bool SaveFile(Guid GuidCatology, string FileNameThumbnail)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetReadConnectionString(), "cont_Catologies_ngocnv10052014_UpdateImage", 2);
sph.DefineSqlParameter("@CatologyGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, GuidCatology);
sph.DefineSqlParameter("@URLHinhAnh", SqlDbType.NVarChar, 256, ParameterDirection.Input, FileNameThumbnail);
return Convert.ToInt32(sph.ExecuteNonQuery()) > 0;
}
internal static bool RemoveBookInBag(Guid FileGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetReadConnectionString(), "doc_FileSystem_RemoveBookInBag", 1);
sph.DefineSqlParameter("@FileGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, FileGuid);
int row = sph.ExecuteNonQuery();
return (row > 0);
}
internal static bool CapNhapDanhSachFollower(int userlogin, int id)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "UserProfile_hoadm01082015_CapNhapDanhSachFollower", 2);
sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, userlogin);
sph.DefineSqlParameter("@Follower", SqlDbType.Int, ParameterDirection.Input, id);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
/// <summary>
/// Chuong
/// </summary>
/// <param name="itemGuid"></param>
/// <returns></returns>
internal static bool DeleteByItemGuid(Guid itemGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetReadConnectionString(), "doc_FileSystem_DeleteByItemGuid", 1);
sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, itemGuid);
int row = sph.ExecuteNonQuery();
return (row > 0);
}
internal bool ShareDocForStudent(Guid buoiguid, Guid monguid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetReadConnectionString(), "gv_BuoiGiangDay_tsandtm_ShareDocForStudent", 2);
sph.DefineSqlParameter("@buoiguid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, buoiguid);
sph.DefineSqlParameter("@monguid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, monguid);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
internal static bool UpdateItemGuid(Guid itemGuid, string ControlID, Guid UserGuid, Guid itemGuidTam)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "doc_FileSystem_UpdateItemGuid", 4);
sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, itemGuid);
sph.DefineSqlParameter("@ControlID", SqlDbType.NVarChar, 256, ParameterDirection.Input, ControlID);
sph.DefineSqlParameter("@UpdatedUser", SqlDbType.UniqueIdentifier, ParameterDirection.Input, UserGuid);
sph.DefineSqlParameter("@ItemGuidTam", SqlDbType.UniqueIdentifier, ParameterDirection.Input, itemGuidTam);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
internal static bool UpdateLogLoi(Guid userGuid, string tableName, Guid itemGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetReadConnectionString(), "doc_FileSystem_UpdateItemGuidFileLogLoi", 3);
sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
sph.DefineSqlParameter("@TableName", SqlDbType.NVarChar, 256, ParameterDirection.Input, tableName);
sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, itemGuid);
int row = sph.ExecuteNonQuery();
return (row > 0);
}
/// <summary>
/// Updates a row in the UserProfile table. Returns true if row updated.
/// </summary>
/// <returns>bool</returns>
public static bool Update(Users item)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "UserProfile_hoadm01082015_Update", 9);
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("@UpdateUser", 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 = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
