public override async Task <IObjectModel> SelectByIDAsync(long id, long userId, CancellationToken cancellationToken) { DataTable dt; Dictionary <string, object> param = new Dictionary <string, object>(); param.Add(DBObjects.SPParameter.ObjectId, GetParameter(DBObjects.SPParameter.ObjectId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, id)); param.Add(DBObjects.SPParameter.UserId, GetParameter(DBObjects.SPParameter.UserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, userId)); dt = await this.GetSPDataTableAsync(DBObjects.StoredProcedures.pspObjectSelectById.ToString(), cancellationToken, param); IObjectModel model = new ObjectModel(); model.ObjectId = Convert.ToInt64(dt.Rows[0][DBObjects.Fields.ObjectId]); model.ModuleId = Convert.ToInt64(dt.Rows[0][DBObjects.Fields.ModuleId]); model.Name = dt.Rows[0][DBObjects.Fields.Name].ToString(); model.Description = PublicFunctions.ConvertNULL(dt.Rows[0][DBObjects.Fields.Description], ""); model.Caption = dt.Rows[0][DBObjects.Fields.Caption].ToString(); model.URL = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dt.Rows[0][DBObjects.Fields.URL])); model.ParentObjectId = Convert.ToInt64(dt.Rows[0][DBObjects.Fields.ParentObjectId]); model.ObjectLevel = Convert.ToInt32(dt.Rows[0][DBObjects.Fields.ObjectLevel]); model.AllowWrite = Convert.ToBoolean(dt.Rows[0][DBObjects.Fields.AllowWrite]); model.AllowDelete = Convert.ToBoolean(dt.Rows[0][DBObjects.Fields.AllowDelete]); model.IsActive = Convert.ToBoolean(dt.Rows[0][DBObjects.Fields.IsActive]); model.ObjectOrder = Convert.ToByte(PublicFunctions.ConvertDBNullToNull(dt.Rows[0][DBObjects.Fields.ObjectOrder])); model.ObjectImage = PublicFunctions.ConvertNULL(dt.Rows[0][DBObjects.Fields.ObjectImage], ""); return(model); }
public override async Task <IAdvertisementModel> SelectByIDAsync(Int64 id, Int64 userId, CancellationToken cancellationToken) { DataTable dt = null; Dictionary <string, object> param = new Dictionary <string, object>(); param.Add(DBObjects.SPParameter.AdvertisementId, GetParameter(DBObjects.SPParameter.AdvertisementId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, id)); param.Add(DBObjects.SPParameter.UserId, GetParameter(DBObjects.SPParameter.UserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, userId)); dt = await this.GetSPDataTableAsync(DBObjects.StoredProcedures.hspAdvertisementSelectById.ToString(), cancellationToken, param); IAdvertisementModel model = new AdvertisementModel(); model.AdvertisementId = Convert.ToInt64(dt.Rows[0]["AdvertisementId"]); model.Name = PublicFunctions.ConvertNULL(dt.Rows[0]["Name"], ""); model.Description = PublicFunctions.ConvertNULL(dt.Rows[0]["Description"], ""); model.CategoryName = PublicFunctions.ConvertNULL(dt.Rows[0]["CategoryName"], ""); model.IsMoreThanOne = Convert.ToInt32(PublicFunctions.ConvertNULL(dt.Rows[0]["IsMoreThanOne"], false)); model.Quantity = PublicFunctions.ConvertNULL(dt.Rows[0]["Quantity"], (int)0); model.IsVisibleToPublic = Convert.ToInt32(PublicFunctions.ConvertNULL(dt.Rows[0]["IsVisibleToPublic"], false)); model.ChargingTypeId = PublicFunctions.ConvertNULL(dt.Rows[0]["ChargingTypeId"], (long)0); model.DefaultTimeChargingId = PublicFunctions.ConvertNULL(dt.Rows[0]["DefaultTimeChargingId"], (long)0); model.MinimumCharges = PublicFunctions.ConvertNULL(dt.Rows[0]["MinimumCharges"], (decimal)0.00); model.BondCharges = PublicFunctions.ConvertNULL(dt.Rows[0]["BondCharges"], (decimal)0.00); model.DepositCharges = PublicFunctions.ConvertNULL(dt.Rows[0]["DepositCharges"], (decimal)0.00); model.FixedRateCharges = PublicFunctions.ConvertNULL(dt.Rows[0]["FixedRateCharges"], (decimal)0.00); model.FixedRateLabel = PublicFunctions.ConvertNULL(dt.Rows[0]["FixedRateLabel"], ""); model.SpecialTerms = PublicFunctions.ConvertNULL(dt.Rows[0]["SpecialTerms"], ""); model.VisibilityType = PublicFunctions.ConvertNULL(dt.Rows[0]["VisibilityType"], (int)0); model.LocationId = PublicFunctions.ConvertNULL(dt.Rows[0]["LocationId"], (long)0); model.AdvertiserId = PublicFunctions.ConvertNULL(dt.Rows[0]["AdvertiserId"], (long)0); model.Email = PublicFunctions.ConvertNULL(dt.Rows[0]["Email"], ""); model.Web = PublicFunctions.ConvertNULL(dt.Rows[0]["Web"], ""); model.PhoneNumber = PublicFunctions.ConvertNULL(dt.Rows[0]["PhoneNumber"], ""); model.Address = PublicFunctions.ConvertNULL(dt.Rows[0]["Address"], ""); model.AddDate = PublicFunctions.ConvertNULL(dt.Rows[0]["AddDate"], DateTime.Now.AddYears(-100)); model.ChargingDetail = PublicFunctions.ConvertNULL(dt.Rows[0]["ChargingDetail"], ""); model.ChargingTypeName = PublicFunctions.ConvertNULL(dt.Rows[0]["ChargingTypeName"], ""); return(model); }
/// <summary> /// Custom rights implementation on Objects /// </summary> /// <param name="userId"></param> /// <param name="objName"></param> /// <returns>AuthModel which defines Edit/Delete rights</returns> public AuthModel AuthorizeObject(long userId, string objName, string action) { DataTable dt; AuthModel model = null; Dictionary <string, object> param = new Dictionary <string, object>(); param.Add(DBObjects.SPParameter.UserId, GetParameter(DBObjects.SPParameter.UserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, userId)); param.Add(DBObjects.SPParameter.ObjectName, GetParameter(DBObjects.SPParameter.ObjectName, ParameterDirection.Input, ((int)SqlDbType.VarChar), 50, objName)); dt = this.GetSPDataTable(DBObjects.StoredProcedures.pspAuthorization.ToString(), ref param); if (dt.Rows.Count > 0) { model = new AuthModel(); model.AllowWrite = PublicFunctions.ConvertNULL(dt.Rows[0]["AllowWrite"], false); model.AllowDelete = PublicFunctions.ConvertNULL(dt.Rows[0]["AllowDelete"], false); model.ObjectName = Convert.ToString(dt.Rows[0]["ObjectName"]); model.URL = Convert.ToString(dt.Rows[0]["URL"]); model.IsWithoutSearch = PublicFunctions.ConvertNULL(dt.Rows[0]["IsWithoutSearch"], false); model.IsPublicUser = Convert.ToBoolean(dt.Rows[0]["IsPublicUser"]); } return(model); }
public override async Task <long> SaveAsync(IAdvertisementModel model, CancellationToken cancellationToken) { Dictionary <string, object> param = new Dictionary <string, object>(); string csIds = "", csPrices = ""; if (model.TimePrices != null && model.TimePrices.Count > 0) { foreach (ValueId par in model.TimePrices) { csIds = csIds + par.Id + ","; csPrices = csPrices + par.Price + ","; } } param.Add(DBObjects.SPParameter.Name, GetParameter(DBObjects.SPParameter.Name, ParameterDirection.Input, ((int)SqlDbType.NVarChar), model.Name.Length, PublicFunctions.ConvertNulltoDBNull(model.Name))); param.Add(DBObjects.SPParameter.Address, GetParameter(DBObjects.SPParameter.Address, ParameterDirection.Input, ((int)SqlDbType.NVarChar), model.Address.Length, PublicFunctions.ConvertNulltoDBNull(model.Address))); param.Add(DBObjects.SPParameter.PhoneNumber, GetParameter(DBObjects.SPParameter.PhoneNumber, ParameterDirection.Input, ((int)SqlDbType.NVarChar), model.PhoneNumber.Length, PublicFunctions.ConvertNulltoDBNull(model.PhoneNumber))); param.Add(DBObjects.SPParameter.Web, GetParameter(DBObjects.SPParameter.Web, ParameterDirection.Input, ((int)SqlDbType.NVarChar), model.Web.Length, PublicFunctions.ConvertNulltoDBNull(model.Web))); param.Add(DBObjects.SPParameter.Email, GetParameter(DBObjects.SPParameter.Email, ParameterDirection.Input, ((int)SqlDbType.NVarChar), model.Email.Length, PublicFunctions.ConvertNulltoDBNull(model.Email))); param.Add(DBObjects.SPParameter.AdvertiserId, GetParameter(DBObjects.SPParameter.AdvertiserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, PublicFunctions.ConvertNulltoDBNull(model.AdvertiserId))); param.Add(DBObjects.SPParameter.CategoryId, GetParameter(DBObjects.SPParameter.CategoryId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, PublicFunctions.ConvertNulltoDBNull(model.CategoryIds[0]))); param.Add(DBObjects.SPParameter.LocationId, GetParameter(DBObjects.SPParameter.LocationId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, PublicFunctions.ConvertNulltoDBNull(model.LocationId))); param.Add(DBObjects.SPParameter.VisibilityType, GetParameter(DBObjects.SPParameter.VisibilityType, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, PublicFunctions.ConvertNulltoDBNull(model.VisibilityType))); param.Add(DBObjects.SPParameter.SpecialTerms, GetParameter(DBObjects.SPParameter.SpecialTerms, ParameterDirection.Input, ((int)SqlDbType.NVarChar), model.SpecialTerms.Length, PublicFunctions.ConvertNulltoDBNull(model.SpecialTerms))); param.Add(DBObjects.SPParameter.FixedRateLabel, GetParameter(DBObjects.SPParameter.FixedRateLabel, ParameterDirection.Input, ((int)SqlDbType.NVarChar), model.FixedRateLabel.Length, PublicFunctions.ConvertNulltoDBNull(model.FixedRateLabel))); param.Add(DBObjects.SPParameter.FixedRateCharges, GetParameter(DBObjects.SPParameter.FixedRateCharges, ParameterDirection.Input, ((int)SqlDbType.Decimal), 16, PublicFunctions.ConvertNulltoDBNull(model.FixedRateCharges))); param.Add(DBObjects.SPParameter.DepositCharges, GetParameter(DBObjects.SPParameter.DepositCharges, ParameterDirection.Input, ((int)SqlDbType.Decimal), 16, PublicFunctions.ConvertNULL(model.DepositCharges, (Decimal)0))); param.Add(DBObjects.SPParameter.BondCharges, GetParameter(DBObjects.SPParameter.BondCharges, ParameterDirection.Input, ((int)SqlDbType.Decimal), 16, PublicFunctions.ConvertNULL(model.BondCharges, (Decimal)0))); param.Add(DBObjects.SPParameter.MinimumCharges, GetParameter(DBObjects.SPParameter.MinimumCharges, ParameterDirection.Input, ((int)SqlDbType.Decimal), 16, PublicFunctions.ConvertNULL(model.MinimumCharges, (Decimal)0))); param.Add(DBObjects.SPParameter.DefaultTimeChargingId, GetParameter(DBObjects.SPParameter.DefaultTimeChargingId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 16, PublicFunctions.ConvertNulltoDBNull(model.DefaultTimeChargingId))); param.Add(DBObjects.SPParameter.ChargingTypeId, GetParameter(DBObjects.SPParameter.ChargingTypeId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 16, PublicFunctions.ConvertNulltoDBNull(model.ChargingTypeId))); param.Add(DBObjects.SPParameter.IsVisibleToPublic, GetParameter(DBObjects.SPParameter.IsVisibleToPublic, ParameterDirection.Input, ((int)SqlDbType.Bit), 4, PublicFunctions.ConvertNulltoDBNull(Convert.ToBoolean(model.IsVisibleToPublic)))); param.Add(DBObjects.SPParameter.Quantity, GetParameter(DBObjects.SPParameter.Quantity, ParameterDirection.Input, ((int)SqlDbType.Int), 16, PublicFunctions.ConvertNulltoDBNull(model.Quantity))); param.Add(DBObjects.SPParameter.IsMoreThanOne, GetParameter(DBObjects.SPParameter.IsMoreThanOne, ParameterDirection.Input, ((int)SqlDbType.Bit), 4, PublicFunctions.ConvertNulltoDBNull(Convert.ToBoolean(model.IsMoreThanOne)))); param.Add(DBObjects.SPParameter.Description, GetParameter(DBObjects.SPParameter.Description, ParameterDirection.Input, ((int)SqlDbType.NVarChar), model.Description.Length, PublicFunctions.ConvertNulltoDBNull(model.Description))); param.Add(DBObjects.SPParameter.IdList, GetParameter(DBObjects.SPParameter.IdList, ParameterDirection.Input, ((int)SqlDbType.NVarChar), csIds.Length, PublicFunctions.ConvertNulltoDBNull(csIds))); param.Add(DBObjects.SPParameter.PriceList, GetParameter(DBObjects.SPParameter.PriceList, ParameterDirection.Input, ((int)SqlDbType.NVarChar), csPrices.Length, PublicFunctions.ConvertNulltoDBNull(csPrices))); param.Add(DBObjects.SPParameter.AddUserId, GetParameter(DBObjects.SPParameter.AddUserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, model.UserId)); param.Add(DBObjects.SPParameter.AdvertisementId, GetParameter(DBObjects.SPParameter.AdvertisementId, ParameterDirection.Output, ((int)SqlDbType.BigInt), 8, 0)); param.Add(DBObjects.SPParameter.RetVal, GetParameter(DBObjects.SPParameter.RetVal, ParameterDirection.Output, ((int)SqlDbType.Int), 4, 0)); await this.ExecuteSPAsync(DBObjects.StoredProcedures.hspAdvertisementSave.ToString(), cancellationToken, param); return(Convert.ToInt64(((SqlParameter)param[DBObjects.SPParameter.RetVal]).Value)); }