public Owner(int id, OwnerType type, string name) { this.ID = id; this.Type = type; this.Name = name; this.listOfAccounts = new List<Account>(); }
public IList<RTKM> GetRTKMReport(OwnerType ownerType) { IList<RTKM> list = new List<RTKM>(); SqlService sql = new SqlService(_sqlConnection); sql.AddParameter("@pOwnerType", System.Data.SqlDbType.TinyInt, (int)ownerType); using (SqlDataReader r = sql.ExecuteSPReader("ICMS_spReport_RTKM")) { if (r.HasRows) { while (r.Read()) { RTKM rtkm = new RTKM(); rtkm.TTRef = r.SafeGetString(r.GetOrdinal("ref")); rtkm.TTID = r.SafeGetString(r.GetOrdinal("id")); rtkm.TTNo = r.SafeGetString(r.GetOrdinal("no")); rtkm.Distance = r.SafeGetInt(r.GetOrdinal("km")).Value; rtkm.Trips = r.SafeGetInt(r.GetOrdinal("trips")).Value; rtkm.Quantity = r.SafeGetInt(r.GetOrdinal("qty")).Value; list.Add(rtkm); } } } return list; }
private User GetUser(OwnerType owner) => _fixture.Build <User>().With(u => u.Name, owner.ToString()).Create();
/* * PRIVATE * METHODS */ //UpdateOwner => on variable //Launch when picked up by somebody bool _UpdateOwner(GameObject newOwner, OwnerType newOwnerType) { this.owner = newOwner; this.ownerType = newOwnerType; return true; }
public override int GetHashCode() { return(Name.GetHashCode() ^ PropertyType.GetHashCode() ^ OwnerType.GetHashCode()); }
public void AddCrown(int crown, OwnerType owner = OwnerType.Defender) { CampVO camp = owner == OwnerType.Attacker ? Attacker : Defender; camp.player.crown += crown; }
public IEnumerable <T> FindAttributes <T>() where T : class => OwnerType.FindAttributes <T>().Concat(Method.FindAttributes <T>());
public OwnerInfo(OwnerType type) { ownerType = type; }
/// <summary> /// 获得或者使用资源 /// </summary> /// <param name="resource"></param> public void AddResource(ResourceVO addResource, OwnerType owner = OwnerType.Defender) { AddResource(addResource.resourceType, addResource.resourceCount, owner); }
public static PhoneListVm GetPhoneList(OwnerType ownerType) { return(((List <Entities.Admin.Phone>)null).MapToPhoneListVm(ownerType)); }
public static TileEntity Create(OwnerType owner, EntityModel model, bool isFriendly = false) { var entityObj = LoadAndCreate(model); var tileEntity = new TileEntity(); tileEntity.owner = owner; tileEntity.model = model; tileEntity.State = EntityStateType.Idle; tileEntity.aiType = (EntityAiType)model.targetType; tileEntity.entityType = model.entityType; tileEntity.Friendly = isFriendly; if (model.tileSize > 0) { tileEntity.width = tileEntity.height = model.tileSize * 2; // REMARK:建筑实际占用格子扩大2倍 } else { tileEntity.width = tileEntity.height = 1; } tileEntity.currentHp = tileEntity.maxHp = Mathf.Max(model.hp, 1); // REMARK:这里设置最大hp的最小值为1,不然对于工人等直接就是dead状态。 tileEntity.animationNamePrefix = model.nameForResource + "_"; // REMARK:建筑按照格子建造、士兵按照边行走(所以士兵位置比建筑偏移(0.5,0.5)) if (EntityTypeUtil.IsAnyActor(model.entityType)) { tileEntity.renderTileSizeOffset = new Vector2((tileEntity.width * 0.5f) - 1.0f, (tileEntity.height * 0.5f) - 1.0f); } else { tileEntity.renderTileSizeOffset = new Vector2((tileEntity.width * 0.5f) - 0.5f, (tileEntity.height * 0.5f) - 0.5f); } tileEntity.view = entityObj.GetComponent <EntityViewComponent>(); if (tileEntity.view == null) { if (EntityTypeUtil.IsAnyActor(tileEntity.entityType)) { tileEntity.view = entityObj.AddComponent <ActorView>(); } else if (EntityTypeUtil.IsAnyTower(tileEntity.entityType)) { tileEntity.view = entityObj.AddComponent <TowerView>(); } else { tileEntity.view = entityObj.AddComponent <EntityViewComponent>(); } } if (EntityTypeUtil.IsAnyBuilding(tileEntity.entityType))//[建筑类] { //1格以上建筑有地皮 if (model.tileSize > 2) { var floorBase = (GameObject)ResourceManager.Instance.LoadAndCreate(model.raceType + "/Entities/Misc/Floor4");//地皮 tileEntity.view.AddSubView(floorBase, Vector3.zero); IsoHelper.FaceToWorldCamera(floorBase.transform); IsoHelper.MoveAlongCamera(floorBase.transform, Constants.FLOOR_Z_ORDER); floorBase.transform.localScale = Vector3.one * model.tileSize / 4;//REMARK 现有素材占4x4个tilesize } if (EntityTypeUtil.IsBarracks(model)) { tileEntity.blockingRange = 3; } else { tileEntity.blockingRange = model.tileSize * 2 - 1; } tileEntity.AddComponent <ConstructBuildingComponent>(); if (model.entityType == EntityType.Tower) { tileEntity.AddComponent <TowerComponent>(); } else if (model.entityType == EntityType.Wall) { tileEntity.AddComponent <WallComponent>(); } else if (EntityTypeUtil.IsGatherResourceBuilding(model)) { tileEntity.AddComponent <GatherResourceBuildingComponent>(); } else if (EntityTypeUtil.IsStorageResoruceBuilding(model)) { tileEntity.AddComponent <ResourceStorageBuildingComponent>(); } else if (EntityTypeUtil.IsArmyShop(model)) { tileEntity.AddComponent <ProductSoldierBuildingComponent>(); } else if (EntityTypeUtil.IsSkillShop(model)) { tileEntity.AddComponent <ProductSkillBuildingComponent>(); } else if (EntityTypeUtil.IsWorkerHouse(model)) { tileEntity.AddComponent <WorkerHouseComponent>(); } else if (EntityTypeUtil.IsFederal(model)) { tileEntity.AddComponent <FederalComponent>(); } else if (EntityTypeUtil.IsResearch(model)) { tileEntity.AddComponent <ResearchBuildingComponent>(); } } else if (EntityTypeUtil.IsAnyActor(model.entityType)) //[角色类] { // 战斗模式 家园模式 通用组件 tileEntity.AddComponent <ActorMoveComponent>(); if (GameWorld.Instance.worldType == WorldType.Home || GameWorld.Instance.worldType == WorldType.Visit) //家园模式 或者 访问模式 { // 家园模式 // 工人(添加工人组件&添加到工人小屋中) if (EntityTypeUtil.IsWorker(model)) { tileEntity.AddComponent <WorkmanComponent>(); var houseComp = IsoMap.Instance.GetWorkerHouseComponent(); Assert.Should(houseComp != null, "worker house is not exist..."); houseComp.AddAWorkman(tileEntity); } else { tileEntity.AddComponent <ArmyComponent>(); } } else //战斗模式 { tileEntity.AddComponent <GameBufferComponent>(); // 设置士兵的监视范围(寻找目标用) REMARK:设定为4.0秒可以移动的范围 tileEntity.monitorRange = Mathf.Clamp(model.speed * 4.0f, 5.0f, 20.0f); if (EntityTypeUtil.IsBombMan(model)) { tileEntity.monitorRange = 0.0f; // 暂时不限制炸弹人 tileEntity.AddComponent <BombManComponent>(); } else if (EntityTypeUtil.IsCurer(model)) { tileEntity.AddComponent <CurerComponent>(); } else if (isFriendly) // 友军/援军 { tileEntity.AddComponent <FriendComponent>(); } else { tileEntity.AddComponent <ActorComponent>(); } // 除【友军/援军】以外添加拆墙组件(REMARK:友军/援军不可拆墙) if (!isFriendly) { tileEntity.AddComponent <ActorDestroyWallComponent>(); } } } else if (EntityTypeUtil.IsAnyTrap(model)) // [陷阱类] { tileEntity.AddComponent <TrapComponent>(); } Assert.Should((tileEntity.blockingRange == 0 || (tileEntity.blockingRange % 2) == 1), "invalid blockingRange..."); Assert.Should(tileEntity.blockingRange <= tileEntity.width - 1 && tileEntity.blockingRange <= tileEntity.height - 1, "invalid blockingRange..."); return(tileEntity); }
public static OwnerTypeModel ToServiceModel(this OwnerType ownerType) { return(Mapper.Map <OwnerType, OwnerTypeModel>(ownerType)); }
public static EmailListVm GetEmailListVm(OwnerType ownerType) { return(((List <Entities.Admin.Email>)null).MapToEmailListVm(ownerType)); }
public List<Owner> GetAllByOwnerType(OwnerType ownerType) { GetAllByOwnerTypeCommand getAllByOwnerTypeCommand = new GetAllByOwnerTypeCommand(ownerType); getAllByOwnerTypeCommand.Execute(); return getAllByOwnerTypeCommand.CommandResult; }
/// <summary> /// Parse a new authorise request /// </summary> /// <param name="type"> The session owner's type</param> /// <param name="typeId">The type identifier</param> /// <param name="authParams">The session owner"s ID</param> /// <returns>System.String An authorisation code</returns> public string NewAuthoriseRequest(OwnerType type, string typeId, dynamic authParams) { // Generate an auth code var authCode = SecureKey.Make(); // Remove any old sessions the user might have this.AuthServer.Session.DeleteSession(authParams.client_id, type, typeId); // Create a new session var sessionId = this.AuthServer.Session.CreateSession(authParams.client_id, type, typeId); // Associate a redirect URI this.AuthServer.Session.AssociateRedirectUri(sessionId, authParams.redirect_uri); // Associate the auth code var authCodeId = this.AuthServer.Session.AssociateAuthCode(sessionId, authCode, DateTime.Now.AddSeconds(this.authTokenTTL)); // Associate the scopes to the auth code foreach (var scope in authParams.scopes) { this.AuthServer.Session.AssociateAuthCodeScope(authCodeId, scope.ID); } return authCode; }
public Boolean SaveAsTemplate(OwnerType t, String prefixName, List <dtoTemplateTranslation> translations, List <String> contentModules, lm.Comol.Core.MailCommons.Domain.Messages.MessageSettings settings, lm.Comol.Core.DomainModel.ModuleObject obj = null) { Boolean saved = false; if (UserContext.isAnonymous) { View.CurrentMode = Domain.EditMessageMode.None; } else { TemplateType type = TemplateType.None; dtoBaseTemplateOwner ownership = new dtoBaseTemplateOwner() { IdPerson = UserContext.CurrentUserID, ModuleCode = View.ModuleCode }; switch (t) { case OwnerType.Object: ownership.Type = OwnerType.Object; ownership.IdObject = obj.ObjectLongID; ownership.IdObjectCommunity = obj.CommunityID; ownership.IdObjectModule = obj.ServiceID; ownership.IdObjectType = obj.ObjectTypeID; ownership.IsPortal = false; break; case OwnerType.Person: ownership.IsPortal = true; ownership.Type = OwnerType.Person; break; case OwnerType.Module: ownership.IsPortal = false; ownership.IdCommunity = View.ContainerIdCommunity; ownership.IdModule = CurrentManager.GetModuleID(View.ModuleCode); ownership.ModuleCode = View.ModuleCode; ownership.Type = OwnerType.Module; break; default: ownership = null; break; } if (ownership != null) { TemplateDefinition template = Service.AddTemplate(prefixName, type, ownership, contentModules, translations, settings); if (template == null) { View.DisplayTemplateUnSaved(t); } else { View.DisplayTemplateSaved(t); } } else { View.DisplayTemplateUnSaved(t); } } return(saved); }
private void GridBinding(int estterm_sub_id, OwnerType ownerType) { DataSet ds = null; if (ownerType == OwnerType.Dept) { rbnComDeptEmp.Text = "전체 부서 데이터"; UltraWebGrid1.Columns.FromKey("TGT_EMP_NAME").Hidden = true; UltraWebGrid1.Columns.FromKey("TGT_POS_CLS_NAME").Hidden = true; UltraWebGrid1.Columns.FromKey("TGT_POS_DUT_NAME").Hidden = true; UltraWebGrid1.Columns.FromKey("TGT_POS_GRP_NAME").Hidden = true; UltraWebGrid1.Columns.FromKey("TGT_POS_RNK_NAME").Hidden = true; UltraWebGrid1.Columns.FromKey("TGT_POS_KND_NAME").Hidden = true; } else if (ownerType == OwnerType.Dept) { rbnComDeptEmp.Text = "전체 사원 데이터"; UltraWebGrid1.Columns.FromKey("TGT_EMP_NAME").Hidden = false; UltraWebGrid1.Columns.FromKey("TGT_POS_CLS_NAME").Hidden = false; UltraWebGrid1.Columns.FromKey("TGT_POS_DUT_NAME").Hidden = false; UltraWebGrid1.Columns.FromKey("TGT_POS_GRP_NAME").Hidden = false; UltraWebGrid1.Columns.FromKey("TGT_POS_RNK_NAME").Hidden = false; UltraWebGrid1.Columns.FromKey("TGT_POS_KND_NAME").Hidden = false; } if (rbnComDeptEmp.Checked) { UltraWebGrid1.Columns.FromKey("TGT_DEPT_NAME").Header.Caption = "부서명"; UltraWebGrid1.Columns.FromKey("TGT_EMP_NAME").Header.Caption = "사원명"; UltraWebGrid1.Columns.FromKey("ESTTERM_SUB_NAME").Hidden = true; UltraWebGrid1.Columns.FromKey("EST_DEPT_NAME").Hidden = true; UltraWebGrid1.Columns.FromKey("EST_EMP_NAME").Hidden = true; Biz_EmpInfos biz = new Biz_EmpInfos(); if (OwnerTypeMode == OwnerType.Dept) { ds = biz.GetRelDeptList("WHERE", SENTENCE, "TM"); } else if (OwnerTypeMode == OwnerType.Emp_User) { ds = biz.GetRelEmpList("WHERE", SENTENCE, "TM"); } } else { UltraWebGrid1.Columns.FromKey("ESTTERM_SUB_NAME").Hidden = false; UltraWebGrid1.Columns.FromKey("EST_DEPT_NAME").Hidden = false; UltraWebGrid1.Columns.FromKey("EST_EMP_NAME").Hidden = false; UltraWebGrid1.Columns.FromKey("TGT_DEPT_NAME").Header.Caption = "피평가자부서"; UltraWebGrid1.Columns.FromKey("TGT_EMP_NAME").Header.Caption = "피평가자명"; Biz_Datas biz = new Biz_Datas(); if (OwnerTypeMode == OwnerType.Dept) { } else if (OwnerTypeMode == OwnerType.Emp_User) { } ds = biz.GetEstDataByRelGroup(COMP_ID , EST_ID , ESTTERM_REF_ID , estterm_sub_id , ESTTERM_STEP_ID , "AND " , SENTENCE); } UltraWebGrid1.DataSource = ds.Tables[0]; UltraWebGrid1.DataBind(); lblRowCount.Text = ds.Tables[0].Rows.Count.ToString("#,##0"); }
protected override OptionResult Run(Lot lot, Household me) { if (me != null) { List <ItemBase> allOptions = new List <ItemBase>(); foreach (RabbitHole hole in Sims3.Gameplay.Queries.GetObjects <RabbitHole>()) { if (!hole.RabbitHoleTuning.kCanInvestHere) { continue; } if (IsAlreadyOwned(hole, me)) { continue; } OwnerType type = OwnerType.NotOwned; PropertyData data = me.RealEstateManager.FindProperty(hole); if (data != null) { if (data.IsFullOwner) { type = OwnerType.Full; } else { type = OwnerType.Partial; } } allOptions.Add(new RabbitHoleItem(hole, type)); } foreach (Lot venue in LotManager.AllLots) { if (IsAlreadyOwned(venue, me)) { continue; } OwnerType type = OwnerType.NotOwned; int totalValue = 0; PropertyData data = me.RealEstateManager.FindProperty(venue); if (data != null) { type = OwnerType.Full; totalValue = data.TotalValue; } else { if (!venue.IsPurchaseableVenue) { continue; } } allOptions.Add(new VenueItem(venue, type, totalValue)); } CommonSelection <ItemBase> .Results choices = new CommonSelection <ItemBase>(Name, allOptions).SelectMultiple(); if ((choices == null) || (choices.Count == 0)) { return(OptionResult.Failure); } List <ItemBase> purchase = new List <ItemBase>(); foreach (ItemBase item in choices) { if (item.mType != OwnerType.Full) { purchase.Add(item); } else { item.Perform(me); } } foreach (ItemBase item in purchase) { if (!item.Perform(me)) { SimpleMessageDialog.Show(Name, Common.Localize(GetTitlePrefix() + ":Failure", false, new object[] { me.Name })); return(OptionResult.Failure); } } } return(OptionResult.SuccessClose); }
/// <summary> /// Returns a hash code for this instance. /// </summary> /// <returns> /// A hash code for this instance, suitable for use in hashing algorithms and data structures like a hash table. /// </returns> public override int GetHashCode() { return(OwnerType.GetHashCode()); }
public ItemBase(string name, OwnerType type) : base(name) { mType = type; }
public static IEnumerable <ItemEntity> GetItemsByOwner(OwnerType ownerType, int owner) { return((from entry in ItemsManager.Items where entry.OwnerType == ownerType && entry.Owner == owner select entry).ToList()); }
public RabbitHoleItem(RabbitHole hole, OwnerType type) : base(hole.CatalogName, type) { mHole = hole; }
public void RemoveResource(ResourceType resourceType, int resourceCount, OwnerType owner = OwnerType.Defender) { AddResource(resourceType, -resourceCount, owner); }
public VenueItem(Lot venue, OwnerType type, int totalValue) : base(venue.Name, type) { mVenue = venue; mTotalValue = totalValue; }
/// <summary> /// 得到大本营的Model /// </summary> /// <param name="owner"></param> /// <returns></returns> public EntityModel GetCenterBuildingModel(OwnerType owner = OwnerType.Defender) { CampVO camp = owner == OwnerType.Attacker ? Attacker : Defender; return(FindEntityModelById(camp.player.baseId)); }
/// <summary> /// 魚雷を発射したオーナーをセット /// </summary> /// <param name="type"></param> public void SetOwner(OwnerType type) { owner = type; }
public T FindAttribute <T>() where T : class => Method.FindAttribute <T>() ?? OwnerType.FindAttribute <T>();
public static void Delete(OwnerType ownerType, int owner) { throw new NotImplementedException(); }
public bool PickUp(GameObject newOwner, OwnerType newOwnerType) { this._UpdateOwner (newOwner,newOwnerType); return true; }
internal static EmailListVm MapToEmailListVm(this List <Email> emails, OwnerType ownerType) { return(emails.MapToEmailListVm(ItemTypeBc.Instance.GetEmailTypes(ownerType))); }
public static OwnerId Create(UInt32 value, OwnerType type) => new OwnerId() { Value = value, Type = type };
private User GetPrimaryUser(OwnerType owner) => _fixture.Build <User>().With(u => u.IdamsUserId, PrimaryUserId).Create();
public DataSet SelectEmp(int comp_id , int estterm_ref_id , int estterm_sub_id , int estterm_step_id , string est_id , string q_obj_id , int tgt_emp_id , OwnerType ownerType) { string query = @"SELECT EM.COMP_ID ,ED.DEPT_NAME ,CE.EMP_NAME ,PC.POS_CLS_ID ,PC.POS_CLS_NAME ,PD.POS_DUT_ID ,PD.POS_DUT_NAME ,PG.POS_GRP_ID ,PG.POS_GRP_NAME ,PR.POS_RNK_ID ,PR.POS_RNK_NAME ,EM.ESTTERM_REF_ID ,EM.ESTTERM_SUB_ID ,EM.ESTTERM_STEP_ID ,EM.EST_ID ,EM.Q_OBJ_ID ,QO.Q_OBJ_NAME ,EM.TGT_DEPT_ID ,EM.TGT_EMP_ID ,EM.CREATE_DATE ,EM.CREATE_USER ,EM.UPDATE_DATE ,EM.UPDATE_USER FROM EST_QUESTION_DEPT_EMP_MAP EM JOIN COM_DEPT_INFO ED ON (ED.DEPT_REF_ID = EM.TGT_DEPT_ID) JOIN REL_DEPT_EMP RD ON (EM.TGT_EMP_ID = RD.EMP_REF_ID) JOIN COM_EMP_INFO CE ON (RD.EMP_REF_ID = CE.EMP_REF_ID) JOIN EST_QUESTION_OBJECT QO ON (EM.Q_OBJ_ID = QO.Q_OBJ_ID) LEFT OUTER JOIN EST_POSITION_CLS PC ON (CE.POSITION_CLASS_CODE = PC.POS_CLS_ID) LEFT OUTER JOIN EST_POSITION_DUT PD ON (CE.POSITION_DUTY_CODE = PD.POS_DUT_ID) LEFT OUTER JOIN EST_POSITION_GRP PG ON (CE.POSITION_GRP_CODE = PG.POS_GRP_ID) LEFT OUTER JOIN EST_POSITION_RNK PR ON (CE.POSITION_RANK_CODE = PR.POS_RNK_ID) WHERE (EM.COMP_ID = @COMP_ID OR @COMP_ID = 0) AND (EM.ESTTERM_REF_ID = @ESTTERM_REF_ID OR @ESTTERM_REF_ID = 0) AND (EM.ESTTERM_SUB_ID = @ESTTERM_SUB_ID OR @ESTTERM_SUB_ID = 0) AND (EM.EST_ID = @EST_ID OR @EST_ID ='' ) AND (EM.Q_OBJ_ID = @Q_OBJ_ID OR @Q_OBJ_ID ='' ) AND (EM.TGT_EMP_ID = @TGT_EMP_ID OR @TGT_EMP_ID = 0)"; if (ownerType == OwnerType.Dept) { query += @" AND EM.TGT_EMP_ID < 0"; } else if (ownerType == OwnerType.Emp_User) { query += @" AND EM.TGT_EMP_ID > 0"; } IDbDataParameter[] paramArray = CreateDataParameters(6); paramArray[0] = CreateDataParameter("@COMP_ID", SqlDbType.Int); paramArray[0].Value = comp_id; paramArray[1] = CreateDataParameter("@ESTTERM_REF_ID", SqlDbType.Int); paramArray[1].Value = estterm_ref_id; paramArray[2] = CreateDataParameter("@ESTTERM_SUB_ID", SqlDbType.Int); paramArray[2].Value = estterm_sub_id; paramArray[3] = CreateDataParameter("@EST_ID", SqlDbType.NVarChar, 12); paramArray[3].Value = est_id; paramArray[4] = CreateDataParameter("@Q_OBJ_ID", SqlDbType.NVarChar, 20); paramArray[4].Value = q_obj_id; paramArray[5] = CreateDataParameter("@TGT_EMP_ID", SqlDbType.Int); paramArray[5].Value = tgt_emp_id; DataSet ds = DbAgentObj.FillDataSet(query, "QUESTIONDEPTEMPMAPGET", null, paramArray, CommandType.Text); return(ds); }
public void LogGenerate(ElementItem gridElement, OwnerType ownerType) { GenerateItem(new StepMessageData(GetMessageText(gridElement), ownerType)); _scrollRect.verticalNormalizedPosition = -0.2f; }
/// <summary> /// Delete a session /// <para /> /// Example SQL query: /// <code> /// DELETE FROM oauth_sessions WHERE client_id = :clientId AND owner_type = :type AND owner_id = :typeId /// </code> /// </summary> /// <param name="clientId">The client ID</param> /// <param name="ownerType">The type of the session owner (e.g. "user")</param> /// <param name="ownerId">The ID of the session owner (e.g. "123")</param> /// <exception cref="System.ArgumentException"> /// clientId /// or /// ownerType /// or /// ownerId /// </exception> public void DeleteSession(string clientId, OwnerType ownerType, string ownerId) { if (string.IsNullOrEmpty(clientId)) throw new ArgumentException("clientId"); if (string.IsNullOrEmpty(ownerId)) throw new ArgumentException("ownerId"); // DELETE FROM oauth_sessions WHERE client_id = :clientId AND owner_type = :type AND owner_id = :typeId using (var adc = new AditOAUTHDataContext(Constants.DBConnectionString)) { var os = adc.oauth_sessions.SingleOrDefault(o => o.client_id == clientId && o.owner_type == ownerType.ToString() && o.owner_id == ownerId); if (os == null) return; adc.oauth_sessions.DeleteOnSubmit(os); adc.SubmitChanges(); } }
public int DeleteWithJoin_DB(IDbConnection conn , IDbTransaction trx , object comp_id , object est_id , object estterm_ref_id , object estterm_sub_id , object estterm_step_id , object est_dept_id , object est_emp_id , object tgt_dept_id , object tgt_emp_id , object year_yn , object merge_yn , OwnerType ownerType) { string query = @"DELETE EST_DATA FROM EST_DATA ED JOIN EST_TERM_SUB ESU ON (ED.COMP_ID = ESU.COMP_ID AND ED.ESTTERM_SUB_ID = ESU.ESTTERM_SUB_ID) JOIN EST_TERM_STEP EST ON (ED.COMP_ID = EST.COMP_ID AND ED.ESTTERM_STEP_ID = EST.ESTTERM_STEP_ID) WHERE (ED.COMP_ID = @COMP_ID OR @COMP_ID = 0) AND (ED.EST_ID = @EST_ID OR @EST_ID ='' ) AND (ED.ESTTERM_REF_ID = @ESTTERM_REF_ID OR @ESTTERM_REF_ID = 0) AND (ED.ESTTERM_SUB_ID = @ESTTERM_SUB_ID OR @ESTTERM_SUB_ID = 0) AND (ED.ESTTERM_STEP_ID = @ESTTERM_STEP_ID OR @ESTTERM_STEP_ID = 0) AND (ED.EST_DEPT_ID = @EST_DEPT_ID OR @EST_DEPT_ID = 0) AND (ED.EST_EMP_ID = @EST_EMP_ID OR @EST_EMP_ID = 0) AND (ED.TGT_DEPT_ID = @TGT_DEPT_ID OR @TGT_DEPT_ID = 0) AND (ED.TGT_EMP_ID = @TGT_EMP_ID OR @TGT_EMP_ID = 0) AND (ESU.YEAR_YN = @YEAR_YN OR @YEAR_YN ='') AND (EST.MERGE_YN = @MERGE_YN OR @MERGE_YN ='')"; if (ownerType == OwnerType.Dept) { query += @" AND TGT_EMP_ID < 0"; } else if (ownerType == OwnerType.Emp_User) { query += @" AND TGT_EMP_ID > 0"; } IDbDataParameter[] paramArray = CreateDataParameters(11); paramArray[0] = CreateDataParameter("@COMP_ID", SqlDbType.Int); paramArray[0].Value = comp_id; paramArray[1] = CreateDataParameter("@EST_ID", SqlDbType.NVarChar, 12); paramArray[1].Value = est_id; paramArray[2] = CreateDataParameter("@ESTTERM_REF_ID", SqlDbType.Int); paramArray[2].Value = estterm_ref_id; paramArray[3] = CreateDataParameter("@ESTTERM_SUB_ID", SqlDbType.Int); paramArray[3].Value = estterm_sub_id; paramArray[4] = CreateDataParameter("@ESTTERM_STEP_ID", SqlDbType.Int); paramArray[4].Value = estterm_step_id; paramArray[5] = CreateDataParameter("@EST_DEPT_ID", SqlDbType.Int); paramArray[5].Value = est_dept_id; paramArray[6] = CreateDataParameter("@EST_EMP_ID", SqlDbType.Int); paramArray[6].Value = est_emp_id; paramArray[7] = CreateDataParameter("@TGT_DEPT_ID", SqlDbType.Int); paramArray[7].Value = tgt_dept_id; paramArray[8] = CreateDataParameter("@TGT_EMP_ID", SqlDbType.Int); paramArray[8].Value = tgt_emp_id; paramArray[9] = CreateDataParameter("@YEAR_YN", SqlDbType.NChar); paramArray[9].Value = year_yn; paramArray[10] = CreateDataParameter("@MERGE_YN", SqlDbType.NChar); paramArray[10].Value = merge_yn; int affectedRow = DbAgentObj.ExecuteNonQuery(conn, trx, query, paramArray, CommandType.Text); return(affectedRow); }
/// <summary> /// Create a new session /// <para /> /// Example SQL query: /// <code> /// INSERT INTO oauth_sessions (client_id, owner_type, owner_id) /// VALUE (:clientId, :ownerType, :ownerId) /// </code> /// <para /> /// </summary> /// <param name="clientId">The client ID</param> /// <param name="ownerType">The type of the session owner (e.g. "user")</param> /// <param name="ownerId">The ID of the session owner (e.g. "123")</param> /// <returns>System.Int32. The session ID</returns> /// <exception cref="System.ArgumentException"> /// clientId /// or /// ownerType /// or /// ownerId /// </exception> public int CreateSession(string clientId, OwnerType ownerType, string ownerId) { int session; if (string.IsNullOrEmpty(clientId)) throw new ArgumentException("clientId"); if (string.IsNullOrEmpty(ownerId)) throw new ArgumentException("ownerId"); // INSERT INTO oauth_sessions (client_id, owner_type, owner_id) VALUE (:clientId, :ownerType, :ownerId) using (var adc = new AditOAUTHDataContext(Constants.DBConnectionString)) { var os = new oauth_session { client_id = clientId, owner_type = ownerType.ToString(), owner_id = ownerId }; adc.oauth_sessions.InsertOnSubmit(os); adc.SubmitChanges(); session = os.id; } return session; }
///// <summary> ///// Creates the and persist form1099 oid. ///// </summary> ///// <returns></returns> //public static dynamic CreateAndPersistForm1099OID() //{ // var userDataId = 0L; // List<ErrorMessage> errorMessageList; // var primaryTaxPayer = IT_PersonalInfo.CreateAndPersistPrimaryTaxPayer(userId, FilingStatus.Single, ref userDataId); // var form1099OID = CreateForm1099OID(OwnerType.PrimaryTaxPayer); // var form1099OIDJson = JsonConvert.SerializeObject(form1099OID); // taxReturnData.TaxData = form1099OIDJson; // taxReturnData.UserDataId = userDataId; // //Persist Form1099OID // var userData = mInterestIncomeRepository.PersistTaxReturnForm1099OIDData(taxReturnData); // userData.UserId = userId; // return userData; //} /// <summary> /// Creates the form1099 oid. /// </summary> /// <param name="ownerType">Type of the owner.</param> /// <returns></returns> public static Form1099OID CreateForm1099OID(OwnerType ownerType) { Form1099OID form1099OID = null; form1099OID = new Form1099OID() { Form1099OIDId = 0, Payer = new Payer { PayerName = "Test Payer", PayerIdentificationNumber = "1234", Address = new Address { AddressId = 0, AddressType = AddressType.TaxPayerAddress, PayerAddress = new PayerAddress { City = "Test Payer City", StreetAddress = "Test Payer Street Address", State = new State { StateId = mPersonalInfoRepository.GetAllState().First().StateId }, ZipCode = "123456" }, } }, AccountNumber = "TestAc12345", OriginalIssueDiscount = Utilities.CreateRandomNumber(0, 2000), OtherPeriodicInterest = Utilities.CreateRandomNumber(0, 2000), EarlyWithdrawalPenalty = Utilities.CreateRandomNumber(0, 2000), IncomeMarketDiscount = Utilities.CreateRandomNumber(0, 2000), ForeignTaxPaid = Utilities.CreateRandomNumber(0, 2000), ForeignCountryId = 1, IsMutualFundRegulatedInvestment = Convert.ToBoolean(Utilities.CreateRandomNumber(0, 1)), USTreasuryObligations = Utilities.CreateRandomNumber(0, 2000), InvestmentExpenses = Utilities.CreateRandomNumber(0, 2000), IsStateInformationAvailable = Convert.ToBoolean(Utilities.CreateRandomNumber(0, 1)), InterestReceivedAsNominee = Utilities.CreateRandomNumber(0, 2000), AdjustmentAmount = Utilities.CreateRandomNumber(0, 2000), TaxableInterestAmount = Utilities.CreateRandomNumber(0, 2000), FederalTaxWithHoldingAmount = Utilities.CreateRandomNumber(0, 2000), Description = "testContent", Form1099StateInfo = new List <Form1099StateInformation> { new Form1099StateInformation { State = new State { StateId = mPersonalInfoRepository.GetAllState().First().StateId }, StateIdentificationNumber = "Test SIN143", StateTaxWithholdingAmount = Utilities.CreateRandomNumber(0, 2000) }, new Form1099StateInformation { State = new State { StateId = mPersonalInfoRepository.GetAllState().First().StateId }, StateIdentificationNumber = "Test SIN144", StateTaxWithholdingAmount = Utilities.CreateRandomNumber(0, 2000) }, }, AcquisitionPremium = Utilities.CreateRandomNumber(0, 2000), HasToReportTaxExempt = Convert.ToBoolean(Utilities.CreateRandomNumber(0, 1)), HasToReportAdjustment = Convert.ToBoolean(Utilities.CreateRandomNumber(0, 1)), TaxExemptInterestState = new State { StateId = mPersonalInfoRepository.GetAllState().First().StateId }, //TODO //StateExemptInterest = Utilities.CreateRandomNumber(0, 2000), TaxExemptInterest = Utilities.CreateRandomNumber(0, 2000), Form = FormType.Form1099OID }; return(form1099OID); }