private static EAD_Project.Models.contact_us FillDTO(SqlDataReader reader) { var dto = new EAD_Project.Models.contact_us(); dto.name = reader.GetString(0); dto.email = reader.GetString(1); dto.subject = reader.GetString(2); dto.message = reader.GetString(3); return(dto); }
public static int Save(EAD_Project.Models.contact_us dto) { String sqlQuery = ""; sqlQuery = String.Format("INSERT INTO dbo.contact_us(name,email,subject,message) VALUES('{0}','{1}','{2}','{3}')", dto.name, dto.email, dto.subject, dto.message); using (DBHelper helper = new DBHelper()) { return(helper.ExecuteQuery(sqlQuery)); } }
public static EAD_Project.Models.contact_us GetUserById(string pid) { var query = String.Format("Select * from dbo.contact_us Where email='{0}'", pid); using (DBHelper helper = new DBHelper()) { var reader = helper.ExecuteReader(query); EAD_Project.Models.contact_us dto = null; if (reader.Read()) { dto = FillDTO(reader); } return(dto); } }