public int Add(ref Mugurtham.Core.User.UserCoreEntity objUserCoreEntity, out string strUserID) { strUserID = Helpers.primaryKey; try { IUnitOfWork objIUnitOfWork = new UnitOfWork(); using (objIUnitOfWork as IDisposable) { Mugurtham.DTO.User.User objDTOUser = new DTO.User.User(); using (objDTOUser as IDisposable) { objUserCoreEntity.ID = strUserID; assignHomePagePath(ref objUserCoreEntity); AssignDTOFromEntity(ref objDTOUser, ref objUserCoreEntity); } objIUnitOfWork.RepositoryUser.Add(objDTOUser); objDTOUser = null; } objIUnitOfWork.commit(); objIUnitOfWork = null; } catch (Exception objEx) { Helpers.LogExceptionInFlatFile(objEx); } return 0; }
//Create group public static int Create(GroupDTO GroupDTO) { try { GlobalSettings.LoggedInClientId = GroupDTO.ClientID; int PartnerId = ClientService.GetById(GroupDTO.ClientID).PartnerId; GlobalSettings.LoggedInPartnerId = PartnerId; var group = new Group(); UnitOfWork uow = new UnitOfWork(); GroupDTO.ClientID = GroupDTO.ClientID; group = Transform.GroupToDomain(GroupDTO); uow.GroupRepo.Insert(group); uow.SaveChanges(); GroupDTO.Id = group.Id; return GroupDTO.Id; } catch (Exception) { throw; } }
protected void PhonebooksGridView_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; if (CustomerUtilities.IsLoggedIn() == true) { using (var uow = new UnitOfWork()) { Phonebook phonebook = new Phonebook(uow); SetPhonebookValues(phonebook, e.NewValues); phonebook.Customer = uow.GetObjectByKey<Customer>(CustomerUtilities.CurrentCustomer().Oid); ValidationResult validation = new PhonebookValidator().Validate(phonebook); if (validation.IsValid) { uow.CommitChanges(); } else { e.Cancel = true; uow.Dispose(); } } } else { Response.Redirect(UrlManager.Root); } EndEditing(grid, e); }
public FrmCrearTipoEmpleado(TipoEmpleado tipoempleado, XPCollection xpcTipoEmpleado, UnitOfWork uow) : this() { this.TipoEmpleado = tipoempleado; this.uow = uow; this.xpcTipoEmpleado = xpcTipoEmpleado; }
public override void UpdateDatabaseBeforeUpdateSchema() { base.UpdateDatabaseBeforeUpdateSchema(); if (CurrentDBVersion > new Version(0, 0, 0, 0) && CurrentDBVersion <= new Version(10, 1, 6)) { var differenceObjects = new Dictionary<object, string>(); using (var reader = ExecuteReader("select [Oid], [Model] from [ModelDifferenceObject] where [Model] is not null", false)) { while (reader.Read()) { differenceObjects.Add(reader[0], reader[1] as string); } } using (var uow = new UnitOfWork(((ObjectSpace)ObjectSpace).Session.DataLayer)) { foreach (var differenceObject in differenceObjects) { var modelDifferenceObject = uow.GetObjectByKey<ModelDifferenceObject>(differenceObject.Key); var serializableDictionary = new SerializableDictionary<string, string>(); var xmlReader = XmlReader.Create(new StringReader(differenceObject.Value), new XmlReaderSettings { ConformanceLevel = ConformanceLevel.Auto }); serializableDictionary.ReadXml(xmlReader); var aspects = serializableDictionary["aspects"].Split(',').ToList(); var defaultAspect = serializableDictionary["DefaultAspect"]; defaultAspect = GetDefaultAspectFromVersion9(serializableDictionary, aspects, defaultAspect); if (!string.IsNullOrEmpty(defaultAspect)) modelDifferenceObject.AspectObjects.Add(new AspectObject(uow) { Name = CaptionHelper.DefaultLanguage, Xml = defaultAspect }); foreach (var aspect in aspects.Where(aspect => !string.IsNullOrEmpty(aspect) && !string.IsNullOrEmpty(serializableDictionary[aspect]))) { modelDifferenceObject.AspectObjects.Add(new AspectObject(uow) { Name = aspect, Xml = serializableDictionary[aspect] }); } } uow.CommitChanges(); } } }
private bool DeletePayrollTable(List<Guid> listProfileID, Guid cutOffDurationID) { #region Delete PayrollTable try { using (var context = new VnrHrmDataContext()) { var unitOfWork = new UnitOfWork(context); int pageSize = 2000;//tối đa là 2100 parameter int result = 0; foreach (var listProfileIDBySize in listProfileID.Chunk(pageSize)) { result += unitOfWork.SetIsDelete(context.Sal_PayCommission.Where(m => m.CutoffDurationID != null && m.ProfileID != null && !m.IsDelete.HasValue && (Guid)m.CutoffDurationID == cutOffDurationID && listProfileIDBySize.Contains((Guid)m.ProfileID))); } return true; } } catch (Exception) { return false; } #endregion }
protected void Application_PostAuthenticateRequest(Object sender, EventArgs e) { if (FormsAuthentication.CookiesSupported != true) return; if (Request.Cookies[FormsAuthentication.FormsCookieName] == null) return; //let us take out the username now var formsAuthenticationTicket = FormsAuthentication.Decrypt(Request.Cookies[FormsAuthentication.FormsCookieName].Value); if (formsAuthenticationTicket == null) return; var username = formsAuthenticationTicket.Name; var roles = String.Empty; using (IDataContextAsync context = new OIDataContext()) using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context)) { IRepositoryAsync<Account> accountRepository = new Repository<Account>(context, unitOfWork); var user = accountRepository.Query(u => u.Username == username).Include(r => r.Role).Select().SingleOrDefault(); if (user != null) roles = user.Role.RoleType; } //Let us set the Pricipal with our user specific details HttpContext.Current.User = new System.Security.Principal.GenericPrincipal( new System.Security.Principal.GenericIdentity(username, "Forms"), roles.Split(';')); }
public ActionResult Approve(long id) { ICollection<ValidationResult> error = new List<ValidationResult>(); CommitteeResolution committeeResolution; try { using (var unitOfWork = new UnitOfWork(new BankModuleFactory())) { var Service = new CommitteeResolutionService(unitOfWork); committeeResolution = Service.Get(sr => sr.LoanApplicationId == id).First(); committeeResolution.UserId = Authentication.User.Id; Service.ApproveResolution(committeeResolution); error = unitOfWork.Commit(); } if (error.Any()) { ModelState.AddModelError(string.Empty, error.First().ErrorMessage); return View(); } } catch (Exception ex) { ModelState.AddModelError(string.Empty, ex.Message); return View(); } return RedirectToAction("LoanApplicationList"); }
public LocationCoreEntity GetByProfileID(string strProfileID) { LocationCoreEntity objLocationCoreEntity = new LocationCoreEntity(); try { Mugurtham.DTO.Profile.Location objLocation = new Mugurtham.DTO.Profile.Location(); IUnitOfWork objUOW = new UnitOfWork(); using (objUOW as IDisposable) objLocation = objUOW.RepositoryLocation.GetAll().ToList().Where(p => p.ProfileID.Trim().ToLower() == strProfileID.Trim().ToLower()).FirstOrDefault(); objUOW = null; if (objLocation != null) { using (objLocation as IDisposable) { AssignEntityFromDTO(ref objLocation, ref objLocationCoreEntity); } } objLocation = null; } catch (Exception objEx) { Helpers.LogExceptionInFlatFile(objEx); } return objLocationCoreEntity; }
public void Initialize() { var connection = DbConnectionFactory.CreateTransient() as System.Data.Common.DbConnection; _context = new WebSiteContext(connection); IUnitOfWork _uow = new UnitOfWork<WebSiteContext>(_context); _repository = new BannerRepository(_uow); }
public ActionResult AddPatientMedication(patientmedication medication) { unitOfWork.Repository<patientmedication>().Insert(medication); unitOfWork.Save(); unitOfWork = new UnitOfWork(); return PartialView("_PatientMedication", unitOfWork.Repository<patientmedication>().Filter(x => x.PatientId == medication.PatientId).Get()); }
protected override IObjectSpace CreateObjectSpaceCore(UnitOfWork unitOfWork, ITypesInfo typesInfo) { var objectSpace = new XpandObjectSpace(new XpandUnitOfWork(unitOfWork.DataLayer), typesInfo) { AsyncServerModeSourceResolveSession = AsyncServerModeSourceResolveSession, AsyncServerModeSourceDismissSession = AsyncServerModeSourceDismissSession }; return objectSpace; }
//Create template public static int Create(TemplateDTO TemplateDTO) { if (TemplateDTO.Title == null || TemplateDTO.Title == "") { return 0; } try { var Template = new Template(); GlobalSettings.LoggedInClientId = TemplateDTO.ClientId; int PartnerId = ClientService.GetById(TemplateDTO.ClientId).PartnerId; GlobalSettings.LoggedInPartnerId = PartnerId; UnitOfWork uow = new UnitOfWork(); Template = Transform.TemplateToDomain(TemplateDTO); uow.TemplateRepo.Insert(Template); uow.SaveChanges(); TemplateDTO.Id = Template.Id; return TemplateDTO.Id; } catch (Exception) { throw; } }
public Task<FormatedList<UserModel>> GetAll (NameValueCollection requestParams) { return Task.Run(() => { using(var session = new UnitOfWork<FoodMenuEntities>()) { IUserRepository userRepository = session.GetRepository<IUserRepository>(); var userList = userRepository.Find(u => u.IsActive).Select(u => new UserModel { Id = u.Id, Email = u.Email, Password = u.Password, FirstName = u.FirstName, LastName = u.LastName, BusinessId = u.BusinessId, Address = u.Address, }); var parser = new DataTableEntityParser<UserModel>(requestParams,userList.AsQueryable()); return parser.Parse(); } }); }
public void Dispose_Then_throw_exception_on_DbContext_get() { var uow1 = new UnitOfWork(_dbContextFactoryMock.Object); uow1.Dispose(); Assert.Throws<ObjectDisposedException>(() => { var dbContext = uow1.DbContext; }); }
private static IDictionary<string, int> PrefillAuthors(IList<boeken> books, AuthorRepository authorsRepo, UnitOfWork unitOfWork) { var allAuthorsInOldDb = books.Select(_ => _.auteurs.Trim()).Distinct().ToList(); var newAuthors = authorsRepo.All.ToList(); var result = new Dictionary<string, int>(); Console.WriteLine("Found {0} authors in old db", allAuthorsInOldDb.Count()); foreach(var a in allAuthorsInOldDb) { var candidate = newAuthors.FirstOrDefault(_ => _.Name.ToLower() == a.ToLower()); if (candidate == null) { candidate = new Author() { State = State.Added, Name = a }; authorsRepo.InsertOrUpdate(candidate); unitOfWork.Save(); newAuthors.Add(candidate); } result[a.ToLower()] = candidate.Id; } return result; }
public async Task<ReturnModel<UserModel>> Create (UserModel userModel) { var result = new ReturnModel<UserModel> { Status = true }; using(var session = new UnitOfWork<FoodMenuEntities>()) { var userRepository = session.GetRepository<IUserRepository>(); if(!(await userRepository.ValidateEmail(userModel.Email,userModel.Id))) { result.Error = ("כתובת האמייל כבר בשימוש."); result.Status = false; return result; } var user = new User(); user.Id = userModel.Id; user.Email = userModel.Email; user.Password = userModel.Password; user.FirstName = userModel.FirstName; user.LastName = userModel.LastName; user.BusinessId = userModel.BusinessId; user.Address = userModel.Address; user.IsActive = true; userRepository.Add(user); await session.SaveChangesAsync(); userModel.Id = user.Id; userModel.Token = Guid.NewGuid().ToString(); result.Result = userModel; return result; } }
//Create Contact public static int Create(ContactDTO ContactDTO) { try { GlobalSettings.LoggedInClientId = ContactDTO.ClientId; int PartnerId = ClientService.GetById(ContactDTO.ClientId).PartnerId; GlobalSettings.LoggedInPartnerId = PartnerId; var contact = new Contact(); using (var uow = new UnitOfWork()) { contact = Transform.ContactToDomain(ContactDTO); uow.ContactRepo.Insert(contact); uow.SaveChanges(); if (ContactDTO.Groups != null) { foreach (var item in ContactDTO.Groups) { AddGroupToContact(contact.Id, item.Id); } } return (contact.Id); } } catch (Exception) { throw; } }
public Log GetNextPrevImage(int? id, Enums.Arrow? arrow, string person) { using (var unitOfWork = new UnitOfWork()) { var repository = new LogRepository(unitOfWork.Session); if (id == null) { return repository.Query(r => r.PersonName == person).FirstOrDefault(); } else { switch (arrow) { case Enums.Arrow.Left: return repository.Query(r => r.PersonName == person && r.Id < id).LastOrDefault(); break; case Enums.Arrow.Right: return repository.Query(r => r.PersonName == person && r.Id > id).FirstOrDefault(); break; default: break; } } return repository.Query(r => r.PersonName == person).First(); } }
public DailyUrgentPoReport() { uow = new UnitOfWork(); _ReportName = @"DailyUrgentPoReport.xls"; _SheetName = @"主页"; _SaveFilePath = string.Format(@"{0}DailyUrgentPoReport - NPD\DailyUrgentPoReport_{1}.xls", SystemSetting.GetInstance(uow).WIPReportPath, DateTime.Today.ToString("yyyy_MM_dd")); }
public void CompleteComputingTask(Guid asynTaskID, Guid userID, int totalComputed, int totalProfile, DataErrorCode dataErrorCode) { #region Lưu Sys_AsynTask khi xử lý xong if (asynTaskID != Guid.Empty) { using (var taskContext = new VnrHrmDataContext()) { IUnitOfWork taskunitOfWork = new UnitOfWork(taskContext); var asynTask = taskunitOfWork.CreateQueryable<Sys_AsynTask>(s => s.ID == asynTaskID).FirstOrDefault(); if (asynTask != null) { asynTask.PercentComplete = 1D; asynTask.TimeEnd = DateTime.Now; asynTask.Status = AsynTaskStatus.Done.ToString(); var time = asynTask.TimeEnd.Value.Subtract(asynTask.TimeStart).TotalMinutes; asynTask.Description += " - Result: " + totalComputed + "/" + totalProfile; asynTask.Description += " - Time: " + time.ToString("N2"); if (dataErrorCode == DataErrorCode.Locked) { asynTask.PercentComplete = 1D;//Không cần nhân với 100 asynTask.Description = "Dữ Liệu Quẹt Thẻ Đã Bị Khóa"; } dataErrorCode = taskunitOfWork.SaveChanges(); } } } #endregion }
public void Integration_LogDataContext_URF_QueryFluent_CallInfo_Include_StationCallsign_Return_StationCallsign() { List<CallInfo> callis = null; using (IDataContextAsync context = new ContestqsoDataContext()) using (IUnitOfWorkAsync unitOfWorkData = new UnitOfWork(context)) { bool caught = false; IRepositoryAsync<CallInfo> _CallinfoRepository = new Repository<CallInfo>(context, unitOfWorkData); try { TestContext.WriteLine("Integration_LogDataContext_URF_QueryFluent_CallInfo_Include_StationCallsign_Return_StationCallsign"); //tracked callis = _CallinfoRepository.Query(x => x.UserName == "default") .Include(x => x.Station).Include(x => x.CallSign) .Select().OrderBy(t => t.SessionName).ThenBy(t => t.CallGroup) .ToList(); } catch (Exception ex) { TestContext.WriteLine(string.Format("Integration_LogDataContext_URF_QueryFluent_CallInfo_Include_StationCallsign_Return_StationCallsign exception {0}", ex.Message)); caught = true; } Assert.IsFalse(caught); //exception Assert.IsNotNull(callis); Assert.IsInstanceOfType(callis, typeof(List<CallInfo> ) ); Assert.AreEqual(3, callis.Count ); Assert.IsNotNull(callis[0].CallSign); Assert.IsNotNull(callis[0].Station); } }
TestResult DeleteUser() { using (var unitOfWork = new UnitOfWork(new AuthorizationModuleFactory(false))) { var UserService = new UserService(unitOfWork); var testUser = UserService.Get(user => user.Login == "ivan_test++").FirstOrDefault(); UserService.Delete(testUser); try { var result = unitOfWork.Commit(); if (result.Count > 0) return new TestResult(TestResultType.Failure, MethodBase.GetCurrentMethod().Name, result.First().ErrorMessage); } catch (Exception ex) { while (ex.InnerException != null) ex = ex.InnerException; return new TestResult(TestResultType.Failure, MethodBase.GetCurrentMethod().Name, ex.Message); } } using (var unitOfWork = new UnitOfWork(new AuthorizationModuleFactory(false))) { var UserService = new UserService(unitOfWork); User testUser = UserService.Get(user => user.Login == "ivan_test++").FirstOrDefault(); if (testUser != null) return new TestResult(TestResultType.Failure, MethodBase.GetCurrentMethod().Name, "Can find deleted user."); else return new TestResult(TestResultType.Success, MethodBase.GetCurrentMethod().Name, "User deleted successfully."); } }
// private void createObjectTypeColumn(XPClassInfo xpClassInfo, UnitOfWork unitOfWork) // { // unitOfWork.CreateObjectTypeRecords(xpClassInfo); // var newObject = xpClassInfo.CreateNewObject(unitOfWork); // unitOfWork.CommitChanges(); // unitOfWork.Delete(newObject); // unitOfWork.CommitChanges(); // } private void updateObjectType(UnitOfWork unitOfWork, XPClassInfo xpClassInfo, XPClassInfo mergedXPClassInfo, IDbCommand command) { var propertyName = XPObject.Fields.ObjectType.PropertyName; command.CommandText = "UPDATE [" + getTableName(mergedXPClassInfo) + "] SET " + propertyName + "=" + unitOfWork.GetObjectType(xpClassInfo).Oid + " WHERE " + propertyName + " IS NULL OR " + propertyName + "=" +unitOfWork.GetObjectType(mergedXPClassInfo).Oid; command.ExecuteNonQuery(); }
public FrmCrearTipoNomina(TipoNomina tiponomina, XPCollection xpcTipoNomina, UnitOfWork uow) : this() { this.TipoNomina = tiponomina; this.uow = uow; this.xpcTipoNomina = xpcTipoNomina; }
public override void Setup(ApplicationModulesManager moduleManager) { base.Setup(moduleManager); var businessClassesList = GetAdditionalClasses(moduleManager); WCTypesInfo.Instance.Register(businessClassesList); if (Application == null || GetPath() == null) return; Application.SettingUp += ApplicationOnSettingUp; if (FullConnectionString != null) { var xpoMultiDataStoreProxy = new SqlMultiDataStoreProxy(FullConnectionString, GetReflectionDictionary()); using (var dataLayer = new SimpleDataLayer(xpoMultiDataStoreProxy)) { using (var session = new Session(dataLayer)) { using (var unitOfWork = new UnitOfWork(session.DataLayer)) { RunUpdaters(session); AddDynamicModules(moduleManager, unitOfWork); } } } } else { var assemblies = AppDomain.CurrentDomain.GetAssemblies().Where(assembly => assembly.ManifestModule.ScopeName.EndsWith(CompileEngine.XpandExtension)); foreach (var assembly1 in assemblies) { moduleManager.AddModule(assembly1.GetTypes().Where(type => typeof(ModuleBase).IsAssignableFrom(type)).Single()); } } Application.SetupComplete += ApplicationOnSetupComplete; }
private void RefreshUsersList() { repository = UnitOfWork.CreateInstance(); AllUsers = repository.Users.GetAll().OrderBy(u=>u.UserName).ToList(); UserListViewModel viewModel = new UserListViewModel(AllUsers); usersbindingSource.DataSource = viewModel.Users; }
public virtual void ShouldAllowByDefaultRegisterDataSourcesWithSameName() { try { InternalEnvironment.RegisterDataSource(new DataSource(il => new NullDataSession())); InternalEnvironment.RegisterDataSource(new DataSource(il => new NullDataSession())); using (var uow = new UnitOfWork()) { Awaken(uow); } InternalEnvironment.RegisterDataSource(new DataSource("test", IsolationLevel.RepeatableRead, il => new NullDataSession())); InternalEnvironment.RegisterDataSource(new DataSource("test", il => new NullDataSession())); using (var uow = new UnitOfWork("test")) { Awaken(uow); } Assert.That( () => InternalEnvironment.RegisterDataSource(new DataSource(il => new NullDataSession()), true), Throws.Exception.With.Message.EqualTo("Data source with name: '' has already been registered.")); Assert.That( () => InternalEnvironment.RegisterDataSource(new DataSource("test", il => new NullDataSession()), true), Throws.Exception.With.Message.EqualTo("Data source with name: 'test' has already been registered.")); } finally { InternalEnvironment.UnregisterDataSource(); InternalEnvironment.UnregisterDataSource("test"); } }
public virtual ActionResult Create(TerminalModel terminal) { try { using (UnitOfWork unitOfWork = new UnitOfWork()) { TerminalRepository insertionRepository = new TerminalRepository(unitOfWork.DataContext); DBTerminal dbTerminal = new DBTerminal { Id = terminal.Id, PhoneNumber = terminal.PhoneNumber, IsPublic = terminal.IsPublic, RegionId = terminal.RegionId, CorrectionFacilityId = terminal.CorrectionFacilityId, Description = terminal.Description, IsActive = terminal.IsActive }; insertionRepository.InsertObject(dbTerminal); unitOfWork.Commit(); // обновляем идентификатор terminal.Id = dbTerminal.Id; } // сохраняем идентификатор видеотерминала this.WriteInformation("Видеотерминал с идентификатором \"{0}\" добавлен.", terminal.Id); return RedirectToAction("Create"); } catch { return View(); } }
public void Integration_LogDataContext_URF_QueryableTrack_IncludeParam_Station_Return_Station_Track() { List<CallInfo> callis = null; IQueryable<CallInfo> CallInfo1 = null; using (IDataContextAsync context = new ContestqsoDataContext()) using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context)) { bool caught = false; IRepositoryAsync<CallInfo> _CallinfoRepository = new Repository<CallInfo>(context, unitOfWork); try { //var LogQ = _logRepository.Queryable(x => x.LogId == 1, x => x.Stations, x => x.CallSign); //CallInfo1 = _CallinfoRepository.Item(x => x.UserName == "default", x => x.Station); CallInfo1 = _CallinfoRepository.QueryableTrack(false, x => x.UserName == "default", x => x.Station); callis = CallInfo1.ToList(); } catch (Exception ex) { TestContext.WriteLine(string.Format("Integration_LogDataContext_URF_QueryableTrack_IncludeParam_Station_Return_Station_Track exception {0}", ex.Message)); caught = true; } Assert.IsFalse(caught); //exception Assert.IsNotNull(CallInfo1); Assert.IsInstanceOfType(CallInfo1, typeof(IQueryable<CallInfo>)); Assert.AreEqual(3, callis.Count ); //check if tracked //Assert.AreEqual(CallInfo1.Where(z=>z.CallGroup == (int)CallGroupEnum.CALL1).Select(x=>x.CallsignId).SingleOrDefault().)) Assert.AreEqual(Infrastructure.ObjectState.Unchanged, callis[0].ObjectState); Assert.IsNull(callis[0].CallSign); Assert.IsNotNull(callis[0].Station); Assert.IsTrue(_CallinfoRepository.GetEntityTrackingState(callis[0])); } }
public Result <ServiceResponse> SignUp(SignUpRequest request) { return(this.UseConnection("Default", connection => { request.CheckNotNull(); Check.NotNullOrWhiteSpace(request.Email, "email"); Check.NotNullOrEmpty(request.Password, "password"); UserRepository.ValidatePassword(request.Email, request.Password, true); Check.NotNullOrWhiteSpace(request.DisplayName, "displayName"); if (connection.Exists <UserRow>( UserRow.Fields.Username == request.Email | UserRow.Fields.Email == request.Email)) { throw new ValidationError("EmailInUse", Texts.Validation.EmailInUse); } using (var uow = new UnitOfWork(connection)) { string salt = null; var hash = UserRepository.GenerateHash(request.Password, ref salt); var displayName = request.DisplayName.TrimToEmpty(); var email = request.Email; var username = request.Email; var fld = UserRow.Fields; var userId = (int)connection.InsertAndGetID(new UserRow { Username = username, Source = "sign", DisplayName = displayName, Email = email, PasswordHash = hash, PasswordSalt = salt, IsActive = 0, InsertDate = DateTime.Now, InsertUserId = 1, LastDirectoryUpdate = DateTime.Now }); byte[] bytes; using (var ms = new MemoryStream()) using (var bw = new BinaryWriter(ms)) { bw.Write(DateTime.UtcNow.AddHours(3).ToBinary()); bw.Write(userId); bw.Flush(); bytes = ms.ToArray(); } var token = Convert.ToBase64String(MachineKey.Protect(bytes, "Activate")); var externalUrl = Config.Get <EnvironmentSettings>().SiteExternalUrl ?? Request.Url.GetLeftPart(UriPartial.Authority) + VirtualPathUtility.ToAbsolute("~/"); var activateLink = UriHelper.Combine(externalUrl, "Account/Activate?t="); activateLink = activateLink + Uri.EscapeDataString(token); var emailModel = new ActivateEmailModel(); emailModel.Username = username; emailModel.DisplayName = displayName; emailModel.ActivateLink = activateLink; var emailSubject = Texts.Forms.Membership.SignUp.ActivateEmailSubject.ToString(); var emailBody = TemplateHelper.RenderTemplate( MVC.Views.Membership.Account.SignUp.AccountActivateEmail, emailModel); ESignature.DAL.Email.SendMail("*****@*****.**", email, emailBody, "Welcome to E- Signature - Sign Up Your Account"); //Common.EmailHelper.Send(emailSubject, emailBody, email); uow.Commit(); UserRetrieveService.RemoveCachedUser(userId, username); return new ServiceResponse(); } })); }
public CreateStorage(UnitOfWork _unitOfWork) { unitOfWork = _unitOfWork; }
public override int Update(Comunidad entity) { uow = new UnitOfWork(); uow.ComunidadRepository.Update(entity); return(1); }
public FeatureControllerTest() { IUnitOfWork uow = new UnitOfWork(); _controller = new FeatureController(uow); }
public Boolean Untrack(int id) { UnitOfWork work = new UnitOfWork(); return(work.QuestRepository.Untrack(id)); }
private Patient GetPatient(int id) { return(UnitOfWork.Repository <Patient>().Queryable().SingleOrDefault(p => p.Id == id)); }
public HubAllocationService(UnitOfWork unitOfWork) { this._unitOfWork = unitOfWork; }
public ClientService(UnitOfWork _unitOfWork) { unitOfWork = _unitOfWork; }
// constructor public OrderController() { objectProvider = objectProvider == null ? new ObjectProvider() : objectProvider; unitOfWork = unitOfWork == null ? objectProvider.UnitOfWork : unitOfWork; orderRepository = orderRepository == null ? unitOfWork.OrderRepository : orderRepository; }
public JsonResult CreateOrEdit(DetailRecord input, Guid detailDoctorId, bool isEdit) { try { if (isEdit) //update { using (var workScope = new UnitOfWork(new PatientManagementDbContext())) { var elm = workScope.DetailRecords.Get(input.Id); if (elm != null) //update { //Che bien du lieu elm = input; elm.DoctorId = detailDoctorId; workScope.DetailRecords.Put(elm, elm.Id); workScope.Complete(); //attachments handle return(Json(new { status = true, mess = "Cập nhập thành công ", data = new { detailRecordId = input.Id } })); } else { return(Json(new { status = false, mess = "Không tồn tại " + KeyElement })); } } } else //Thêm mới { using (var workScope = new UnitOfWork(new PatientManagementDbContext())) { //Che bien du lieu input.Id = Guid.NewGuid(); input.DoctorId = detailDoctorId; workScope.DetailRecords.Add(input); workScope.Complete(); } return(Json(new { status = true, mess = "Thêm thành công " + KeyElement, data = new { detailRecordId = input.Id } })); } } catch (Exception ex) { return(Json(new { status = false, mess = "Có lỗi xảy ra: " + ex.Message })); } }
public EFILE_CHIASE_NGUOIDUNGBusiness(UnitOfWork unitofwork) : base(unitofwork) { }
public ReportService(UnitOfWork _unitOfWork) { unitOfWork = _unitOfWork; }
public string GetFullAddress(ClientContactAddress address, string sLanguage = "zh-CN") { switch (sLanguage) { case "zh-CN": using (var tempUow = new UnitOfWork()) { var country = tempUow.GetObjectByKey <CodeCountry>(address.n_Country); return((country == null ? "" : country.s_Name) + (string.IsNullOrEmpty(address.s_State) ? "" : address.s_State) + (string.IsNullOrEmpty(address.s_City) ? "" : address.s_City) + (string.IsNullOrEmpty(address.s_StreetAll) ? "" : address.s_StreetAll)); } case "en-US": using (var tempUow = new UnitOfWork()) { var sCountry = ""; var country = tempUow.GetObjectByKey <CodeCountry>(address.n_Country); if (country != null) { sCountry = string.IsNullOrEmpty(country.s_OtherName) ? country.s_Name : country.s_OtherName; } var sState = ""; CodeState state = null; if (!string.IsNullOrEmpty(address.s_State)) { if (country != null) { state = country.States.Cast <CodeState>().FirstOrDefault(f => f.s_StateName == address.s_State); } sState = state == null ? address.s_State : (string.IsNullOrEmpty(state.s_OStateName) ? state.s_StateName : state.s_OStateName); } var sCity = ""; CodeCity city = null; if (!string.IsNullOrEmpty(address.s_City)) { if (state != null) { city = state.Cities.Cast <CodeCity>().FirstOrDefault(f => f.s_CityName == address.s_City); } sCity = city == null ? address.s_City : (string.IsNullOrEmpty(city.s_OCityName) ? city.s_CityName : city.s_OCityName); } var sFullAddress = address.s_StreetAll; if (!string.IsNullOrEmpty(sCity)) { if (!string.IsNullOrEmpty(sFullAddress)) { sFullAddress = sFullAddress + ", "; } sFullAddress = sFullAddress + sCity; } if (!string.IsNullOrEmpty(sState)) { if (!string.IsNullOrEmpty(sFullAddress)) { sFullAddress = sFullAddress + ", "; } sFullAddress = sFullAddress + sState; } if (!string.IsNullOrEmpty(sCountry)) { if (!string.IsNullOrEmpty(sFullAddress)) { sFullAddress = sFullAddress + ", "; } sFullAddress = sFullAddress + sCountry; } return(sFullAddress); } default: return(""); } }
protected Repository(UnitOfWork unitOfWork) { _unitOfWork = unitOfWork; }
public EfNewsService(UnitOfWork unitOfWork) { _unitOfWork = unitOfWork; }
public XReportDialogViewModel(ReportType type) { XReport = new XReportHolder(UnitOfWork.get().Orders.GetAllOpenInZ()); IsXMode = type.Value.Equals(ReportType.X.Value); ReportName = type.Value; }
public void Init() { this.uow = new UnitOfWork(Shared.BuildConnectionClosure); }
public GameDetailsController(UnitOfWork unitOfWork, BattleShipIdentityContext dBContext) { _unitOfWork = unitOfWork; }
public void SaveExcelOffLineData(DataSet dataSetInvoices, string SupplierGSTIN, string UserId, string offlineid) { UnitOfWork unitofwork = new UnitOfWork(); try { decimal temp; foreach (EnumConstants.OfflineSheetName sheetName in Enum.GetValues(typeof(EnumConstants.OfflineSheetName))) { if (sheetName == EnumConstants.OfflineSheetName.B2B) { var table = GetExcelDataTable(dataSetInvoices, EnumConstants.OfflineSheetName.B2B); var dt = Get5RowOnward(table, 3); if (dt != null) { var invo = from item in dt.AsEnumerable() select new GST_TRN_OFFLINE_INVOICE_DATAITEM { GST_TRN_OFFLINE_INVOICE = GetInvoiceInformation(item, SupplierGSTIN, Convert.ToByte(EnumConstants.OfflineSheetName.B2B), UserId, offlineid), RateId = GetRateId(decimal.TryParse(item.ItemArray[8].ToString(), out temp)? temp :(decimal?)null), TotalTaxableValue = decimal.TryParse(item.ItemArray[9].ToString(), out temp)? temp :(decimal?)null, CessAmt = decimal.TryParse(item.ItemArray[10].ToString(), out temp) ? temp : (decimal?)null, }; foreach (var item in invo) { unitOfWork.OfflineinvoicedataitemRepository.Create(item); unitOfWork.Save(); } } } else if (sheetName == EnumConstants.OfflineSheetName.B2CL) { var table = GetExcelDataTable(dataSetInvoices, EnumConstants.OfflineSheetName.B2CL); var dt = Get5RowOnward(table, 2); if (dt != null) { var invo = from item in dt.AsEnumerable() select new GST_TRN_OFFLINE_INVOICE_DATAITEM { GST_TRN_OFFLINE_INVOICE = GetInvoiceInformation(item, SupplierGSTIN, Convert.ToByte(EnumConstants.OfflineSheetName.B2CL), UserId, offlineid), RateId = GetRateId(decimal.TryParse(item.ItemArray[4].ToString(), out temp) ? temp : (decimal?)null), TotalTaxableValue = (decimal.TryParse(item.ItemArray[5].ToString(), out temp) ? temp : (decimal?)null), CessAmt = (decimal.TryParse(item.ItemArray[6].ToString(), out temp) ? temp : (decimal?)null), }; foreach (var item in invo) { unitOfWork.OfflineinvoicedataitemRepository.Create(item); unitOfWork.Save(); } } } else if (sheetName == EnumConstants.OfflineSheetName.B2CS) { var table = GetExcelDataTable(dataSetInvoices, EnumConstants.OfflineSheetName.B2CS); var dt = Get5RowOnward(table, 2); if (dt != null) { var invo = from item in dt.AsEnumerable() select new GST_TRN_OFFLINE_INVOICE_DATAITEM { GST_TRN_OFFLINE_INVOICE = GetInvoiceInformation(item, SupplierGSTIN, Convert.ToByte(EnumConstants.OfflineSheetName.B2CS), UserId, offlineid), RateId = GetRateId(decimal.TryParse(item.ItemArray[2].ToString(), out temp) ? temp : (decimal?)null), TotalTaxableValue = (decimal.TryParse(item.ItemArray[3].ToString(), out temp) ? temp : (decimal?)null), CessAmt = (decimal.TryParse(item.ItemArray[4].ToString(), out temp) ? temp : (decimal?)null), }; foreach (var item in invo) { unitOfWork.OfflineinvoicedataitemRepository.Create(item); unitOfWork.Save(); } } } else if (sheetName == EnumConstants.OfflineSheetName.CDNR) { var table = GetExcelDataTable(dataSetInvoices, EnumConstants.OfflineSheetName.CDNR); var dt = Get5RowOnward(table, 2); if (dt != null) { var invo = from item in dt.AsEnumerable() select new GST_TRN_OFFLINE_INVOICE_DATAITEM { GST_TRN_OFFLINE_INVOICE = GetInvoiceInformation(item, SupplierGSTIN, Convert.ToByte(EnumConstants.OfflineSheetName.CDNR), UserId, offlineid), RateId = GetRateId(decimal.TryParse(item.ItemArray[9].ToString(), out temp) ? temp : (decimal?)null), TotalTaxableValue = (decimal.TryParse(item.ItemArray[10].ToString(), out temp) ? temp : (decimal?)null), CessAmt = (decimal.TryParse(item.ItemArray[11].ToString(), out temp) ? temp : (decimal?)null), }; foreach (var item in invo) { unitOfWork.OfflineinvoicedataitemRepository.Create(item); unitOfWork.Save(); } } } else if (sheetName == EnumConstants.OfflineSheetName.CDNUR) { var table = GetExcelDataTable(dataSetInvoices, EnumConstants.OfflineSheetName.CDNUR); var dt = Get5RowOnward(table, 2); if (dt != null) { var invo = from item in dt.AsEnumerable() select new GST_TRN_OFFLINE_INVOICE_DATAITEM { GST_TRN_OFFLINE_INVOICE = GetInvoiceInformation(item, SupplierGSTIN, Convert.ToByte(EnumConstants.OfflineSheetName.CDNUR), UserId, offlineid), RateId = GetRateId(decimal.TryParse(item.ItemArray[9].ToString(), out temp) ? temp : (decimal?)null), TotalTaxableValue = (decimal.TryParse(item.ItemArray[10].ToString(), out temp) ? temp : (decimal?)null), CessAmt = (decimal.TryParse(item.ItemArray[11].ToString(), out temp) ? temp : (decimal?)null), }; foreach (var item in invo) { unitOfWork.OfflineinvoicedataitemRepository.Create(item); unitOfWork.Save(); } } } else if (sheetName == EnumConstants.OfflineSheetName.EXP) { var table = GetExcelDataTable(dataSetInvoices, EnumConstants.OfflineSheetName.EXP); var dt = Get5RowOnward(table, 2); if (dt != null) { var invo = from item in dt.AsEnumerable() select new GST_TRN_OFFLINE_INVOICE_DATAITEM { GST_TRN_OFFLINE_INVOICE = GetInvoiceInformation(item, SupplierGSTIN, Convert.ToByte(EnumConstants.OfflineSheetName.EXP), UserId, offlineid), RateId = GetRateId((decimal.TryParse(item.ItemArray[7].ToString(), out temp) ? temp : (decimal?)null)), TotalTaxableValue = (decimal.TryParse(item.ItemArray[8].ToString(), out temp) ? temp : (decimal?)null), }; foreach (var item in invo) { unitOfWork.OfflineinvoicedataitemRepository.Create(item); unitOfWork.Save(); } } } else if (sheetName == EnumConstants.OfflineSheetName.AT) { var table = GetExcelDataTable(dataSetInvoices, EnumConstants.OfflineSheetName.AT); var dt = Get5RowOnward(table, 2); if (dt != null) { var invo = from item in dt.AsEnumerable() select new GST_TRN_OFFLINE_INVOICE_DATAITEM { GST_TRN_OFFLINE_INVOICE = GetInvoiceInformation(item, SupplierGSTIN, Convert.ToByte(EnumConstants.OfflineSheetName.AT), UserId, offlineid), RateId = GetRateId((decimal.TryParse(item.ItemArray[1].ToString(), out temp) ? temp : (decimal?)null)), CessAmt = (decimal.TryParse(item.ItemArray[3].ToString(), out temp) ? temp : (decimal?)null), }; foreach (var item in invo) { unitOfWork.OfflineinvoicedataitemRepository.Create(item); unitOfWork.Save(); } } } else if (sheetName == EnumConstants.OfflineSheetName.ATADJ) { var table = GetExcelDataTable(dataSetInvoices, EnumConstants.OfflineSheetName.ATADJ); var dt = Get5RowOnward(table, 2); if (dt != null) { var invo = from item in dt.AsEnumerable() select new GST_TRN_OFFLINE_INVOICE_DATAITEM { GST_TRN_OFFLINE_INVOICE = GetInvoiceInformation(item, SupplierGSTIN, Convert.ToByte(EnumConstants.OfflineSheetName.ATADJ), UserId, offlineid), RateId = GetRateId(decimal.TryParse(item.ItemArray[1].ToString(), out temp) ? temp : (decimal?)null), // Gros= Convert.ToDecimal(item.ItemArray[9]), CessAmt = (decimal.TryParse(item.ItemArray[3].ToString(), out temp) ? temp : (decimal?)null) }; foreach (var item in invo) { unitOfWork.OfflineinvoicedataitemRepository.Create(item); unitOfWork.Save(); } } } //else if (sheetName == EnumConstants.OfflineSheetName.EXEMP) //{ // var table = GetExcelDataTable(dataSetInvoices, EnumConstants.OfflineSheetName.EXEMP); // var dt = Get5RowOnward(table); // var invo = from item in dt.AsEnumerable() // select new GST_TRN_OFFLINE_INVOICE_DATAITEM // { // GST_TRN_OFFLINE_INVOICE = GetInvoiceInformation(item, SupplierGSTIN, Convert.ToByte(EnumConstants.OfflineSheetName.EXEMP), UserId), // // RateId = GetRateId(Convert.ToDecimal(item.ItemArray[1])), // // Gros= Convert.ToDecimal(item.ItemArray[9]), // CessAmt = Convert.ToDecimal(item.ItemArray[3]), // }; // foreach (var item in invo) // { // item.ValueID = item.GST_TRN_OFFLINE_INVOICE.ValueId; // // item.Rate = item.Rate; // // item.TotalTaxableValue = item.TotalTaxableValue; // item.CessAmt = item.CessAmt; // unitOfWork.OfflineinvoicedataitemRepository.Create(item); // unitOfWork.Save(); // } //} else if (sheetName == EnumConstants.OfflineSheetName.HSN) { var table = GetExcelDataTable(dataSetInvoices, EnumConstants.OfflineSheetName.HSN); var dt = Get5RowOnward(table, 2); if (dt != null) { var invo = from item in dt.AsEnumerable() select new GST_TRN_OFFLINE_INVOICE_DATAITEM { GST_TRN_OFFLINE_INVOICE = GetInvoiceInformation(item, SupplierGSTIN, Convert.ToByte(EnumConstants.OfflineSheetName.HSN), UserId, offlineid), TotalQuantity = (decimal.TryParse(item.ItemArray[3].ToString(), out temp) ? temp : (decimal?)null), TotalValue = (decimal.TryParse(item.ItemArray[4].ToString(), out temp) ? temp : (decimal?)null), TotalTaxableValue = (decimal.TryParse(item.ItemArray[5].ToString(), out temp) ? temp : (decimal?)null), // RateId = GetRateId(Convert.ToDecimal(item.ItemArray[6])), IGSTAmt = (decimal.TryParse(item.ItemArray[6].ToString(), out temp) ? temp : (decimal?)null), CGSTAmt = (decimal.TryParse(item.ItemArray[7].ToString(), out temp) ? temp : (decimal?)null), SGSTAmt = (decimal.TryParse(item.ItemArray[8].ToString(), out temp) ? temp : (decimal?)null), CessAmt = (decimal.TryParse(item.ItemArray[9].ToString(), out temp) ? temp : (decimal?)null), }; foreach (var item in invo) { unitOfWork.OfflineinvoicedataitemRepository.Create(item); unitOfWork.Save(); } } } } } catch (DbEntityValidationException ex) { foreach (var eve in ex.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } }
public BaseXpoController() : base() { fSession = CreateSession(); }
/// <summary> /// Construtor /// </summary> public TipoGuiaSaida() { _unitOfWork = new UnitOfWork(); }
/// <summary> /// Creates instance of the repository. /// </summary> /// <param name="Context">Database context.</param> /// <param name="UnitOfWork">Instance of unit of work that owns the repository.</param> public RemoteServerRepositoryBase(Context Context, UnitOfWork UnitOfWork) : base(Context, UnitOfWork) { }
public ProjectsController() { this.unitOfWork = new UnitOfWork(); projectService = new ProjectService(unitOfWork); }
public clsOffline() { unitOfWork = new UnitOfWork(); }
public FluentInvoiceDetailQuery(UnitOfWork unitOfWork) { _unitOfWork = unitOfWork; }
private async Task DownloadCountryData(Country country, DateTime?lastUpdatedDate) { ShowLoader(String.Format(AppResources.SplashLoaderTextDownloadingCountryData, country.Name)); if (user == null) { Token registerAnonymousToken = await DrumbleApiService.RegisterAnonymous(cancellationTokenSource.Token); user = new User(registerAnonymousToken); UnitOfWork.UserRepository.Insert(user); UnitOfWork.Save(); } IEnumerable <PublicTransportOperator> operators = await BumbleApiService.Operators(cancellationTokenSource.Token, user); UnitOfWork.PublicTransportOperatorRepository.RemoveAll(); IEnumerable <PublicTransportOperator> operatorsList = operators.ToList(); if (operatorsList.Count() == 0) { throw new Exception(AppResources.ApiErrorPopupMessageNoResources); } List <OperatorSetting> operatorSettings = UnitOfWork.OperatorSettingRepository.GetAll().ToList(); foreach (PublicTransportOperator transportOperator in operatorsList) { if (!operatorSettings.Select(x => x.OperatorName).Contains(transportOperator.Name)) { if (transportOperator.IsPublic) { UnitOfWork.OperatorSettingRepository.Insert(new OperatorSetting(transportOperator.Name, true)); } else { UnitOfWork.OperatorSettingRepository.Insert(new OperatorSetting(transportOperator.Name, false)); } } } UnitOfWork.PublicTransportOperatorRepository.InsertRange(operatorsList); UnitOfWork.Save(); user.Country = country; UnitOfWork.UserRepository.Update(user); UnitOfWork.Save(); CacheSetting cacheSetting = UnitOfWork.CacheSettingRepository.GetByType(ResourceType.Operators); cacheSetting.LastRefreshedDateUtc = DateTime.UtcNow; UnitOfWork.CacheSettingRepository.Update(cacheSetting); UnitOfWork.Save(); HideLoader(); TryNavigateToStartPage(); }
public void TestInitialize() { string dateConvert = "2021-04-04 12:14:11"; IFormatProvider format = new System.Globalization.CultureInfo("es-ES", false); DateTime date = new DateTime(); date = DateTime.ParseExact(dateConvert, "yyyy-MM-dd HH:mm:ss", format); _data = new List <ActivityPracticioner> { new ActivityPracticioner { IdActivityPracticioner = 9, Qualification = 0, ActivityPracticionerStatus = ActivityPracticionerStatus.NOTQUALIFIED, Enrollment = "zS18012149", Activity = new Activity { IdActivity = 1, Name = "Primer reporte parcial", ActivityType = ActivityType.PartialReport, ActivityStatus = ActivityStatus.ACTIVE, Description = "Entregar el primer reporte parcial corresponsdiente a 200 horas.", ValueActivity = 10, StartDate = new DateTime(), FinishDate = date, StaffNumberTeacher = "5678" } } }; DbSet <ActivityPracticioner> _mockSet = DbContextMock.GetQueryableMockDbSet(_data, x => x.IdActivityPracticioner); ProfessionalPracticesContext _mockContext = DbContextMock.GetContext(_mockSet); _unitOfWork = new UnitOfWork(_mockContext); _dataActivity = new List <Activity> { new Activity { IdActivity = 1, Name = "Primer reporte parcial", ActivityType = ActivityType.PartialReport, ActivityStatus = ActivityStatus.ACTIVE, Description = "Entregar el primer reporte parcial corresponsdiente a 200 horas.", ValueActivity = 10, StartDate = new DateTime(), FinishDate = date, StaffNumberTeacher = "5678" } }; DbSet <Activity> _mockSetActivity = DbContextMock.GetQueryableMockDbSet(_dataActivity, x => x.IdActivity); ProfessionalPracticesContext _mockContextActivity = DbContextMock.GetContext(_mockSetActivity); _unitOfWorkActivity = new UnitOfWork(_mockContextActivity); _dataDocument = new List <Document> { new Document { IdDocument = 1, Name = "datos.docx", RouteSave = "C:/Users/MARTHA/Documents/Activity/1", DeliveryDate = date, ActivityPracticioner = new ActivityPracticioner { IdActivityPracticioner = 9, Qualification = 0, ActivityPracticionerStatus = ActivityPracticionerStatus.NOTQUALIFIED, Enrollment = "zS18012149", IdActivity = 1, Activity = new Activity { IdActivity = 1, Name = "Primer reporte parcial", ActivityType = ActivityType.PartialReport, ActivityStatus = ActivityStatus.ACTIVE, Description = "Entregar el primer reporte parcial corresponsdiente a 200 horas.", ValueActivity = 10, StartDate = new DateTime(), FinishDate = date, StaffNumberTeacher = "5678" } } } }; DbSet <Document> _mockSetDocument = DbContextMock.GetQueryableMockDbSet(_dataDocument, x => x.IdDocument); ProfessionalPracticesContext _mockContextDocument = DbContextMock.GetContext(_mockSetDocument); _unitOfWorkDocument = new UnitOfWork(_mockContextDocument); }
public FluentJobCostTypeQuery(UnitOfWork unitOfWork) { _unitOfWork = unitOfWork; }
public FilmEdit(UnitOfWork unitOfWork, IAuthorization authorization, IWebHostEnvironment hostEnvironment) { _unitOfWork = unitOfWork; _authorization = authorization; _hostEnvironment = hostEnvironment; }
public ProjectService(UnitOfWork uow, IMapper mapper) : base(uow, mapper) { }