private void LogsContextSeeding()
{
LogsContext.Seeding.Add(new Logs.SeedModel {
IsSeed = true
});
LogsContext.SaveChanges();
}
/// <summary>
/// Saves a new tenant to the database.
/// </summary>
/// <param name="name">Tenants full name, "First Last"</param>
/// <returns>True if operation was successful and changes were saved.</returns>
public static bool AddTenant(string id, string name)
{
using (var context = new LogsContext())
{
context.Database.BeginTransaction();
try
{
context.Add(
new Tenant()
{
Id = id,
Name = name
});
context.SaveChanges();
context.Database.CommitTransaction();
}
catch (Exception)
{
context.Database.RollbackTransaction();
return(false);
}
}
return(true);
}
/// <summary>
/// Saves a log entry to the database.
/// </summary>
/// <param name="when">Date and time when this occured, using the format "YY-MM-DD HH:MM:SS"</param>
/// <param name="doorId">Door id involved.</param>
/// <param name="eventId">Event id, what happened</param>
/// <param name="tagId">Tag id used.</param>
/// <returns>True if operation was successful and changes were saved.</returns>
public static bool LogEntry(string when, string doorId, string eventId, string tagId)
{
using (var context = new LogsContext())
{
context.Database.BeginTransaction();
try
{
context.Add(
new LogEntry()
{
When = DateTime.ParseExact(when, "yy-MM-dd HH:mm:ss", null),
DoorId = doorId,
EventId = eventId,
TagId = tagId
}
);
context.SaveChanges();
context.Database.CommitTransaction();
}
catch (Exception)
{
context.Database.RollbackTransaction();
return(false);
}
}
return(true);
}
public static void Log(Logs log)
{
LogsContext db = new LogsContext();
db.Logs.Add(log);
db.SaveChanges();
db.Dispose();
}
public void UpdateSeedLogs()
{
LogsContext.ExecuteTransaction(() =>
{
LogsContext.Seeding.Add(new Logs.SeedModel {
IsSeed = true
});
LogsContext.SaveChanges();
});
}
public async Task <ActionResult> CheckingData(string y = "")
{
var providerData = db.Facilities.ToList();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseUrl);
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/x-www-form-urlencoded"));
Task <string> callTask = Task.Run(() => GetAccessToken());
// Wait for it to finish
callTask.Wait();
// Get the result
var ret = callTask.Result;
// Add the Authorization header with the AccessToken.
client.DefaultRequestHeaders.Add("Authorization", "Bearer " + ret);
//try
//{
foreach (var value in providerData)
{
// create the URL string.
string url = string.Format(client.BaseAddress + "/api/PCClaims/GetCheckInData");
var parameters = new Dictionary <string, string> {
{ "ProviderId", value.ProviderId.ToString() }, { "Key", value.Key.ToString() }, { "StartDate", startDate.ToString() }, { "EndDate", endDate.ToString() }
};
var encodedContent = new FormUrlEncodedContent(parameters);
// make the request
//System.Net.ServicePointManager.SecurityProtocol |= SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12;
var response = await client.PostAsync(url, encodedContent);
// parse the response and return the data.
if (response.IsSuccessStatusCode)
{
string jsonString = await response.Content.ReadAsStringAsync();
List <APIResponse> responseData = JsonConvert.DeserializeObject <List <APIResponse> >(jsonString);
foreach (var api in responseData)
{
Logs logs = new Logs();
logs.ProviderName = value.ProviderName;
logs.ProviderKey = api.providerId.ToString();
logs.Action = api.enrolleeNo;
logs.LastName = api.lastName;
logs.FirstName = api.firstName;
logs.OtherNames = api.othername;
logs.TrasactionDate = api.checkInDate;
//logs.BatchTime = DateTime.Today;
var objDetails = SqlMapper.QueryMultiple(con, "GetReg", new { EnrolleeNum = api.enrolleeNo, startDate = startDate, lastDate = endDate }, null, 100000, commandType: CommandType.StoredProcedure);
PatientDetails details = new PatientDetails();
var Data = objDetails.Read <PatientDetails>();
details.RegistrationNo = Data.Select(x => x.RegistrationNo).LastOrDefault();
details.PlanType = Data.Select(x => x.PlanType).LastOrDefault();
details.CheckInBy = Data.Select(x => x.CheckInBy).LastOrDefault();
if (!string.IsNullOrEmpty(details.RegistrationNo))
{
logs.PatientHospitalNo = details.RegistrationNo;
}
else
{
logs.PatientHospitalNo = "This enrollee number is incorrect,please edit the enrollee number";
}
if (!string.IsNullOrEmpty(details.PlanType))
{
logs.PlanType = details.PlanType;
}
else
{
logs.PlanType = "The enrollee number must be corrected to view this Data";
}
if (!string.IsNullOrEmpty(details.CheckInBy))
{
logs.CheckInBy = details.CheckInBy;
}
else
{
logs.CheckInBy = "The enrollee number must be corrected to view this Data";
}
con.Close();
//check Values
var checkexistence = data.CheckexistingValues(api.enrolleeNo, api.checkInDate).ToList();
if (checkexistence.Count < 1)
{
db.PatientChecks.Add(logs);
}
db.SaveChanges();
}
}
var result = await data.SendReportPerlocation(startDate, value.ProviderId.ToString(), value.ProviderEmail, value.ProviderName);
if (result == "Success")
{
TempData["MessageSent"] = "Message Sent Sucessfully";
}
else
{
TempData["MessageSent"] = result;
break;
}
}
//}
//catch (Exception ex)
//{
// TempData["error"] = "Invalid Value: This is not an Hospital Number" + ex.InnerException;
// return View();
//}
TempData["sucess"] = "Sucessfully Completed";
return(View());
}
}
public static void ExecureQuery(string filePath)
{
XmlDocument xmlDocument = new XmlDocument();
xmlDocument.Load(filePath);
string pathQuery = "/review-queries/query";
XmlNodeList xmlQuery = xmlDocument.SelectNodes(pathQuery);
string fileName = "../../search-results.xml";
using (var writer = new XmlTextWriter(fileName, Encoding.UTF8))
{
writer.Formatting = Formatting.Indented;
writer.IndentChar = '\t';
writer.Indentation = 1;
writer.WriteStartDocument();
writer.WriteStartElement("search-results");
writer.WriteStartElement("result-set");
BookstoreEntities context = new BookstoreEntities();
foreach (XmlNode query in xmlQuery)
{
if (query.Attributes["type"].Value == "by-period")
{
string startDateStr = query["start-date"].InnerText;
string endDateStr = query["end-date"].InnerText;
DateTime startDate = DateTime.ParseExact(startDateStr, "d-MMM-yyyy", CultureInfo.InvariantCulture);
DateTime endDate = DateTime.ParseExact(endDateStr, "d-MMM-yyyy", CultureInfo.InvariantCulture);
var searchQuery =
from r in context.Reviews
where r.CreationDate >= startDate && r.CreationDate <= endDate
select r;
searchQuery = searchQuery.OrderByDescending(x => x.CreationDate);
searchQuery = searchQuery.OrderByDescending(x => x.ReviewText);
WriteBookmarks(writer, searchQuery.ToList());
}
else
{
string authorName = query["author-name"].InnerText;
var searchQuery =
from r in context.Reviews
join a in context.Authors on r.AuthorId equals a.AuthorId
where a.Name == authorName
select r;
searchQuery = searchQuery.OrderByDescending(x => x.CreationDate);
searchQuery = searchQuery.OrderByDescending(x => x.ReviewText);
WriteBookmarks(writer, searchQuery.ToList());
}
//Create log
var logsContext = new LogsContext();
Log log = new Log
{
Date = DateTime.Now,
QueryXml = CreateQueryXml(query)
};
logsContext.Logs.Add(log);
logsContext.SaveChanges();
}
writer.WriteEndElement();
writer.WriteEndDocument();
}
}
/// <summary>
/// Moves a tenant from an apartment and updates the tenants tag.
/// </summary>
/// <param name="tenantOrTagId">Full name of tenant or tenants tag id. </param>
/// <param name="apartmentId">Id of apartment to move in to,
/// or an empty string to simply move out and not into another apartment.</param>
/// <returns>True if operation was successful and changes were saved.</returns>
public static bool MoveTenant(string tenantOrTagId, string apartmentId)
{
using (var context = new LogsContext())
{
try
{
var tenant = context.Tenants
.Where(t => t.Id == tenantOrTagId)
.FirstOrDefault();
var tag = context.Tags
.Include(t => t.Tenant)
.Where(t => t.Id == tenantOrTagId || t.Tenant.Id == tenantOrTagId)
.FirstOrDefault();
if (tenant == null && tag != null)
{
tenant = tag.Tenant;
}
else if (tenant == null && tag == null)
{
// Tenant not found by tenant id or tag id.
return(false);
}
context.Database.BeginTransaction();
try
{
if (apartmentId == "")
{
// Tenant moved out. Remove tenant and tag.
context.Tenants.Remove(tenant);
if (tag != null)
{
context.Tags.Remove(tag);
}
}
else
{
// Tenant moved to another apartment.
// Set tenants new apartment id.
tenant.ApartmentId = apartmentId;
if (tag != null)
{
// Remove old tag if there was one.
context.Tags.Remove(tag);
}
// Set tenants new tag.
context.Add(
new Tag()
{
Tenant = tenant,
TenantId = tenant.Id,
Id = TagHelper.GetNextApartmentTag(apartmentId),
}
);
}
context.SaveChanges();
context.Database.CommitTransaction();
}
catch (Exception)
{
context.Database.RollbackTransaction();
return(false);
}
}
catch (Exception)
{
return(false);
}
}
return(true);
}
/// <summary>
/// Sets up seed data in DBContext LogsContext.
/// </summary>
public static void Seed()
{
// Open database connection.
using (var context = new LogsContext())
{
// Start transaction.
context.Database.BeginTransaction();
try
{
#region Add Locations
var locations = new List <Location>
{
new Location()
{
Id = "UT"
},
new Location()
{
Id = "SOPRUM"
},
new Location()
{
Id = "TVÄTT"
},
new Location()
{
Id = "VAKT"
},
new Location()
{
Id = "0101"
},
new Location()
{
Id = "0102"
},
new Location()
{
Id = "0103"
},
new Location()
{
Id = "0201"
},
new Location()
{
Id = "0202"
},
new Location()
{
Id = "0301"
},
new Location()
{
Id = "0302"
},
};
context.AddRange(locations);
#endregion
#region Add Doors
// Add doors
var doors = new List <Door>
{
new Door()
{
Id = "UT01", LocationId = "UT", Description = "Dörr ut mot gatan."
},
new Door()
{
Id = "SOPRUM01", LocationId = "SOPRUM", Description = "Dörr mot soprummet."
},
new Door()
{
Id = "TVÄTT01", LocationId = "TVÄTT", Description = "Dörr mot tvättstugan."
},
new Door()
{
Id = "VAKT01", LocationId = "VAKT", Description = "Dörr mot vaktmästarens rum."
},
// doors for apartments 0101, 0102, 0103
new Door()
{
Id = "LGH0101", LocationId = "0101", Description = "Dörr till lägenhet."
},
new Door()
{
Id = "BLK0101", LocationId = "0101", Description = "Dörr till balkong/altan."
},
new Door()
{
Id = "LGH0102", LocationId = "0102", Description = "Dörr till lägenhet."
},
new Door()
{
Id = "BLK0102", LocationId = "0102", Description = "Dörr till balkong/altan."
},
new Door()
{
Id = "LGH0103", LocationId = "0103", Description = "Dörr till lägenhet."
},
new Door()
{
Id = "BLK0103", LocationId = "0103", Description = "Dörr till balkong/altan."
},
// ... 0201, 0202
new Door()
{
Id = "LGH0201", LocationId = "0201", Description = "Dörr till lägenhet."
},
new Door()
{
Id = "BLK0201", LocationId = "0201", Description = "Dörr till balkong/altan."
},
new Door()
{
Id = "LGH0202", LocationId = "0202", Description = "Dörr till lägenhet."
},
new Door()
{
Id = "BLK0202", LocationId = "0202", Description = "Dörr till balkong/altan."
},
// ... 0301, 0302
new Door()
{
Id = "LGH0301", LocationId = "0301", Description = "Dörr till lägenhet."
},
new Door()
{
Id = "BLK0301", LocationId = "0301", Description = "Dörr till balkong/altan."
},
new Door()
{
Id = "LGH0302", LocationId = "0302", Description = "Dörr till lägenhet."
},
new Door()
{
Id = "BLK0302", LocationId = "0302", Description = "Dörr till balkong/altan."
},
};
context.AddRange(doors);
#endregion
#region Add Events
var events = new List <Event>
{
new Event()
{
Id = "DÖUT", Description = "Dörr öppnad - utifrån."
},
new Event()
{
Id = "DÖIN", Description = "Dörr öppnad - inifrån"
},
new Event()
{
Id = "DS", Description = "Dörr stängd."
},
new Event()
{
Id = "FDUT", Description = "Fel dörr - Otillåtet försök att öppna en dörr utifrån."
},
new Event()
{
Id = "FDIN", Description = "Fel dörr - Otillåtet försök att öppna en dörr inifrån."
}
};
context.AddRange(events);
#endregion
#region Add Tenants
var tenants = new List <Tenant>
{
new Tenant()
{
Id = "00010101-0001", Name = "Liam Jönsson", ApartmentId = "0101"
},
new Tenant()
{
Id = "00010101-0002", Name = "Elias Petterson", ApartmentId = "0102"
},
new Tenant()
{
Id = "00010101-0003", Name = "Wilma Johansson", ApartmentId = "0102"
},
new Tenant()
{
Id = "00010101-0004", Name = "Alicia Sanchez", ApartmentId = "0103"
},
new Tenant()
{
Id = "00010101-0005", Name = "Aaron Sanchez", ApartmentId = "0103"
},
new Tenant()
{
Id = "00010101-0006", Name = "Olivia Erlander", ApartmentId = "0201"
},
new Tenant()
{
Id = "00010101-0007", Name = "William Erlander", ApartmentId = "0201"
},
new Tenant()
{
Id = "00010101-0008", Name = "Alexander Erlander", ApartmentId = "0201"
},
new Tenant()
{
Id = "00010101-0009", Name = "Astrid Erlander", ApartmentId = "0201"
},
new Tenant()
{
Id = "00010101-0010", Name = "Lucas Adolfsson", ApartmentId = "0202"
},
new Tenant()
{
Id = "00010101-0011", Name = "Ebba Adolfsson", ApartmentId = "0202"
},
new Tenant()
{
Id = "00010101-0012", Name = "Lilly Adolfsson", ApartmentId = "0202"
},
new Tenant()
{
Id = "00010101-0013", Name = "Ella Ahlström", ApartmentId = "0301"
},
new Tenant()
{
Id = "00010101-0014", Name = "Alma Alfredsson", ApartmentId = "0301"
},
new Tenant()
{
Id = "00010101-0015", Name = "Elsa Ahlström", ApartmentId = "0301"
},
new Tenant()
{
Id = "00010101-0016", Name = "Maja Ahlström", ApartmentId = "0301"
},
new Tenant()
{
Id = "00010101-0017", Name = "Noah Almgren", ApartmentId = "0302"
},
new Tenant()
{
Id = "00010101-0018", Name = "Adam Andersen", ApartmentId = "0302"
},
new Tenant()
{
Id = "00010101-0019", Name = "Kattis Backman", ApartmentId = "0302"
},
new Tenant()
{
Id = "00010101-0020", Name = "Oscar Chen", ApartmentId = "0302"
},
new Tenant()
{
Id = "00010101-0021", Name = "Vaktmästare", ApartmentId = "VAKT"
},
};
context.AddRange(tenants);
#endregion
#region Add Tags
var tags = new List <Tag>
{
new Tag()
{
Id = "0101A", TenantId = "00010101-0001"
},
new Tag()
{
Id = "0102A", TenantId = "00010101-0002"
},
new Tag()
{
Id = "0102B", TenantId = "00010101-0003"
},
new Tag()
{
Id = "0103A", TenantId = "00010101-0004"
},
new Tag()
{
Id = "0103B", TenantId = "00010101-0005"
},
new Tag()
{
Id = "0201A", TenantId = "00010101-0006"
},
new Tag()
{
Id = "0201B", TenantId = "00010101-0007"
},
new Tag()
{
Id = "0201C", TenantId = "00010101-0008"
},
new Tag()
{
Id = "0201D", TenantId = "00010101-0009"
},
new Tag()
{
Id = "0202A", TenantId = "00010101-0010"
},
new Tag()
{
Id = "0202B", TenantId = "00010101-0011"
},
new Tag()
{
Id = "0202C", TenantId = "00010101-0012"
},
new Tag()
{
Id = "0301A", TenantId = "00010101-0013"
},
new Tag()
{
Id = "0301B", TenantId = "00010101-0014"
},
new Tag()
{
Id = "0301C", TenantId = "00010101-0015"
},
new Tag()
{
Id = "0301D", TenantId = "00010101-0016"
},
new Tag()
{
Id = "0302A", TenantId = "00010101-0017"
},
new Tag()
{
Id = "0302B", TenantId = "00010101-0018"
},
new Tag()
{
Id = "0302C", TenantId = "00010101-0019"
},
new Tag()
{
Id = "0302D", TenantId = "00010101-0020"
},
new Tag()
{
Id = "VAKT01", TenantId = "00010101-0021"
},
};
context.AddRange(tags);
#endregion
#region Add Access
var accesses = new List <Access>
{
new Access()
{
TagId = "VAKT01", DoorId = "VAKT01"
},
// TODO add more...
};
#endregion
#region Add Logs
var logs = new List <LogEntry>
{
new LogEntry()
{
When = DateTime.ParseExact("23-10-20 10:07:00", "dd-MM-yy HH:mm:ss", null), TagId = "0201C", DoorId = "LGH0201", EventId = "DÖIN"
}, // william erlander tar in tidningen
new LogEntry()
{
When = DateTime.ParseExact("23-10-20 10:08:00", "dd-MM-yy HH:mm:ss", null), TagId = "0201C", DoorId = "LGH0201", EventId = "DÖUT"
},
new LogEntry()
{
When = DateTime.ParseExact("23-10-20 10:19:00", "dd-MM-yy HH:mm:ss", null), TagId = "0302A", DoorId = "LGH0302", EventId = "DÖIN"
}, // noah almgren slänger soporna
new LogEntry()
{
When = DateTime.ParseExact("23-10-20 10:19:00", "dd-MM-yy HH:mm:ss", null), TagId = "0201A", DoorId = "LGH0201", EventId = "DÖIN"
}, // olivia erlander går till jobbet
new LogEntry()
{
When = DateTime.ParseExact("23-10-20 10:20:00", "dd-MM-yy HH:mm:ss", null), TagId = "0302A", DoorId = "SOPRUM01", EventId = "DÖUT"
},
new LogEntry()
{
When = DateTime.ParseExact("23-10-20 10:20:33", "dd-MM-yy HH:mm:ss", null), TagId = "0201A", DoorId = "UT01", EventId = "DÖIN"
},
new LogEntry()
{
When = DateTime.ParseExact("23-10-20 10:21:00", "dd-MM-yy HH:mm:ss", null), TagId = "0302A", DoorId = "SOPRUM01", EventId = "DÖIN"
},
new LogEntry()
{
When = DateTime.ParseExact("23-10-20 10:22:00", "dd-MM-yy HH:mm:ss", null), TagId = "0302A", DoorId = "LGH0302", EventId = "DÖUT"
},
new LogEntry()
{
When = DateTime.ParseExact("23-10-20 10:55:00", "dd-MM-yy HH:mm:ss", null), TagId = "0202A", DoorId = "LGH0202", EventId = "DÖIN"
}, // lucas adolfson hämtar posten
new LogEntry()
{
When = DateTime.ParseExact("23-10-20 10:56:00", "dd-MM-yy HH:mm:ss", null), TagId = "0202A", DoorId = "LGH0202", EventId = "DÖUT"
},
new LogEntry()
{
When = DateTime.ParseExact("23-10-20 11:03:00", "dd-MM-yy HH:mm:ss", null), TagId = "0301D", DoorId = "LGH0301", EventId = "DÖIN"
}, // maja ahlström hämtar posten
new LogEntry()
{
When = DateTime.ParseExact("23-10-20 11:04:00", "dd-MM-yy HH:mm:ss", null), TagId = "0301D", DoorId = "LGH0301", EventId = "DÖUT"
},
new LogEntry()
{
When = DateTime.ParseExact("23-10-19 08:19:12", "dd-MM-yy HH:mm:ss", null), TagId = "0101A", DoorId = "BLK0101", EventId = "DÖIN"
}, // liam går ut på altanen
new LogEntry()
{
When = DateTime.ParseExact("23-10-19 08:22:45", "dd-MM-yy HH:mm:ss", null), TagId = "0201D", DoorId = "BLK0201", EventId = "DÖIN"
}, // astrid går ut på balkongen
new LogEntry()
{
When = DateTime.ParseExact("23-10-19 08:25:09", "dd-MM-yy HH:mm:ss", null), TagId = "0201D", DoorId = "BLK0201", EventId = "DÖUT"
},
new LogEntry()
{
When = DateTime.ParseExact("23-10-19 08:27:10", "dd-MM-yy HH:mm:ss", null), TagId = "0101A", DoorId = "BLK0101", EventId = "DÖUT"
},
};
context.AddRange(logs);
#endregion
context.SaveChanges();
context.Database.CommitTransaction();
}
catch (Exception)
{
// Roll back transaction if there's any exception inserting data.
context.Database.RollbackTransaction();
return;
}
}
}
