public ResponseProviderWithCDCList GetCDCsForProvider(string providerID)
{
ResponseProviderWithCDCList theResponse = new ResponseProviderWithCDCList();
string providerName = getProviderNameFromID(Int32.Parse(providerID));
if (providerName == null)
{
theResponse.statusCode = 2;
theResponse.statusDescription = "There is no provider with ID " + providerID;
return theResponse;
}
openDataConnection();
SqlCommand getCDCs = new SqlCommand("GetCDCsForProvider", theConnection);
getCDCs.Parameters.AddWithValue("@providerID", providerID);
getCDCs.CommandType = System.Data.CommandType.StoredProcedure;
theReader = getCDCs.ExecuteReader();
if (theReader.HasRows)
{
theResponse.providers = new List<ProviderWithCDC>();
ProviderWithCDC thisProvider = new ProviderWithCDC();
thisProvider.providerName = providerName;
thisProvider.providerID = Int32.Parse(providerID);
thisProvider.cdcs = new List<CDC>();
theResponse.providers.Add(thisProvider);
while (theReader.Read())
{
CDC thisCDC = new CDC();
thisCDC.id = (int)theReader["CDCID"];
thisCDC.name = theReader["CDCName"].ToString();
thisCDC.address = theReader["CDCAddress"].ToString();
thisCDC.state = theReader["CDCState"].ToString();
thisCDC.zip = theReader["CDCZip"].ToString();
thisCDC.phone = theReader["CDCPhone"].ToString();
thisCDC.email = theReader["CDCEmailAddress"].ToString();
thisCDC.providerID = thisProvider.providerID;
thisProvider.cdcs.Add(thisCDC);
}
theResponse.statusCode = 0;
theResponse.statusDescription = "";
}
else
{
theResponse.statusCode = 2;
theResponse.statusDescription = "There are no Providers in the database";
}
theReader.Close();
closeDataConnection();
return theResponse;
}
public CDC GetCDCForStop(int stopID)
{
CDC thisCDC = null;
openDataConnection();
SqlCommand getCDC = new SqlCommand("GetCDCForStop", theConnection);
getCDC.Parameters.AddWithValue("@stopID", stopID);
getCDC.CommandType = System.Data.CommandType.StoredProcedure;
try
{
theReader = getCDC.ExecuteReader();
if (theReader.HasRows)
{
while (theReader.Read())
{
thisCDC = new CDC();
thisCDC.name = theReader["CDCName"].ToString();
}
}
}
catch (Exception _exception)
{
}
closeDataConnection();
return thisCDC;
}
public ResponseCDCList GetAllCDCsForProvider(string providerID)
{
ResponseCDCList theResponse = new ResponseCDCList();
openDataConnection();
SqlCommand cmdRead = new SqlCommand("GetAllCDCs", theConnection);
cmdRead.CommandType = System.Data.CommandType.StoredProcedure;
theReader = cmdRead.ExecuteReader();
if (theReader.HasRows)
{
List<CDC> allCDCs = new List<CDC>();
int wantedProviderID = Int32.Parse(providerID);
while (theReader.Read())
{
int thisProviderID = (int)theReader["ProviderID"];
if (thisProviderID > 0 && thisProviderID == wantedProviderID)
{
CDC thisCDC = new CDC();
thisCDC.id = (int)theReader["CDCID"];
thisCDC.name = theReader["CDCName"].ToString();
thisCDC.address = theReader["CDCAddress"].ToString();
thisCDC.state = theReader["CDCState"].ToString();
thisCDC.zip = theReader["CDCZip"].ToString();
thisCDC.phone = theReader["CDCPhone"].ToString();
thisCDC.email = theReader["CDCEmailAddress"].ToString();
thisCDC.providerID = (int)theReader["ProviderID"];
allCDCs.Add(thisCDC);
}
}
theResponse.cdcs = allCDCs;
theResponse.statusCode = 0;
theResponse.statusDescription = "";
}
else
{
theResponse.statusCode = 4;
theResponse.statusDescription = "No CDCs have been defined";
}
theReader.Close();
closeDataConnection();
return theResponse;
}
public ResponseProviderWithCDCList GetAllProvidersWithCDCs()
{
ResponseProviderWithCDCList theResponse = new ResponseProviderWithCDCList();
openDataConnection();
SqlCommand getAll = new SqlCommand("GetAllProvidersWithCDCs", theConnection);
getAll.CommandType = System.Data.CommandType.StoredProcedure;
theReader = getAll.ExecuteReader();
if (theReader.HasRows)
{
int currentProviderID = 0;
ProviderWithCDC thisProvider = null;
theResponse.providers = new List<ProviderWithCDC>();
while (theReader.Read())
{
int thisProviderID = (int)theReader["ProviderID"];
if (currentProviderID != thisProviderID)
{
thisProvider = new ProviderWithCDC();
thisProvider.providerID = (int)theReader["ProviderID"];
thisProvider.providerName = theReader["ProviderName"].ToString();
theResponse.providers.Add(thisProvider);
thisProvider.cdcs = new List<CDC>();
currentProviderID = thisProviderID;
}
CDC thisCDC = new CDC();
thisCDC.id = (int)theReader["CDCID"];
thisCDC.name = theReader["CDCName"].ToString();
thisCDC.address = theReader["CDCAddress"].ToString();
thisCDC.state = theReader["CDCState"].ToString();
thisCDC.zip = theReader["CDCZip"].ToString();
thisCDC.phone = theReader["CDCPhone"].ToString();
thisCDC.email = theReader["CDCEmailAddress"].ToString();
thisCDC.providerID = thisProvider.providerID;
thisProvider.cdcs.Add(thisCDC);
}
theResponse.statusCode = 0;
theResponse.statusDescription = "";
}
else
{
theResponse.statusCode = 2;
theResponse.statusDescription = "There are no Providers in the database";
}
theReader.Close();
closeDataConnection();
return theResponse;
}
public Response CreateCDC(CDC aCDCModel)
{
Response theResponse = new Response();
if (aCDCModel != null)
{
if (aCDCModel.name == null || aCDCModel.name.Equals(""))
{
theResponse.statusDescription = "CDC Name was not provided";
}
if (aCDCModel.providerID == 0)
{
theResponse.statusDescription = "CDC Provider ID was not provided";
}
if (theResponse.statusDescription.Equals(""))
{
if (cdcExists(aCDCModel.name))
{
theResponse.statusCode = 3;
theResponse.statusDescription = "A CDC by the name of " + aCDCModel.name + " already exists";
return theResponse;
}
openDataConnection();
SqlCommand cmdCreate = null;
if (aCDCModel.address == null && aCDCModel.state == null && aCDCModel.zip == null && aCDCModel.phone == null && aCDCModel.email == null)
{
cmdCreate = new SqlCommand("CreateCDC", theConnection);
}
else
{
cmdCreate = new SqlCommand("CreateCDCWithDetail", theConnection);
cmdCreate.Parameters.AddWithValue("@cdcAddress", aCDCModel.address);
cmdCreate.Parameters.AddWithValue("@cdcState", aCDCModel.state);
cmdCreate.Parameters.AddWithValue("@cdcZip", aCDCModel.zip);
cmdCreate.Parameters.AddWithValue("@cdcPhone", aCDCModel.phone);
cmdCreate.Parameters.AddWithValue("@cdcEmailAddress", aCDCModel.email);
}
cmdCreate.Parameters.AddWithValue("@cdcName", aCDCModel.name);
cmdCreate.Parameters.AddWithValue("@providerID", aCDCModel.providerID);
cmdCreate.CommandType = System.Data.CommandType.StoredProcedure;
try
{
int numRowsAffected = cmdCreate.ExecuteNonQuery();
if (numRowsAffected > 0)
{
theResponse.statusCode = 0;
theResponse.statusDescription = "";
}
else
{
theResponse.statusCode = 6;
theResponse.statusDescription = "Specified CDC could not be added";
}
}
catch (Exception _exception)
{
theResponse.statusCode = 6;
theResponse.statusDescription = _exception.Message;
}
closeDataConnection();
}
else
{
theResponse.statusCode = 6;
}
}
else
{
theResponse.statusCode = 6;
theResponse.statusDescription = "Expected CDC Model not recieved";
}
return theResponse;
}
