public DataPage <BSOInfo> BSO_Find(
BSOSearchCriteria criteria,
List <SortCriteria <BSOSortField> > sortCriteria,
PageRequest pageRequest)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.AddInputParameter("@TemporaryPolicyNumberFrom", SqlDbType.NVarChar, criteria.TemporaryPolicyNumberFrom);
parameters.AddInputParameter("@TemporaryPolicyNumberTo", SqlDbType.NVarChar, criteria.TemporaryPolicyNumberTo);
parameters.AddInputParameter("@PolicyPartyNumber", SqlDbType.NVarChar, criteria.PolicyPartyNumber);
parameters.AddInputParameter("@StatusId", SqlDbType.BigInt, criteria.StatusId);
parameters.AddInputParameter("@ResponsibleID", SqlDbType.BigInt, criteria.ResponsibleID);
parameters.AddInputParameter("@StatusDateFrom", SqlDbType.Date, criteria.StatusDateFrom);
parameters.AddInputParameter("@StatusDateTo", SqlDbType.Date, criteria.StatusDateTo);
parameters.AddInputParameter("@ChangeDateFrom", SqlDbType.DateTime, criteria.ChangeDateFrom);
parameters.AddInputParameter("@ChangeDateTo", SqlDbType.DateTime, criteria.ChangeDateTo);
parameters.AddInputParameter("@DeliveryCenterIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.DeliveryCenterIds));
parameters.AddInputParameter("@DeliveryPointIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.DeliveryPointIds));
//parameters.AddInputParameter("@ResponsibleIDs", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.ResponsibleIDs));
SqlParameter totalCountParameter = parameters.AddOutputParameter("@total_count", SqlDbType.Int);
parameters.AddInputParameter("@sort_criteria", SqlDbType.Structured, DaoHelper.GetSortFieldsTable(sortCriteria));
parameters.AddInputParameter("@Page_size", SqlDbType.Int, pageRequest.PageSize);
parameters.AddInputParameter("@Page_number", SqlDbType.Int, pageRequest.PageNumber);
List <BSOInfo> bsos = Execute_GetList(BSOInfoMaterializer.Instance, "BSO_Find", parameters);
return(DaoHelper.GetDataPage(bsos, totalCountParameter, pageRequest));
}
public List <FundRequestRecid> ClientVisitId_GetByFundRequesetRecid(IEnumerable <long> recids)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.AddInputParameter("@Recids", SqlDbType.Structured, DaoHelper.GetObjectIds(recids));
return(Execute_GetList <FundRequestRecid>(FundRequestRecidMaterializer.Instance, "ClientVisitId_GetByFundRequesetRecid", parameters));
}
public List <Nomernik.ClientShotInfo> ClientsShotInfo_Get(IEnumerable <long> listClientIds)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.AddInputParameter("@ClientIDs", SqlDbType.Structured, DaoHelper.GetObjectIds(listClientIds));
List <Nomernik.ClientShotInfo> list = Execute_GetList(NomernikClientShotInfoMaterializer.Instance, "NomernikClientsShotInfo_Get", parameters);
return(list);
}
public DataPage <ClientVisitInfo> ClientVisit_Find(
ClientVisitSearchCriteria criteria,
List <SortCriteria <ClientVisitSortField> > sortCriteria,
PageRequest pageRequest)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.AddInputParameter("@ID", SqlDbType.BigInt, criteria.Id);
parameters.AddInputParameter("@UnifiedPolicyNumber", SqlDbType.NVarChar, criteria.UnifiedPolicyNumber);
parameters.AddInputParameter("@SNILS", SqlDbType.NVarChar, criteria.SNILS);
parameters.AddInputParameter("@DocumentTypeId", SqlDbType.BigInt, criteria.DocumentTypeId);
parameters.AddInputParameter("@DocumentNumber", SqlDbType.NVarChar, criteria.DocumentNumber);
parameters.AddInputParameter("@DocumentSeries", SqlDbType.NVarChar, criteria.DocumentSeries);
parameters.AddInputParameter("@TemporaryPolicyNumber", SqlDbType.NVarChar, criteria.TemporaryPolicyNumber);
parameters.AddInputParameter("@TemporaryPolicyDateFrom", SqlDbType.DateTime, criteria.TemporaryPolicyDateFrom);
parameters.AddInputParameter("@TemporaryPolicyDateTo", SqlDbType.DateTime, criteria.TemporaryPolicyDateTo);
parameters.AddInputParameter("@PolicyNumber", SqlDbType.NVarChar, criteria.PolicyNumber);
parameters.AddInputParameter("@PolicySeries", SqlDbType.NVarChar, criteria.PolicySeries);
parameters.AddInputParameter("@PolicyDateFrom", SqlDbType.DateTime, criteria.PolicyDateFrom);
parameters.AddInputParameter("@PolicyDateTo", SqlDbType.DateTime, criteria.PolicyDateTo);
parameters.AddInputParameter("@UpdateDateFrom", SqlDbType.DateTime, criteria.UpdateDateFrom);
parameters.AddInputParameter("@UpdateDateTo", SqlDbType.DateTime, criteria.UpdateDateTo);
parameters.AddInputParameter("@StatusDateFrom", SqlDbType.DateTime, criteria.StatusDateFrom);
parameters.AddInputParameter("@StatusDateTo", SqlDbType.DateTime, criteria.StetusDateTo);
parameters.AddInputParameter("@Firstname", SqlDbType.NVarChar, criteria.Firstname);
parameters.AddInputParameter("@Secondname", SqlDbType.NVarChar, criteria.Secondname);
parameters.AddInputParameter("@Lastname", SqlDbType.NVarChar, criteria.Lastname);
parameters.AddInputParameter("@UserId", SqlDbType.BigInt, criteria.UserId);
parameters.AddInputParameter("@Birthday", SqlDbType.Date, criteria.Birthday);
parameters.AddInputParameter("@PartyNumber", SqlDbType.NVarChar, criteria.PartyNumber);
parameters.AddInputParameter("@DeliveryCenterIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.DeliveryCenterIds));
parameters.AddInputParameter("@DeliveryPointIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.DeliveryPointIds));
parameters.AddInputParameter("@StatusIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.StatusIds));
parameters.AddInputParameter("@ScenarioIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.ScenarioIds));
parameters.AddInputParameter("@IsTemporaryPolicyNumberNotEmpty", SqlDbType.Bit, criteria.IsTemporaryPolicyNumberNotEmpty);
parameters.AddInputParameter("@IsActualInVisitGroup", SqlDbType.Bit, criteria.IsActualInVisitGroup);
parameters.AddInputParameter("@IsReadyToFundSubmitRequest", SqlDbType.Bit, criteria.IsReadyToFundSubmitRequest);
parameters.AddInputParameter("@IsDifficultCase", SqlDbType.Bit, criteria.IsDifficultCase);
SqlParameter totalCountParameter = parameters.AddOutputParameter("@total_count", SqlDbType.Int);
parameters.AddInputParameter("@sort_criteria", SqlDbType.Structured, DaoHelper.GetSortFieldsTable(sortCriteria));
parameters.AddInputParameter("@Page_size", SqlDbType.Int, pageRequest.PageSize);
parameters.AddInputParameter("@Page_number", SqlDbType.Int, pageRequest.PageNumber);
List <ClientVisitInfo> clients = Execute_GetList(ClientVisitInfoMaterializer.Instance, "ClientVisit_Find", parameters);
return(DaoHelper.GetDataPage(clients, totalCountParameter, pageRequest));
}
public List <BSOHistoryItem> BSO_GetListHistory(DateTime StatusDateFrom, DateTime StatusDateTo, List <long> BSO_IDs)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.AddInputParameter("@StatusDateFrom", SqlDbType.DateTime, StatusDateFrom);
parameters.AddInputParameter("@StatusDateTo", SqlDbType.DateTime, StatusDateTo);
var temp = DaoHelper.GetObjectIds(BSO_IDs);
parameters.AddInputParameter("@BSO_IDs", SqlDbType.Structured, DaoHelper.GetObjectIds(BSO_IDs));
List <BSOHistoryItem> result = Execute_GetList(BSOHistoryItemMaterializer.Instance, "BSO_GetListHistory", parameters);
return(result);
}
public long User_Save(User.SaveData data)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.AddInputParameter("@Login", SqlDbType.NVarChar, data.Login);
parameters.AddInputParameter("@PasswordHash", SqlDbType.NVarChar, data.PasswordHash);
parameters.AddInputParameter("@DepartmentId", SqlDbType.BigInt, data.DepartmentId);
parameters.AddInputParameter("@DeliveryPointId", SqlDbType.BigInt, data.DeliveryPointId);
parameters.AddInputParameter("@Firstname", SqlDbType.NVarChar, data.Firstname);
parameters.AddInputParameter("@Secondname", SqlDbType.NVarChar, data.Secondname);
parameters.AddInputParameter("@Lastname", SqlDbType.NVarChar, data.Lastname);
parameters.AddInputParameter("@Roles", SqlDbType.Structured, DaoHelper.GetObjectIds(data.Roles));
parameters.AddInputParameter("@SaveDate", SqlDbType.DateTime, DateTime.Now);
parameters.AddInputParameter("@Position", SqlDbType.NVarChar, data.Position);
parameters.AddInputParameter("@Email", SqlDbType.NVarChar, data.Email);
parameters.AddInputParameter("@Phone", SqlDbType.NVarChar, data.Phone);
SqlParameter userId = parameters.AddInputOutputParameter("@UserID", SqlDbType.BigInt, data.Id);
Execute_StoredProcedure("User_Save", parameters);
return((long)userId.Value);
}