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