public Project[] getProjects(int builder_id) { MySqlCommand selectBuilderProjects = new MySqlCommand("SELECT id, project_name, first_crossroad, second_crossroad, cardinal, location_notes, " + "aquisition_price, improvement_cost, date_created, last_modified, last_requested_timestamp, " + "approval_timestamp, decline_timestamp, total_lot_count" + "FROM Projects " + "WHERE builder_id = @builderId;", databaseConnection); selectBuilderProjects.Parameters.Add("@builderId", MySqlDbType.Int32).Value = builder_id; List<Project> projectList = new List<Project>(); Project[] projects = new Project[0]; int projectCount = 0; databaseConnection.Open(); MySqlDataReader reader; try { reader = selectBuilderProjects.ExecuteReader(CommandBehavior.SequentialAccess); while (reader.Read()) { int i = reader.GetInt32(0); String pn = reader.GetString(1); String fcs = reader.GetString(2); String scs = reader.GetString(3); String city = reader.GetString(4); String state = reader.GetString(5); String c = reader.GetString(6); String ln = reader.GetString(7); Decimal aq = reader.GetDecimal(8); Decimal ic = reader.GetDecimal(9); DateTime dc = reader.GetDateTime(10); DateTime lu = reader.GetDateTime(11); DateTime lr = reader.GetDateTime(12); DateTime a = reader.GetDateTime(13); DateTime d = reader.GetDateTime(14); int tlc = reader.GetInt32(15); projectCount++; Project newProject = new Project(i, builder_id, pn, fcs, scs, city, state, c, ln, aq, ic, dc, lu, lr, a, d, tlc); projectList.Add(newProject); } projects = new Project[projectCount]; List<Project>.Enumerator projectEnum = projectList.GetEnumerator(); int j = 0; while (projectEnum.MoveNext()) { projects[j] = projectEnum.Current; j++; } } catch (Exception e) { Debug.Print(e.Message); return null; } reader.Close(); databaseConnection.Close(); return projects; }
public Project[] getProjects(int builder_id) { MySqlCommand selectBuilderProjects = new MySqlCommand("SELECT id, project_name, first_cross_street, second_cross_street, cardinal, location_notes, aquisition_price, improvement_cost, total_lot_count, last_modified" + "FROM Projects " + "WHERE buider_id = @builderId", databaseConnection); selectBuilderProjects.Parameters.Add("@builderId", MySqlDbType.Int32).Value = builder_id; List<Project> projectList = new List<Project>(); Project[] projects = new Project[0]; int projectCount = 0; databaseConnection.Open(); MySqlDataReader reader; try { reader = selectBuilderProjects.ExecuteReader(CommandBehavior.SequentialAccess); while (reader.Read()) { int i = reader.GetInt32(0); String pn = reader.GetString(1); String fcs = reader.GetString(2); String scs = reader.GetString(3); String c = reader.GetString(4); String ln = reader.GetString(5); Decimal aq = reader.GetDecimal(6); Decimal ic = reader.GetDecimal(7); int tlc = reader.GetInt32(8); DateTime lm = reader.GetDateTime(9); projectCount++; Project newProject = new Project(i, builder_id, pn, fcs, scs, c, ln, aq, ic, tlc, lm); projectList.Add(newProject); } projects = new Project[projectCount]; List<Project>.Enumerator projectEnum = projectList.GetEnumerator(); for (int i = 0; i < projectCount; i++) { projects[i] = projectEnum.Current; projectEnum.MoveNext(); } } catch (Exception e) { return null; } reader.Close(); databaseConnection.Close(); return projects; }
public Project getProposal(int proposal_id) { MySqlCommand getProposal = new MySqlCommand("SELECT id, project_name, first_crossroad, second_crossroad, city, state, cardinal, location_notes, " + "aquisition_price, improvement_cost, date_created, last_modified, last_requested_timestamp, " + "approval_timestamp, decline_timestamp, total_lot_count, builder_id " + "FROM Projects " + "WHERE id = @ProposalId;", databaseConnection); getProposal.Parameters.Add("@ProposalId", MySqlDbType.Int32).Value = proposal_id; MySqlDataReader reader; databaseConnection.Open(); try { reader = getProposal.ExecuteReader(CommandBehavior.SequentialAccess); if (reader.Read()) { int i = reader.GetInt32(0); String pn = reader.GetString(1); String fcs = reader.GetString(2); String scs = reader.GetString(3); String city = reader.GetString(4); String state = reader.GetString(5); String c = reader.GetString(6); String ln = reader.GetString(7); Decimal aq = reader.GetDecimal(8); Decimal ic = reader.GetDecimal(9); DateTime dc = reader.GetDateTime(10); DateTime lu = reader.GetDateTime(11); DateTime lr = reader.GetDateTime(12); DateTime a = reader.GetDateTime(13); DateTime d = reader.GetDateTime(14); int tlc = reader.GetInt32(15); int builder_id = reader.GetInt32(16); Project newProject = new Project(i, builder_id, pn, fcs, scs, city, state, c, ln, aq, ic, dc, lu, lr, a, d, tlc); return newProject; } } catch (MySqlException e) { Debug.Print(e.Message); return null; } finally { databaseConnection.Close(); } return null; }