public static string GetNotes(string userid)
{
string notes;
UserNotes.TryGetValue(userid, out notes);
return(notes);
}
public IActionResult UpdateUser(UserNotes data)
{
if (data == null)
{
return(BadRequest());
}
else
{
IActionResult result = _operations.UpdateUserData(data);
return(result);
}
}
public UserNotes GetUserDataError(string username)
{
Users user = _db.Users.Where(x => x.Username == username).FirstOrDefault();
if (user.Activated)
{
UserNotes userData = _db.UserNotes.Where(x => x.Id == user.UserData).FirstOrDefault();
return(userData);
}
else
{
return(null);
}
}
public async Task <UserNotes> CreateNote(string notes, string userId, string createdBy, string modifiedBy)
{
var nt = new UserNotes
{
Modifiedby = modifiedBy,
Createdby = createdBy,
DtCreated = DateTime.Now,
DtModified = DateTime.Now,
Note = notes,
Userid = userId
};
return(await uow.ClientNoteRepository.AddAsync(nt));
}
public List <UserNotes> List(string UserName, bool HistoryFlag)
{
List <UserNotes> List = new List <UserNotes>();
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[config].[uspReadUserNotes]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlCmd.Parameters.AddWithValue("@UserName", UserName);
SqlCmd.Parameters.AddWithValue("@HistoryFlag", HistoryFlag);
using (var dr = SqlCmd.ExecuteReader())
{
while (dr.Read())
{
var detail = new UserNotes
{
NoteID = Convert.ToInt32(dr["NoteID"]),
UserID = Convert.ToInt32(dr["UserID"]),
RequestNote = dr["RequestNote"].ToString(),
NoteDate = Convert.ToDateTime(dr["NoteDate"]),
InsertedBy = dr["InsertedBy"].ToString(),
ResponseRequired = Convert.ToBoolean(dr["ResponseRequired"]),
ResponseNote = dr["ResponseNote"].ToString(),
ReadFlag = Convert.ToBoolean(dr["ReadFlag"])
};
if (!Convert.IsDBNull(dr["ResponseDate"]))
{
detail.ResponseDate = Convert.ToDateTime(dr["ResponseDate"]);
}
List.Add(detail);
}
}
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(List);
}
public UserNotes Details(int NoteID)
{
UserNotes Note = new UserNotes();
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[config].[uspReadUserNotes]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlCmd.Parameters.AddWithValue("@NoteID", NoteID);
using (var dr = SqlCmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
Note.NoteID = Convert.ToInt32(dr["NoteID"]);
Note.UserID = Convert.ToInt32(dr["UserID"]);
Note.RequestNote = dr["RequestNote"].ToString();
Note.NoteDate = Convert.ToDateTime(dr["NoteDate"]);
Note.ResponseRequired = Convert.ToBoolean(dr["ResponseRequired"]);
Note.InsertedBy = dr["InsertedBy"].ToString();
Note.ResponseNote = dr["ResponseNote"].ToString();
Note.ReadFlag = Convert.ToBoolean(dr["ReadFlag"]);
if (!Convert.IsDBNull(dr["ResponseDate"]))
{
Note.ResponseDate = Convert.ToDateTime(dr["ResponseDate"]);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(Note);
}
private void ShowModalWindow(string dateDay, string para, int paraNumber, UserNotes note, ref Button butonClick)
{
switch ((butonClick.Content as MaterialDesignThemes.Wpf.PackIcon).Kind)
{
case MaterialDesignThemes.Wpf.PackIconKind.NoteAddOutline:
_mWindow._homePage = this;
_mWindow._buttonRefAddNote = butonClick;
_mWindow.GridModalWindows.Visibility = System.Windows.Visibility.Visible;
_mWindow.ModalWindowAddNotes.Visibility = System.Windows.Visibility.Visible;
_mWindow.DosentOpacityGrid.IsEnabled = false;
_mWindow.NameGridChangeOrAddNotes.Text = "Добавление заметки";
_mWindow.SaveNoteButton.Content = "Сохранить";
_mWindow.SaveNoteButton.ToolTip = "Сохранить заметку";
_mWindow.KindHeaderTextBock.Kind = MaterialDesignThemes.Wpf.PackIconKind.NoteAddOutline;
_mWindow.SaveNoteButton.Visibility = System.Windows.Visibility.Hidden;
_mWindow.DateNoteTextBlock.Text = dateDay;
_mWindow.ParaNoteTextBlock.Text = para;
_mWindow.paraNumber = paraNumber;
Storyboard sb = _mWindow.FindResource("ShowModalWindowAddNewNote") as Storyboard;
sb.Begin();
_mWindow.NewNoteTextBox.Clear();
notes = note;
break;
case MaterialDesignThemes.Wpf.PackIconKind.NoteMultipleOutline:
notes = note;
_mWindow._homePage = this;
_mWindow._buttonRefAddNote = butonClick;
_mWindow.GridModalWindows.Visibility = System.Windows.Visibility.Visible;
_mWindow.ModalWindowAddNotes.Visibility = System.Windows.Visibility.Visible;
_mWindow.DosentOpacityGrid.IsEnabled = false;
_mWindow.NameGridChangeOrAddNotes.Text = "Изменение заметки";
_mWindow.SaveNoteButton.Content = "Изменить";
_mWindow.SaveNoteButton.ToolTip = "Изменить заметку";
_mWindow.KindHeaderTextBock.Kind = MaterialDesignThemes.Wpf.PackIconKind.NoteMultipleOutline;
_mWindow.SaveNoteButton.Visibility = System.Windows.Visibility.Visible;
_mWindow.DateNoteTextBlock.Text = dateDay;
_mWindow.ParaNoteTextBlock.Text = para;
_mWindow.paraNumber = paraNumber;
_mWindow.NewNoteTextBox.Text = note.NoteText;
_mWindow.tmpNoteUserId = note.IDNotes;
Storyboard sbChangeNote = _mWindow.FindResource("ShowModalWindowAddNewNote") as Storyboard;
sbChangeNote.Begin();
break;
}
}
public IActionResult Unhandled(string username)
{
UserNotes result = _operations.GetUserDataError(username);
if (result == null)
{
var response = new
{
message = "User is not activated",
HttpStatusCode.NoContent
};
return(new JsonResult(response));
}
else
{
return(new JsonResult(result));
}
}
public async Task SaveUserNote(UserNotes userNote)
{
Notes Notes = new Notes();
int month = userNote.NoteDate.Month;
int day = userNote.NoteDate.Day;
int year = userNote.NoteDate.Year;
UserNotes note;
if ((note = await Notes.UserNotes.Where(n => n.UserLogin.Equals(userNote.UserLogin) &&
n.NoteDate.Year.Equals(year) &&
n.NoteDate.Month.Equals(month) &&
n.NoteDate.Day.Equals(day))
.FirstOrDefaultAsync()) != null)
{
if (string.IsNullOrWhiteSpace(userNote.Note))
{
Notes.UserNotes.Remove(note);
}
else
{
note.Note = userNote.Note;
Notes.Entry(note).State = EntityState.Modified;
}
}
else if (string.IsNullOrWhiteSpace(userNote.Note))
{
return;
}
else
{
UserNotes newNote = new UserNotes
{
Note = userNote.Note,
UserLogin = userNote.UserLogin,
NoteDate = userNote.NoteDate
};
Notes.UserNotes.Add(newNote);
}
await Notes.SaveChangesAsync();
}
public IActionResult UpdateUserData(UserNotes data)
{
Users user = _db.Users.Where(x => x.UserData == data.Id).FirstOrDefault();
try
{
if (user.Activated)
{
_db.UserNotes.Update(data);
_db.SaveChanges();
return(new OkResult());
}
else
{
return(new UnprocessableEntityResult());
}
}
catch (NullReferenceException)
{
return(new NotFoundResult());
}
}
public GetUserDataResult GetUserData(string username)
{
try
{
Users user = _db.Users.Where(x => x.Username == username).FirstOrDefault();
if (user == null)
{
return(new GetUserDataResult(null, "not found"));
}
if (user.Activated)
{
UserNotes userData = _db.UserNotes.Where(x => x.Id == user.UserData).FirstOrDefault();
return(new GetUserDataResult(userData, "ok"));
}
else
{
return(new GetUserDataResult(null, "not active"));
}
}
catch (Exception)
{
return(new GetUserDataResult(null, "error"));
}
}
public bool AddNote(UserNotes Note, string InsertUser)
{
bool rpta = false;
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[adm].[uspAddUserNote]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlParameter ParInsertUser = new SqlParameter
{
ParameterName = "@InsertUser",
SqlDbType = SqlDbType.VarChar,
Size = 50,
Value = InsertUser
};
SqlCmd.Parameters.Add(ParInsertUser);
SqlParameter pUserID = new SqlParameter
{
ParameterName = "@UserID",
SqlDbType = SqlDbType.Int,
Value = Note.UserID
};
SqlCmd.Parameters.Add(pUserID);
SqlParameter pNote = new SqlParameter
{
ParameterName = "@RequestNote",
SqlDbType = SqlDbType.VarChar,
Value = Note.RequestNote.Trim()
};
SqlCmd.Parameters.Add(pNote);
SqlParameter pResponseRequired = new SqlParameter
{
ParameterName = "@ResponseRequired",
SqlDbType = SqlDbType.Bit,
Value = Note.ResponseRequired
};
SqlCmd.Parameters.Add(pResponseRequired);
//EXEC Command
SqlCmd.ExecuteNonQuery();
rpta = true;
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(rpta);
}
// Get Teacher Sheldue
private List <Sheldue> ParseWordFileTeacherMethod()
{
List <Sheldue> allSheldue = new List <Sheldue>();
try
{
string pathFileWord = Path.GetFullPath(departmnetListReferensToFile["Информационное"]);
Application app = new Application();
string[] nameTeacher = _name.ToUpper().Split(' ');
Document doc = app.Documents.Open(pathFileWord, Visible: false);
bool twoGroupInTable = true;
try
{
foreach (Table table in doc.Tables)
{
twoGroupInTable = table.Columns.Count > 7 ? true : false;
switch (twoGroupInTable)
{
case true:
try
{
for (int i = 3; i < table.Rows.Count; i++)
{
string[] teacherCellParse = RangeText(table.Cell(i, 5).Range.Text).Split(new char[] { ' ', '/' });
foreach (var name in teacherCellParse)
{
if (nameTeacher[0] == name)
{
string paraNumber = RangeText(table.Cell(i, 2).Range.Text);
string work = RangeText(table.Cell(i, 3).Range.Text);
string auditoria = RangeText(table.Cell(i, 4).Range.Text);
string teacher = RangeText(table.Cell(i, 5).Range.Text);
UserNotes note = new UserNotes();
if (userNotes.Count != 0)
{
note = GetUserNote(paraNumber, work);
}
allSheldue.Add(new Sheldue(System.Windows.Visibility.Visible,
note.Para != null ? MaterialDesignThemes.Wpf.PackIconKind.NoteMultipleOutline : MaterialDesignThemes.Wpf.PackIconKind.NoteAddOutline,
$"Para{paraNumber}",
paraNumber,
work,
teacher,
auditoria,
note));
}
}
teacherCellParse = RangeText(table.Cell(i, 9).Range.Text).Split(new char[] { ' ', '/' });
foreach (var name in teacherCellParse)
{
if (nameTeacher[0] == name)
{
string paraNumber = RangeText(table.Cell(i, 6).Range.Text);
string work = RangeText(table.Cell(i, 7).Range.Text);
string auditoria = RangeText(table.Cell(i, 8).Range.Text);
string teacher = RangeText(table.Cell(i, 9).Range.Text);
UserNotes note = new UserNotes();
if (userNotes.Count != 0)
{
note = GetUserNote(paraNumber, work);
}
allSheldue.Add(new Sheldue(System.Windows.Visibility.Visible,
note.Para != null ? MaterialDesignThemes.Wpf.PackIconKind.NoteMultipleOutline : MaterialDesignThemes.Wpf.PackIconKind.NoteAddOutline,
$"Para{paraNumber}",
paraNumber,
work,
teacher,
auditoria,
note));
}
}
}
}
catch
{
continue;
}
break;
case false:
try
{
for (int i = 3; i < table.Rows.Count; i++)
{
string[] teacherCellParse = RangeText(table.Cell(i, 5).Range.Text).Split(new char[] { ' ', '/' });
foreach (var name in teacherCellParse)
{
if (nameTeacher[0] == name)
{
string paraNumber = RangeText(table.Cell(i, 2).Range.Text);
string work = RangeText(table.Cell(i, 3).Range.Text);
string auditoria = RangeText(table.Cell(i, 4).Range.Text);
string teacher = RangeText(table.Cell(i, 5).Range.Text);
UserNotes note = new UserNotes();
if (userNotes.Count != 0)
{
note = GetUserNote(paraNumber, work);
}
allSheldue.Add(new Sheldue(System.Windows.Visibility.Visible,
note.Para != null ? MaterialDesignThemes.Wpf.PackIconKind.NoteMultipleOutline : MaterialDesignThemes.Wpf.PackIconKind.NoteAddOutline,
$"Para{paraNumber}",
paraNumber,
work,
teacher,
auditoria,
note));
}
}
}
}
catch
{
continue;
}
break;
}
}
}
catch
{
doc.Close();
app.Quit();
return(allSheldue);
}
finally
{
doc.Close();
app.Quit();
}
}
catch (Exception ex)
{
int lineEx = new System.Diagnostics.StackTrace(ex, true).GetFrame(0).GetFileLineNumber();
IFCore.IFCore.loggerMain.Error("DAL => ParseCellsRanegTextTable class " + ex.ToString() + lineEx);
}
return(allSheldue);
}
// Get Student Sheldue
private List <Sheldue> ParseWordFileStudentMethod()
{
List <Sheldue> allSheldue = new List <Sheldue>();
try
{
string pathFileWord = Path.GetFullPath(departmnetListReferensToFile[_department]);
Application app = new Application();
string group = $"ГРУППА {_group.Replace(" ", "")}";
Document doc = app.Documents.Open(pathFileWord, Visible: false);
try
{
foreach (Table table in doc.Tables)
{
try
{
for (int j = 1; j < table.Columns.Count - 1; j++)
{
if (RangeText(table.Cell(1, j).Range.Text) == group)
{
if (j > 4)
{
for (int i = 3; i <= table.Rows.Count; i++)
{
try
{
if (RangeText(table.Cell(i, 6).Range.Text) != string.Empty)
{
string paraNumber = RangeText(table.Cell(i, 6).Range.Text);
string work = RangeText(table.Cell(i, 7).Range.Text);
string auditoria = RangeText(table.Cell(i, 8).Range.Text);
string teacher = RangeText(table.Cell(i, 9).Range.Text);
UserNotes note = new UserNotes();
if (userNotes.Count != 0)
{
note = GetUserNote(paraNumber, work);
}
allSheldue.Add(new Sheldue(System.Windows.Visibility.Visible,
note.Para != null
? MaterialDesignThemes.Wpf.PackIconKind.NoteMultipleOutline
: MaterialDesignThemes.Wpf.PackIconKind.NoteAddOutline,
$"Para{paraNumber}",
paraNumber,
work,
teacher,
auditoria,
note));
}
}
catch
{
continue;
}
}
}
else
{
for (int i = 3; i <= table.Rows.Count - 1; i++)
{
try
{
if (RangeText(table.Cell(i, 2).Range.Text) != string.Empty)
{
string paraNumber = RangeText(table.Cell(i, 2).Range.Text);
string work = RangeText(table.Cell(i, 3).Range.Text);
string auditoria = RangeText(table.Cell(i, 4).Range.Text);
string teacher = RangeText(table.Cell(i, 5).Range.Text);
UserNotes note = new UserNotes();
if (userNotes.Count != 0)
{
note = GetUserNote(paraNumber, work);
}
allSheldue.Add(new Sheldue(System.Windows.Visibility.Visible,
note.Para != null ? MaterialDesignThemes.Wpf.PackIconKind.NoteMultipleOutline : MaterialDesignThemes.Wpf.PackIconKind.NoteAddOutline,
$"Para{paraNumber}",
paraNumber,
work,
teacher,
auditoria,
note));
}
}
catch
{
continue;
}
}
}
}
}
}
catch (Exception ex)
{
int lineEx = new System.Diagnostics.StackTrace(ex, true).GetFrame(0).GetFileLineNumber();
IFCore.IFCore.loggerMain.Error("DAL => ParseWordFileStudentMethod class " + ex.ToString() + lineEx);
}
}
return(allSheldue);
}
catch (Exception ex)
{
doc.Close();
app.Quit();
int lineEx = new System.Diagnostics.StackTrace(ex, true).GetFrame(0).GetFileLineNumber();
IFCore.IFCore.loggerMain.Error("DAL => ParseWordFileStudentMethod class " + ex.ToString() + lineEx);
return(allSheldue);
}
finally
{
doc.Close();
app.Quit();
}
}
catch (Exception ex)
{
int lineEx = new System.Diagnostics.StackTrace(ex, true).GetFrame(0).GetFileLineNumber();
IFCore.IFCore.loggerMain.Error("DAL => ParseWordFileStudentMethod class " + ex.ToString() + lineEx);
}
return(allSheldue);
}
public bool AddNote(UserNotes Note, string InsertUser)
{
return(UDAL.AddNote(Note, InsertUser));
}
public async Task <IActionResult> UpdateNote([FromBody] IDictionary <string, string> noteModel)
{
UserNotes note = _clientNoteService.UpdateNote(noteModel["Note"], noteModel["NoteId"], noteModel["Modifiedby"]);
return(Ok(note));
}
public static void SetNotes(string userid, string notes)
{
UserNotes.AddOrUpdate(userid, notes, (olduserid, oldnote) => notes);
}
