//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; }