public static List <EstateProject> GetEstateProjects()
{
List <EstateProject> projects = new List <EstateProject>();
con.Open();
string query = "SELECT * FROM [dbo].[ProjectsTable]";
SqlCommand cmd = new SqlCommand(query, con);
cmd.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
List <string> users = new List <string>();
List <string> apartments = new List <string>();
while (reader.Read())
{
string id = reader[0].ToString();
string desc = reader[1].ToString();
int noWork;
if (reader[2] == DBNull.Value)
{
noWork = 0;
}
else
{
noWork = Convert.ToInt32(reader[2]);
}
apartments.Add(reader[3].ToString());
users.Add(reader[4].ToString());
EstateProject project = new EstateProject(id, desc, noWork);
projects.Add(project);
}
con.Close();
int count = 0;
foreach (EstateProject p in projects)
{
string [] usersstr = users[count].Split(',');
foreach (string user in usersstr)
{
if (user != "NULL")
{
p.AssignManager(user);
}
}
string[] appStr = apartments[count].Split(',');
foreach (string ap in appStr)
{
if (ap != "NULL")
{
p.AssignApartment(ap);
}
}
}
return(projects);
}
public static List <EstateProject> FindProjects(string uname)
{
List <EstateProject> projects = new List <EstateProject>();
con.Open();
string query = "SELECT * FROM [dbo].[ProjectsTable] WHERE Users LIKE '%,'+@username+',%'";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@username", uname);
cmd.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string id = reader[0].ToString();
string desc = reader[1].ToString();
int noWork = Convert.ToInt32(reader[2]);
string[] apartments = reader[3].ToString().Split(',');
string[] Users = reader[4].ToString().Split(',');
List <Apartment> apartments1 = new List <Apartment>();
List <User> users = new List <User>();
foreach (string user in Users)
{
users.Add(FindUser(user));
}
foreach (string apartment in apartments)
{
apartments1.Add(FindApartment(apartment));
}
con.Open();
EstateProject project = new EstateProject(id, desc, noWork, apartments1, users);
projects.Add(project);
}
con.Close();
return(projects);
}
public ProjectDetails(EstateProject p)
{
InitializeComponent();
project = p;
}
public ModifyProject(EstateProject p)
{
InitializeComponent();
this.project = p;
}
