public Preparation GetTestimonialArticleById(int tid)
 {
     DataRow row = facade.GetTestimonialArticleById(tid);
     if (row != null)
     {
         Preparation p = new Preparation(row[0].ToString(), row[1].ToString(), row[2].ToString(), row[3].ToString(), row[4].ToString(), row[5].ToString(), row[6].ToString());
         return p;
     }
     else
     {
         return null;
     }
 }
 public List<Preparation> View_TestimonialArticle()
 {
     List<Preparation> pList = new List<Preparation>();
     DataTable tbl = facade.View_TestimonialArticle();
     foreach (DataRow r in tbl.Rows)
     {
         Preparation p = new Preparation(r[0].ToString(), r[1].ToString(), r[2].ToString(), r[3].ToString(), r[4].ToString(), r[5].ToString(), r[6].ToString());
         pList.Add(p);
     }
     return pList;
 }
 public Preparation GetSlider()
 {
     DataRow r = facade.GetSlider();
     if (r != null)
     {
         Preparation p = new Preparation(r[0].ToString(), r[1].ToString(), r[2].ToString(), r[3].ToString(), r[4].ToString(), r[5].ToString(), r[6].ToString());
         return p;
     }
     else { return null; }
 }