public static void updateTemplate(EmailTemplateInfo Info)
{
string sql = "update email_template set subject = ?subject,body=?body,status=?status,header=?header,footer=?footer" +
" where email_templateid = ?email_templateid";
DAO.ExecuteNonQuery(sql, new MySqlParameter("subject", Info.Subject), new MySqlParameter("body", Info.Body),
new MySqlParameter("status", Info.Status), new MySqlParameter("createddate", Info.CreatedDate), new MySqlParameter("header", Info.Header), new MySqlParameter("footer", Info.Footer),
new MySqlParameter("email_templateid", Info.email_templateid));
}
public static DataTable getMailTemplateByParentId(int parentId)
{
EmailTemplateInfo Info = new EmailTemplateInfo();
string sql = "Select email_templateid as id,subject,body,status,header,footer,version,date_format(createddate,'%d-%b-%Y-%T') as createddate,username from email_template e inner join users u on e.userid=u.userid where parentid = ?parentid";
MySqlDataReader dr = DAO.ExecuteReader(sql, new MySqlParameter("parentid", parentId));
DataSet ds = new DataSet();
ds.EnforceConstraints = false;
DataTable dt = new DataTable();
ds.Load(dr, LoadOption.PreserveChanges, new string[1]);
dt = ds.Tables[0];
dr.Close();
dr.Dispose();
return dt;
}
public static void insertTemplate(EmailTemplateInfo Info)
{
string sql = "Insert into email_template(subject,header,body,footer,status,createddate,version,active,userid) Values(?subject,?header,?body,?footer,?status,?createddate,?version,?active,?userid);select last_insert_id()";
int id = Convert.ToInt32(DAO.ExecuteScalar(sql, new MySqlParameter("subject", Info.Subject), new MySqlParameter("header", Info.Header), new MySqlParameter("body", Info.Body), new MySqlParameter("footer", Info.Footer),
new MySqlParameter("status", Info.Status), new MySqlParameter("createddate", DateTime.UtcNow), new MySqlParameter("version", Info.Version), new MySqlParameter("active", true), new MySqlParameter("userid", GPSession.UserId)));
sql = "update email_template set parentid=?id where email_templateid = ?id";
DAO.ExecuteNonQuery(sql, new MySqlParameter("id", id));
//insertVersion(id, Info.Version);
}
public static EmailTemplateInfo getMailTemplate(int emailtemplateid)
{
EmailTemplateInfo Info = new EmailTemplateInfo();
string sql = "Select email_templateid as id,subject,body,status,header,footer,version,parentid from email_template where email_templateid = ?emailtemplateid";
MySqlDataReader dr = DAO.ExecuteReader(sql, new MySqlParameter("emailtemplateid", emailtemplateid));
while (dr.Read())
{
Info.email_templateid = Convert.ToInt32(dr["id"]);
Info.Subject = dr["subject"].ToString();
Info.Body = dr["body"].ToString();
Info.Status = Convert.ToInt32(dr["status"]);
Info.Header = dr["header"].ToString();
Info.Footer = dr["footer"].ToString();
Info.Version = Convert.ToInt32(dr["version"].ToString());
Info.ParentId = Convert.ToInt32(dr["parentid"].ToString());
}
dr.Close();
dr.Dispose();
return Info;
}
