public IEnumerable<DiveShortViewModel> GetShortDivesListByUserId(string userId)
{
using (EntityContext _context = new EntityContext())
{
try
{
var dives = _context.Dives.Where(d => d.User.Id == userId && d.Status)
.Include(d => d.Countries)
.OrderBy(d => d.DiveDate)
.ToArray()
.Select((d, n) => new DiveShortViewModel
{
DiveID = d.DiveID,
DiveNumber = n + 1,
CountryID = d.Countries.CountryKod,
CountryName = d.Countries.ValueEU,
DiveDate = d.DiveDate.ToString("dd/MM/yyyy"),
Depth = d.MaxDepth,
Time = d.TotalMinutes
}).Reverse();
return dives;
}
catch (Exception ex)
{
throw ex;
}
}
}
public bool Login(Account account)
{
try
{
using (var context = new EntityContext())
{
var user = context.Account.SingleOrDefault(x => x.userID == account.userID);
if (user != null)
{
user.sessionExpiresAt = account.sessionExpiresAt;
user.sessionID = account.sessionID;
}
else
{
context.Account.Add(account);
}
context.SaveChanges();
return true;
}
}
catch(Exception ex)
{
return false;
}
}
/// <summary>
/// Initializes a new instance of the <see cref="EntitySerializer"/> class.
/// </summary>
/// <param name="entityContext">
/// The entity context.
/// </param>
/// <param name="binaryWriter">
/// The binary writer.
/// </param>
/// <param name="root">
/// The root object.
/// </param>
/// <param name="serializingEntity">
/// The serializing entity delegate.
/// </param>
private EntitySerializer(EntityContext entityContext, BinaryWriter binaryWriter, object root, SerializingEntity serializingEntity)
: base(binaryWriter)
{
this.entityContext = entityContext;
this.root = root;
this.serializingEntity = serializingEntity;
}
public UnitOfWork(EntityContext pEntityContext)
{
this.aEntityContex=pEntityContext;
this.Cuentas = new CuentaRepository(this.aEntityContex);
this.Mensajes = new MensajeRepositoty(this.aEntityContex);
this.Servicios = new ServicioRepository(this.aEntityContex);
}
public IEnumerable<DiveGeoViewModel> GetDivesGeoData(User user)
{
using (EntityContext _context = new EntityContext())
{
try
{
var result = _context.Dives.Where(d => d.User.Id == user.Id && d.Status)
.Include(d => d.Photos)
.OrderBy(d => d.DiveDate)
.ToArray()
.Select((dive, i) => new DiveGeoViewModel()
{
DiveId = dive.DiveID,
DiveNumber = (i + 1),
DiveDate = dive.DiveDate.ToShortDateString(),
DiveComment = dive.Comments,
Depth = dive.MaxDepth.ToString(),
DiveTime = dive.TotalMinutes.ToString(),
Location = dive.Location,
CoordinateX = dive.DiveX.ToString(),
CoordinateY = dive.DiveY.ToString(),
HasPhotos = dive.Photos.Any()
});
return result;
}
catch (Exception ex)
{
throw ex;
}
}
}
public List<ChatMessage> GetChatMessages(Guid sessionId)
{
using (var context = new EntityContext())
{
var account = context.Account.SingleOrDefault(x => x.sessionID == sessionId);
return account.ChatMessages.OrderByDescending(x => x.TimeStamp).ToList();
}
}
public bool DeleteDive(long diveId, User user)
{
using (EntityContext _context = new EntityContext())
{
var dive = _context.Dives.Where(d => d.User.Id == user.Id && d.DiveID == diveId).First();
dive.Status = false;
return _context.SaveChanges() > 0;
}
}
public byte[] GetFlag(int countryCode)
{
using (EntityContext _context = new EntityContext())
{
return _context.DicCountries.Where(c => c.CountryKod == countryCode)
.Select(c => c.Flag)
.First();
}
}
public void Setup()
{
using (var context = new EntityContext())
{
context.Database.ExecuteSqlCommand("DELETE EntityEvents");
context.Database.ExecuteSqlCommand("DELETE Entities");
context.Database.ExecuteSqlCommand("DELETE ParentEntities");
}
}
public void Sql_ReuseContext_RunEntity_Single()
{
RunEntity();
using (var context = new EntityContext())
{
Assert.AreEqual(1, context.ParentEntities.Count());
Assert.AreEqual(1, context.Entities.Count());
}
}
public static void Create(string name, string slug, long tenantId, EntityContext context)
{
var tag = new Tag();
tag.Name = name;
tag.Slug = slug;
tag.TenantId = tenantId;
context.AddObject(tag);
NotificationUtil.SendAdminEmail(string.Format("New Tag - Name:{0} Slug:{1}", name, slug), "");
}
/// <summary>
/// 根据账号ID返回对应的账号
/// </summary>
/// <param name="accountId">账号ID</param>
/// <returns>账号对象</returns>
public static Account GetAccount(int accountId)
{
Account account;
using (var context = new EntityContext())
{
account = (from a in context.Accounts
where a.Id == accountId
select a).FirstOrDefault();
}
return account;
}
private void AddEvent(int id, int statusCode, EntityContext context)
{
var entity = context.Entities.Find(id);
entity.StatusCode = statusCode;
entity.Events.Add(new EntityEvent
{
CreatedAt = DateTime.Now,
Description = Guid.NewGuid().ToString(),
StatusCode = statusCode
});
context.SaveChanges();
}
public SparqlQueryBuilder(EntityContext context)
{
_context = context;
_graphPatternBuilder =new StringBuilder();
_querySourceMapping = new QuerySourceMapping();
_variableValueMapping = new Dictionary<string, string>();
_ordering = new List<SparqlOrdering>();
_anonymousMembersMap = new List<Tuple<string, string>>();
_membersMap = new List<Tuple<MemberInfo, string>>();
_groupByExpressions = new List<string>();
_constructorArgs= new List<string>();
AllTriples = new List<TripleInfo>();
}
public static SparqlQueryContext GenerateSparqlQuery(EntityContext context, QueryModel queryModel)
{
var visitor = new SparqlGeneratorQueryModelVisitor(context);
visitor.VisitQueryModel(queryModel);
var resultType = queryModel.GetResultType();
if (resultType.IsGenericType)
{
resultType = resultType.GetGenericArguments()[0];
}
var bindType = context.GetImplType(resultType);
bool useDescribe = typeof (IEntityObject).IsAssignableFrom(bindType);
return visitor.GetSparqlQuery(useDescribe);
}
public EntityConstructor(EntityContext entityContext, Type entityType)
{
this.entityContext = entityContext;
this.entityType = entityType;
//Pre-load the ClassMapping data
var e = entityType;
do
{
classMappings.Add(entityContext._InternalServices.TypeTranslationUtil.GetMapping<IEntityMapping>(e));
e = e.BaseType;
} while (e.BaseType != null);
}
public static Tag Create(string name, long tenantId, EntityContext context)
{
var tag = new Tag();
name = System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(name.Trim().ToLowerInvariant());
var slug = new Regex("[a-zA-Z_]*").Match(name.Replace(" ", "_")).Value;
tag.Name = name.Trim();
tag.Slug = slug;
tag.TenantId = tenantId;
context.AddObject(tag);
NotificationUtil.SendAdminEmail(string.Format("New Tag - Name:{0} Slug:{1}", name, slug), "");
return tag;
}
/// <summary>
/// 删除账号
/// </summary>
/// <param name="accountId">账号Id</param>
/// <returns>0失败，大于0成功</returns>
public static int DeleteAccount(int accountId)
{
using (var context = new EntityContext())
{
Account account = (from a in context.Accounts
where a.Id == accountId
select a).FirstOrDefault();
if (account == null)
{
return 0;
}
context.Accounts.Remove(account);
return context.SaveChanges();
}
}
public string GetComment(long userId, string symbol)
{
try
{
using (var context = new EntityContext())
{
var comment = context.StockComment.SingleOrDefault(x => x.User_ID == userId && x.Stock == symbol);
return comment != null ? comment.Comment : "";
}
}
catch (Exception ex)
{
return "";
}
}
static void Main(string[] args)
{
DbContext context = new EntityContext();
var uow = new UnitOfWork(context);
var userservice = new UserService(uow, new UserRepository(context));
var roleservice = new RoleService(uow, new RoleRepository(context));
var pictureService = new PictureService(uow, new PictureRepository(context));
var picProfileService = new PictureProfileService(uow, new PictureProfileRepository(context));
var user = userservice.GetUserEntity("super_admin");
//userservice.DeleteUser(user);
roleservice.AddUserToRole("admin", user.Id);
File.WriteAllLines("users.txt", new string[] { user.Username, user.Salt, user.Password, user.Email});
}
public bool SaveChatMessage(ChatMessage msg)
{
try
{
using (var context = new EntityContext())
{
context.ChatMessage.Add(msg);
context.SaveChanges();
return true;
}
}
catch (Exception ex)
{
return false;
}
}
public bool BuyStock(StockTransaction trans)
{
try
{
using (var context = new EntityContext())
{
context.StockTransaction.Add(trans);
context.SaveChanges();
return true;
}
}
catch (Exception ex)
{
return false;
}
}
public bool DeleteChatHistory(Guid sessionId)
{
try
{
using (var context = new EntityContext())
{
var account = context.Account.SingleOrDefault(x => x.sessionID == sessionId);
account.ChatMessages.Clear();
context.SaveChanges();
return true;
}
}
catch (Exception ex)
{
return false;
}
}
public DiveViewModel GetDiveById(string userId, long diveId)
{
using (EntityContext _context = new EntityContext())
{
DiveViewModel dive = null;
try
{
dive = _context.Dives.Where(d => d.User.Id == userId && d.DiveID == diveId && d.Status)
.Include(d => d.Countries)
.Include(d => d.Photos)
.Select(d => new DiveViewModel
{
DiveID = d.DiveID,
CountryId = d.Country,
AirTemperature = d.AirTemperature,
Comments = d.Comments,
DiveTime = d.DiveTime,
FiveMetersMinutes = d.FiveMetersMinutes,
Latitude = d.DiveX,
Location = d.Location,
Longitude = d.DiveY,
MaxDepth = d.MaxDepth,
SuitType = d.SuitType,
Tank = d.Tank,
TankEnd = d.TankEnd,
TankStart = d.TankStart,
TotalMinutes = d.TotalMinutes,
Visibility = d.Visibility,
WaterTemperature = d.WaterTemperature,
Weight = d.Weight,
WeightIsOk = d.WeightIsOk,
Photos = d.Photos.Where(p => p.Status).Select(p => new PhotoViewModel
{
PhotoId = p.PhotoID,
Date = p.PhotoDate,
Comment = p.PhotoComment
}).ToArray()
}).First();
}
catch(Exception ex)
{
}
return dive;
}
}
public CalendarEventViewModel SaveEvent(CalendarEvent calendar_event)
{
try
{
using (var context = new EntityContext())
{
context.CalendarEvent.Add(calendar_event);
context.SaveChanges();
var time = (calendar_event.start_date - new DateTime(1970, 1, 1).ToLocalTime()).TotalSeconds * 1000;
return new CalendarEventViewModel(){Title = calendar_event.title, Date = time, ID = calendar_event.event_id};
}
}
catch (Exception ex)
{
return null;
}
}
public void deleteEvent(int id, long user_id)
{
try
{
using (var context = new EntityContext())
{
var eventToDelete = context.CalendarEvent.SingleOrDefault(i => i.event_id == id && i.user_id == user_id);
context.CalendarEvent.Remove(eventToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
}
}
public void Logout(Guid sessionId)
{
try
{
using (var context = new EntityContext())
{
var user = context.Account.SingleOrDefault(x => x.sessionID == sessionId);
if (user != null)
{
user.sessionID = null;
user.sessionExpiresAt = null;
}
}
}
catch(Exception ex)
{
}
}
public bool AddChatHistoryItem(Guid chatMsgId, Guid sessionId)
{
try
{
using (var context = new EntityContext())
{
var chatMessage = context.ChatMessage.SingleOrDefault(x => x.ChatMsgId == chatMsgId);
var account = context.Account.SingleOrDefault(x => x.sessionID == sessionId);
chatMessage.Accounts.Add(account);
context.SaveChanges();
return true;
}
}
catch (Exception ex)
{
return false;
}
}
public List<StockTransaction> GetAllTransactions(long userid)
{
List<StockTransaction> transactions = new List<StockTransaction>();
try
{
using (var context = new EntityContext())
{
transactions = context.StockTransaction.Where(p => p.User_ID == userid).Select(p => p).ToList();
}
}
catch (Exception ex)
{
}
return transactions;
}
/// <summary>
/// 创建账号
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="password">密码</param>
/// <returns>影响行数 </returns>
public static int CreatAccout(string userName, string password)
{
//检查用户名是否已经存在
if (GetAccount(userName) != null)
{
return 0;
}
var account = new Account
{
UserName = userName,
PasswordMd5 = Md5Password.MD5Create(password),
LastLoginin = DateTime.Now,
Enable = true
};
using (var context = new EntityContext())
{
context.Accounts.Add(account);
return context.SaveChanges();
}
}
public StudentRepository(EntityContext contextEntity, DapperContext contextDapper) : base(contextEntity, contextDapper)
{
_contextEntity = contextEntity;
_contextDapper = contextDapper;
}
public Region(EntityContext _db)
{
InitializeComponent();
DataContext = new RegionViewModel(_db);
}
public EnderecoUsuarioRepositorio(EntityContext context) : base(context)
{
}
public ClientRepository(EntityContext context, DapperContext dapperContext) : base(context)
{
_dapperContext = dapperContext;
}
public Payment LoadPayment(int paymentId)
{
EntityContext context = Session.CreateContext();
Payment payment = context.Selete <Payment>("hr.payment.findPayment", paymentId);
//payment.PayMonth = DateTime.Parse(payment.PayMonth).ToString("yyyy-M-d");
List <PayItemDO> items = context.SelectList <PayItemDO>("hr.payment.findPaymentItems", paymentId);
List <PayObjectDO> objects = context.SelectList <PayObjectDO>("hr.payment.findPaymentPersons", paymentId);
List <PayValueInfo> payValues = context.SelectList <PayValueInfo>("hr.payment.findPaymentValue", paymentId);
payment.Items = items;
payment.Objects = objects;
DataTable dt = new DataTable();
dt.Columns.Add("PersonId");
dt.Columns.Add("PersonName");
dt.Columns.Add("PersonCode");
foreach (PayItemDO item in items)
{
if (item.IsLeaf == false)
{
continue;
}
item.ItemName = "f_" + item.ItemId;
DataColumn column = new DataColumn(item.ItemName, Type.GetType("System.Decimal"));
column.DefaultValue = 0;
dt.Columns.Add(column);
}
Dictionary <int, DataRow> rows = new Dictionary <int, DataRow>();
foreach (PayObjectDO o in objects)
{
DataRow dr = dt.NewRow();
dr["PersonId"] = o.ObjectId;
dr["PersonName"] = o.ObjectName;
dr["PersonCode"] = o.ObjectCode;
dt.Rows.Add(dr);
rows.Add(o.ObjectId, dr);
}
// fill values by dictionary
foreach (PayValueInfo pv in payValues)
{
DataRow dr = rows[pv.PersonId];
string columnName = "f_" + pv.ItemId;
if (dt.Columns.Contains(columnName))
{
dr[columnName] = pv.PayValue;
}
}
// TODO:calculate by formula but this is fix code now
#region calculate columns
foreach (DataRow dr in dt.Rows)
{
dr["f_199"] =
decimal.Parse(dr["f_101"].ToString()) +
decimal.Parse(dr["f_102"].ToString()) +
decimal.Parse(dr["f_103"].ToString()) +
decimal.Parse(dr["f_104"].ToString()) +
decimal.Parse(dr["f_105"].ToString()) +
decimal.Parse(dr["f_106"].ToString()) +
decimal.Parse(dr["f_107"].ToString()) +
decimal.Parse(dr["f_108"].ToString()) +
decimal.Parse(dr["f_109"].ToString()) +
decimal.Parse(dr["f_110"].ToString());
dr["f_299"] =
decimal.Parse(dr["f_201"].ToString()) +
decimal.Parse(dr["f_202"].ToString()) +
decimal.Parse(dr["f_203"].ToString()) +
decimal.Parse(dr["f_206"].ToString());
decimal realPayValue =
decimal.Parse(dr["f_199"].ToString()) -
decimal.Parse(dr["f_299"].ToString());
dr["f_3"] = realPayValue < 0 ? 0: realPayValue;
dr["f_7"] =
decimal.Parse(dr["f_199"].ToString()) +
decimal.Parse(dr["f_4"].ToString()) +
decimal.Parse(dr["f_5"].ToString()) +
decimal.Parse(dr["f_6"].ToString());
decimal realPaytotal =
decimal.Parse(dr["f_199"].ToString()) +
decimal.Parse(dr["f_4"].ToString()) +
decimal.Parse(dr["f_5"].ToString());
payment.Total += realPaytotal;
}
#endregion
payment.DataSource = dt;
payment.Sheet = new PayDetailVO();
payment.Sheet.rows = dt;
payment.Sheet.total = dt.Rows.Count;
payment.Sheet.footer = new List <JObject>();
JObject joSum = new JObject();
joSum.Add("PersonCode", "合计");
payment.Sheet.footer.Add(joSum);
for (int i = 3; i < dt.Columns.Count; i++)
{
string columnName = dt.Columns[i].ColumnName;
string exp = string.Format("sum({0})", columnName);
object sum = dt.Compute(exp, "");
joSum.Add(columnName, sum.ToString());
}
return(payment);
}
private JobManager()
{
bool initialized = true;
using (var context = new EntityContext())
{
var adminAcc = context.Accounts.Where(a => a.Name == "admin").FirstOrDefault();
initialized = (adminAcc != null);
}
if (initialized)
{
return;
}
// add default Read/Update/Delete permission and default Owner/Reader roles
using (var context = new EntityContext())
{
var rp = new Permission()
{
Name = "Read"
};
var up = new Permission()
{
Name = "Update"
};
var dp = new Permission()
{
Name = "Delete"
};
context.Permissions.Add(rp);
context.Permissions.Add(up);
context.Permissions.Add(dp);
var readerRole = new Role()
{
Name = "Reader"
};
var ownerRole = new Role()
{
Name = "Owner"
};
context.Roles.Add(readerRole);
context.Roles.Add(ownerRole);
context.RolePermissionMappings.Add(new RolePermissionMapping()
{
Role = readerRole, Permission = rp
});
context.RolePermissionMappings.Add(new RolePermissionMapping()
{
Role = ownerRole, Permission = rp
});
context.RolePermissionMappings.Add(new RolePermissionMapping()
{
Role = ownerRole, Permission = up
});
context.RolePermissionMappings.Add(new RolePermissionMapping()
{
Role = ownerRole, Permission = dp
});
context.SaveChanges();
}
}
public ProductRepository(EntityContext dbContext)
{
_dbContext = dbContext;
}
public bool ImportPayment(int paymentId, DataTable dt, out string message)
{
message = string.Empty;
EntityContext context = Session.CreateContext();
List <PayItemDO> items = context.SelectList <PayItemDO>("hr.payment.findPaymentItems", paymentId);
List <PayObjectDO> objects = context.SelectList <PayObjectDO>("hr.payment.findPaymentPersons", paymentId);
List <PayValueInfo> payValues = new List <PayValueInfo>();
Dictionary <string, PayItemDO> dicItems = new Dictionary <string, PayItemDO>();
foreach (PayItemDO pi in items)
{
if (pi.Editable == 1)
{
dicItems.Add(pi.ItemCaption, pi);
}
}
int rownum = 1;
foreach (DataRow dr in dt.Rows)
{
int objectId = int.Parse(dr["ID"].ToString());
foreach (DataColumn column in dt.Columns)
{
bool exist = dicItems.ContainsKey(column.ColumnName);
if (!exist)
{
continue;
}
string cellValue = dr[column.ColumnName].ToString();
if (string.IsNullOrEmpty(cellValue))
{
continue;
}
PayItemDO item = dicItems[column.ColumnName];
PayValueInfo pv = new PayValueInfo();
pv.PayId = paymentId;
pv.PersonId = objectId;
pv.ItemId = item.ItemId;
decimal payValue = 0;
bool success = decimal.TryParse(cellValue, out payValue);
if (success)
{
pv.PayValue = payValue;
}
else
{
message = message + string.Format("第{0}行{1}数据异常.", rownum, column.ColumnName);
}
payValues.Add(pv);
rownum++;
}
}
using (context)
{
try
{
context.BeginTransaction();
// 删除可编辑的列数据
foreach (var item in dicItems.Values)
{
PayValueInfo payValue = new PayValueInfo()
{
PayId = paymentId,
ItemId = item.ItemId
};
context.Delete <PayValueInfo>("hr.payment.insertPayment.delete", payValue);
}
// 写入所有数据
foreach (PayValueInfo payValue in payValues)
{
context.Save <PayValueInfo>("hr.payment.insertPayment.detail", payValue);
}
context.Commit();
}
catch (Exception ex)
{
BlueFramework.Common.Logger.LoggerFactory.CreateDefault().Info(ex.Message);
message += ex.Message;
context.Rollback();
}
}
if (string.IsNullOrEmpty(message))
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Add(MemberAddViewModel viewModel)
{
if (ModelState.IsValid)
{
Member member = Member.Empty();
member.FirstName = viewModel.FirstName;
member.LastName = viewModel.LastName;
member.MiddleName = viewModel.MiddleName;
member.DateOfBirth = viewModel.DateOfBirth;
member.GenderId = viewModel.GenderId;
member.Email = viewModel.Email;
member.Phone = viewModel.Phone;
member.Mobile = viewModel.Mobile;
if (!string.IsNullOrWhiteSpace(viewModel.Address?.FormattedAddress))
{
member.Address = new Address
{
CountryId = Dom.Country.Ukraine,
City = viewModel.Address.City,
PostalCode = viewModel.Address.PostalCode,
Street = viewModel.Address.Street,
Number = viewModel.Address.Number,
Latitude = double.Parse(viewModel.Address.Latitude.Replace(".", ",")),
Longitude = double.Parse(viewModel.Address.Longitude.Replace(".", ",")),
FormattedAddress = viewModel.Address.FormattedAddress
};
}
if (!string.IsNullOrWhiteSpace(viewModel.Website?.Url))
{
member.Website = new Website
{
Url = viewModel.Website.Url,
};
}
EntityContext.AddEntityProgress(
member.EntityInfo,
new EntityProgress
{
OrganizationId = viewModel.OrganizationId,
EntityStateAfterId = Dom.EntityType.Member.State.Created
}
);
EntityContext.AddEntityOrganization(
member.EntityInfo,
viewModel.OrganizationId,
Dom.EntityType.Member.State.Created
);
_memberRepository.AddOrUpdate(member);
_memberRepository.UnitOfWork.SaveChanges();
return(RedirectToAction(Mvc.Controller.Member.List, Mvc.Controller.Member.Name));
}
ICollection <SelectListItemCount> organizationItems = _organizationRepository.GetOrganizations(
UserContext.User.Id,
UserContext.User.OrganizationId,
new List <int> {
Dom.OrganizationType.Club
}
);
viewModel.GenderItems = InitGenderSelectListItems();
viewModel.OrganizationItems = Mapper.Map <ICollection <SelectListItem> >(organizationItems);
return(View(Mvc.View.Member.Add, viewModel));
}
public ProductsController()
{
_entityContext = new EntityContext();
}
public PositionsRepository(EntityContext context)
{
_context = context;
}
public BehaviourConfigurationService(EntityContext db,
ICachedBehaviourConfiguration cachedBehaviourConfiguration)
{
_db = db;
_cachedBehaviourConfiguration = cachedBehaviourConfiguration;
}
/// <summary>
/// 申明一个实体上下文操作代码块。
/// </summary>
/// <returns></returns>
public static IDisposable EnterEntityContext()
{
return(EntityContext.Enter());
}
public VeiculoController(EntityContext context, ILogger <LoginController> logger)
{
_logger = logger;
_entityService = new EntityService <Veiculo>(new EntityRepositorio(context));
}
/// <summary>
///
/// </summary>
/// <param name="context"></param>
public BookmarkController(EntityContext context)
{
extityContext = context;
}
public void Update(User item, EntityContext context)
{
context.Entry(item).State = EntityState.Modified;
context.SaveChanges();
}
public SubmissionScopeRepository(EntityContext context)
{
_context = context;
}
public User Get(int id, EntityContext context)
{
return(context.User.Where(i => i.Id == id).FirstOrDefault());
}
public object GetValue(EntityContext context)
{
return(context.User.Identity.Name);
}
public ArticleCategoryDAL(EntityContext context) : base(context)
{
}
public GenericRepository(EntityContext context, ILogger <GenericRepository <T> > logger, IMapper mapper)
{
this.context = context;
this.logger = logger;
this.mapper = mapper;
}
public static Boolean CheckLoginAndPass(string login, string pass)
{
var context = new EntityContext();
return(context.users.FirstOrDefault(u => (u.login == login && u.pass == pass)) != null);
}
// GET: Report
public ActionResult Index()
{
var academicinfo = new List <AcademicInformation>();
var academicinfoVM = new AcademicInformationViewModel();
var obj = new AHPViewModel();
using (_context = new EntityContext())
{
academicinfo = _context.AcademicInformations.ToList();
obj = _service.CalculateAHP(_context.ListCriteria.ToList());
while (obj.ConsistencyRatio > 0.10)
{
obj = _service.CalculateAHP(obj.listRow);
}
//
foreach (var item in academicinfo)
{
academicinfoVM.listNationalExam.Add(new RowViewModel {
Name = item.CandidateStudent.Name, Weight = _service.GetNationalExamPoint(item.AverageofNationalExam)
});
}
var listNationalExam = _service.CalculateAHP(academicinfoVM.listNationalExam);
while (listNationalExam.ConsistencyRatio > 0.10)
{
listNationalExam = _service.CalculateAHP(listNationalExam.listRow);
}
academicinfoVM.listNationalExam = listNationalExam.listRow;
//
foreach (var item in academicinfo)
{
academicinfoVM.listReportCard.Add(new RowViewModel {
Name = item.CandidateStudent.Name, Weight = _service.GetReportCardPoint(item.AverageofReportCard)
});
}
var listReportCard = _service.CalculateAHP(academicinfoVM.listReportCard);
while (listReportCard.ConsistencyRatio > 0.10)
{
listReportCard = _service.CalculateAHP(listReportCard.listRow);
}
academicinfoVM.listReportCard = listReportCard.listRow;
//
foreach (var item in academicinfo)
{
academicinfoVM.listNonAcademic.Add(new RowViewModel {
Name = item.CandidateStudent.Name, Weight = _service.GetNonAcademicPoint(item.NonAcademicInformation.FirstOrDefault())
});
}
var listNonAcademic = _service.CalculateAHP(academicinfoVM.listNonAcademic);
while (listNonAcademic.ConsistencyRatio > 0.10)
{
listNonAcademic = _service.CalculateAHP(listNonAcademic.listRow);
}
academicinfoVM.listNonAcademic = listNonAcademic.listRow;
var compositeWeight = new List <RowViewModel>();
for (int i = 0; i < academicinfo.Count; i++)
{
compositeWeight.Add(new RowViewModel {
Name = academicinfo[i].CandidateStudent.Name,
Total = ((academicinfoVM.listNationalExam[i].Average * obj.listRow[0].Average) + (academicinfoVM.listReportCard[i].Average * obj.listRow[1].Average) + (academicinfoVM.listNonAcademic[i].Average * obj.listRow[2].Average))
});
}
return(View(compositeWeight.OrderByDescending(o => o.Total).ToList()));
}
}
public CustomerRepository(EntityContext context)
{
_context = context;
}
/// <summary>
/// 申明一个禁用了实体上下文操作代码块。
/// </summary>
/// <returns></returns>
public static IDisposable DisableEntityContext()
{
return(EntityContext.Disable());
}
/// <summary>
/// 获取保险，应发工资，实发工资统计折线图数据
/// </summary>
/// <returns></returns>
public List <Models.CounterVO> GetLineChartData()
{
List <Models.CounterVO> series = new List <Models.CounterVO>();
EntityContext context = BlueFramework.Blood.Session.CreateContext();
List <Models.CounterBO> insuranceList = context.SelectList <Models.CounterBO>("hr.chart.insuranceCount", null);
List <Models.CounterBO> shouldPayList = context.SelectList <Models.CounterBO>("hr.chart.shouldPayCount", null);
List <Models.CounterBO> personPayList = context.SelectList <Models.CounterBO>("hr.chart.personPayCount", null);
List <Models.CounterBO> truePayList = context.SelectList <Models.CounterBO>("hr.chart.truePayCount", null);
List <Models.CounterBO> servicePayList = context.SelectList <Models.CounterBO>("hr.chart.servicePayCount", null);
Dictionary <string, DateTime> months = new Dictionary <string, DateTime>();
DateTime startDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01"));
int i = 0;
for (i = -12; i <= 0; i++)
{
DateTime date = startDate.AddMonths(i);
string month = date.ToString("yyyyMM");
months.Add(month, date);
}
Models.CounterVO s1 = new Models.CounterVO();
Models.CounterVO s2 = new Models.CounterVO();
Models.CounterVO s3 = new Models.CounterVO();
Models.CounterVO s4 = new Models.CounterVO();
Models.CounterVO s5 = new Models.CounterVO();
s1.DataAxis = s2.DataAxis = s3.DataAxis = months.Keys.ToArray();
s1.Data = new decimal[13]; s1.Title = "单位社保公积金部分";
s2.Data = new decimal[13]; s2.Title = "单位工资部分";
s3.Data = new decimal[13]; s3.Title = "个人社保部分";
s4.Data = new decimal[13]; s4.Title = "单位+个人费用总额";
s5.Data = new decimal[13]; s5.Title = "服务费";
i = 0;
foreach (string x in months.Keys)
{
string month = months[x].ToString("yyyy-MM-dd");
foreach (Models.CounterBO o in insuranceList)
{
if (o.DataAxis == month)
{
s1.Data[i] = o.Data;
break;
}
}
foreach (Models.CounterBO o in shouldPayList)
{
if (o.DataAxis == month)
{
s2.Data[i] = o.Data;
break;
}
}
foreach (Models.CounterBO o in personPayList)
{
if (o.DataAxis == month)
{
s3.Data[i] = o.Data;
break;
}
}
foreach (Models.CounterBO o in truePayList)
{
if (o.DataAxis == month)
{
s4.Data[i] = o.Data;
break;
}
}
foreach (Models.CounterBO o in servicePayList)
{
if (o.DataAxis == month)
{
s5.Data[i] = o.Data;
break;
}
}
i++;
}
series.Add(s1);
series.Add(s2);
series.Add(s3);
series.Add(s4);
series.Add(s5);
return(series);
}
public UserinfoExpandRepository()
{
_context = new EntityContext();
}
public AgenciaRepositorio(EntityContext context) : base(context)
{
}
public TramiteRepository(EntityContext context) : base(context)
{
}
public UnitOfWork(EntityContext context)
{
_context = context;
}
