public float detectionDist; //TODO: Move this to the AI weapon system
public virtual void Init(string objectID, BaseEntityController controller, bool weaponsActive, VesselShipStats shipStats, SceneController sceneController)
{
this.objectID = objectID;
this.controller = controller;
this.shipStats = shipStats;
gameManager = GameManager.Instance;
}
public ICollection <OptionType> GetOptionTypeByProductId(int productId)
{
ICollection <OptionType> list = null;
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@ProductId", productId)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Product_GetOptionTypeByProductId]", parameters);
list = BaseEntityController.FillEntities <OptionType>(reader);
if (list != null)
{
for (int i = 0; i < list.Count; i++)
{
if (!String.IsNullOrEmpty(list.ElementAt(i).ProductOptionXml))
{
list.ElementAt(i).ProductOptionList = Utility.XmlToObjectList <ProductOptions>(list.ElementAt(i).ProductOptionXml, "/ProductOptions/ProductOption");
}
}
}
return(list);
}
public ICollection <AdonType> GetAllAdonType()
{
#region Parameters
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[AdonType_GetAllAdonType]", null);
return(BaseEntityController.FillEntities <AdonType>(reader));
}
public ICollection <Mail> GetAllNotSendEmails()
{
#region Parameters
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Mail_GetAllNotSendEmails]", null);
return(BaseEntityController.FillEntities <Mail>(reader));
}
/// <summary>
/// Get All product categories by branch
/// </summary>
/// <param name="branchId"></param>
/// <returns></returns>
public ICollection <ProductCategories> GetProductCategories()
{
#region Parameters
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[ProductCategories_GetProductCategories]", null);
return(BaseEntityController.FillEntities <ProductCategories>(reader));
}
public ICollection <SliderImage> GetHomePageSliders()
{
#region Parameters
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[SliderImage_GetHomePageSliders]", null);
return(BaseEntityController.FillEntities <SliderImage>(reader));
}
/*
* public int UpdateCarParkingService(CarParkingService carParkingService)
* {
#region Parameters
*
* IParameter[] parameters = new Parameter[]{
* new Parameter("@CarParkingServiceId",carParkingService.CarParkingServiceId),
* new Parameter("@ServiceName",carParkingService.ServiceName),
* new Parameter("@ServicePrice",carParkingService.ServicePrice)
* };
*
#endregion
* object result = DBHandler.ExecuteScalar(System.Data.CommandType.StoredProcedure, "[CarParkingService_UpdateCarParkingService]", parameters);
* return Convert.ToInt32(result.ToString());
* }
*
* public CarReservation GetCarReservationById(int carReservationId)
* {
#region Parameters
*
* IParameter[] parameters = new Parameter[]{
* new Parameter("@CarReservationId",carReservationId )
* };
*
#endregion
*
* IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[CarReservation_GetCarReservationById]", parameters);
* return BaseEntityController.FillEntity<CarReservation>(reader);
* }*/
public ICollection <Branches> GetAllBranch()
{
#region Parameters
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Branch_GetAllBranch]", null);
return(BaseEntityController.FillEntities <Branches>(reader));
}
public override void Init(string objectID, BaseEntityController controller, bool weaponsActive, VesselShipStats shipStats, SceneController sceneController)
{
base.Init(objectID, controller, weaponsActive, shipStats, sceneController);
//Create the aim assist object
aimAssist = new AimAssist();
aimAssist.Init(this, sceneController.dynamicHud.aimSightUI);
SetupWeapons();
}
public override void Init(string objectID, BaseEntityController controller, bool weaponsActive, VesselShipStats shipStats, SceneController sceneController)
{
base.Init(objectID, controller, weaponsActive, shipStats, sceneController);
// Retrieves interface for the target finder
targetFinder = this.GetComponent <ITargetFinder>();
// creates new target checker for relative direction check
targetChecker = new TargetDirectionCheck();
}
public StatHandler(BaseStats baseStats, EntityType entityType, BaseEntityController controller)
{
this.currentStats = baseStats;
this.defaultStats = baseStats;
this.controller = controller;
//Init variables
currentFireRate = currentStats.fireRate;
currentHealth = currentStats.maxHealth;
damageBuff = currentStats.statModifier.damageModif;
}
public ContactAddresses GetUserAddressByUserId(Int64 userLoginId)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@UserLoginId", userLoginId)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Users_GetUsersBillingAddressByUserId]", parameters);
return(BaseEntityController.FillEntity <ContactAddresses>(reader));
}
//AimAssist aimAssist;
public override void Init(string objectID, BaseEntityController controller, bool weaponsActive, VesselShipStats shipStats, SceneController sceneController)
{
base.Init(objectID, controller, weaponsActive, shipStats, sceneController);
aimAssist = new AimAssist();
aimAssist.Init(this, sceneController.dynamicHud.aimSightUI);
targetChecker = new TargetDirectionCheck();
//shipTransforms = this.GetComponent<VesselTransforms>();
detectionDist = shipStats.maxProximityDist / 3;
SetupWeapons();
}
public ICollection <OrderDetails> GetOrderDetail(long orderId)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@OrderId", orderId)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[OrderDetail_GetOrderDetail]", parameters);
return(BaseEntityController.FillEntities <OrderDetails>(reader));
}
/*
* public int UpdateCarParkingService(CarParkingService carParkingService)
* {
#region Parameters
*
* IParameter[] parameters = new Parameter[]{
* new Parameter("@CarParkingServiceId",carParkingService.CarParkingServiceId),
* new Parameter("@ServiceName",carParkingService.ServiceName),
* new Parameter("@ServicePrice",carParkingService.ServicePrice)
* };
*
#endregion
* object result = DBHandler.ExecuteScalar(System.Data.CommandType.StoredProcedure, "[CarParkingService_UpdateCarParkingService]", parameters);
* return Convert.ToInt32(result.ToString());
* }
*
* public CarReservation GetCarReservationById(int carReservationId)
* {
#region Parameters
*
* IParameter[] parameters = new Parameter[]{
* new Parameter("@CarReservationId",carReservationId )
* };
*
#endregion
*
* IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[CarReservation_GetCarReservationById]", parameters);
* return BaseEntityController.FillEntity<CarReservation>(reader);
* }*/
public Orders GetOrderById(Int64 orderId)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@OrderId", orderId)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Orders_GetOrderById]", parameters);
return(BaseEntityController.FillEntity <Orders>(reader));
}
/// <summary>
/// Get all deal child products that were added against deal
/// </summary>
/// <param name="productId"></param>
/// <returns></returns>
public ICollection <Products> GetProductByCategoryId(Int16 categoryId)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@CategoryId", categoryId)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Product_GetProductByCategoryId]", parameters);
return(BaseEntityController.FillEntities <Products>(reader));
}
public ICollection <ProductAdon> GetDealAdonsByProductId(Int32 productId)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@ProductId", productId)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Product_GetDealAdonByProductId]", parameters);
return(BaseEntityController.FillEntities <ProductAdon>(reader));
}
/// <summary>
/// Get All products that are not added in branch
/// </summary>
/// <param name="branchId"></param>
/// <returns></returns>
public ICollection <Products> GetProductsNotInBranch(Int32 branchId)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@BranchID", branchId)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Product_GetProductsNotInBranch]", parameters);
return(BaseEntityController.FillEntities <Products>(reader));
}
public Branches GetBranchById(Int32 branchId)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@BranchId", branchId)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Branch_GetBranchById]", parameters);
return(BaseEntityController.FillEntity <Branches>(reader));
}
/// <summary>
/// Get PromotionCodes by PromotionCodeId
/// </summary>
/// <param name="productId"></param>
/// <returns></returns>
public PromotionCodes GetPromotionCodesById(int promotionCodeId)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@PromotionCodeId", promotionCodeId)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[PromotionCode_GetPromotionCodeById]", parameters);
return(BaseEntityController.FillEntity <PromotionCodes>(reader));
}
public ProductsInBranches GetProductInBranchById(Int64 branchProductID)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@BranchProductID", branchProductID)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[BranchProduct_GetProductInBranchById]", parameters);
return(BaseEntityController.FillEntity <ProductsInBranches>(reader));
}
public UserLogin ValidateUser(String username, String password)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@Username", username),
new Parameter("@Password", password)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Users_ValidateUser]", parameters);
return(BaseEntityController.FillEntity <UserLogin>(reader));
}
public Products GetProductDetailByProductId(int productId, Int32?comboId)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@ProductId", productId)
, new Parameter("@ComboId", comboId)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Product_GetProductDetailsByProductId]", parameters);
return(BaseEntityController.FillEntity <Products>(reader));
}
public Adon GetAdonById(Int16 adonId)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@AdOnID", adonId)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Adon_GetAdonById]", parameters);
return(BaseEntityController.FillEntity <Adon>(reader));
}
public ContactInfo GetContactInfoByEmailOrPhone(bool isEmail, String filterValue)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@FilterValue", filterValue),
new Parameter("@IsEmail", isEmail)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[ContactInfo_GetContactInfoByEmailOrPhone]", parameters);
return(BaseEntityController.FillEntity <ContactInfo>(reader));
}
/// <summary>
/// Get All product categories by branch
/// </summary>
/// <param name="branchId"></param>
/// <returns></returns>
public ICollection <ProductCategories> GetHomePageProductCategories(int branchId)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@BranchId", branchId)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[ProductCategories_GetHomePageProductCategories]", parameters);
return(BaseEntityController.FillEntities <ProductCategories>(reader));
}
public ICollection <AdonType> GetAdonType(Int32 pageNumber, Int32 pageSize)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@PageNumber", pageNumber)
, new Parameter("@PageSize", pageSize)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[AdonType_GetAdonType]", parameters);
return(BaseEntityController.FillEntities <AdonType>(reader));
}
public Mail GetMailByReferenceId(long referenceId, string referenceType)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@ReferenceId", referenceId),
new Parameter("@ReferenceType", referenceType)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Mail_GetMailByReferenceId]", parameters);
return(BaseEntityController.FillEntity <Mail>(reader));
}
public FileEntityResult Update(long fileId, IEnumerable <FileEntityDetail> details, Dictionary <long, long[]> taxonomyTypeTaxonomies, User byUser = null)
{
var entity = BaseEntityController.Update <FileEntity, FileEntityDetail, FileEntityTaxonomy>(_entityHelper, _taxonomyHelper, fileId, details, taxonomyTypeTaxonomies, byUser, false);
try
{
Save();
return(new FileEntityResult(JsonResultState.Success, entity.Name, _stringLocalizer["Update successfuly!"]));
}
catch (Exception ex)
{
return(new FileEntityResult(JsonResultState.Failed, entity.Name, ex.Message));
}
}
/// <summary>
/// Get Promotion code list
/// </summary>
/// <param name="promotionName"></param>
/// <param name="promotionCode"></param>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public ICollection <PromotionCodes> GetPromotionCode(String promotionName, String promotionCode, Int32 pageNumber, Int32 pageSize)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@PromotionName", promotionName)
, new Parameter("@PromotionCode", promotionCode)
, new Parameter("@PageNumber", pageNumber)
, new Parameter("@PageSize", pageSize)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[PromotionCode_GetPromotionCode]", parameters);
return(BaseEntityController.FillEntities <PromotionCodes>(reader));
}
public ICollection <Orders> GetOrderByContactInfoId(int branchId, long contactInfoId, int pageNumber, int pageSize)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@BranchId", branchId),
new Parameter("@ContactInfoId", contactInfoId),
new Parameter("@PageNumber", pageNumber),
new Parameter("@PageSize", pageSize)
};
#endregion
IDataReader reader = DBHandler.ExecuteReader(System.Data.CommandType.StoredProcedure, "[Orders_GetOrderByContactInfoId]", parameters);
return(BaseEntityController.FillEntities <Orders>(reader));
}
