private TableReturn SavePickList(PickListResponseDto pickListInsert, string transcationType)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = PickListStoredProcedure.StoredProcedureParameters[0].ToString(), Value = pickListInsert.PickListNo.AsDbValue()
},
new SqlParameter {
ParameterName = PickListStoredProcedure.StoredProcedureParameters[1].ToString(), Value = transcationType.AsDbValue()
},
new SqlParameter {
ParameterName = PickListStoredProcedure.StoredProcedureParameters[2].ToString(), Value = pickListInsert.AssignedUserId.AsDbValue()
},
new SqlParameter {
ParameterName = PickListStoredProcedure.StoredProcedureParameters[3].ToString(), Value = pickListInsert.LastSentDeviceId.AsDbValue()
},
new SqlParameter
{
ParameterName = PickListStoredProcedure.StoredProcedureParameters[4].ToString(),
TypeName = PickListStoredProcedure.StoredProcedureTypeNames[0].ToString(),
SqlDbType = SqlDbType.Structured,
Value = pickListInsert.PickListDetail.ToList().ToDataTable()
},
};
return(_tcContext.Set <TableReturn>().FromSqlRaw(PickListStoredProcedure.Sql, parms.ToArray()).AsEnumerable().FirstOrDefault());
}
public async Task <CartonStorageDto> GetCartonById(int cartonId)
{
var carton = _mapper.Map <CartonStorageDto>(await _tcContext.CartonStorages.
Include(x => x.CartonLocations).
Where(x => x.CartonNo == cartonId)
.FirstOrDefaultAsync());
if (carton != null)
{
var customer = await _tcContext.Customers.Where(x => x.TrackingId == carton.CustomerId).
FirstOrDefaultAsync();
carton.CustomerName = customer.Name;
carton.CustomerCode = customer.CustomerCode;
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = CartonRequestStoredProcedure.StoredProcedureParameters[0].ToString(), Value = cartonId.AsDbValue()
},
};
carton.CartonRequests = _tcContext.Set <CartonRequest>().FromSqlRaw(CartonRequestStoredProcedure.Sql, parms.ToArray()).ToList();
}
return(_mapper.Map <CartonStorageDto>(carton));
}
public int SaveUser(UserDto user, byte[] passwrodHash, byte[] passwordSalt, string trasactionType)
{
if (trasactionType == TransactionType.Reset.ToString())
{
var passwordHistoryList = _tcContext.UserPasswordHistories
.Where(x => x.UserId == user.UserId).OrderByDescending(x => x.TrackingId).Take(5).ToList();
if (PasswordManager.IsPreviousUsedPassword(passwordHistoryList, user.UserPassword))
{
throw new ServiceException(new ErrorMessage[]
{
new ErrorMessage()
{
Message = $"Cannot use old 5 passwrods"
}
});
}
}
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = UserInsertUpdateDeleteStoredProcedureSearch.StoredProcedureParameters[0].ToString(), Value = user.UserId.AsDbValue()
},
new SqlParameter {
ParameterName = UserInsertUpdateDeleteStoredProcedureSearch.StoredProcedureParameters[1].ToString(), Value = user.UserName.AsDbValue()
},
new SqlParameter {
ParameterName = UserInsertUpdateDeleteStoredProcedureSearch.StoredProcedureParameters[2].ToString(), Value = user.UserFullName.AsDbValue()
},
new SqlParameter {
ParameterName = UserInsertUpdateDeleteStoredProcedureSearch.StoredProcedureParameters[3].ToString(), Value = user.EmpId.AsDbValue()
},
new SqlParameter {
ParameterName = UserInsertUpdateDeleteStoredProcedureSearch.StoredProcedureParameters[4].ToString(), Value = user.DepartmentId.AsDbValue()
},
new SqlParameter {
ParameterName = UserInsertUpdateDeleteStoredProcedureSearch.StoredProcedureParameters[5].ToString(), Value = passwrodHash.AsDbValue()
},
new SqlParameter {
ParameterName = UserInsertUpdateDeleteStoredProcedureSearch.StoredProcedureParameters[6].ToString(), Value = passwordSalt.AsDbValue()
},
new SqlParameter {
ParameterName = UserInsertUpdateDeleteStoredProcedureSearch.StoredProcedureParameters[7].ToString(), Value = user.UserRoles != null?string.Join(",", user.UserRoles.Select(x => x.Id.ToString()).ToArray()) : string.Empty
},
new SqlParameter {
ParameterName = UserInsertUpdateDeleteStoredProcedureSearch.StoredProcedureParameters[8].ToString(), Value = user.Email.AsDbValue()
},
new SqlParameter {
ParameterName = UserInsertUpdateDeleteStoredProcedureSearch.StoredProcedureParameters[9].ToString(), Value = user.Active.AsDbValue()
},
new SqlParameter {
ParameterName = UserInsertUpdateDeleteStoredProcedureSearch.StoredProcedureParameters[10].ToString(), Value = trasactionType
},
new SqlParameter {
ParameterName = UserInsertUpdateDeleteStoredProcedureSearch.StoredProcedureParameters[11].ToString(), Value = user.TransactionUserId.AsDbValue()
}
};
return(_tcContext.Set <IntReturn>().FromSqlRaw(UserInsertUpdateDeleteStoredProcedureSearch.Sql, parms.ToArray()).AsEnumerable().First().Value);
}
public List <T> GetCartonsToDocketRePrint <T>(DocketRePrintModel model) where T : class
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = DocketStoredProcedure.StoredProcedureParameters[0].ToString(), Value = model.RequestNo.AsDbValue()
},
new SqlParameter {
ParameterName = DocketStoredProcedure.StoredProcedureParameters[1].ToString(), Value = model.PrintedBy.AsDbValue()
},
new SqlParameter {
ParameterName = DocketStoredProcedure.StoredProcedureParameters[2].ToString(), Value = model.RequestType.AsDbValue()
},
new SqlParameter {
ParameterName = DocketStoredProcedure.StoredProcedureParameters[3].ToString(), Value = model.SerialNo.AsDbValue()
}
};
var result = _tcContext.Set <T>().FromSqlRaw(DocketStoredProcedure.SqlRePrint, parms.ToArray()).ToList();
if (result == null || result != null && result.Count == 0 && model.RequestType.ToLower() != RequestTypes.collection.ToString())
{
throw new ServiceException(new ErrorMessage[]
{
new ErrorMessage()
{
Code = string.Empty,
Message = $"Unable to find docket by {model.RequestNo}"
}
});
}
return(result);
}
public string SaveRolePermission(RoleResponse response, string transactionType)
{
int userId = 0; //get userid
#region Sql Parameter loading
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = UserRoleStoredProcedure.StoredProcedureParameters[0].ToString(),
Value = response.RoleId.AsDbValue()
},
new SqlParameter {
ParameterName = UserRoleStoredProcedure.StoredProcedureParameters[1].ToString(),
Value = response.RoleName.AsDbValue()
},
new SqlParameter {
ParameterName = UserRoleStoredProcedure.StoredProcedureParameters[2].ToString(),
Value = userId.AsDbValue()
},
new SqlParameter {
ParameterName = UserRoleStoredProcedure.StoredProcedureParameters[3].ToString(),
Value = transactionType
},
new SqlParameter
{
ParameterName = UserRoleStoredProcedure.StoredProcedureParameters[4].ToString(),
TypeName = UserRoleStoredProcedure.StoredProcedureTypeNames[0].ToString(),
SqlDbType = SqlDbType.Structured,
Value = response.RolePermissionList.ToList().ToDataTable()
}
};
#endregion
return(_tcContext.Set <StringReturn>().FromSqlRaw(UserRoleStoredProcedure.Sql, parms.ToArray()).AsEnumerable().First().Value);
}
public BaseMetadataRepository(tlrmCartonContext tccontext, IMapper mapper, BaseMetaRepositoryValidator validator)
{
_tcContext = tccontext;
_dbSet = _tcContext.Set <TEntity>();
_mapper = mapper;
_validator = validator;
}
public List <T> GetSearchResult <T>(GenericReportData model) where T : class
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = GenericReportStoredProcedure.StoredProcedureParameters[0].ToString(), Value = model.ReportName.AsDbValue()
},
new SqlParameter
{
ParameterName = GenericReportStoredProcedure.StoredProcedureParameters[1].ToString(),
TypeName = GenericReportStoredProcedure.StoredProcedureTypeNames[0].ToString(),
SqlDbType = SqlDbType.Structured,
Value = model.ReportFilters.ToList().ToDataTable()
}
};
return(_tcContext.Set <T>().FromSqlRaw(GenericReportStoredProcedure.Sql, parms.ToArray()).ToList());
}
public bool UpdateCompanyProfile(CompanyDto request)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[0].ToString(), Value = request.CompanyId.AsDbValue()
},
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[1].ToString(), Value = request.CompanyName.AsDbValue()
},
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[2].ToString(), Value = request.Address1.AsDbValue()
},
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[3].ToString(), Value = request.Address2.AsDbValue()
},
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[4].ToString(), Value = request.Address3.AsDbValue()
},
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[5].ToString(), Value = request.Country.AsDbValue()
},
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[6].ToString(), Value = request.Tel.AsDbValue()
},
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[7].ToString(), Value = request.Fax.AsDbValue()
},
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[8].ToString(), Value = request.Email.AsDbValue()
},
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[9].ToString(), Value = request.VatNo.AsDbValue()
},
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[10].ToString(), Value = request.NbtNo.AsDbValue()
},
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[11].ToString(), Value = request.SvatNo.AsDbValue()
},
new SqlParameter {
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[12].ToString(), Value = request.UserId.AsDbValue()
},
new SqlParameter
{
ParameterName = CompanyProfileStoredProcedure.StoredProcedureParameters[13].ToString(),
TypeName = CompanyProfileStoredProcedure.StoredProcedureTypeNames[0].ToString(),
SqlDbType = SqlDbType.Structured,
Value = request.TaxEffectiveDate.Where(x => x.Id == 0).ToList().ToDataTable()
},
};
return(_tcContext.Set <BoolReturn>().FromSqlRaw(CompanyProfileStoredProcedure.Sql, parms.ToArray()).AsEnumerable().First().Value);
}
private bool SaveLocations(LocationDto location, string transcationType)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = LocationStoredProcedure.StoredProcedureParameters[0].ToString(), Value = location.Code.AsDbValue()
},
new SqlParameter {
ParameterName = LocationStoredProcedure.StoredProcedureParameters[1].ToString(), Value = location.Name.AsDbValue()
},
new SqlParameter {
ParameterName = LocationStoredProcedure.StoredProcedureParameters[2].ToString(), Value = location.Active.AsDbValue()
},
new SqlParameter {
ParameterName = LocationStoredProcedure.StoredProcedureParameters[3].ToString(), Value = location.Rms1Location.AsDbValue()
},
new SqlParameter {
ParameterName = LocationStoredProcedure.StoredProcedureParameters[4].ToString(), Value = location.IsVehicle.AsDbValue()
},
new SqlParameter {
ParameterName = LocationStoredProcedure.StoredProcedureParameters[5].ToString(), Value = location.IsRcLocation.AsDbValue()
},
new SqlParameter {
ParameterName = LocationStoredProcedure.StoredProcedureParameters[6].ToString(), Value = location.IsBay.AsDbValue()
},
new SqlParameter {
ParameterName = LocationStoredProcedure.StoredProcedureParameters[7].ToString(), Value = location.WareHouseCode.AsDbValue()
},
new SqlParameter {
ParameterName = LocationStoredProcedure.StoredProcedureParameters[8].ToString(), Value = transcationType
},
new SqlParameter {
ParameterName = LocationStoredProcedure.StoredProcedureParameters[9].ToString(), Value = 0
},
};
return(_tcContext.Set <BoolReturn>().FromSqlRaw(LocationStoredProcedure.Sql, parms.ToArray()).AsEnumerable().FirstOrDefault().Value);
}
public ImportResultDto GetAlternativeNoUpdateResult(List <ExcelParseAlternativeNoUpdateViewModel> alternativeNoList, int userId)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = ImportDataAlternativeNoStoredprocedure.StoredProcedureParameters[0].ToString(), Value = userId.AsDbValue()
},
new SqlParameter
{
ParameterName = ImportDataAlternativeNoStoredprocedure.StoredProcedureParameters[1].ToString(),
TypeName = ImportDataAlternativeNoStoredprocedure.StoredProcedureTypeNames[0].ToString(),
SqlDbType = SqlDbType.Structured,
Value = alternativeNoList.ToList().ToDataTable()
},
};
var outSuccessCount = new SqlParameter
{
ParameterName = ImportDataAlternativeNoStoredprocedure.StoredProcedureParameters[2].ToString(),
SqlDbType = SqlDbType.Int,
Direction = ParameterDirection.Output
};
parms.Add(outSuccessCount);
var result = _tcContext.Set <ImportErrorModelItemDto>().FromSqlRaw(ImportDataAlternativeNoStoredprocedure.Sql, parms.ToArray()).ToList();
if (result == null || result != null && result.Count() == 0)
{
return(new ImportResultDto(alternativeNoList.Count(), 0, alternativeNoList.Count(), new List <ImportErrorModelItemDto>()));
}
else
{
return(new ImportResultDto((int)outSuccessCount.Value, result.Count(), alternativeNoList.Count(), result));
}
}
public async Task <InventoryByCustomerReponse> GetInventoryByCustomer(int customerId, string woType,
DateTime asAtDate, bool includeSubAccount)
{
var parms = SendResponse(customerId, woType, asAtDate, InventoryReportTypes.Detail.ToString(),
includeSubAccount, out SqlParameter outParam);
var inventoryList = await _tcContext.Set <InventoryByCustomer>().
FromSqlRaw(InventoryByCustomerStoredProcedure.Sql, parms.ToArray()).ToListAsync();
var totalRows = (int)outParam.Value;
var postResponse = _mapper.Map <List <InventoryByCustomer> >(inventoryList);
var inventorySummaryList = postResponse.GroupBy(t => t.WoType)
.Select(t => new InventoryByCustomerSummary()
{
WoType = t.Key,
CartonCount = t.Count()
}).ToList();
var retrievalList = postResponse.Where(x => x.WoType.ToLower() == RequestTypes.retrieval.ToString()).ToList();
var retreivalSummaryList = retrievalList.GroupBy(t => t.RetrievalType)
.Select(t => new InventoryByRetreivalSummary()
{
WoType = t.Key,
CartonCount = t.Count()
}).ToList();
var inventoryByCustomer = new InventoryByCustomerReponse()
{
InventoryList = postResponse,
InventorySummary = inventorySummaryList,
RetreivalSummary = retreivalSummaryList
};
return(inventoryByCustomer);
}
public async Task <PagedResponse <CartonOwnershipSearch> > SearchOwnership(string fromValue, string toValue, string searchBy,
int pageIndex, int pageSize)
{
List <SqlParameter> parms = _searchManager.SearchFromToSearchBy("ownershipSearch", fromValue, toValue, searchBy,
pageIndex, pageSize, out SqlParameter outParam);
var cartonList = await _tcContext.Set <CartonOwnershipSearch>().FromSqlRaw(SearchStoredProcedureFromToSearchBy.Sql,
parms.ToArray()).ToListAsync();
var totalRows = (int)outParam.Value;
#region paging
var postResponse = _mapper.Map <List <CartonOwnershipSearch> >(cartonList);
var paginationResponse = new PagedResponse <CartonOwnershipSearch>
{
Data = postResponse,
pageNumber = pageIndex,
pageSize = pageSize,
totalCount = totalRows,
totalPages = (int)Math.Ceiling(totalRows / (double)pageSize),
};
#endregion
return(paginationResponse);
}
public async Task <List <DashBoardWeeklyWOStatusDetail> > GetWeelklyWoStatusAsync()
{
var result = await _tcContext.Set <DashBoardWeeklyWOStatusDetail>().FromSqlRaw("dashBoardWeeklyWoStatus").ToListAsync();
if (!result.Any())
{
throw new ServiceException(new ErrorMessage[]
{
new ErrorMessage()
{
Code = string.Empty,
Message = $"Unable to find Weekly Wo data"
}
});
}
return(result);
}
public async Task <PagedResponse <RequestSearchDto> > SearchRequest(string requestType, string searchText, int pageIndex, int pageSize)
{
List <SqlParameter> parms = _searchManager.Search("requestSearch", requestType, searchText, pageIndex, pageSize, out SqlParameter outParam);
var cartonList = await _tcContext.Set <RequestSearch>().FromSqlRaw(SearchStoredProcedureByType.Sql, parms.ToArray()).ToListAsync();
var totalRows = (int)outParam.Value;
#region paging
var postResponse = _mapper.Map <List <RequestSearchDto> >(cartonList);
var paginationResponse = new PagedResponse <RequestSearchDto>
{
Data = postResponse,
pageNumber = pageIndex,
pageSize = pageSize,
totalCount = totalRows,
totalPages = (int)Math.Ceiling(totalRows / (double)pageSize),
};
#endregion
return(paginationResponse);
}
public async Task <UserLoginResponse> Login(UserLoginModel model)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = LoginStoredProcedure.StoredProcedureParameters[0].ToString(), Value = model.UserName.AsDbValue()
}
};
var result = await _tcContext.Set <LoginValidationResult>().FromSqlRaw(LoginStoredProcedure.Sql, parms.ToArray()).ToListAsync();
if (result.FirstOrDefault().Code == "1011")// password expired
{
var userLoginResponse = new UserLoginResponse()
{
UserName = model.UserName,
Token = _tokenServiceRepository.CreateToken(model.UserName)
};
throw new ServiceException(new ErrorMessage[]
{
new ErrorMessage()
{
Code = result.FirstOrDefault().Code,
Message = result.FirstOrDefault().Message,
Meta = userLoginResponse
}
});
}
if (string.IsNullOrEmpty(result.FirstOrDefault().Code))
{
var systemUserPassword = await _userPasswordRepository.GetSystemUserPasswords(model.UserName);
if (PasswordManager.IsValidPassword(systemUserPassword.PasswordSalt, systemUserPassword.PasswordHash, model.Password))
{
parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = LoginPermissionStoredProcedure.StoredProcedureParameters[0].ToString(), Value = model.UserName.AsDbValue()
}
};
var resultPermission = await _tcContext.Set <UserModulePermission>().FromSqlRaw(LoginPermissionStoredProcedure.Sql, parms.ToArray()).ToListAsync();
var userInfo = GetUserOtherInfo(model.UserName);
return(new UserLoginResponse()
{
UserName = model.UserName,
UserFirstName = userInfo.UserFirstName,
UserLastName = userInfo.UserLastName,
UserRole = userInfo.UserRole,
Token = _tokenServiceRepository.CreateToken(model.UserName),
Permissions = resultPermission
});
}
else
{
parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = LoginAttemptsUpdateStoredProcedure.StoredProcedureParameters[0].ToString(), Value = model.UserName.AsDbValue()
},
new SqlParameter {
ParameterName = LoginAttemptsUpdateStoredProcedure.StoredProcedureParameters[1].ToString(), Value = 0
}
};
await _tcContext.Set <LoginValidationResult>().FromSqlRaw(LoginAttemptsUpdateStoredProcedure.Sql, parms.ToArray()).ToListAsync();
throw new ServiceException(new ErrorMessage[]
{
new ErrorMessage()
{
Code = "1010",
Message = "Invalid Password"
}
});
}
}
throw new ServiceException(new ErrorMessage[]
{
new ErrorMessage()
{
Code = result.FirstOrDefault().Code,
Message = result.FirstOrDefault().Message
}
});
}
private bool SaveCustomer(CustomerDto customerTransaction, string transcationType)
{
#region Assign values to utds
List <CustomerAuthorizationListUtdDto> lstAuthorization = new List <CustomerAuthorizationListUtdDto>();
List <CustomerAuthorizationListDetailUdtDto> lstAuthorizationLevel = new List <CustomerAuthorizationListDetailUdtDto>();
var custAuth = customerTransaction.CustomerAuthorizationListHeaders.ToList();
int ix = 0;
foreach (var customerAuthItem in custAuth)
{
var b = _mapper.Map <CustomerAuthorizationListUtdDto>(customerAuthItem);
b.AutoId = ix + 1;
lstAuthorization.Add(b);
var d = _mapper.Map <List <CustomerAuthorizationListDetailUdtDto> >(customerAuthItem.CustomerAuthorizationListDetails.ToList());
foreach (var customerAuthlevel in d)
{
customerAuthlevel.AutoId = b.AutoId;
lstAuthorizationLevel.Add(customerAuthlevel);
}
ix = ix + 1;
}
#endregion
#region Sql Parameter loading
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[0].ToString(),
Value = transcationType == TransactionTypes.Insert.ToString()? 0: customerTransaction.TrackingId
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[1].ToString(), Value = customerTransaction.CustomerCode.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[2].ToString(), Value = customerTransaction.Name.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[3].ToString(), Value = customerTransaction.Address1.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[4].ToString(), Value = customerTransaction.Address2.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[5].ToString(), Value = customerTransaction.Address3.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[6].ToString(), Value = customerTransaction.Telephone1.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[7].ToString(), Value = customerTransaction.Telephone2.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[8].ToString(), Value = customerTransaction.Fax.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[9].ToString(), Value = customerTransaction.ZipCode.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[10].ToString(), Value = customerTransaction.CountryId.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[11].ToString(), Value = customerTransaction.Email.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[12].ToString(), Value = customerTransaction.ContractNo.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[13].ToString(), Value = customerTransaction.ContractStartDate.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[14].ToString(), Value = customerTransaction.ContractEndDate.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[15].ToString(), Value = customerTransaction.DeliveryName.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[16].ToString(), Value = customerTransaction.DeliveryAddress1.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[17].ToString(), Value = customerTransaction.DeliveryAddress2.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[18].ToString(), Value = customerTransaction.DeliveryAddress3.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[19].ToString(), Value = customerTransaction.DeliveryTelephone1.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[20].ToString(), Value = customerTransaction.DeliveryTelephone2.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[21].ToString(), Value = customerTransaction.DeliveryFax.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[22].ToString(), Value = customerTransaction.PickUpName.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[23].ToString(), Value = customerTransaction.PickUpAddress1.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[24].ToString(), Value = customerTransaction.PickUpAddress2.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[25].ToString(), Value = customerTransaction.PickUpAddress3.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[26].ToString(), Value = customerTransaction.PickUpTelephone1.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[27].ToString(), Value = customerTransaction.PickUpTelephone2.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[28].ToString(), Value = customerTransaction.PickUpFax.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[29].ToString(), Value = customerTransaction.City.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[30].ToString(), Value = customerTransaction.ContactName.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[31].ToString(), Value = customerTransaction.ContactAddress1.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[32].ToString(), Value = customerTransaction.ContactAddress2.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[33].ToString(), Value = customerTransaction.ContactAddress3.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[34].ToString(), Value = customerTransaction.ContactTelephone1.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[35].ToString(), Value = customerTransaction.ContactTelephone2.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[36].ToString(), Value = customerTransaction.ContactFax.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[37].ToString(), Value = customerTransaction.PoNo.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[38].ToString(), Value = customerTransaction.VatNo.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[39].ToString(), Value = customerTransaction.SvatNo.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[40].ToString(), Value = customerTransaction.BillingCycle.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[41].ToString(), Value = customerTransaction.Route.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[42].ToString(), Value = customerTransaction.IsSeparateInvoice.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[43].ToString(), Value = customerTransaction.ContactPersonInv.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[44].ToString(), Value = customerTransaction.SubInvoice.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[45].ToString(), Value = customerTransaction.ServiceProvided.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[46].ToString(), Value = customerTransaction.AccountType.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[47].ToString(), Value = customerTransaction.MainCustomerCode.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[48].ToString(), Value = customerTransaction.Active.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[49].ToString(), Value = customerTransaction.User.AsDbValue()
},
new SqlParameter {
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[50].ToString(), Value = transcationType.AsDbValue()
},
new SqlParameter
{
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[51].ToString(),
TypeName = CustomerStoredProcedure.StoredProcedureTypeNames[0].ToString(),
SqlDbType = SqlDbType.Structured,
Value = lstAuthorization.ToDataTable()
},
new SqlParameter
{
ParameterName = CustomerStoredProcedure.StoredProcedureParameters[52].ToString(),
TypeName = CustomerStoredProcedure.StoredProcedureTypeNames[1].ToString(),
SqlDbType = SqlDbType.Structured,
Value = lstAuthorizationLevel.ToDataTable()
}
};
#endregion
return(_tcContext.Set <BoolReturn>().FromSqlRaw(CustomerStoredProcedure.Sql, parms.ToArray()).AsEnumerable().First().Value);
}
public async Task <CartonOverviewDto> GetCartonOverview(int cartonNo)
{
CartonOverviewDto cartonOverView = new CartonOverviewDto();
List <SqlParameter> parms = _searchManager.Search("cartonInquiry", cartonNo.ToString(), SearchStoredProcedure.PageIndex, SearchStoredProcedure.PageSize, out SqlParameter outParam);
var cartonList = await _tcContext.Set <CartonInquiry>().FromSqlRaw(SearchStoredProcedure.Sql, parms.ToArray()).ToListAsync();
cartonOverView.CartonHeader = cartonList.FirstOrDefault();
cartonOverView.RequestHeader = _tcContext.InvoiceConfirmations.Where(x => x.CartonNo == cartonNo.ToString()).OrderBy(x => x.TrackingId).ToList();
var cartonLocationList = _tcContext.CartonLocations.Where(x => x.CartonNo == cartonNo).OrderBy(x => x.Id).ToList();
cartonOverView.LocationDetail = _mapper.Map <List <CartonLocationDto> >(cartonLocationList);
var pickList = _tcContext.PickLists.Where(x => x.CartonNo == cartonNo).OrderBy(x => x.TrackingId).ToList();
cartonOverView.PickList = _mapper.Map <List <PickListDto> >(pickList);
List <SqlParameter> parameters = new List <SqlParameter>
{
new SqlParameter {
ParameterName = InquiryDocketByCartonStoredProcedure.StoredProcedureParameters[0].ToString(), Value = cartonNo.AsDbValue()
}
};
cartonOverView.PrintedDockets = await _tcContext.Set <DocketPrintDetail>().FromSqlRaw(InquiryDocketByCartonStoredProcedure.Sql, parameters.ToArray()).ToListAsync();
cartonOverView.CartonOwnership = _tcContext.CartonOwnerShips.Where(x => x.CartonNo == cartonNo).OrderBy(x => x.OwnershipChangedDate).ToList();
return(cartonOverView);
}
public List <InvoiceResponse> GetInvoiceById(string invoiceNo)
{
#region Sql Parameter loading
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = InvoiceStoredProcedureById.StoredProcedureParameters[0].ToString(), Value = invoiceNo.AsDbValue()
}
};
#endregion
return(_tcContext.Set <InvoiceResponse>().FromSqlRaw(InvoiceStoredProcedureById.Sql, parms.ToArray()).ToList());
}
