public MessageResultDto UpdateGroup(Guid id, string name)
{
var result = new MessageResultDto();
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository <Group> groupRepository = new Repository <Group>(session);
var existingGroup = groupRepository.FindOne(x => x.Id != id, new Tuple <Expression <Func <Group, object> >, string>(x => x.Name, name));
if (null == existingGroup)
{
var group = groupRepository.FindOne(x => x.Id == id);
group.Name = name;
groupRepository.Update(group);
transaction.Commit();
result.SuccessMessage("Group updated successfully", group.Id);
}
else
{
result.ErrorMessage("Group with same name already exisits");
}
}
return(result);
}
private static void WrongUrl(string MainUrl, Exception ex)
{
Console.WriteLine(ex.InnerException);
var result = Repository.FindOne(x => x.UrlName == MainUrl);
result.IsVisited = true;
result.IsWrong = true;
result.LastTime = DateTime.Now;
Repository.Edit(result);
}
public ActionResult StartRequest(int id_request)
{
System.Linq.Expressions.Expression <Func <Request, bool> >
expr = x => x.Id == id_request;
Request request = requestContext.FindOne(expr);
if (request == null)
{
return(RedirectToAction("Index", "Home"));
}
return(View(request));
}
public virtual void DeleteFor(T data, string ruleSet = null)
{
var castedDto = data as IDataTransferObject;
if (castedDto == null)
{
throw new InvalidOperationException("Cannot use this method with data parameter is not implement IDataTransferObject interface.");
}
U entity = Repository.FindOne(e => e.Id == castedDto.Id);
if (entity == null)
{
throw new InvalidOperationException(String.Format("The row with id \"{0}\" is not found.", castedDto.Id));
}
OnDeletingEntity(data, entity);
if (UseAutoValidate)
{
((IAutoValidable)entity).Validate(ruleSet);
Repository.Remove(entity);
}
else
{
Repository.Remove(entity);
}
}
public void FindOne_Will_Throws_NonUniqueResult()
{
CreateParentObjectInDB("Parent1", 1);
Console.WriteLine("Count of Parent which name is 'Parent1' : " + Repository <Parent> .Count(WhereNameIn("Parent1")));
Repository <Parent> .FindOne(WhereNameIn("Parent1"));
}
/// <summary>
/// Show individual film.
/// </summary>
/// <param name="id">Id of the film.</param>
public ActionResult Details(int id)
{
ViewBag.Shows = _showRepository.FindAllWhere(show => show.Film.Id == id);
ViewBag.Crew = _crewMappingRepository.FindAllWhere(mapping => mapping.Film.Id == id);
return(View(Repository.FindOne(id)));
}
public MessageResultDto AddGroup(string name)
{
Group group = null;
var result = new MessageResultDto();
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository<Group> groupRepository = new Repository<Group>(session);
var existingGroup = groupRepository.FindOne(new Tuple<Expression<Func<Group, object>>, string>(x => x.Name, name));
if (null == existingGroup)
{
group = new Group { Name = name };
groupRepository.Add(group);
transaction.Commit();
result.SuccessMessage("Group added successfully", group.Id);
}
else
{
result.ErrorMessage("Group with same name already exisits");
}
}
return result;
}
public virtual void UpdateWith(T data, string ruleSet = null)
{
var castedDto = data as IDataTransferObject;
if (castedDto == null)
{
throw new InvalidOperationException("Cannot use this method with data parameter is not implement IDataTransferObject interface.");
}
U entity = Repository.FindOne(castedDto.Id);
Mapper.Fill(data as T, entity);
if (entity == null)
{
throw new InvalidOperationException(String.Format("The row with id \"{0}\" is not found.", castedDto.Id));
}
OnSavingEntity(data, entity);
if (UseAutoValidate)
{
Repository.SaveWithValidate(entity, ruleSet);
}
else
{
Repository.Save(entity);
}
}
private static Zone LoadCubeFromDatabase()
{
var repository = new Repository();
var zone = repository.FindOne <Zone>(o => o.Name == "Aldest");
return(zone);
}
public void FindFirstWillThrowExceptionWhereMoreThanOneMatch()
{
//create another object named Parent1
CreateExampleParentObjectInDb("Parent1", 1);
Repository <Parent> .FindOne(WhereNameEquals("Parent1"));
}
public static Exit GetExitByName(string exitName)
{
var repository = new Repository();
var exitId = (int)typeof(ExitTemplate).GetField(exitName).GetValue(null);
return(repository.FindOne <Exit>(o => o.ExitTemplate.Id == exitId));
}
public MessageResultDto AddUser(string firstname, string lastname, string nickname, string username, string password, Guid groupId)
{
var result = new MessageResultDto();
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository<Group> groupRepository = new Repository<Group>(session);
var group = groupRepository.FindOne(x => x.Id == groupId);
IRepository<User> userRepository = new Repository<User>(session);
var existingUser = userRepository.FindOne(x => x.Username == username);
if (null == existingUser)
{
userRepository.Add(new User
{
FirstName = firstname,
LastName = lastname,
Nickname = nickname,
Username = username,
Password = password,
Group = group
});
transaction.Commit();
}
else
{
result.ErrorMessage("User with same username already exists");
}
}
return result;
}
/// <summary>
/// Remove user from database
/// </summary>
public async void OnDeletedCommandExecuted(object sender)
{
var obj = (sender as Button).BindingContext;
var id = (obj as User).DbId;
int userId = Convert.ToInt32(id);
var user = Repository.FindOne <User>(userId);
if (user == null)
{
await App.Current.MainPage.DisplayAlert("Error!", "User doesn't exist or has been deleted.", "Ok");
RemoveItemFromList(userId);
return;
}
IsBusy = true;
try
{
await Repository.SyncDelete(user);
RemoveItemFromList(userId);
}
catch (Exception ex)
{
await DisplayError(ex.Message);
}
finally
{
IsBusy = false;
}
}
public MessageResultDto AddGroup(string name)
{
Group group = null;
var result = new MessageResultDto();
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository <Group> groupRepository = new Repository <Group>(session);
var existingGroup = groupRepository.FindOne(new Tuple <Expression <Func <Group, object> >, string>(x => x.Name, name));
if (null == existingGroup)
{
group = new Group {
Name = name
};
groupRepository.Add(group);
transaction.Commit();
result.SuccessMessage("Group added successfully", group.Id);
}
else
{
result.ErrorMessage("Group with same name already exisits");
}
}
return(result);
}
/// <summary>
/// Edit a film.
/// </summary>
/// <param name="id">Id of the film.</param>
public ActionResult Edit(int id)
{
Film model = Repository.FindOne(id);
ViewBag.Genre = new SelectList(_genreRepository.FindAll(), "Id", "Name", model.Genre.Id);
return(View(model));
}
public MessageResultDto UpdateUser(Guid id, string firstname, string lastname, string nickname, string username, Guid groupId)
{
var result = new MessageResultDto();
result.Message = "User updated successfully";
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository <User> userRepository = new Repository <User>(session);
var user = userRepository.FindOne(x => x.Id == id);
if (user.Group.Id == groupId)
{
IRepository <Group> groupRepository = new Repository <Group>(session);
var group = groupRepository.FindOne(x => x.Id == groupId);
user.Group = group;
}
user.FirstName = firstname;
user.LastName = lastname;
user.Nickname = nickname;
user.Username = username;
userRepository.Add(user);
transaction.Commit();
}
return(result);
}
/// <summary>
/// Edit a show.
/// </summary>
/// <param name="id">Id of the show.</param>
public ActionResult Edit(int id)
{
Show show = Repository.FindOne(id);
ViewBag.Film = new SelectList(_filmRepository.FindAll(), "Id", "Title", show.Film.Id);
return(View(show));
}
private void Update_Click(object sender, EventArgs e)
{
if (!Validate())
{
return;
}
var DbUser = Repository.FindOne <User>(x => x.Email.Equals(Email));
DbUser.FirstName = FirstName.Text;
DbUser.LastName = LastName.Text;
DbUser.About = About.Text;
DbUser.ImageSource = ImageSource;
Repository.SaveOrUpdate(DbUser);
AlertDialog.Builder dialog = new AlertDialog.Builder(this);
AlertDialog alert = dialog.Create();
alert.SetIcon(Resource.Drawable.sound);
alert.SetTitle("Success");
alert.SetMessage("User Updated succesfully \n do you want to Go back");
alert.SetButton("ListView", (s, ev) =>
{
StartActivity(typeof(ListViewActivity));
});
alert.SetButton2("No", (s, ev) =>
{
return;
});
alert.Show();
}
private async void OnDatabasePlayer([FromSource] Player player, int id)
{
var response = Repository <Shared.Entity.Player> .FindOne(e => e.SteamId == player.Identifiers.FirstOrDefault());
var json = JsonConvert.SerializeObject(response);
player.TriggerEvent("fivelife.database.response", id, json);
}
/// <summary>
/// Show individual order.
/// </summary>
/// <param name="id">Id of the order.</param>
public ActionResult Details(int id)
{
Order order = Repository.FindOne(id);
order.Tickets = _ticketRepository.FindAllWhere(ticket => ticket.Order == id);
return(View(order));
}
public void FindOne_With_Expression()
{
var founded = Repository <Parent> .FindOne(parent => parent.Name == "Parent1");
Assert.AreEqual(parentsInDB[0], founded);
Assert.IsFalse(Repository <Parent> .IsTransient(founded));
}
public void FindOne_With_Criterion()
{
var founded = Repository <Parent> .FindOne(new[] { Restrictions.Eq("Name", parentsInDB[0].Name) });
Assert.AreEqual(parentsInDB[0].Id, founded.Id);
Assert.IsFalse(Repository <Parent> .IsTransient(founded));
}
public virtual T FindBy(object id)
{
var entity = Repository.FindOne(id);
var transfer = Mapper.Convert(entity);
OnReadingEntity(transfer, entity);
return(transfer);
}
public virtual T FindBy(Expression <Func <U, bool> > predicate)
{
var entity = Repository.FindOne(predicate);
var transfer = Mapper.Convert(entity);
OnReadingEntity(transfer, entity);
return(transfer);
}
public virtual T FindBy(Specification <U> spec)
{
var entity = Repository.FindOne(spec);
var transfer = Mapper.Convert(entity);
OnReadingEntity(transfer, entity);
return(transfer);
}
public void FindOne_Will_Throws_NonUniqueResult()
{
CreateParentObjectInDB("Parent1", 1);
Console.WriteLine("Count of Parent which name is 'Parent1' : " + Repository <Parent> .Count(WhereNameIn("Parent1")));
// 해당 이름을 가진 데이터가 2개 이상이므로, 유일하지 않다는 예외가 발생한다.
//
Assert.Throws <NonUniqueResultException>(() => Repository <Parent> .FindOne(WhereNameIn("Parent1")));
}
public void DetachedCriteria_AddEqOrNull()
{
foreach (var parent in parentsInDB)
{
var loaded = Repository <Parent> .FindOne(ParentDetachedCriteria.AddEqOrNull("Name", parent.Name));
Assert.IsNotNull(loaded);
Assert.AreEqual(parent.Name, loaded.Name);
}
}
private void OnLoginClick(object sender, EventArgs e)
{
if (!Validate())
{
return;
}
var UserFind = Repository.FindOne <User>(x => x.Email.Equals(Email.Text.ToString()));
if (UserFind == null)
{
Android.App.AlertDialog.Builder dialog = new AlertDialog.Builder(this);
AlertDialog alert = dialog.Create();
alert.SetTitle("User Not Found");
alert.SetMessage("User is not registered");
alert.SetIcon(Resource.Drawable.sound);
alert.SetButton("Register", (c, ev) =>
{
StartActivity(typeof(Resources.Activities.RegisterActivity));
});
alert.SetButton2("Retry", (c, ev) =>
{
return;
});
alert.Show();
}
else
{
UserFind = Repository.Find <User>(x => x.Email.Equals(Email.Text) && x.Password.Equals(Password.Text)).FirstOrDefault();
if (UserFind == null)
{
Android.App.AlertDialog.Builder dialog = new AlertDialog.Builder(this);
AlertDialog alert = dialog.Create();
alert.SetTitle("Incorrect Password");
alert.SetMessage("Password is incorrect");
alert.SetIcon(Resource.Drawable.sound);
alert.SetButton("Retry", (c, ev) =>
{
return;
});
alert.Show();
}
else
{
ISharedPreferences prefs = PreferenceManager.GetDefaultSharedPreferences(this);
ISharedPreferencesEditor editor = prefs.Edit();
editor.PutString("shared_Email", UserFind.Email);
editor.PutString("shared_FName", UserFind.FirstName);
editor.Apply();
StartActivity(typeof(ListViewActivity));
}
}
}
public CmsPageLanguageInfo FetchPageInfo(IRepository <CmsPageLanguageInfo> langRepository, CmsPage page, CmsLanguage pageLanguage)
{
langRepository = new Repository <CmsPageLanguageInfo>();
Dictionary <string, object> searchvaluepair = new Dictionary <string, object>();
searchvaluepair.Add("PageId", page.Id);
searchvaluepair.Add("LanguageShortCode", pageLanguage.shortCode);
CmsPageLanguageInfo foundLanguageInfo = langRepository.FindOne(searchvaluepair);
return(foundLanguageInfo);
}
private static void GetSitesData(string Url)
{
var uri = new Uri(Url);
HtmlWeb web = new HtmlWeb();
HtmlDocument doc = web.Load(Url);
var result = RepositorySite.FindOne(x => x.Url == uri.Host);
if (result == null)
{
RepositorySite.Save(new Site(uri.Host, doc.DocumentNode.OuterHtml, GetTtitle(doc), GetDescription(doc)));
}
}
public LoggedUserInfoDto ValidateUser(string username, string password)
{
LoggedUserInfoDto userDto = null;
using (ISession session = _sessionFactory.OpenSession())
{
IRepository <User> userRepository = new Repository <User>(session);
var user = userRepository.FindOne(x => x.Username == username && x.Password == password && !x.IsLocked);
userDto = Mapper.Map <LoggedUserInfoDto>(user);
}
return(userDto);
}
public UserDto GetSingle(Guid id)
{
UserDto userDto = null;
using (ISession session = _sessionFactory.OpenSession())
{
IRepository <User> userRepository = new Repository <User>(session);
var user = userRepository.FindOne(id);
userDto = Mapper.Map <UserDto>(user);
}
return(userDto);
}
public MessageResultDto UpdateGroup(Guid id, string name)
{
var result = new MessageResultDto();
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository<Group> groupRepository = new Repository<Group>(session);
var group = groupRepository.FindOne(x => x.Id == id);
group.Name = name;
groupRepository.Update(group);
transaction.Commit();
}
return result;
}
public MessageResultDto DeleteGroup(Guid id)
{
var result = new MessageResultDto();
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository<Group> groupRepository = new Repository<Group>(session);
var group = groupRepository.FindOne(id);
if (group.Users.Count > 0)
{
result.ErrorMessage("Group has got users registered. Please remove the user(s) from the group first.");
}
else
{
groupRepository.Delete(id);
transaction.Commit();
result.Message = "Group deleted successfully";
}
}
return result;
}
public MessageResultDto DeleteUser(Guid id)
{
var result = new MessageResultDto();
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository<User> userRepository = new Repository<User>(session);
var user = userRepository.FindOne(id);
if (user.Accounts.Count > 0)
{
result.ErrorMessage("User has got accounts registered. Please remove all accounts first");
}
else
{
userRepository.Delete(id);
transaction.Commit();
result.Message = "User deleted successfully";
}
}
return result;
}
public NhibernateDatabaseContext()
{
SessionFactory = CreateSessionFactory();
using (ISession session = SessionFactory.OpenSession())
using (var transaction = session.BeginTransaction())
{
var groupRepository = new Repository<Group>(session);
var group = groupRepository.FindOne(x => x.Name == _groupName);
if (group == null)
{
group = new Group
{
Name = _groupName,
IsSysAccount = true,
};
var user = new User
{
FirstName = "System",
LastName = "Administrator",
Username = "******",
Nickname = "SuperAdmin",
Password = "******",
Group = group,
};
groupRepository.Add(group);
(new Repository<User>(session)).Add(user);
transaction.Commit();
}
}
}
public MessageResultDto AddUser(string firstname, string lastname, string nickname, string username, Guid groupId)
{
User user;
var result = new MessageResultDto();
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository<Group> groupRepository = new Repository<Group>(session);
var group = groupRepository.FindOne(x => x.Id == groupId);
IRepository<User> userRepository = new Repository<User>(session);
var existingUser = userRepository.FindOne(new Tuple<Expression<Func<User, object>>, string>(x => x.Username, username));
if (null == existingUser)
{
user = new User
{
FirstName = firstname,
LastName = lastname,
Nickname = nickname,
Username = username,
Password = Constants.DEFAULT_PASSWORD,
Group = group
};
userRepository.Add(user);
transaction.Commit();
result.SuccessMessage("User added successfully", user.Id);
}
else
{
result.ErrorMessage("User with same username already exists");
}
}
return result;
}
public static Exit GetExitByName(string exitName)
{
var repository = new Repository();
var exitId = (int) typeof (ExitTemplate).GetField(exitName).GetValue(null);
return repository.FindOne<Exit>(o => o.ExitTemplate.Id == exitId);
}
public MessageResultDto UpdateGroup(Guid id, string name)
{
var result = new MessageResultDto();
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository<Group> groupRepository = new Repository<Group>(session);
var existingGroup = groupRepository.FindOne(x => x.Id != id, new Tuple<Expression<Func<Group, object>>, string>(x => x.Name, name));
if (null == existingGroup)
{
var group = groupRepository.FindOne(x => x.Id == id);
group.Name = name;
groupRepository.Update(group);
transaction.Commit();
result.SuccessMessage("Group updated successfully", group.Id);
}
else
{
result.ErrorMessage("Group with same name already exisits");
}
}
return result;
}
public GroupDto GetSingle(Guid id)
{
GroupDto groupDto = null;
using (ISession session = _sessionFactory.OpenSession())
{
IRepository<Group> groupRepository = new Repository<Group>(session);
var group = groupRepository.FindOne(id);
groupDto = Mapper.Map<GroupDto>(group);
}
return groupDto;
}
public UserDto GetSingle(Guid id)
{
UserDto userDto = null;
using (ISession session = _sessionFactory.OpenSession())
{
IRepository<User> userRepository = new Repository<User>(session);
var user = userRepository.FindOne(id);
userDto = Mapper.Map<UserDto>(user);
}
return userDto;
}
public MessageResultDto LockedStatus(Guid id, bool isLocked)
{
var result = new MessageResultDto();
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository<User> userRepository = new Repository<User>(session);
var user = userRepository.FindOne(id);
user.IsLocked = isLocked ;
transaction.Commit();
result.Message = string.Format("User has been {0} successsfully", isLocked ? "locked" : "unlocked");
}
return result;
}
public MessageResultDto ResetPassword(Guid id)
{
var result = new MessageResultDto();
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository<User> userRepository = new Repository<User>(session);
var user = userRepository.FindOne(id);
user.Password = Constants.DEFAULT_PASSWORD;
transaction.Commit();
result.Message = "Password has been reset successfully";
}
return result;
}
public LoggedUserInfoDto ValidateUser(string username, string password)
{
LoggedUserInfoDto userDto = null;
using (ISession session = _sessionFactory.OpenSession())
{
IRepository<User> userRepository = new Repository<User>(session);
var user = userRepository.FindOne(x => x.Username == username && x.Password == password);
userDto = Mapper.Map<LoggedUserInfoDto>(user);
}
return userDto;
}
public MessageResultDto UpdateUser(Guid id, string firstname, string lastname, string nickname, string username, string password, Guid groupId)
{
var result = new MessageResultDto();
using (ISession session = _sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
IRepository<User> userRepository = new Repository<User>(session);
var user = userRepository.FindOne(x => x.Id == id);
if (user.Group.Id == groupId)
{
IRepository<Group> groupRepository = new Repository<Group>(session);
var group = groupRepository.FindOne(x => x.Id == groupId);
user.Group = group;
}
user.FirstName = firstname;
user.LastName = lastname;
user.Nickname = nickname;
user.Username = username;
user.Password = password;
userRepository.Add(user);
transaction.Commit();
}
return result;
}
public string Delete(string operatorID)
{
AjaxResult ajaxResult = new AjaxResult();
string errorMsg = string.Empty;
DoResult doResult = DoResult.Failed;
string actionMessage = string.Empty;
try
{
if (!string.IsNullOrWhiteSpace(operatorID))
{
IRepository<string> repository = new Repository<string>();
UnitOfWork.ExecuteWithTrans<Operator>(() =>
{
repository.Delete<Operator>(operatorID);
IDictionary<string, object> parameters = new Dictionary<string, object>();
parameters.SafeAdd("OperatorID", operatorID);
Employee employee = repository.FindOne<Employee>(parameters);
repository.Delete<Employee>(parameters);
parameters.Clear();
parameters.SafeAdd("EmployeeID", employee.ID);
repository.Delete<EmployeeOrg>(parameters);
parameters.Clear();
parameters.SafeAdd("ObjectID", operatorID);
repository.Delete<ObjectRole>(parameters);
});
doResult = DoResult.Success;
//获取提示信息
actionMessage = RemarkAttribute.GetEnumRemark(doResult);
ajaxResult.RetValue = CurrentId;
ajaxResult.PromptMsg = actionMessage;
}
ajaxResult.Result = doResult;
}
catch (Exception ex)
{
actionMessage = RemarkAttribute.GetEnumRemark(doResult);
log.Error(actionMessage, ex);
}
return JsonConvert.SerializeObject(ajaxResult);
}
