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;
}
