public static List<Struct_MailTemplates> Fetch_Record(string templatekey)
{
SqlConnection con = new SqlConnection(Config.ConnectionString);
con.Open();
System.Collections.Generic.List<Struct_MailTemplates> items = new System.Collections.Generic.List<Struct_MailTemplates>();
Struct_MailTemplates str_ct = default(Struct_MailTemplates);
SqlCommand cmd = new SqlCommand("SELECT subject,contents from mailtemplates where templatekey=@templatekey", con);
cmd.Parameters.Add(new SqlParameter("@templatekey", templatekey));
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
str_ct = new Struct_MailTemplates();
str_ct.Subject = reader["subject"].ToString();
str_ct.Contents = reader["contents"].ToString();
items.Add(str_ct);
}
reader.Close();
con.Close();
return items;
}
public static List <Struct_MailTemplates> Fetch_Record(string templatekey)
{
SqlConnection con = new SqlConnection(Config.ConnectionString);
con.Open();
System.Collections.Generic.List <Struct_MailTemplates> items = new System.Collections.Generic.List <Struct_MailTemplates>();
Struct_MailTemplates str_ct = default(Struct_MailTemplates);
SqlCommand cmd = new SqlCommand("SELECT subject,contents from mailtemplates where templatekey=@templatekey", con);
cmd.Parameters.Add(new SqlParameter("@templatekey", templatekey));
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
str_ct = new Struct_MailTemplates();
str_ct.Subject = reader["subject"].ToString();
str_ct.Contents = reader["contents"].ToString();
items.Add(str_ct);
}
reader.Close();
con.Close();
return(items);
}
