public void Delete_TimeTable_By_TimeTable()
{
string timeTableName = "Test TimeTable to Delete";
// Add to database
using (ThamesClipperContext ctx = new ThamesClipperContext())
{
TimeTableRepository timeTableRepository = new TimeTableRepository(ctx);
timeTableRepository.Add(new TimeTable { Name = timeTableName });
timeTableRepository.SaveChanges();
}
// Find and delete it
using (ThamesClipperContext ctx = new ThamesClipperContext())
{
List<TimeTable> timeTables = ctx.TimeTables.Where(pier => pier.Name == timeTableName).ToList();
Assert.AreEqual(1, timeTables.Count());
TimeTableRepository timeTableRepository = new TimeTableRepository(ctx);
timeTableRepository.Delete(timeTables[0]);
timeTableRepository.SaveChanges();
}
// Check that nothing is there
using (ThamesClipperContext ctx = new ThamesClipperContext())
{
List<TimeTable> timeTables = ctx.TimeTables.Where(pier => pier.Name == timeTableName).ToList();
Assert.AreEqual(0, timeTables.Count());
}
}
public JsonResult Delete(int id)
{
try
{
_timeTableRepository.Delete(id);
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { result = e.Message }, JsonRequestBehavior.AllowGet));
}
}
public void Save()
{
List <time_table> kiolvasottTimeTableElemek = new List <time_table>();
List <time_table> torolniTimeTableElemek = new List <time_table>();
int selectedYear = selectedDate.Year;
int selectedMonth = selectedDate.Month;
foreach (DataRow row in view.globalTimeTable.Rows)
{
if (!string.IsNullOrEmpty(row.ItemArray[view.globalTimeTable.Columns.Count - 1].ToString()))
{
for (int i = 1; i < row.ItemArray.Length - 1; i++)
{
int userId = (int)row.ItemArray[view.globalTimeTable.Columns.Count - 1];
string cellValue = row.ItemArray[i].ToString();
int selectedDay = i;
DateTime startDate = new DateTime(selectedYear, selectedMonth, selectedDay);
DateTime endDate = startDate;
bool betegSzabi = false;
bool fizetettSzabi = false;
if (!string.IsNullOrEmpty(cellValue))
{
switch (cellValue)
{
case "B":
betegSzabi = true;
break;
case "FSZ":
fizetettSzabi = true;
break;
default:
if (cellValue.Contains('-'))
{
string[] kezdVeg = cellValue.Split('-');
int startH = Convert.ToInt32(kezdVeg[0]);
int endH = Convert.ToInt32(kezdVeg[1]);
if (endH < startH)
{
endDate = endDate.AddDays(1);
}
TimeSpan startTime = new TimeSpan(startH, 0, 0);
TimeSpan endTime = new TimeSpan(endH, 0, 0);
startDate = startDate.Date + startTime;
endDate = endDate.Date + endTime;
}
break;
}
kiolvasottTimeTableElemek.Add(new time_table(userId, startDate, endDate, fizetettSzabi, betegSzabi, DateTime.Now));
}
else
{
torolniTimeTableElemek.Add(new time_table(userId, startDate, endDate, fizetettSzabi, betegSzabi, DateTime.Now));
}
}
}
}
foreach (time_table item in kiolvasottTimeTableElemek)
{
if (repoTimeTable.Exists(item))
{
try
{
repoTimeTable.Update(item);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
else
{
try
{
repoTimeTable.Insert(item);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
repoTimeTable.Save();
}
foreach (time_table item in torolniTimeTableElemek)
{
if (repoTimeTable.Exists(item))
{
repoTimeTable.Delete(item);
}
repoTimeTable.Save();
}
}