public static FacilityDS.FacilityDSDataTable GetFacilityByUser(Int32 userId)
{
FacilityDSTableAdapter ta = new FacilityDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.GetFacilityByUser(userId));
}
public static Int32 DeleteFacility(Int32 facilityId)
{
FacilityDSTableAdapter ta = new FacilityDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.Delete(facilityId));
}
public static FacilityDS.FacilityDSDataTable GetFacilityByGuid(Guid facilityGuid)
{
FacilityDSTableAdapter ta = new FacilityDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.GetFacilityByGuid(facilityGuid));
}
public static FacilityDS.FacilityDSDataTable SelectFacility(Int32 facilityId)
{
FacilityDSTableAdapter ta = new FacilityDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.GetData(facilityId));
}
public static FacilityDS.FacilityDSDataTable GetFacilitiesByAgent(Int32 stamp_max_ms, Int32 agent_id)
{
FacilityDSTableAdapter ta = new FacilityDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.GetFacilitiesByAgent(stamp_max_ms, agent_id));
}
public static FacilityDS.FacilityDSDataTable GetAllFacilities(Int32 stamp_max_ms)
{
FacilityDSTableAdapter ta = new FacilityDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.GetAllFacilities(stamp_max_ms));
}
public static int SetCommand(int facility_id, int agent_id, string command)
{
FacilityDSTableAdapter ta = new FacilityDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.SetCommand
(Helper.ResolveEmptyInt(facility_id)
, Helper.ResolveEmptyInt(agent_id)
, command
));
}
public static Int32 UpdateFacility(Int32 facilityId, bool active, Int32 userId, Int32 surveyId, string name, string address, string phone, string ipAddress, string webReferrer)
{
FacilityDSTableAdapter ta = new FacilityDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
System.Nullable <Int32> user_id = Helper.ResolveEmptyInt(userId);
System.Nullable <Int32> survey_id = Helper.ResolveEmptyInt(surveyId);
return(ta.Update(facilityId, active, user_id, survey_id, name, address, phone, ipAddress, webReferrer));
}
public static int SetStatus(int facility_id, string status, int stamp_max_ms, ref string command, ref int agent_id)
{
FacilityDSTableAdapter ta = new FacilityDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
int?agent_id_ = 0;
int ret = ta.SetStatus
(Helper.ResolveEmptyInt(facility_id)
, status
, Helper.ResolveEmptyInt(stamp_max_ms)
, ref command
, ref agent_id_
);
agent_id = agent_id_.HasValue ? agent_id_.Value : 0;
return(ret);
}