private static void UpdatePeople(int pId)
{
var doorsDb = new DOORSEntities();
var verpsDb = new VERPSEntities();
string vUser = Properties.Settings.Default.vUser;
string vPass = Properties.Settings.Default.vPass;
string vUri = Properties.Settings.Default.vUri;
System.Uri myUri = new Uri(vUri);
VERPSServiceReference.ApplicationData vsr = new VERPSServiceReference.ApplicationData(myUri);
vsr.Credentials = new NetworkCredential(vUser, vPass, "adm");
try
{
var person = vsr.hrPeople.Where(p => p.Id == pId).SingleOrDefault();
if (person != null)
{
person.AccessCardID = DateTime.Now.ToString();
vsr.UpdateObject(person);
Console.WriteLine("OK");
}
else
{
Console.WriteLine("YOK!");
}
}
catch (Exception ex)
{
Console.WriteLine("CART!");
}
vsr.SaveChanges();
Console.WriteLine("DONE!");
}
private static void CalcWorkingTimes(DateTime opDate)
{
var doorsDb = new DOORSEntities();
var verpsDb = new VERPSEntities();
string vUser = Properties.Settings.Default.vUser;
string vPass = Properties.Settings.Default.vPass;
string vUri = Properties.Settings.Default.vUri;
System.Uri myUri = new Uri(vUri);
VERPSServiceReference.ApplicationData vsr = new VERPSServiceReference.ApplicationData(myUri);
vsr.Credentials = new NetworkCredential(vUser, vPass, "adm");
int i = 0;
int j = 0;
var doorTimes = from d in doorsDb.vwDoorTimes
where d.EventDay == opDate
select d;
//////var empTimes = from b in verpsDb.hrWorkingHours
////// where b.WorkingDate.Equals(opDate)
////// select b;
foreach (var doorT in doorTimes)
{
//////foreach (var empTime in empTimes)
//////{
////// if (doorT.UserExtID == empTime.DoorSysID && doorT.EventDay == empTime.WorkingDate)
////// {
////// empTime.EntryTime = doorT.EntryTime;
////// empTime.ExitTime = doorT.ExitTime;
////// empTime.Modified = DateTimeOffset.Now;
////// }
//////}
string ssss = doorT.UserExtID;
try
{
//if (ssss == "44B14BDB7D23454CADA5C2FDE8168D80")
//{
// string sssssss = "0";
//}
var doorTime = vsr.hrWorkingHours.Where(p => p.DoorSysID == doorT.UserExtID && p.WorkingDate == doorT.EventDay).SingleOrDefault();
if (doorTime != null)
{
doorTime.EntryTime = doorT.EntryTime;
doorTime.ExitTime = doorT.ExitTime;
DateTime startTime = (DateTime)doorT.EntryTime;
DateTime endTime = (DateTime)doorT.ExitTime;
TimeSpan timeSpan = endTime.Subtract(startTime);
int workedMinute = (timeSpan.Hours * 60) + timeSpan.Minutes;
int assignedMinute = (int)doorTime.AssignedWorkingHour * 60;
int minuteDiff = workedMinute - assignedMinute;
doorTime.TotalHours = timeSpan.Hours;
doorTime.TotalMinutes = timeSpan.Minutes;
doorTime.HourDiff = minuteDiff / 60;
doorTime.MinuteDiff = minuteDiff % 60;
if (workedMinute >= 480)
{
doorTime.TotalHours = 8;
doorTime.TotalMinutes = 0;
}
vsr.UpdateObject(doorTime);
j += 1;
}
}
catch (Exception ex)
{
}
i += 1;
}
vsr.SaveChanges();
//////verpsDb.SaveChanges();
Console.WriteLine(i);
Console.WriteLine(j);
Console.WriteLine("DONE!");
}