//
// GET: /Product/
public ActionResult Index()
{
// 2 st. Category plockas fram/skapas och används i demo-syfte.
// Vi kan tänka oss att vi fått dessa som resultat av User Input
var categoryRepo = new Repository<Category>();
Category oldCategory = categoryRepo
.FindAll(c => c.Name.Contains("New"))
.OrderByDescending(c => c.ID)
.FirstOrDefault();
if (null == oldCategory) oldCategory = categoryRepo.FindAll().FirstOrDefault();
var newCategory = new Category
{
Name = string.Format("NewCategory - {0}",
DateTime.UtcNow.ToShortDateString())
};
// Nedanstående vill vi inte ha i ProductController - Dags att bryta ut
//
// I det här fallet så uppdaterar vi Category för alla produkter med oldCategory till newCategory.
// Vi skulle kunna tänka oss en större operation här - men detta duger i övningssyfte.
//
// Poängen är att detta är logik som inte direkt rör user input/output.
// Dvs: det bör inte ligga i Controller utan någonstanns i .Domain-projektet.
var filteredProducts = _productRepo
.FindAll(p => p.CategoryID == oldCategory.ID)
.ToList();
foreach (var productToUpdate in filteredProducts)
{
productToUpdate.Category = newCategory;
_productRepo.Save(productToUpdate);
}
return View();
}
public ActionResult About()
{
// Generiskt Repository - Här skapas ett repository för Category
// Repositoryt kräver typer som implementerar IEntity
Repository<Category> categoryRepo = new Repository<Category>();
// Samtliga metoder som finns med i det generiska repositoriet
var categories = categoryRepo.FindAll();
var filteredCategories = categoryRepo.FindAll(c => c.Name.Contains("sport"));
var category = categoryRepo.FindByID(0);
category.Name = "New Name!";
categoryRepo.Save(category);
categoryRepo.Delete(category);
ProductRepository productRepo = new ProductRepository();
var products = productRepo.FindAll(); // + övriga "grund"-metoder
// Metoder implementerade i ProductRepository:
var productsForCategory = productRepo.FindProductsByCategoryID(0);
var productsWithEmptyName = productRepo.FindAll(ProductRepository
.FilterProductsWithEmptyDescription);
return View();
}
private static async Task<IList<Product>> GetProductList()
{
var repo = new Repository<Product>("products");
var list = await repo.FindAll();
return list.OrderBy(x => x.ProductName)
.ToList();
}
private static async Task<IList<Mosque>> GetMosqueList()
{
var repo = new Repository<Mosque>("mosques");
var list = await repo.FindAll();
return list.OrderBy(x => x.Name)
.ToList();
}
public void DetachedCriteria_AddIsInRange()
{
var crit =
DetachedCriteria.For <User>()
.AddInRange(DateTime.Now, "ActivePeriod.Start", "ActivePeriod.End");
var loaded = Repository <User> .FindAll(crit);
Assert.IsTrue(loaded.Count > 0);
loaded.RunEach(log.Debug);
}
public void ShowQuestions(int id)
{
Subject subject = Repository <Subject> .Load(id);
ICollection <Question> questions = Repository <Question> .FindAll(
Where.Question.Subject == subject);
PropertyBag["subject"] = subject;
PropertyBag["questions"] = PaginationHelper.CreatePagination(this,
questions, 15);
}
public static bool IsAuthorizedCompany(HttpContextBase context/*, Guid EventID*/)
{
var userRepo = new Repository<User>();
var user = userRepo.FindAll(u => u.UserName.ToLower() == context.User.Identity.Name.ToLower()).FirstOrDefault();
//var EventOwnerID = user.UserName;
if (user == null)
return false;
else
return true;
//user == null ? false : user.ID == EventID;
}
public void DetachedCriteria_AddIsOverlap_IsEndOpenRange()
{
var loaded =
Repository <User> .FindAll(DetachedCriteria.For <User>()
.AddIsOverlap(new TimeRange(DateTime.Now, null),
"ActivePeriod.Start",
"ActivePeriod.End"));
Assert.IsTrue(loaded.Count > 0);
loaded.RunEach(log.Debug);
}
//
// GET: /Product/
public ActionResult Index()
{
// 2 st. Category plockas fram/skapas och används i demo-syfte.
// Vi kan tänka oss att vi fått dessa som resultat av User Input
var categoryRepo = new Repository <Category>();
Category oldCategory = categoryRepo
.FindAll(c => c.Name.Contains("New"))
.OrderByDescending(c => c.ID)
.FirstOrDefault();
if (null == oldCategory)
{
oldCategory = categoryRepo.FindAll().FirstOrDefault();
}
var newCategory = new Category
{
Name = string.Format("NewCategory - {0}",
DateTime.UtcNow.ToShortDateString())
};
// Nedanstående vill vi inte ha i ProductController - Dags att bryta ut
//
// I det här fallet så uppdaterar vi Category för alla produkter med oldCategory till newCategory.
// Vi skulle kunna tänka oss en större operation här - men detta duger i övningssyfte.
//
// Poängen är att detta är logik som inte direkt rör user input/output.
// Dvs: det bör inte ligga i Controller utan någonstanns i .Domain-projektet.
var filteredProducts = _productRepo
.FindAll(p => p.CategoryID == oldCategory.ID)
.ToList();
foreach (var productToUpdate in filteredProducts)
{
productToUpdate.Category = newCategory;
_productRepo.Save(productToUpdate);
}
return(View());
}
public void DetachedCriteria_AddIsOverlap_IsOverlap_HasRange()
{
var loaded =
Repository <User> .FindAll(DetachedCriteria.For <User>()
.AddIsOverlap(new TimeRange(DateTime.Now.AddHours(-1), DurationUtil.Hours(2)),
"ActivePeriod.Start",
"ActivePeriod.End"));
Assert.IsTrue(loaded.Count > 0);
loaded.RunEach(log.Debug);
}
public void Index(bool isAjax)
{
PropertyBag["subjects"] = PaginationHelper.CreateCachedPagination(
this, Action, 15, delegate
{
return(new List <Subject>(Repository <Subject> .FindAll()).ToArray());
});
if (isAjax)
{
RenderView("index.brailjs");
}
}
public List <Ciudad> GetDataCiudadesAll()
{
List <Ciudad> lista = new List <Ciudad>();
IRepository <SGV.Models.Ciudad> repository = new Repository <SGV.Models.Ciudad>();
var res = repository.FindAll();
foreach (var item in res)
{
lista.Add(TranslateCiudadTableToCiudadEntity(item));
}
return(lista);
}
public List <Persona> GetDataPersonasAll()
{
List <Persona> lista = new List <Persona>();
IRepository <SGV.Models.Persona> repository = new Repository <SGV.Models.Persona>();
var res = repository.FindAll();
foreach (var item in res)
{
lista.Add(TranslatePersonaTableToPersonaEntity(item));
}
return(lista);
}
public List <Producto> GetProductsByName(string nombre)
{
List <Producto> listaproductos = new List <Producto>();
IRepository <SGP.Models.Producto> repository = new Repository <SGP.Models.Producto>();
var query = repository.FindAll(x => x.nombre.Contains(nombre));
foreach (var item in query)
{
listaproductos.Add(TranslateTblProductoToProductoEntity(item));
}
return(listaproductos);
}
public IEnumerable <User> GetUsers()
{
try
{
var users = repo.FindAll(u => !u.IsDeleted);
return(users);
}
catch (Exception)
{
throw;
}
}
/// <summary>Tests the functionality of the <see cref="FileRepository{T}.ReadAllRecordsFromFile(FileInfo,DataSourceInfo)"/> method when
/// reading an empty file.</summary>
/// <param name="sourceInfo">The source info that is used to create the repository.</param>
protected void ReadEmptyFile(DataSourceInfo sourceInfo)
{
/* Create the repository */
Repository <TestDummy> repository = this.CreateRepository <TestDummy>(sourceInfo);
/* Retrieve all entities. This forces the repository to read the file */
IEnumerable <TestDummy> results = repository.FindAll();
/* Check if the contents were read correctly */
Assert.IsNotNull(results);
Assert.AreEqual(0, results.Count());
}
public void CanFindAllMatchingCriteriaWithMultipleSortOrders()
{
Parent secondPosition = CreateExampleParentObjectInDb("ThisTestOnly", 3);
Parent firstPosition = CreateExampleParentObjectInDb("ThisTestOnly", 9999);
CreateExampleParentObjectInDb("NoMatch", 5);
ICollection <Parent> loaded
= Repository <Parent> .FindAll(WhereNameEquals("ThisTestOnly"), OrderByNameAndAgeDescending);
AssertCollectionsEqual(ExpectedList(firstPosition, secondPosition), loaded);
}
private void ImportDays(List <DailyInputDto> dailyInputs)
{
//Get days
var days = dailyInputs
.Select(di => di.Day)
.Distinct()
.OrderBy(d => d)
.ToList();
//Get db days
var dbDays = Repository
.FindAll <Day>()
.ToList();
//Select new days
var newDays = days
.Where(d => !dbDays.Any(dbd => dbd.Date == d))
.Select(d => new Day {
Date = d
})
.ToList();
Repository.InsertAll(newDays);
//Get all
dbDays = Repository
.FindAll <Day>()
.ToList();
//Update numbering
int no = 1;
foreach (var day in dbDays.OrderBy(d => d.Date))
{
day.Number = no++;
}
//Save changes
Repository.UpdateAll <Day>();
}
public void FindAll_WillNotRemoveDuplicates()
{
ICollection <Parent> loaded = Repository <Parent> .FindAll();
foreach (Parent parent in loaded)
{
Console.WriteLine(parent.ToString(true));
}
Assert.AreEqual(parentsInDB.Count, loaded.Count, "Children 속성의 bag 값의 fetch mode가 join이므로 child 갯수만큼 parent 수도 중복되어 가져온다.");
Assert.AreEqual(parentsInDB.Count, loaded.Distinct().Count());
}
public Request Receive()
{
Request result = null;
while (result == null)
{
var request = Repository.FindAll()
.Where(e => e.Status == RequestStatus.InQueue)
.FirstOrDefault();
result = request;
}
return(result);
}
public IList<UserDto> GetAll()
{
IList<UserDto> userDtos = null;
using (ISession session = _sessionFactory.OpenSession())
{
IRepository<User> userRepository = new Repository<User>(session);
var users = userRepository.FindAll().List();
userDtos = Mapper.Map<IList<UserDto>>(users);
}
return userDtos;
}
public IList <GroupDto> GetAll()
{
IList <GroupDto> groupDtos = null;
using (ISession session = _sessionFactory.OpenSession())
{
IRepository <Group> groupRepository = new Repository <Group>(session);
var groups = groupRepository.FindAll().List();
groupDtos = Mapper.Map <IList <GroupDto> >(groups);
}
return(groupDtos);
}
public IList <UserDto> GetAllInGroup(Guid groupId)
{
IList <UserDto> userDtos = null;
using (ISession session = _sessionFactory.OpenSession())
{
IRepository <User> userRepository = new Repository <User>(session);
var users = userRepository.FindAll(x => x.Group.Id == groupId).List();
userDtos = Mapper.Map <IList <UserDto> >(users);
}
return(userDtos);
}
private void AddRoleClaims(ClaimsPrincipal incomingPrinicipal)
{
Repository <AspNetUser> repository = new Repository <AspNetUser>(new SportsEntities());
AspNetUser aspNetUser = repository.FindAll(u => u.UserName == incomingPrinicipal.Identity.Name).First <AspNetUser>();
foreach (AspNetRole aspNetRole in aspNetUser.AspNetRoles)
{
foreach (BSPN.Data.Claim securityClaim in aspNetRole.Claims)
{
((ClaimsIdentity)incomingPrinicipal.Identity).AddClaim(new System.Security.Claims.Claim(securityClaim.ClaimType, securityClaim.ClaimValue));
}
}
}
public IList<GroupDto> GetAll()
{
IList<GroupDto> groupDtos = null;
using (ISession session = _sessionFactory.OpenSession())
{
IRepository<Group> groupRepository = new Repository<Group>(session);
var groups = groupRepository.FindAll().List();
groupDtos = Mapper.Map<IList<GroupDto>>(groups);
}
return groupDtos;
}
public List <Producto> GetProducts()
{
List <Producto> listaproductos = new List <Producto>();
IRepository <SGP.Models.Producto> repository = new Repository <SGP.Models.Producto>();
var lista = repository.FindAll();
foreach (var item in lista)
{
listaproductos.Add(TranslateTblProductoToProductoEntity(item));
}
return(listaproductos);
}
public IEnumerable <OfficeHoursTeacherAvailability> GetAvailabilities(int ohId)
{
OfficeHoursTeacherAvailability x = null;
OfficeHours oh = null;
LmsUser u = null;
var defaultQuery = new DefaultQueryOver <OfficeHoursTeacherAvailability, int>()
.GetQueryOver(() => x)
.JoinAlias(() => x.Meeting, () => oh, JoinType.InnerJoin)
.JoinAlias(() => x.User, () => u, JoinType.InnerJoin)
.Where(() => x.Meeting.Id == ohId);
return(Repository.FindAll(defaultQuery));
}
public bool ConfirmAccount(string Id)
{
var userRepo = new Repository <User>();
var currentUser = userRepo.FindAll(u => u.ConfirmationToken == Id).FirstOrDefault();
if (currentUser != null)
{
currentUser.IsConfirmed = true;
userRepo.Update(currentUser);
return(true);
}
return(false);
}
/// <summary>Tests the functionality of the <see cref="FileRepository{T}.WriteAllRecordsToFile(FileInfo,DataSourceInfo,IEnumerable{T})"/>
/// method when writing an empty file.</summary>
/// <param name="sourceInfo">The source info that is used to create the repository.</param>
/// <param name="templatePath">The path to the file that serves as a template to check the output of the repository.</param>
protected void WriteEmptyFile(DataSourceInfo sourceInfo, string templatePath)
{
Repository <TestDummy> repository = this.CreateRepository <TestDummy>(sourceInfo);
/* Retrieve all entities. This forces the repository to read the file */
IEnumerable <TestDummy> results = repository.FindAll();
repository.DeleteEntities(results);
repository.SaveChanges();
TestCaseHelper.CheckTestResult(templatePath, FileSourceInfo.SelectSourceFileInfo(sourceInfo).FullName);
}
public Message ReplyTwitterDirectMessage(int conversationId, string message, bool isCloseConversation = false)
{
var twitterService = DependencyResolver.Resolve <ITwitterService>();
Conversation conversation = _conversationService.CheckIfExists(conversationId);
if (conversation.Source != ConversationSource.TwitterDirectMessage)
{
throw SocialExceptions.BadRequest("Conversation source must be twitter direct message.");
}
_conversationService.CheckIfCanReopenWhenReply(conversation);
var messages = Repository.FindAll().Include(t => t.Sender).Include(t => t.Receiver).Where(t => t.ConversationId == conversation.Id).ToList();
SocialAccount twitterAccount = GetSocialAccountFromMessages(messages);
if (twitterAccount == null)
{
throw SocialExceptions.BadRequest($"Twitter account has been deleted.");
}
var customer = messages.Where(t => t.IsDeleted == false && t.Sender.Type == SocialUserType.Customer)
.OrderByDescending(t => t.SendTime).Select(t => t.Sender).FirstOrDefault();
if (customer == null)
{
throw new NotSupportedException($"Cant't find last message from conversation. Conversation Id={conversationId}.");
}
IUser prviousTwitterUser = twitterService.GetUser(twitterAccount, long.Parse(customer.OriginalId));
if (prviousTwitterUser == null)
{
throw new NotSupportedException($"Cant't find twitter user. Conversation Id={conversationId}.");
}
// publish twitter direct message
IMessage twitterDirectMessage = twitterService.PublishMessage(twitterAccount, prviousTwitterUser, message);
// create message to db
Message directMessage = TwitterConverter.ConvertToMessage(twitterDirectMessage);
directMessage.ConversationId = conversation.Id;
directMessage.SenderId = twitterAccount.Id;
directMessage.SendAgentId = UserContext.UserId;
directMessage.ReceiverId = customer.Id;
Save(directMessage, isCloseConversation);
return(this.Find(directMessage.Id));
}
public IEnumerable <Review> GetAllReviews()
{
// TODO: implement new version
//var allReviews = revRepo.FindAll();
//List<ReviewInfo> infos = new List<ReviewInfo>();
//foreach (var review in allReviews)
//{
// ReviewInfo info = new ReviewInfo();
// Mapper.Map(ref review, ref info);
// infos.Add(info);
//}
//throw new NotImplementedException();
return(revRepo.FindAll());
}
private async Task <TwitterAuth> FindAndDeleteAsync(string authorizationId)
{
var auth = Repository.FindAll().Where(t => t.AuthorizationId == authorizationId).FirstOrDefault();
if (auth != null)
{
await UnitOfWorkManager.RunWithNewTransaction(CurrentUnitOfWork.GetSiteId(), async() =>
{
await Repository.DeleteAsync(auth.Id);
});
}
return(auth);
}
public IList FindAll()
{
var userRepository = new Repository();
try
{
return(userRepository.FindAll(this));
}
catch (Exception ex)
{
Console.WriteLine(ex);
throw;
}
}
private void getSqlTemplateList(out List <MailTemplate> getTemplateList, out string message)
{
getTemplateList = null;
message = null;
try
{
IRepository <MailTemplate, int> newRepo = new Repository <MailTemplate, SqlDbContext, int>(new SqlDbContext());
getTemplateList = newRepo.FindAll();
message = Message.Message_OK;
}
catch (Exception ex)
{
message = ex.Message;
}
}
private void getSqlDbServerList(out List <EM_ServerConnect> getDbServerList, out string message)
{
getDbServerList = null;
message = null;
try
{
IRepository <EM_ServerConnect, int> newRepo = new Repository <EM_ServerConnect, SqlDbContext, int>(new SqlDbContext());
getDbServerList = newRepo.FindAll();
message = Message.Message_OK;
}
catch (Exception ex)
{
message = ex.Message;
}
}
public void Load()
{
var locales = Repository <Locale> .FindAll();
Assert.IsNotNull(locales);
Assert.Greater(locales.Count, 0);
foreach (Locale locale in locales)
{
if (locale.Id != CultureInfo.InvariantCulture)
{
Assert.IsNotEmpty(locale.Name, "locale.Name is empty. locale=" + locale);
}
}
}
public IEnumerable <OfficeHoursSlot> GetSlotsForDate(DateTime start, DateTime end, int ohId)
{
OfficeHoursTeacherAvailability availability = null;
OfficeHoursSlot x = null;
OfficeHours oh = null;
LmsUser u = null;
var defaultQuery = new DefaultQueryOver <OfficeHoursSlot, int>()
.GetQueryOver(() => x)
.JoinAlias(() => x.User, () => u, JoinType.InnerJoin)
.JoinAlias(() => x.Availability, () => availability, JoinType.InnerJoin)
.JoinAlias(() => availability.Meeting, () => oh, JoinType.InnerJoin)
.Where(() => x.Start >= start && x.Start < end && oh.Id == ohId);
return(Repository.FindAll(defaultQuery));
}
public string Delete(string argument)
{
AjaxResult ajaxResult = new AjaxResult();
string errorMsg = string.Empty;
DoResult doResult = DoResult.Failed;
string actionMessage = string.Empty;
try
{
if (!string.IsNullOrWhiteSpace(argument))
{
string roleID = argument;
IRepository<string> repository = new Repository<string>();
IDictionary<string, object> parameters = new Dictionary<string, object>();
parameters.SafeAdd("RoleID", roleID);
IList<ObjectRole> objectRoleList = repository.FindAll<ObjectRole>(parameters);
if (objectRoleList.Count == 0)
{
repository.Delete<Role>(roleID);
repository.ExecuteSql<RolePrivilege>(string.Format("Delete from AC_RolePrivilege where RoleID='{0}'", roleID));
doResult = DoResult.Success;
actionMessage = RemarkAttribute.GetEnumRemark(doResult);
}
else
{
doResult = DoResult.Failed;
actionMessage = "请先解除该角色与操作员的关联！";
}
ajaxResult.RetValue = CurrentId;
ajaxResult.PromptMsg = actionMessage;
}
ajaxResult.Result = doResult;
}
catch (Exception ex)
{
actionMessage = RemarkAttribute.GetEnumRemark(doResult);
log.Error(actionMessage, ex);
}
return JsonConvert.SerializeObject(ajaxResult);
}
public string CreateConfirmationToken(string UserName)
{
var userRepo = new Repository<User>();
var currentUser = userRepo.FindAll(u => u.UserName == UserName).FirstOrDefault();
currentUser.ConfirmationToken = Guid.NewGuid().ToString();
userRepo.Update(currentUser);
return currentUser.ConfirmationToken;
}
public bool ConfirmAccount(string Id)
{
var userRepo = new Repository<User>();
var currentUser = userRepo.FindAll(u => u.ConfirmationToken == Id).FirstOrDefault();
if (currentUser != null)
{
currentUser.IsConfirmed = true;
userRepo.Update(currentUser);
return true;
}
return false;
}
