private async Task AddOrUpdateDarkSkyWeather(TodayType type, long time, double latitude, double longitude, string timezone, string summary,
                                                     string icon, double temperature, double apparentTemperature, string username)
        {
            var darkSkyWeather = await _context.DarkSkyWeathers.FirstOrDefaultAsync(m => m.Type == type &&
                                                                                    m.time == time &&
                                                                                    m.latitude == latitude &&
                                                                                    m.longitude == longitude);

            if (darkSkyWeather == null)
            {
                darkSkyWeather = new DarkSkyWeather()
                {
                    latitude            = latitude,
                    longitude           = longitude,
                    timezone            = timezone,
                    time                = time,
                    summary             = summary,
                    icon                = icon,
                    temperature         = temperature,
                    apparentTemperature = apparentTemperature,

                    DateCreated  = DateTime.Now,
                    DateModified = DateTime.Now,
                    UserCreated  = username,
                    UserModified = username,

                    Type = type
                };

                await _context.AddAsync(darkSkyWeather);

                await _context.SaveChangesAsync();

                _logger.LogInformation($"GetDarkSkyWeatherApi {type} add new DarkSkyWeather {darkSkyWeather.Id}");
            }
            else
            {
                darkSkyWeather.summary             = summary;
                darkSkyWeather.icon                = icon;
                darkSkyWeather.temperature         = temperature;
                darkSkyWeather.apparentTemperature = apparentTemperature;

                darkSkyWeather.DateModified = DateTime.Now;
                darkSkyWeather.UserModified = username;

                await _context.SaveChangesAsync();

                _logger.LogInformation($"GetDarkSkyWeatherApi {type} update DarkSkyWeather {darkSkyWeather.Id}");
            }
        }
Exemplo n.º 2
0
 public static int ContactRecoveryAll(string userIds, string levelIds, int statusMapId, int statusCareId, int day, int branchId, TodayType todayType, EmployeeType employeeType, int userId, DateTime recoveryDate, int createdBy)
 {
     return DataProvider.Instance().Contacts_Recovery_All(userIds, levelIds, statusMapId, statusCareId, day, branchId, todayType, employeeType, userId, recoveryDate, createdBy);
 }
Exemplo n.º 3
0
 // Recovery
 public static List<ContactInfo> FilterRecovery(string userIds, string levelIds, int statusMapId, int statusCareId, int day, int branchId, TodayType todayType, EmployeeType employeeType, int pageIndex, int pageSize, out int totalRecord)
 {
     return FillContactCollection(DataProvider.Instance().Contacts_Filter_Recovery(userIds, levelIds, statusMapId, statusCareId, day, branchId, todayType, employeeType, pageIndex, pageSize), out totalRecord);
 }
Exemplo n.º 4
0
 public abstract IDataReader Contacts_Filter_Recovery(string userIds, string levelIds, int statusMapId, int statusCareId, int day, int branchId, TodayType todayType, EmployeeType employeeType, int pageIndex, int pageSize);
Exemplo n.º 5
0
 // Recovery
 public abstract int Contacts_Recovery_All(string userIds, string levelIds, int statusMapId, int statusCareId, int day, int branchId, TodayType todayType, EmployeeType employeeType, int userId, DateTime recoveryDate, int createdBy);
Exemplo n.º 6
0
 public static int ContactRecoveryAll(string userIds, string levelIds, int statusMapId, int statusCareId, int day, int branchId, int sourceType, TodayType todayType, EmployeeType employeeType, int userId, DateTime recoveryDate, int createdBy, DateTime?callToDate, DateTime?callFromDate, DateTime?handoverToDate, DateTime?handoverFromDate)
 {
     return(DataProvider.Instance().Contacts_Recovery_All(userIds, levelIds, statusMapId, statusCareId, day, branchId, sourceType, todayType, employeeType, userId, recoveryDate, createdBy, callToDate, callFromDate, handoverToDate, handoverFromDate));
 }
