public bool AddNewScheduleProperties(UpdateSchProperty _updateScheuleProperties)
{
try
{
using (ScheduleContext = new ScheduleContext(database))
{
ScheduleContext.UpdateSchProperties.Add(_updateScheuleProperties);
ScheduleContext.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public bool UpdateScheuleProperties(UpdateSchProperty _updateSchProperty)
{
try
{
using (ScheduleContext = new ScheduleContext(database))
{
ScheduleContext.Entry(_updateSchProperty).State = EntityState.Modified;
ScheduleContext.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public void Update()
{
IBuidingQuery = new BuildingQuery(database);
IScheduleQuery = new ScheduleQuery(database);
bool success = false;
FilePath filePath = IScheduleQuery.GetFilePath("schedule");
if (filePath == null)
{
Console.WriteLine("File Path is null");
}
IEnumerable <string> folderList = Directory.EnumerateDirectories(filePath.Path);
foreach (var scheduleFilePath in folderList)
{
Console.WriteLine(scheduleFilePath);
DateTime lastEditFolder = Directory.GetLastWriteTime(scheduleFilePath);
DirectoryInfo Directorys = new DirectoryInfo(scheduleFilePath); //Assuming Test is your Folder
FileInfo[] Files = Directorys.GetFiles("*.xlsm"); //Getting Text files
if (Files.Length == 0)
{
Console.WriteLine("Folder is empty, Continue the next one");
continue;
}
FileInfo LastFile = Files[Files.Length - 1];
string folderName = GetScheduleClass(scheduleFilePath);
// checking folder
var scheduleClass = IScheduleQuery.GetScheduleClass(folderName);//CheckingFolder(folderName);
if (scheduleClass != null)
{
Console.WriteLine("Schedule Class is not Null");
if (!CheckingFolderModified(scheduleClass, lastEditFolder))
{
Console.WriteLine("Nothing changed, Countinue!");
continue;
}
scheduleClass.LastModified = lastEditFolder;
Console.WriteLine($"Last file: modified time:{scheduleClass.LastModified.ToString()}");
var updateSchProperties = scheduleClass.UpdateSchProperty;
if (updateSchProperties == null)
{
//update scheduleclass
updateSchProperties = new UpdateSchProperty
{
FileName = LastFile.Name,
CreatedDate = LastFile.CreationTime,
ModifiedDate = LastFile.LastWriteTime,
};
success = IScheduleQuery.AddNewScheduleProperties(updateSchProperties);
if (success)
{
Console.WriteLine("Add new schedule class property successfull");
}
else
{
Console.WriteLine("Add new schedule class property error");
}
}
else
{
string time1 = updateSchProperties.ModifiedDate.ToString("MM/dd/yyyy, hh:mm:");
string time2 = LastFile.LastWriteTime.ToString("MM/dd/yyyy, hh:mm:");
if (time1 == time2)
{
Console.WriteLine("Nothing changed, Continue!");
continue;
}
}
Console.WriteLine("Update Excel file:{0}", LastFile);
//update file
UpdateScheduleFile(LastFile, scheduleClass);
scheduleClass.UpdateSchProperties_Id = updateSchProperties.id;
success = IScheduleQuery.UpdateScheuleClass(scheduleClass);
if (success)
{
Console.WriteLine("Update schedule class successfully");
}
else
{
Console.WriteLine("Update schedule class error");
}
updateSchProperties.FileName = LastFile.Name;
updateSchProperties.CreatedDate = LastFile.CreationTime;
updateSchProperties.ModifiedDate = LastFile.LastWriteTime;
success = IScheduleQuery.UpdateScheuleProperties(updateSchProperties);
if (success)
{
Console.WriteLine("Update schedule class property successfully");
}
else
{
Console.WriteLine("Update schedule class property error");
}
Console.WriteLine("Finished add");
}
else
{
Console.WriteLine("Schedule Class is null");
// add new folder add new file
ScheduleClass schClass = new ScheduleClass
{
Name = folderName,
LastModified = lastEditFolder
};
success = IScheduleQuery.AddNewScheuleClass(schClass);
if (success)
{
Console.WriteLine("Add new schedule class successfully");
}
else
{
Console.WriteLine("Add new schedule class error");
}
//update file
UpdateScheduleFile(LastFile, schClass);
UpdateSchProperty prop = new UpdateSchProperty
{
FileName = LastFile.Name,
CreatedDate = LastFile.CreationTime,
ModifiedDate = LastFile.LastWriteTime
};
success = IScheduleQuery.AddNewScheduleProperties(prop);
if (success)
{
Console.WriteLine("Add new schedule class property successfully");
}
else
{
Console.WriteLine("Add new schedule class property error");
}
schClass.UpdateSchProperties_Id = prop.id;
success = IScheduleQuery.UpdateScheuleClass(schClass);
if (success)
{
Console.WriteLine("Update schedule class successfully");
}
else
{
Console.WriteLine("Update schedule class error");
}
}
}
}
