public static DataSet GetAllProjects(int clientID, int accountManager, int deliveryManager, int lead,
char serviceLine, char commTerms, char reviewFrequency)
{
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@clientID", SqlDbType.Int));
paramList[0].Value = clientID;
paramList.Add(new SqlParameter("@accountManager", SqlDbType.Int));
paramList[1].Value = accountManager;
paramList.Add(new SqlParameter("@deliveryManager", SqlDbType.Int));
paramList[2].Value = deliveryManager;
paramList.Add(new SqlParameter("@lead", SqlDbType.Int));
paramList[3].Value = lead;
paramList.Add(new SqlParameter("@serviceLine", SqlDbType.VarChar, 1));
paramList[4].Value = serviceLine;
paramList.Add(new SqlParameter("@commTerms", SqlDbType.VarChar, 1));
paramList[5].Value = commTerms;
paramList.Add(new SqlParameter("@reviewFrequency", SqlDbType.VarChar, 1));
paramList[6].Value = reviewFrequency;
return(DataBaseGenerics.GetData("Execute SelectAllProjects @clientID, @accountManager, @deliveryManager, @lead, @serviceLine, @commTerms, @reviewFrequency", paramList, CommandType.Text, QueryType.Select_Statement));
}
public static DataSet GetAllClients()
{
return(DataBaseGenerics.GetData("Execute SelectAllClients", CommandType.Text));
}
