/// <summary>
/// Read csv file;
/// </summary>
/// <param name="context"></param>
public void Execute(IJobExecutionContext context)
{
// Read list from Database.
var listImagesCSV = ReadWriteCSV.ReadCSV(pathCSV);
// Change Active For LockScreen
foreach (var item in listImagesCSV.Where(x => x.Type == "LockScreen").ToList())
{
// Check TimeTo duedate to change default images to active
if (item.TimeTo > DateTime.Now)
{
StartMove(-item.ID, item.TimeTo, Directory.GetFiles(pathDefaultLockScreen)[0], pathLockScreen + "default.jpg", item.Type);
}
// Check TimeForm to change images list to active images
if (item.TimeFrom > DateTime.Now)
{
StartMove(item.ID, item.TimeFrom, pathImages + item.Name, pathLockScreen + "default.jpg", item.Type);
}
}
// Change Activ For ScreenSaver
foreach (var item in listImagesCSV.Where(x => x.Type == "ScreenSaver").ToList())
{
// Check TimeTo duedate to change default images to active
if (item.TimeTo > DateTime.Now)
{
StartRemove(-item.ID, item.TimeTo, pathScreenSaver, item.Name);
}
// Check TimeStart to change images list to active images
if (item.TimeFrom > DateTime.Now)
{
StartMove(item.ID, item.TimeFrom, pathImages + item.Name, pathScreenSaver + item.Name, item.Type);
}
}
}
public void RecordExists_Invalid_ShouldReturnFalse(string key, int column)
{
File.Delete(@"test.txt");
var sut = new ReadWriteCSV("test.txt", ';');
//sut.AddRecord("1;2;3");
//sut.AddRecord("a;b;c");
var response = sut.RecordExists(key, column);
Assert.False(response.Result);
Assert.True(response.IsSuccessStatusCode);
}
protected void SaveToCSV(bool start, string name, string column1, string column2)
{
//MessageBox.Show(start.ToString() + " ; " + dataTable.Rows.Count.ToString());
if (start && dataTable.Rows.Count > 2)
{
ReadWriteCSV readWriteCSV = new ReadWriteCSV(CreatePath.CreateReportPath(name, fileEnding));
readWriteCSV.WriteToCSV(column1, column2);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
readWriteCSV.WriteToCSV(dataTable.Rows[i][0].ToString(), dataTable.Rows[i][1].ToString());
}
}
}
public JsonResult DeleteAll()
{
try
{
string type = ((int)Session["Type"] != 2) ? "ScreenSaver" : "LockScreen";
// Remove all images in ImagesUpload and Uploaded
List <ImageModel> removeList = (List <ImageModel>)Session["Images"];
foreach (var item in removeList.Where(x => x.Type == type).ToList())
{
// Check if not exists other type
if (!removeList.Exists(x => x.Type != type && x.Name == item.Name))
{
System.IO.File.Delete(Path.Combine(Server.MapPath(pathTempImages), item.Name));
System.IO.File.Delete(Path.Combine(pathImages, item.Name));
}
// Remove Active Images
if (item.TimeFrom < DateTime.Now && item.TimeTo > DateTime.Now)
{
if (item.Type == "ScreenSaver")
{
RemoveActiveToDefault(pathScreenSaver, item.Name, pathDefaultScreenSaver);
}
else
{
RemoveActiveToDefault(pathLockScreen, "default.jpg", pathDefaultLockScreen);
}
}
}
List <ImageModel> tempList = (List <ImageModel>)Session["Images"];
tempList.RemoveAll(x => x.Type == type);
Session["Images"] = tempList;
//ReadWriteCSV.WriteCSV(new List<ImageModel>());
ReadWriteCSV.WriteCSV(tempList);
// Remove all schedule
JobsSchedule.RemoveAllSchedule();
Notification("Notify", "Remove all list images successfuly", MyConstants.NOTIFY_SUCCESS);
return(Json(new { status = true }));
}
catch (Exception)
{
Notification("Error", "Remove all list images failure", MyConstants.NOTIFY_ERROR);
return(Json(new { status = false }));
throw;
}
}
public JsonResult Delete(long id)
{
var sessionCart = (List <ImageModel>)Session["Images"];
string type = ((int)Session["Type"] != 2) ? "ScreenSaver" : "LockScreen";
// Remove that images: all information
foreach (var item in sessionCart.Where(x => x.ID == id).ToList())
{
// Check if not exists other type
if (!sessionCart.Exists(x => x.Type != type && x.Name == item.Name))
{
System.IO.File.Delete(Path.Combine(Server.MapPath(pathTempImages), item.Name));
System.IO.File.Delete(Path.Combine(pathImages, item.Name));
}
// Remove active images
if (item.TimeFrom < DateTime.Now && item.TimeTo > DateTime.Now)
{
if (item.Type == "ScreenSaver")
{
RemoveActiveToDefault(pathScreenSaver, item.Name, pathDefaultScreenSaver);
}
else
{
RemoveActiveToDefault(pathLockScreen, "default.jpg", pathDefaultLockScreen);
}
}
// Remove all schedule apply
JobsSchedule.RemoveAllSchedule();
}
sessionCart.RemoveAll(x => x.ID == id);
Session["Images"] = sessionCart;
ReadWriteCSV.WriteCSV(sessionCart);
// Restart schedule apply after delete that item
JobsSchedule.Start();
if (sessionCart.Count == 0)
{
Session["Images"] = null;
}
return(Json(new
{
status = true
}));
}
protected void SaveToCSV(bool start, string name, string column1, string column2)
{
//MessageBox.Show(start.ToString() + " ; " + dataTable.Rows.Count.ToString());
if (start && dataTable.Rows.Count > 2)
{
string year = System.DateTime.Now.Year.ToString();
string month = System.DateTime.Now.Month.ToString();
string day = System.DateTime.Now.Day.ToString();
string hour = System.DateTime.Now.Hour.ToString();
string minute = System.DateTime.Now.Minute.ToString();
ReadWriteCSV readWriteCSV = new ReadWriteCSV(@"D:\Chart\" + hour + "_" + minute + "_" + day + "_" + month + "_" + year + "_" + name + ".csv");
readWriteCSV.WriteToCSV(column1, column2);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
readWriteCSV.WriteToCSV(dataTable.Rows[i][0].ToString(), dataTable.Rows[i][1].ToString());
}
}
}
public ActionResult Index()
{
try
{
if (ReadWriteCSV.ReadCSV(pathCSV).Count != 0)
{
Session["Images"] = ReadWriteCSV.ReadCSV(pathCSV);
}
else
{
Session["Images"] = null;
}
}
catch (Exception ex)
{
Notification("Error", "Can't read CSV file!, " + ex.ToString(), MyConstants.NOTIFY_ERROR);
}
return(View());
}
protected void SaveToCSV(bool start, string name, string column1, string column2, string column3, string column4)
{
if (start && ValuesAfter1.Count > 2)
{
ReadWriteCSV readWriteCSV = new ReadWriteCSV(CreatePath.CreateReportPath(name, fileEnding));
readWriteCSV.WriteToCSV("Height", column1, column2, column3, column4);
for (int i = 0; i < ValuesBefore1.Count; i++)
{
if ((i < ValuesAfter1.Count))
{
readWriteCSV.WriteToCSV(i.ToString(), ValuesBefore1[i].ToString(), ValuesBefore2[i].ToString(), ValuesAfter1[i].ToString(), ValuesAfter2[i].ToString());
}
else
{
readWriteCSV.WriteToCSV(i.ToString(), ValuesBefore1[i].ToString(), ValuesBefore2[i].ToString());
}
}
}
}
public JsonResult Done()
{
try
{
var imagesList = (List <ImageModel>)Session["Images"];
if (imagesList != null)
{
//Create list object - update url
List <ImageModel> newListImages = new List <ImageModel>();
newListImages = imagesList;
foreach (var item in newListImages)
{
if (!System.IO.File.Exists(pathImages + item.Name))
{
System.IO.File.Copy(Server.MapPath(pathTempImages) + item.Name, pathImages + item.Name);
}
item.Url = pathImages + item.Name;
}
//Save object to file.txt
ReadWriteCSV.WriteCSV(newListImages);
Session["Images"] = imagesList;
Notification("Notify", "Save list images successfuly", MyConstants.NOTIFY_SUCCESS);
// Start Schedule.
JobsSchedule.RemoveAllSchedule();
JobsSchedule.Start();
return(Json(new { status = true }));
}
else
{
Notification("Error", "This list being empty", MyConstants.NOTIFY_ERROR);
return(Json(new { status = false }));
}
}
catch (Exception e)
{
Notification("Error", "Have some error, Please contact with IT!", MyConstants.NOTIFY_ERROR);
return(Json(new { status = e.ToString() }));
}
}
