/// <summary>
/// this function will create a new registry in the database for specific user settings
/// </summary>
/// <param name="user">the specific user</param>
/// <param name="menuItem">the menu item</param>
public void GenerateSpecificMenuSettingForUser(User user, MenuItem menuItem)
{
#region ActionLog
//we format the log action for the element
String logAction = String.Format("S-a generat setarea specifica pentru inregistrare {0} din meniu pentru utilizatorul {1}",
menuItem.MenuDisplay,
user.DisplayName);
//we generate the log Command
String logCommand = String.Format("INSERT INTO settings.meniu_utilizator(utilizator_id, inregistrare_meniu, activ) " +
"VALUES({0},{1},{2})",
user.ID,
menuItem.MenuItemID,
menuItem.IsActive);
//we generate the Computer IP
String IP = MentorBilling.Miscellaneous.IPFunctions.GetWANIp();
#endregion
MeniuUtilizator meniuUtilizator = new MeniuUtilizator
{
UtilizatorId = user.ID,
InregistrareMeniu = menuItem.MenuItemID,
Activ = menuItem.IsActive
};
base.MeniuUtilizator.Add(meniuUtilizator);
base.LogActiuni.Add(ActionLog.LogAction(logAction, IP, logCommand));
base.SaveChanges();
}
/// <summary>
/// this function will update a given specific menu item into the database
/// </summary>
/// <param name="user">the given user</param>
/// <param name="menuItem">the specific menu item</param>
public void UpdateSpecificMenuSettingForUser(User user, MenuItem menuItem)
{
#region ActionLog
//the main log display
String logAction = $"S-a actualizat starea setari {menuItem.MenuDisplay} pentru utilizatorul {user.DisplayName}";
String logCommand = $"UPDATE settings.meniu_utilizator SET activ = {menuItem.IsActive} " +
$"WHERE utilizator_id = {user.ID} AND inregistrare_meniu = {menuItem.MenuItemID}";
//the local element IP
String IP = MentorBilling.Miscellaneous.IPFunctions.GetWANIp();
#endregion
MeniuUtilizator meniuUtilizator = base.MeniuUtilizator.Where(element => element.UtilizatorId == user.ID && element.InregistrareMeniu == menuItem.MenuItemID).FirstOrDefault();
meniuUtilizator.Activ = menuItem.IsActive;
base.Update(meniuUtilizator);
base.LogActiuni.Add(ActionLog.LogAction(logAction, IP, logCommand));
base.SaveChanges();
}
