//If this table type will exist as cached data, uncomment the CachePattern region below and edit.
/*
#region CachePattern
//This region can be eliminated if this is not a table type with cached data.
//If leaving this region in place, be sure to add RefreshCache and FillCache
//to the Cache.cs file with all the other Cache types.
///<summary>A list of all MedLabFacilities.</summary>
private static List<MedLabFacility> listt;
///<summary>A list of all MedLabFacilities.</summary>
public static List<MedLabFacility> Listt{
get {
if(listt==null) {
RefreshCache();
}
return listt;
}
set {
listt=value;
}
}
///<summary></summary>
public static DataTable RefreshCache(){
//No need to check RemotingRole; Calls GetTableRemotelyIfNeeded().
string command="SELECT * FROM medlabfacility ORDER BY ItemOrder";//stub query probably needs to be changed
DataTable table=Cache.GetTableRemotelyIfNeeded(MethodBase.GetCurrentMethod(),command);
table.TableName="MedLabFacility";
FillCache(table);
return table;
}
///<summary></summary>
public static void FillCache(DataTable table){
//No need to check RemotingRole; no call to db.
listt=Crud.MedLabFacilityCrud.TableToList(table);
}
#endregion
*/
///<summary>Checks the database for a MedLabFacility with matching name, address, city, state, zip, phone, and director title/name.
///If the facility doesn't exist, it's inserted. Returns the MedLabFacilityNum for the facility inserted or found.
///Doesn't need any indexes, this runs in under a second with 100k worst case scenario rows (identical data).</summary>
public static long InsertIfNotInDb(MedLabFacility medLabFacility) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
return Meth.GetLong(MethodBase.GetCurrentMethod(),medLabFacility);
}
string command="SELECT * FROM medlabfacility "
+"WHERE FacilityName='"+POut.String(medLabFacility.FacilityName)+"' "
+"AND Address='"+POut.String(medLabFacility.Address)+"' "
+"AND City='"+POut.String(medLabFacility.City)+"' "
+"AND State='"+POut.String(medLabFacility.State)+"' "
+"AND Zip='"+POut.String(medLabFacility.Zip)+"' "
+"AND Phone='"+POut.String(medLabFacility.Phone)+"' "
+"AND DirectorTitle='"+POut.String(medLabFacility.DirectorTitle)+"' "
+"AND DirectorLName='"+POut.String(medLabFacility.DirectorLName)+"' "
+"AND DirectorFName='"+POut.String(medLabFacility.DirectorFName)+"'";
MedLabFacility medLabFacilityDb=Crud.MedLabFacilityCrud.SelectOne(command);
if(medLabFacilityDb==null) {
return Crud.MedLabFacilityCrud.Insert(medLabFacility);
}
return medLabFacilityDb.MedLabFacilityNum;
}
///<summary>Checks the database for a MedLabFacility with matching name, address, city, state, zip, phone, and director title/name.
///If the facility doesn't exist, it's inserted. Returns the MedLabFacilityNum for the facility inserted or found.
///Doesn't need any indexes, this runs in under a second with 100k worst case scenario rows (identical data).</summary>
public static long InsertIfNotInDb(MedLabFacility medLabFacility)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
return(Meth.GetLong(MethodBase.GetCurrentMethod(), medLabFacility));
}
string command = "SELECT * FROM medlabfacility "
+ "WHERE FacilityName='" + POut.String(medLabFacility.FacilityName) + "' "
+ "AND Address='" + POut.String(medLabFacility.Address) + "' "
+ "AND City='" + POut.String(medLabFacility.City) + "' "
+ "AND State='" + POut.String(medLabFacility.State) + "' "
+ "AND Zip='" + POut.String(medLabFacility.Zip) + "' "
+ "AND Phone='" + POut.String(medLabFacility.Phone) + "' "
+ "AND DirectorTitle='" + POut.String(medLabFacility.DirectorTitle) + "' "
+ "AND DirectorLName='" + POut.String(medLabFacility.DirectorLName) + "' "
+ "AND DirectorFName='" + POut.String(medLabFacility.DirectorFName) + "'";
MedLabFacility medLabFacilityDb = Crud.MedLabFacilityCrud.SelectOne(command);
if (medLabFacilityDb == null)
{
return(Crud.MedLabFacilityCrud.Insert(medLabFacility));
}
return(medLabFacilityDb.MedLabFacilityNum);
}
