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