//public static void Delete(Guid ID)
//{
// Functions.DeleteItem(TableName, ID);
//}
public static MEMBER GetByEmailAndPassword(string email, string password)
{
List <WHERE> where = new List <WHERE>();
where.Add(new WHERE("EMAIL", "=", email, null));
where.Add(new WHERE("PASSWORD", "=", password, null));
return(Functions.ConvertToEntity <MEMBER>(Functions.GetByPropertyValue(TableName, where)));
}
public static List <MEMBER> GetSearchList(string name)
{
List <WHERE> where = new List <WHERE>();
if (!string.IsNullOrEmpty(name))
{
where.Add(new WHERE("NAME", "LIKE", "%" + name.Trim().Replace(" ", "%") + "%"));
}
return(Functions.GetByPropertyValue(TableName, where).ConvertToList <MEMBER>());
}
public static List <MAIL> GetAll()
{
List <WHERE> where = new List <WHERE>();
return(Functions.GetByPropertyValue(TableName, where).ConvertToList <MAIL>());
}
public static MAIL Get(int ID)
{
List <WHERE> where = new List <WHERE>();
where.Add(new WHERE("ID", "=", ID, null));
return(Functions.ConvertToEntity <MAIL>(Functions.GetByPropertyValue(TableName, where)));
}
//public static void Delete(Guid ID)
//{
// Functions.DeleteItem(TableName, ID);
//}
public static string GetValueByCode(string code)
{
List <WHERE> where = new List <WHERE>();
where.Add(new WHERE("CODE", "=", code, null));
return(Functions.ConvertToEntity <PARAMETER>(Functions.GetByPropertyValue(TableName, where)).VALUE);
}
public static List <BLOG> GetTitleList(string URLSEO)
{
List <WHERE> where = new List <WHERE>();
where.Add(new WHERE("URLSEO", "=", URLSEO, null));
return(Functions.GetByPropertyValue(TableName, where).ConvertToList <BLOG>());
}
public static BLOG GetBySort(int sort)
{
List <WHERE> where = new List <WHERE>();
where.Add(new WHERE("SORT", "=", sort, null));
return(Functions.ConvertToEntity <BLOG>(Functions.GetByPropertyValue(TableName, where)));
}
public static MEMBER GetByID(Guid memberid)
{
List <WHERE> where = new List <WHERE>();
where.Add(new WHERE("ID", "=", memberid, null));
return(Functions.ConvertToEntity <MEMBER>(Functions.GetByPropertyValue(TableName, where)));
}
public static MEMBER GetByPasswordResetCode(string passwordcode)
{
List <WHERE> where = new List <WHERE>();
where.Add(new WHERE("PASSWORDRESETCODE", "=", passwordcode, null));
return(Functions.ConvertToEntity <MEMBER>(Functions.GetByPropertyValue(TableName, where)));
}
