/// <summary>
/// Get Array object class có parameter.
/// </summary>
/// <returns></returns>
public static Cls_Users[] getArrayObject(DataTable dt)
{
if (dt.Rows.Count == 0)
{
return(null);
}
Cls_Users[] arr = new Cls_Users[dt.Rows.Count];
int i = 0;
foreach (DataRow dr in dt.Rows)
{
arr[i] = converDataRow_To_Object(dr);
i++;
}
return(arr);
}
/// <summary>
/// Converter DataRow sang Object.
/// </summary>
/// <returns></returns>
public static Cls_Users converDataRow_To_Object(DataRow dr)
{
Cls_Users _Object = new Cls_Users();
//ID_User
if (dr.Table.Columns.Contains(fn_ID_User))
{
if (dr[fn_ID_User] != DBNull.Value)
{
_Object.ID_User = (int)dr[fn_ID_User];
}
}
//ID_Catalog
if (dr.Table.Columns.Contains(fn_ID_Catalog))
{
if (dr[fn_ID_Catalog] != DBNull.Value)
{
_Object.ID_Catalog = (int)dr[fn_ID_Catalog];
}
}
//UserName
if (dr.Table.Columns.Contains(fn_UserName))
{
if (dr[fn_UserName] != DBNull.Value)
{
_Object.UserName = (string)dr[fn_UserName];
}
}
//Password
if (dr.Table.Columns.Contains(fn_Password))
{
if (dr[fn_Password] != DBNull.Value)
{
_Object.Password = (string)dr[fn_Password];
}
}
//FullName
if (dr.Table.Columns.Contains(fn_FullName))
{
if (dr[fn_FullName] != DBNull.Value)
{
_Object.FullName = (string)dr[fn_FullName];
}
}
//Image
if (dr.Table.Columns.Contains(fn_Image))
{
if (dr[fn_Image] != DBNull.Value)
{
_Object.Image = (string)dr[fn_Image];
}
}
//Gender
if (dr.Table.Columns.Contains(fn_Gender))
{
if (dr[fn_Gender] != DBNull.Value)
{
_Object.Gender = (string)dr[fn_Gender];
}
}
//Email
if (dr.Table.Columns.Contains(fn_Email))
{
if (dr[fn_Email] != DBNull.Value)
{
_Object.Email = (string)dr[fn_Email];
}
}
//PhoneNumber
if (dr.Table.Columns.Contains(fn_PhoneNumber))
{
if (dr[fn_PhoneNumber] != DBNull.Value)
{
_Object.PhoneNumber = (string)dr[fn_PhoneNumber];
}
}
//Description
if (dr.Table.Columns.Contains(fn_Description))
{
if (dr[fn_Description] != DBNull.Value)
{
_Object.Description = (string)dr[fn_Description];
}
}
//TitleWeb
if (dr.Table.Columns.Contains(fn_TitleWeb))
{
if (dr[fn_TitleWeb] != DBNull.Value)
{
_Object.TitleWeb = (string)dr[fn_TitleWeb];
}
}
//LinkSEO
if (dr.Table.Columns.Contains(fn_LinkSEO))
{
if (dr[fn_LinkSEO] != DBNull.Value)
{
_Object.LinkSEO = (string)dr[fn_LinkSEO];
}
}
//H1SEO
if (dr.Table.Columns.Contains(fn_H1SEO))
{
if (dr[fn_H1SEO] != DBNull.Value)
{
_Object.H1SEO = (string)dr[fn_H1SEO];
}
}
//KeywordSEO
if (dr.Table.Columns.Contains(fn_KeywordSEO))
{
if (dr[fn_KeywordSEO] != DBNull.Value)
{
_Object.KeywordSEO = (string)dr[fn_KeywordSEO];
}
}
//AddTime
if (dr.Table.Columns.Contains(fn_AddTime))
{
if (dr[fn_AddTime] != DBNull.Value)
{
_Object.AddTime = (DateTime)dr[fn_AddTime];
}
}
//EditTime
if (dr.Table.Columns.Contains(fn_EditTime))
{
if (dr[fn_EditTime] != DBNull.Value)
{
_Object.EditTime = (DateTime)dr[fn_EditTime];
}
}
//Hidden
if (dr.Table.Columns.Contains(fn_Hidden))
{
if (dr[fn_Hidden] != DBNull.Value)
{
_Object.Hidden = (bool)dr[fn_Hidden];
}
}
return(_Object);
}
