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