Exemplo n.º 7
0
 // Recovery
 public static List <ContactInfo> FilterRecovery(string userIds, string levelIds, int statusMapId, int statusCareId, int branchId, TodayType todayType, DateTime?handoverFromDate, DateTime?handoverToDate, DateTime?callFromDate, DateTime?callToDate, int sourceType, EmployeeType employeeType, int pageIndex, int pageSize, out int totalRecord)
 {
     return(FillContactCollection(DataProvider.Instance().Contacts_Filter_Recovery(userIds, levelIds, statusMapId, statusCareId, branchId, todayType, handoverFromDate, handoverToDate, callFromDate, callToDate, sourceType, employeeType, pageIndex, pageSize), out totalRecord));
 }
Exemplo n.º 8
0
 public DarkSkyWeatherSpecification(long timeMin, long timeMax, TodayType type)
     : base(m => m.time >= timeMin && m.time <= timeMax && m.Type == type)
 {
 }
Exemplo n.º 9
0
 // Recovery
 public abstract int Contacts_Recovery_All(string userIds, string levelIds, int statusMapId, int statusCareId, int day, int branchId, int sourceType, TodayType todayType, EmployeeType employeeType, int userId, DateTime recoveryDate, int createdBy, DateTime?callToDate, DateTime?callFromDate, DateTime?handoverToDate, DateTime?handoverFromDate);
Exemplo n.º 10
0
 public abstract IDataReader Contacts_Filter_Recovery(string userIds, string levelIds, int statusMapId, int statusCareId, int branchId, TodayType todayType, DateTime?handoverFromDate, DateTime?handoverToDate, DateTime?callFromDate, DateTime?callToDate, int sourceType, EmployeeType employeeType, int pageIndex, int pageSize);
Exemplo n.º 11
0
 // Recovery
 public override int Contacts_Recovery_All(string userIds, string levelIds, int statusMapId, int statusCareId, int day, int branchId, TodayType todayType, EmployeeType employeeType, int userId, DateTime recoveryDate, int createdBy)
 {
     switch (employeeType)
     {
         case EmployeeType.Collaborator:
             return (int)SqlHelper.ExecuteScalar(ConnectionString,
                         GetFullyQualifiedName("Contacts_Update_Recovery_All_Collaborator"),
                         (int) StatusType.HandoverCollaborator, userIds, levelIds, statusMapId, statusCareId, day,
                         branchId, (int) todayType, userId, (int) StatusType.RecoveryCollaborator, recoveryDate,
                         createdBy);
         case EmployeeType.Consultant:
             return (int)SqlHelper.ExecuteScalar(ConnectionString,
                         GetFullyQualifiedName("Contacts_Update_Recovery_All_Consultant"),
                         (int) StatusType.HandoverConsultant, userIds, levelIds, statusMapId, statusCareId, day,
                         branchId, (int) todayType, userId, (int) StatusType.RecoveryConsultant, recoveryDate,
                         createdBy);
     }
     return 0;
 }
Exemplo n.º 12
0
 public override IDataReader Contacts_Filter_Recovery(string userIds, string levelIds, int statusMapId, int statusCareId, int day, int branchId, TodayType todayType, EmployeeType employeeType, int pageIndex, int pageSize)
 {
     switch (employeeType)
     {
         case EmployeeType.Collaborator:
             return SqlHelper.ExecuteReader(ConnectionString, GetFullyQualifiedName("Contacts_Filter_Recovery_Collaborator"), (int)StatusType.HandoverCollaborator, userIds, levelIds, statusMapId, statusCareId, day, branchId, (int)todayType, pageIndex, pageSize);
         case EmployeeType.Consultant:
             return SqlHelper.ExecuteReader(ConnectionString, GetFullyQualifiedName("Contacts_Filter_Recovery_Consultant"), (int)StatusType.HandoverConsultant, userIds, levelIds, statusMapId, statusCareId, day, branchId, (int)todayType, pageIndex, pageSize);
     }
     return null;
 }