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);
}
