public void Remove(LocationRemoveCommand command)
{
Status = EnumDefine.CommonStatusEnum.Deleted;
UpdatedDateUtc = command.CreatedDateUtc;
UpdatedUid = command.UpdatedUid;
UpdatedDateUtc = command.UpdatedDateUtc;
//AddEvent(this.ToRemoveEvent());
}
public async Task ChangeStatus(string id, EnumDefine.CommonStatusEnum status, string userId, DateTime updatedDate)
{
await WithConnection(async (connection) =>
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Id", id, DbType.String);
parameters.Add("@Status", status.AsEnumToInt(), DbType.Int16);
parameters.Add("@UpdatedDateUtc", updatedDate, DbType.DateTime);
parameters.Add("@UpdatedUid", userId, DbType.String);
return(await connection.ExecuteAsync(ProcName.BannerItem_ChangeStatus, parameters, commandType: CommandType.StoredProcedure));
});
}
public void ChangeStatus(EnumDefine.CommonStatusEnum status, DateTime updatedDate, string uid)
{
Status = status;
UpdatedDateUtc = updatedDate;
UpdatedUid = uid;
if (status == CommonStatusEnum.Deleted)
{
AddEvent(ToRemoveCacheEvent());
}
else
{
AddEvent(ToAddOrChangeCacheEvent());
}
}
public void Init(ProvinceUpdateCommand command)
{
Id = command.Id;
Prefix = "";
ProvinceName = command.ProvinceName;
ProvinceNameEN = command.ProvinceNameEN;
Status = EnumDefine.CommonStatusEnum.Active;
ShortName = "";
Priority = 1;
Latitude = command.Latitude;
Longitude = command.Longitude;
RegionId = 1;
UpdatedDateUtc = command.UpdatedDateUtc;
CreatedDateUtc = new DateTime(2018, 03, 14, 11, 46, 02);
CreatedUid = "";
UpdatedUid = command.UpdatedUid;
}
public async Task <RProductGroup[]> Search(string name, EnumDefine.CommonStatusEnum status, RefSqlPaging sqlPaging)
{
return(await WithConnection(async (connection) =>
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Name", name, DbType.String);
parameters.Add("@Status", status.AsEnumToInt(), DbType.Int32);
parameters.Add("@DeleteStatus", EnumDefine.CommonStatusEnum.Deleted.AsEnumToInt(), DbType.Int32);
parameters.Add("@OFFSET", sqlPaging.OffSet, DbType.Int32);
parameters.Add("@FETCH", sqlPaging.PageSize, DbType.Int32);
var data = await connection.QueryAsync <RProductGroup>(ProcName.ProductGroup_Search, parameters, commandType: CommandType.StoredProcedure);
var dataReturn = data.ToArray();
if (dataReturn.Length > 0)
{
sqlPaging.TotalRow = dataReturn[0].TotalRow;
}
return dataReturn;
}));
}
public async Task <RTemplate[]> Search(string code, string templateName, EnumDefine.CommonStatusEnum status, RefSqlPaging paging)
{
return(await WithConnection(async (connection) =>
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Code", string.IsNullOrEmpty(code) ? string.Empty : code, DbType.String);
parameters.Add("@TemplateName", string.IsNullOrEmpty(templateName) ? string.Empty : templateName, DbType.String);
parameters.Add("@Status", status.AsEnumToInt(), DbType.Int16);
parameters.Add("@OFFSET", paging.OffSet, DbType.Int32);
parameters.Add("@FETCH", paging.PageSize, DbType.Int32);
parameters.Add("@DeletedStatus", EnumDefine.CommonStatusEnum.Deleted.AsEnumToInt(), DbType.Int32);
var data = await connection.QueryAsync <RTemplate>(ProcName.Template_Search, parameters, commandType: CommandType.StoredProcedure);
var dataReturn = data.ToArray();
if (dataReturn.Length > 0)
{
paging.TotalRow = dataReturn[0].TotalRow;
}
return dataReturn;
}));
}
public async Task ChangeStreetStatus(string id, EnumDefine.CommonStatusEnum status, string updatedUid, DateTime updatedDate)
{
await _locationRepository.ChangeStreetStatus(id, status, updatedUid, updatedDate);
}
public async Task ChangeBannerItemStatus(string id, EnumDefine.CommonStatusEnum status, string userId, DateTime updatedDate)
{
await _bannerItemRepository.ChangeStatus(id, status, userId, updatedDate);
}
public async Task <RBannerItem[]> SearchBannerItem(string id, string bannerItemName, string bannerId, EnumDefine.CommonStatusEnum status, bool isDefault, DateTimeRange startDate, DateTimeRange endDate, RefSqlPaging paging)
{
return(await _bannerItemRepository.Search(id, bannerItemName, bannerId, status, isDefault, startDate, endDate, paging));
}
public async Task <RBanner[]> SearchBanner(string id, string bannerName, EnumDefine.CommonStatusEnum bannerStatus, RefSqlPaging paging)
{
return(await _bannerRepository.Search(id, bannerName, bannerStatus, paging));
}
public async Task <RProductGroup[]> Search(string name, EnumDefine.CommonStatusEnum status, RefSqlPaging sqlPaging)
{
return(await _productGroupRepository.Search(name, status, sqlPaging));
}
public async Task <RBannerItem[]> Search(string id, string bannerItemName, string bannerId, EnumDefine.CommonStatusEnum status, bool isDefault, DateTimeRange startDate, DateTimeRange endDate, RefSqlPaging paging)
{
return(await WithConnection(async (connection) =>
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Id", string.IsNullOrEmpty(id) ? string.Empty : id, DbType.String);
parameters.Add("@BannerItemName", string.IsNullOrEmpty(bannerItemName) ? string.Empty : bannerItemName, DbType.String);
parameters.Add("@BannerId", string.IsNullOrEmpty(bannerId) ? string.Empty : bannerId, DbType.String);
parameters.Add("@Status", status.AsEnumToInt(), DbType.Int16);
parameters.Add("@IsDefault", isDefault, DbType.Boolean);
parameters.Add("@StartDateUtcFrom", startDate.FromDate, DbType.DateTime);
parameters.Add("@StartDateUtcTo", startDate.ToDate, DbType.DateTime);
parameters.Add("@EndDateUtcFrom", endDate.FromDate, DbType.DateTime);
parameters.Add("@EndDateUtcTo", endDate.ToDate, DbType.DateTime);
parameters.Add("@OFFSET", paging.OffSet, DbType.Int32);
parameters.Add("@FETCH", paging.PageSize, DbType.Int32);
parameters.Add("@DeletedStatus", EnumDefine.CommonStatusEnum.Deleted.AsEnumToInt(), DbType.Int32);
var data = await connection.QueryAsync <RBannerItem>(ProcName.BannerItem_Search, parameters, commandType: CommandType.StoredProcedure);
var dataReturn = data.ToArray();
if (dataReturn.Length > 0)
{
paging.TotalRow = dataReturn[0].TotalRow;
}
return dataReturn;
}));
}
public async Task ChangeTemplateConfigStatus(string id, string userId, DateTime changeDate, EnumDefine.CommonStatusEnum status)
{
await _templateConfigRepository.ChangeStatus(id, userId, changeDate, status);
}
public async Task <RTemplateConfig[]> SearchTemplateConfig(string id, string templateId, EnumDefine.TemplateConfigComponentTypeEnum componentType, EnumDefine.CommonStatusEnum status, RefSqlPaging paging)
{
return(await _templateConfigRepository.Search(id, templateId, componentType, status, paging));
}
public async Task <RTemplate[]> Search(string code, string templateName, EnumDefine.CommonStatusEnum status, RefSqlPaging paging)
{
return(await _templateRepository.Search(code, templateName, status, paging));
}