private ActionResult AddNoteToDB_hlp(DateTime _dt, FieldsOfDataGrid fodg)
{
//n.Note_Id = Guid.NewGuid();//baza sdf
//m_DBNotatki.Database.ExecuteSqlCommand("delete from NotatkaEncja");
Note n = new Note()
{
Message = fodg.Note,
User = fodg.User,
Date = new DateTime(_dt.Year, _dt.Month, _dt.Day, fodg.Hour, fodg.Minute, 0)
};
m_notesDB.Add(n);
try
{
m_notesDB.SaveChanges();
}
catch (Exception e)
{
return(ActionResult.CreateFailResult(e.Message, ErrorType.DataSavingFailedWhileAdding));
}
return(ActionResult.CreateSuccessResult());
}
private void dataGrid1_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
var PosOfDay = e.Row.Item as PositionOfDay;
if (PosOfDay.CurrentHour != PosOfDay.OldHour ||
PosOfDay.CurrentMinute != PosOfDay.OldMinute ||
!PosOfDay.CurrentNote.Equals(PosOfDay.OldNote) ||
!PosOfDay.CurrentUser.Equals(PosOfDay.OldUser)
)
{
ActionResult saveRes = Engine.RemoveNoteFromDB(PosOfDay.OldHour, PosOfDay.OldMinute);
if (!saveRes.IsSuccess)
{
MessageBox.Show(saveRes.ErrorMsg, "Error");
}
var fodg = new FieldsOfDataGrid()
{
Hour = PosOfDay.CurrentHour,
Minute = PosOfDay.CurrentMinute,
Note = PosOfDay.CurrentNote,
User = PosOfDay.CurrentUser
};
ActionResult addNoteResult = Engine.AddNoteToDB(fodg);
if (!addNoteResult.IsSuccess)
{
MessageBox.Show(addNoteResult.ErrorMsg, "Error");
}
}
Engine.UpdateOfPositions();
}
public ActionResult AddNoteToDB(FieldsOfDataGrid fodg)
{
int numberOfNotes = NumberOfNotesFor(Selected_Date, fodg.Hour, fodg.Minute);
if (numberOfNotes > 0)
{
return(ActionResult.CreateFailResult(string.Format("There is already Note for Hour Minute {0}:{1}", fodg.Hour, fodg.Minute), ErrorType.DataAlreadyPresent));
}
return(AddNoteToDB_hlp(Selected_Date, fodg));
}
private void dataGrid1_PreviewKeyDown(object sender, KeyEventArgs e)
{
var Grid = (DataGrid)sender;
if (e.Key == Key.Delete)
{
foreach (var row in Grid.SelectedItems)
{
PositionOfDay PosOfDay = row as PositionOfDay;
if (PosOfDay != null)
{
ActionResult saveRes = Engine.RemoveNoteFromDB(PosOfDay.CurrentHour, PosOfDay.CurrentMinute);
if (!saveRes.IsSuccess)
{
MessageBox.Show(saveRes.ErrorMsg, "Error");
}
}
}
Engine.UpdateOfPositions();
}
else
if (e.Key == Key.Escape)
{
PositionOfDay PosOfDay = Grid.SelectedItem as PositionOfDay;
if (PosOfDay != null)
{
ActionResult saveRes = Engine.RemoveNoteFromDB(PosOfDay.CurrentHour, PosOfDay.CurrentMinute);
if (!saveRes.IsSuccess)
{
MessageBox.Show(saveRes.ErrorMsg, "Error");
}
if (!string.IsNullOrWhiteSpace(PosOfDay.OldNote))
{
var fodg = new FieldsOfDataGrid()
{
Hour = PosOfDay.OldHour,
Minute = PosOfDay.OldMinute,
Note = PosOfDay.OldNote,
User = PosOfDay.OldUser
};
ActionResult addNoteResult = Engine.AddNoteToDB(fodg);
if (!addNoteResult.IsSuccess)
{
MessageBox.Show(addNoteResult.ErrorMsg, "Error");
}
}
Engine.UpdateOfPositions();
}
}
}
private void dataGrid1_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
var PosOfDay = e.Row.Item as PositionOfDay;
if (PosOfDay.CurrentHour != PosOfDay.OldHour ||
PosOfDay.CurrentMinute != PosOfDay.OldMinute ||
!PosOfDay.CurrentNote.Equals(PosOfDay.OldNote) ||
!PosOfDay.CurrentUser.Equals(PosOfDay.OldUser)
)
{
ActionResult saveRes = Engine.RemoveNoteFromDB(PosOfDay.OldHour, PosOfDay.OldMinute);
if (!saveRes.IsSuccess)
{
MessageBox.Show(saveRes.ErrorMsg, "Error");
}
var fodg = new FieldsOfDataGrid()
{
Hour = PosOfDay.CurrentHour,
Minute = PosOfDay.CurrentMinute,
Note = PosOfDay.CurrentNote,
User = PosOfDay.CurrentUser
};
ActionResult addNoteResult = Engine.AddNoteToDB(fodg);
if (!addNoteResult.IsSuccess)
{
MessageBox.Show(addNoteResult.ErrorMsg, "Error");
}
}
Engine.UpdateOfPositions();
}
private void dataGrid1_PreviewKeyDown(object sender, KeyEventArgs e)
{
var Grid = (DataGrid)sender;
if (e.Key == Key.Delete)
{
foreach (var row in Grid.SelectedItems)
{
PositionOfDay PosOfDay = row as PositionOfDay;
if (PosOfDay != null)
{
ActionResult saveRes = Engine.RemoveNoteFromDB(PosOfDay.CurrentHour, PosOfDay.CurrentMinute);
if (!saveRes.IsSuccess)
{
MessageBox.Show(saveRes.ErrorMsg, "Error");
}
}
}
Engine.UpdateOfPositions();
}
else
if (e.Key == Key.Escape)
{
PositionOfDay PosOfDay = Grid.SelectedItem as PositionOfDay;
if (PosOfDay != null)
{
ActionResult saveRes = Engine.RemoveNoteFromDB(PosOfDay.CurrentHour, PosOfDay.CurrentMinute);
if (!saveRes.IsSuccess)
{
MessageBox.Show(saveRes.ErrorMsg, "Error");
}
if (!string.IsNullOrWhiteSpace(PosOfDay.OldNote))
{
var fodg = new FieldsOfDataGrid()
{
Hour = PosOfDay.OldHour,
Minute = PosOfDay.OldMinute,
Note = PosOfDay.OldNote,
User = PosOfDay.OldUser
};
ActionResult addNoteResult = Engine.AddNoteToDB(fodg);
if (!addNoteResult.IsSuccess)
{
MessageBox.Show(addNoteResult.ErrorMsg, "Error");
}
}
Engine.UpdateOfPositions();
}
}
}
private ActionResult AddNoteToDB_hlp(DateTime _dt, FieldsOfDataGrid fodg)
{
//n.Note_Id = Guid.NewGuid();//baza sdf
//m_DBNotatki.Database.ExecuteSqlCommand("delete from NotatkaEncja");
Note n = new Note()
{
Message = fodg.Note,
User = fodg.User,
Date = new DateTime(_dt.Year, _dt.Month, _dt.Day, fodg.Hour, fodg.Minute, 0)
};
m_notesDB.Add(n);
try
{
m_notesDB.SaveChanges();
}
catch (Exception e)
{
return ActionResult.CreateFailResult(e.Message,ErrorType.DataSavingFailedWhileAdding);
}
return ActionResult.CreateSuccessResult();
}
public ActionResult AddNoteToDB(FieldsOfDataGrid fodg)
{
int numberOfNotes = NumberOfNotesFor(Selected_Date, fodg.Hour, fodg.Minute);
if (numberOfNotes > 0)
{
return ActionResult.CreateFailResult(string.Format("There is already Note for Hour Minute {0}:{1}", fodg.Hour, fodg.Minute), ErrorType.DataAlreadyPresent);
}
return AddNoteToDB_hlp(Selected_Date, fodg);
}
