public List <PsPersianWordFrequency> GetByName(string word) { List <PsPersianWordFrequency> tl = new List <PsPersianWordFrequency>(); DataTable dt = gt.GetTableBySql("select * from PS_PersianWordFrequency where val1 ='" + word + "' "); foreach (DataRow item in dt.Rows) //loop through the columns. { PsPersianWordFrequency DIC_FA = new PsPersianWordFrequency(); DIC_FA.Val1 = item["Val1"].ToString().Trim(); DIC_FA.Val2 = item["Val2"].ToString().Trim(); tl.Add(DIC_FA); } return(tl); }
public List <PsPersianWordFrequency> GetAll() { List <PsPersianWordFrequency> tl = new List <PsPersianWordFrequency>(); DataTable dt = gt.GetTableBySql("select * from PS_PersianWordFrequency "); foreach (DataRow item in dt.Rows) //loop through the columns. { PsPersianWordFrequency DIC_PSWF = new PsPersianWordFrequency(); DIC_PSWF.Val1 = item["Val1"].ToString().Trim(); DIC_PSWF.Val2 = item["Val2"].ToString().Trim(); DIC_PSWF.Sundex = item["SUNDEX"].ToString().Trim(); DIC_PSWF.Lavel = int.Parse(item["Lavel"].ToString().Trim()); DIC_PSWF.Lexi = int.Parse(item["lexi"].ToString().Trim()); tl.Add(DIC_PSWF); } return(tl); }