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
};
public OwnerInfo(OwnerType type)
{
ownerType = 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);
}
public RabbitHoleItem(RabbitHole hole, OwnerType type)
: base(hole.CatalogName, type)
{
mHole = hole;
}
/// <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;
}
public VenueItem(Lot venue, OwnerType type, int totalValue)
: base(venue.Name, type)
{
mVenue = venue;
mTotalValue = totalValue;
}
///// <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);
}
public ItemBase(string name, OwnerType type)
: base(name)
{
mType = type;
}
