public List <MessageModel> GetMessages() { List <MessageModel> Models = new List <MessageModel>(); base.Connect(); DataTable dt = base.Select("SELECT [M_Id],[Name],[Subject],[EmailAddress],[Date],[Message],[Answered],[Seen],[AnswerMessage] FROM [tbl_Message] ORDER BY([Date])DESC"); base.DC(); for (int i = 0; i < dt.Rows.Count; i++) { var model = new MessageModel() { Num = i + 1, M_Id = Convert.ToInt32(dt.Rows[i]["M_Id"]), Answere = dt.Rows[i]["AnswerMessage"].ToString(), Answered = Convert.ToInt32(dt.Rows[i]["Answered"]), Date = Statics.DateReturner(dt.Rows[i]["Date"].ToString(), "ShortDate"), Name = dt.Rows[i]["Name"].ToString(), Seen = Convert.ToInt32(dt.Rows[i]["Seen"]), Subject = dt.Rows[i]["Subject"].ToString(), Email = dt.Rows[i]["EmailAddress"].ToString(), Message = dt.Rows[i]["Message"].ToString() }; Models.Add(model); } return(Models); }
public List <EmailModel> GetNewsletter() { List <EmailModel> Models = new List <EmailModel>(); base.Connect(); DataTable dt = base.Select("SELECT [Mail_Id],[EmailAddress],[Date],[IsActive] FROM [tbl_Newsletter]"); base.DC(); for (int i = 0; i < dt.Rows.Count; i++) { var model = new EmailModel() { Num = i + 1, EmailId = Convert.ToInt32(dt.Rows[i]["Mail_Id"]), Active = Convert.ToInt32(dt.Rows[i]["IsActive"]), Email = dt.Rows[i]["EmailAddress"].ToString(), Date = Statics.DateReturner(dt.Rows[i]["Date"].ToString(), "ShortDate") }; Models.Add(model); } return(Models); }