public Project()
{
this.intID = 0;
this.intNumber = 0;
this.intCategory = 0;
this.strName = "";
this.strTip = "";
this.spSubprojects = new Subproject();
}
public static DataSet GetSubprojects(Connection cnConnection, Subproject spSearch)
{
// A table mapping names the DataTable.
DataSet dsSubprojects = new DataSet();
String strCommand = @"SELECT * FROM tabSubprojects";
if ((spSearch.intCategory != 0) || (spSearch.intProjectNumber != 0) ||
(spSearch.strName.Length != 0) || (spSearch.dtStart.Year != 1) || (spSearch.intDuration != 0) ||
(spSearch.intProgress != 0) || (spSearch.strTip.Length != 0))
{
strCommand += @" WHERE ";
}
if (spSearch.intCategory != 0)
{
strCommand += @"intcCategory = '" + spSearch.intCategory + "' ";
}
if (spSearch.intProjectNumber != 0)
{
if (spSearch.intCategory != 0)
{
strCommand += @"AND intProjectNumber = '" + spSearch.intProjectNumber.ToString() + "' ";
}
else
{
strCommand += @"intProjectNumber = '" + spSearch.intProjectNumber.ToString() + "' ";
}
}
if (spSearch.strName.Length != 0)
{
if (spSearch.intCategory != 0 || spSearch.intProjectNumber != 0)
{
strCommand += @"AND nvcName LIKE N'%" + spSearch.strName + "%' ";
}
else
{
strCommand += @"nvcName LIKE N'%" + spSearch.strName + "%' ";
}
}
if (spSearch.dtStart.Year != 1)
{
if (spSearch.intCategory != 0 || spSearch.intProjectNumber != 0 || spSearch.strName.Length != 0)
{
strCommand += @" AND datStart = '" + spSearch.dtStart.Year.ToString() + "-" + spSearch.dtStart.Month.ToString() + "-" + spSearch.dtStart.Day.ToString() + "' ";
}
else
{
strCommand += @"datStart = '" + spSearch.dtStart.Year.ToString() + "-" + spSearch.dtStart.Month.ToString() + "-" + spSearch.dtStart.Day.ToString() + "' ";
}
}
if (spSearch.intDuration != 0)
{
if (spSearch.intCategory != 0 || spSearch.intProjectNumber != 0 || spSearch.strName.Length != 0 || spSearch.dtStart.Year != 1)
{
strCommand += @" AND intDuration = '" + spSearch.intDuration.ToString() + "' ";
}
else
{
strCommand += @"intDuration = '" + spSearch.intDuration.ToString() + "' ";
}
}
if (spSearch.intProgress != 0)
{
if (spSearch.intCategory != 0 || spSearch.intProjectNumber != 0 || spSearch.strName.Length != 0 ||
spSearch.dtStart.Year != 1)
{
strCommand += @" AND intProgress = '" + spSearch.intProgress + "' ";
}
else
{
strCommand += @"intProgress = '" + spSearch.intProgress + "' ";
}
}
if (spSearch.strTip.Length != 0)
{
if (spSearch.intCategory != 0 || spSearch.intProjectNumber != 0 || spSearch.strName.Length != 0 ||
spSearch.dtStart.Year != 1 || spSearch.intProgress != 0)
{
strCommand += @" AND nvcTip = '" + spSearch.strTip + "' ";
}
else
{
strCommand += @"nvcTip = '" + spSearch.strTip + "' ";
}
}
strCommand += " ORDER BY datStart";
//Create a SqlDataAdapter for the Suppliers table.
SqlDataAdapter daSubprojects = new SqlDataAdapter();
SqlConnection cnSqlConnection = new SqlConnection(cnConnection.strConnectionStringPty);
cnSqlConnection.Open();
daSubprojects.SelectCommand = new SqlCommand(strCommand, cnSqlConnection);
daSubprojects.Fill(dsSubprojects, "tabSubprojects");
cnSqlConnection.Close();
return(dsSubprojects);
}