//public object AddRequest(int con_id, int csTypeId, int reqComment, int? address_to_il)
//{
//var res = -1;
//try
//{
// var manager = new DataManager();
// var oldRequests = manager.GetRequestsOnParam(con_id, csTypeId, User.Identity.Name);
// foreach (var reqrow in oldRequests)
// {
// reqrow.req_status = 1;
// reqrow.finishDate = DateTime.Now;
// reqrow.finishedUser = "******";
// reqrow.archivistComment = "Создан дублирующий запрос";
// }
// manager._store.SaveChanges();
// Contract_requess cr = new Contract_requess();
// cr.requestUser = User.Identity.Name;
// if (User.Identity.Name.ToLower().Contains("pristav"))
// {
// cr.requestUserFIO = UserPrincipal.FindByIdentity(new PrincipalContext(ContextType.Domain, "pristav.int"), IdentityType.SamAccountName, User.Identity.Name).Name;
// }
// cr.isUrgent = (User.IsInRole(Consts.LawyerRole) || User.IsInRole(Consts.ADLawyerRole));
// cr.Contracts = manager.GetContract(con_id);
// cr.req_status = 3;
// cr.requestComment = "";
// cr.archivistComment = "";
// cr.requestDate = DateTime.Now;
// cr.reqComment = reqComment;
// cr.reqType = csTypeId;
// if (csTypeId == 5)
// {
// cr.Office_Address = manager.GetAdress(address_to_il.GetValueOrDefault());
// cr.reqComment = 1;
// //cr.address_to_il = null;
// //cr.Office_Address = null;
// }
// manager._store.Contract_requess.Add(cr);
// manager._store.SaveChanges();
// res = cr.id;
// return Json(res, JsonRequestBehavior.AllowGet);
//}
//catch (Exception)
//{
// return Json(res, JsonRequestBehavior.AllowGet);
//}
//}
public object GetRequestInfoToJSON(int _id)
{
using (var ssContext = new ScanStoreContext())
{
return(ssContext.ContractRequess.Where(cr => cr.Id == _id)
.Include(cr => cr.Contract)
.Include(cr => cr.Contract.Cession)
.Include(cr => cr.Contract.Cession.Partner)
.Include(cr => cr.Contract.ContractScans)
.Select(cr => new
{
cr.RequestDate,
cr.RequestComment,
cr.ArchivistComment,
cr.Contract.DebtNumber,
cr.Contract.DebtorFio,
cr.Contract.DebtDate,
cessName = cr.Contract.Cession.Name,
partnerNmae = cr.Contract.Cession.Partner.Name,
contractScans = cr.Contract.ContractScans.Select(cs => new
{
cs.FileName,
cs.CsType,
cs.Size,
cs.InsertDate
})
}).SingleOrDefault());
}
}
public ActionResult <string> EditPartner(int id, [FromBody] Partners _partner)
{
try
{
using (var ssContext = new ScanStoreContext())
{
if (pm.IsValidInData(_partner))
{
var partner = ssContext.Partners.SingleOrDefault(p => p.Id == id);
if (partner != null)
{
partner.Name = _partner.Name;
ssContext.Partners.Update(partner);
ssContext.SaveChanges();
return(Ok(partner));
}
else
{
return(NotFound());
}
}
else
{
return(BadRequest());
}
}
}
catch (Exception ex)
{
return(StatusCode(500, ex.Message));
}
}
public ActionResult EditCession(int id, [FromBody] Cessions _cession)
{
try
{
using (var ssContext = new ScanStoreContext())
{
if (cm.IsValidInData(_cession))
{
var cession = ssContext.Cessions.SingleOrDefault(c => c.Id == id);
if (cession != null)
{
cession.Name = _cession.Name;
cession.PartnerId = _cession.PartnerId;
cession.Date = _cession.Date;
cession.CommitDate = _cession.CommitDate;
ssContext.Cessions.Update(cession);
ssContext.SaveChanges();
return(Ok(cession));
}
else
{
return(NotFound());
}
}
else
{
return(BadRequest());
}
}
}
catch (Exception ex)
{
return(StatusCode(500, ex.Message));
}
}
public Handler(ScanStoreContext context, IPasswordHasher passwordHasher, IJwtTokenGenerator jwtTokenGenerator, IMapper mapper)
{
_context = context;
_passwordHasher = passwordHasher;
_jwtTokenGenerator = jwtTokenGenerator;
_mapper = mapper;
}
public static string MassUpload()
{
ScanStoreContext ssContext = new ScanStoreContext();
var sdir = ssContext.ConfigWebServer.SingleOrDefault(cws => cws.Key == "StorePath").Value;
return(sdir + @"massUploads\");
}
public object GetCessionInfoToJSON(int _id)
{
using (var ssContext = new ScanStoreContext())
{
return(ssContext.Cessions
.Where(cess => cess.Id == _id)
.Include(cess => cess.CessionScans)
.Include(cess => cess.Partner)
.Include(cess => cess.Contracts)
.Select(cess => new
{
cess.Id,
cess.Name,
cess.Date,
partnerName = cess.Partner.Name,
cess.CommitDate,
contractCount = cess.Contracts.Count(),
cessionScans = cess.CessionScans.Select(cs => new
{
cs.Id,
cs.FileName,
cs.Type,
cs.Size
})
}).SingleOrDefault());
}
}
public object GetContractInfoToJSON(int _id)
{
using (var ssContext = new ScanStoreContext())
{
return(ssContext.Contracts
.Where(con => con.Id == _id)
.Include(con => con.ContractScans)
.Select(con => new
{
con.Id,
con.IdPkb,
con.IdPristav,
con.DebtNumber,
con.DebtorFio,
con.DebtDate,
auditing = con.Auditing,
avtocredit = con.Avtocredit,
cessionName = con.Cession.Name,
cessionDate = con.Cession.Date,
partnerName = con.Cession.Partner.Name,
contractScans = con.ContractScans.Select(cs => new
{
id = cs.Id,
csType = cs.CsType,
keeper = cs.Keeper,
city = cs.City,
party = cs.Party,
box = cs.Box,
folder = cs.Folder,
fileName = cs.FileName,
exist = cs.ExistDocument
})
}).SingleOrDefault());
}
}
public Handler(ScanStoreContext context, IPasswordHasher passwordHasher,
ICurrentUserAccessor currentUserAccessor, IMapper mapper)
{
_context = context;
_passwordHasher = passwordHasher;
_currentUserAccessor = currentUserAccessor;
_mapper = mapper;
}
public object GetCessionsListToJSON()
{
using (var ssContext = new ScanStoreContext())
{
return(ssContext.Cessions.Select(cess => new { cess.Id,
cess.Name,
cess.Date,
cess.PartnerId }).ToList());
}
}
public FiltratorContractListMass(ContractsMassViewModel _model)
{
if (_model == null)
{
throw new Exception("Неопределены все обязательные параметры");
}
ssContext = new ScanStoreContext();
//resultContractsList = null;
model = _model;
contractsList = ssContext.Contracts.AsNoTracking().AsQueryable <Contracts>();
sortContractsList = new List <Contracts>();
}
public object GetServiceTasksStatusesTaskToJSON()
{
using (var ssContext = new ScanStoreContext())
{
return(ssContext.ServiceTasksStatusesTask
.Select(stst => new
{
stst.Id,
stst.Name
})
.ToList());
}
}
public object GetContractRequestStatusesToJSON()
{
using (var ssContext = new ScanStoreContext())
{
return(ssContext.ContractRequestStatuses
.Select(crs => new
{
crs.Id,
crs.Name
})
.ToList());
}
}
public object GetContractRequestTypesStatusVisibleToJSON()
{
using (var ssContext = new ScanStoreContext())
{
return(ssContext.ContractRequestTypesStatusVisible
.Select(crt => new
{
crt.Id,
crt.Discript
})
.ToList());
}
}
public object GetContractSignsToJSON()
{
using (var ssContext = new ScanStoreContext())
{
return(ssContext.ContractSigns
.Select(cs => new
{
cs.Id,
cs.Name
})
.ToList());
}
}
public object GetOfficeCityToJSON()
{
using (var ssContext = new ScanStoreContext())
{
return(ssContext.OfficeCity
.Select(oc => new
{
oc.Id,
oc.Name
})
.ToList());
}
}
public object GetOfficeAddressToJSON()
{
using (var ssContext = new ScanStoreContext())
{
return(ssContext.OfficeAddress
.Select(oa => new
{
oa.Id,
oa.City,
oa.Address
})
.ToList());
}
}
public object GetContractMassListToJSON(FiltratorContractListMass _flt)
{
ScanStoreContext ssContext = new ScanStoreContext();
var cons = _flt.resIds.Join(ssContext.Contracts
.Include(con => con.ContractScans)
.Include(con => con.Cession)
.Include(con => con.Cession.Partner)
.Where(con => _flt.resIds.Contains(con.Id)),
ri => ri,
con => con.Id,
(ri, con) => con
)
.Include(con => con.ContractScans)
.Include(con => con.Cession)
.Skip(_flt.model.skip).Take(_flt.model.take);
//var lst = cons.Count();
var cc = cons
.Select(con => new
{
con.Id,
con.IdPkb,
con.IdPristav,
con.DebtNumber,
con.DebtorFio,
con.DebtDate,
auditing = con.Auditing,
avtocredit = con.Avtocredit,
cessionName = con.Cession.Name,
cessionDate = con.Cession.Date,
partnerName = con.Cession.Partner.Name,
contractScans = con.ContractScans.Select(cs => new
{
id = cs.Id,
csType = cs.CsType,
keeper = cs.Keeper,
city = cs.City,
party = cs.Party,
box = cs.Box,
folder = cs.Folder,
fileName = cs.FileName,
exist = cs.ExistDocument
})
});
return(cc);
}
public object GetContractRequestTypesToJSON()
{
using (var ssContext = new ScanStoreContext())
{
return(ssContext.ContractRequestTypes
.Select(crt => new
{
crt.Id,
crt.Name,
crt.Description,
crt.VisibleStatus
})
.ToList());
}
}
public ActionResult DelDoc(Guid id)
{
ScanStoreContext ssContext = new ScanStoreContext();
var file = ssContext.ContractScans.SingleOrDefault(cs => cs.Id == id);
if (file != null)
{
ssContext.ContractScans.Remove(file);
ssContext.SaveChanges();
return(Ok());
}
else
{
return(NotFound());
}
}
public ActionResult GetScan(Guid id)
{
//var User = HttpContext.User.Identity.Name.ToString();
ScanStoreContext ssContext = new ScanStoreContext();
var file = ssContext.ContractScans.SingleOrDefault(cs => cs.Id == id);
if (file != null)
{
string file_path = file.Path;
string file_type = file.Type;
string file_name = Path.GetFileName(file.Path);
return(PhysicalFile(file_path, file_type, file_name));
}
else
{
return(NotFound());
}
}
public bool IsValidInData(Cessions _cession)
{
using (var ssContext = new ScanStoreContext())
{
bool res = false;
var fCess = ssContext.Cessions.SingleOrDefault(c => c.Name == _cession.Name);
var fPartn = ssContext.Partners.SingleOrDefault(p => p.Id == _cession.PartnerId);
if (_cession != null)
{
if (_cession.Name != null && _cession.Name != "" && _cession.Date != null && fCess == null && fPartn != null)
{
res = true;
}
}
return(res);
}
}
public ActionResult DelScan(Guid id)
{
ScanStoreContext ssContext = new ScanStoreContext();
var file = ssContext.ContractScans.SingleOrDefault(cs => cs.Id == id);
if (file != null)
{
file.FileName = "";
file.InsertDate = null;
file.Path = "";
file.Type = "";
file.Size = null;
file.HashFile = null;
ssContext.ContractScans.Update(file);
ssContext.SaveChanges();
return(Ok());
}
else
{
return(NotFound());
}
}
public ActionResult GetZip(int id)
{
ScanStoreContext ssContext = new ScanStoreContext();
var scans = ssContext.CessionScans.Where(c => c.CessionId == id).ToList();
var FileName = string.Format("Сканы цессии {0} от {1:dd.MM.yyyy}.zip", scans.First().Cession.Name, scans.First().Cession.Date);
ZipFile zip_file = new ZipFile(FileName);
if (scans.Count() != 0)
{
foreach (var itemScan in scans)
{
if (System.IO.File.Exists(itemScan.Path))
{
zip_file.Add(itemScan.Path);
}
}
}
zip_file.AddDirectory("");
zip_file.Close();
return(PhysicalFile("", ""));
}
public ActionResult CreateCessions([FromBody] Cessions _cession)
{
try
{
if (cm.IsValidInData(_cession))
{
using (var ssContext = new ScanStoreContext())
{
ssContext.Cessions.Add(_cession);
ssContext.SaveChanges();
}
return(Ok(_cession));
}
else
{
return(BadRequest());
}
}
catch (Exception ex)
{
return(StatusCode(500, ex.Message));
}
}
public ActionResult CreatePartner([FromBody] Partners _partner)
{
try
{
using (var ssContext = new ScanStoreContext())
{
if (pm.IsValidInData(_partner))
{
ssContext.Partners.Add(_partner);
ssContext.SaveChanges();
return(Ok(_partner));
}
else
{
return(BadRequest());
}
}
}
catch (Exception ex)
{
return(StatusCode(500, ex.Message));
}
}
public object GetRequestMassListToJSON(FiltratorRequestListMass _frlm)
{
ScanStoreContext ssContext = new ScanStoreContext();
var conr = _frlm.resIds.Join(ssContext.ContractRequess
.Include(cr => cr.Contract)
.Include(cr => cr.Contract.Cession)
.Include(cr => cr.Contract.Cession.Partner)
.Where(cr => _frlm.resIds.Contains(cr.Id)),
ri => ri,
cr => cr.Id,
(ri, cr) => cr
)
.Include(cr => cr.Contract)
.Include(cr => cr.Contract.Cession)
.Skip(_frlm.model.skip).Take(_frlm.model.take);
var cc = conr
.Select(cr => new
{
requestId = cr.Id,
cr.Contract.Id,
cr.Contract.IdPkb,
cr.Contract.IdPristav,
cr.Contract.DebtNumber,
cr.Contract.DebtorFio,
cr.RequestDate,
cr.ReqStatus,
cr.ReqType,
cessionName = cr.Contract.Cession.Name,
partnerName = cr.Contract.Cession.Partner.Name,
});
return(cc);
}
public Handler(ScanStoreContext context, ICurrentUserAccessor currentUserAccessor)
{
_context = context;
_currentUserAccessor = currentUserAccessor;
}
public ProfileReader(ScanStoreContext context, ICurrentUserAccessor currentUserAccessor, IMapper mapper)
{
_context = context;
_currentUserAccessor = currentUserAccessor;
_mapper = mapper;
}
public QueryHandler(ScanStoreContext context, IJwtTokenGenerator jwtTokenGenerator, IMapper mapper)
{
_context = context;
_jwtTokenGenerator = jwtTokenGenerator;
_mapper = mapper;
}
public DBContextTransactionPipelineBehavior(ScanStoreContext context)
{
_context = context;
}
