Пример #1
0
 public async Task CreateStatement(ApplicationStatement statement, IdentityUser user)
 {
     //Adding statement
     DbSet.Add(statement);
     _context.SaveChanges();
     //binding statement to user
     _context.AspUserStatement.Add(new ApplicationUserStatement
     {
         StatementId = statement.StatementId,
         Id          = user.Id
     });
     //setting current status
     _context.AspCurrentStatus.Add(new ApplicationCurrentStatus {
         CurrentСomment    = "Подача заяви",
         StatementId       = statement.StatementId,
         StatusId          = 1,
         DateOfLastChanges = DateTime.Now
     });
     //adding current status to history of statuses
     _context.AspHistoryOfStatus.Add(new ApplicationHistoryOfStatus
     {
         HistoryOfStatusId = statement.StatementId,
         StatusId          = 1,
         DateOfChanges     = DateTime.Now,
         Сomment           = "Подача заяви",
     });
     //
     await _context.SaveChangesAsync();
 }
Пример #2
0
        public byte[] WorkWithDocFile(ApplicationStatement statement)
        {
            var wordApp = new Microsoft.Office.Interop.Word.Application();

            //Application app = new Application();
            //Document doc = app.Documents.Add(Visible: true);

            Microsoft.Office.Interop.Word.Document wordDoc;
            string docText = null;

            //var room = _context.Rooms.Where(x => x.Id == id);
            if (statement.TypeOfBusinessTrip == "Відрядження закордон")
            {
                wordDoc = wordApp.Documents.Add(Path.GetFullPath(@"documents\statement_foreign.docx")); //Открываем шаблон
                ReplaceStub("{Name}", statement.UserNameGenitiveCase.ToString(), wordDoc);              //Заменяем метку на данные из формы(здесь конкретно из текстбокса с именем textBox_fio)
                ReplaceStub("{LastName}", statement.UserLastNameGenitiveCase.ToString(), wordDoc);
                ReplaceStub("{Surname}", statement.UserSurNameGenitiveCase.ToString(), wordDoc);
                ReplaceStub("{Place}", statement.InstitutionWhereYouGo.ToString(), wordDoc);
                ReplaceStub("{Country}", statement.StatementCountryOfDestination.ToString(), wordDoc);
                ReplaceStub("{City}", statement.StatementPlaceOfDestination.ToString(), wordDoc);
                ReplaceStub("{Purpose}", statement.PurposeOfBusinessTrip.ToString(), wordDoc);
                ReplaceStub("{Transport}", statement.TransportOfBusinessTrip.ToString(), wordDoc);
                ReplaceStub("{Route}", statement.RouteOfBusinessTrip.ToString(), wordDoc);
                ReplaceStub("{Basis}", statement.BasisOfBusinessTrip.ToString(), wordDoc);
                ReplaceStub("{TypeOfSalaryRetention}", statement.TypeOfBusinessTrip.ToString(), wordDoc);
                ReplaceStub("{PaymentOfTravelExpensesOption}", statement.PaymentOfTravelExpenses.ToString(), wordDoc);

                ///Может быть много таких меток
                docText = wordDoc.WordOpenXML;
            }
            else if (statement.TypeOfBusinessTrip == "Відрядження по Україні")
            {
                wordDoc = wordApp.Documents.Add(Path.GetFullPath(@"documents\statement_ukraine.docx")); //Открываем шаблон
                ReplaceStub("{Name}", statement.UserNameGenitiveCase.ToString(), wordDoc);              //Заменяем метку на данные из формы(здесь конкретно из текстбокса с именем textBox_fio)
                ReplaceStub("{LastName}", statement.UserLastNameGenitiveCase.ToString(), wordDoc);
                ReplaceStub("{Surname}", statement.UserSurNameGenitiveCase.ToString(), wordDoc);
                ReplaceStub("{Place}", statement.InstitutionWhereYouGo.ToString(), wordDoc);
                ReplaceStub("{Country}", statement.StatementCountryOfDestination.ToString(), wordDoc);
                ReplaceStub("{City}", statement.StatementPlaceOfDestination.ToString(), wordDoc);
                ReplaceStub("{Purpose}", statement.PurposeOfBusinessTrip.ToString(), wordDoc);
                ReplaceStub("{Transport}", statement.TransportOfBusinessTrip.ToString(), wordDoc);
                ReplaceStub("{Route}", statement.RouteOfBusinessTrip.ToString(), wordDoc);
                ReplaceStub("{Basis}", statement.BasisOfBusinessTrip.ToString(), wordDoc);
                ReplaceStub("{TypeOfSalaryRetention}", statement.TypeOfBusinessTrip.ToString(), wordDoc);
                ReplaceStub("{PaymentOfTravelExpensesOption}", statement.PaymentOfTravelExpenses.ToString(), wordDoc);
                ReplaceStub("{DateStart}", statement.DateOfBusinessTrip.ToString(), wordDoc);
                ReplaceStub("{DateEnd}", statement.DateOfСompletionBusinessTrip.ToString(), wordDoc);

                ///Может быть много таких меток
                docText = wordDoc.WordOpenXML;
            }

            var arr = Encoding.UTF8.GetBytes(docText);


            return(arr);
        }
        public async Task <IActionResult> Create(ApplicationStatement statement)
        {
            if (ModelState.IsValid)
            {
                var userName = HttpContext.User.Claims.FirstOrDefault(user => user.Type.EndsWith("name"))?.Value;

                if (userName != null)
                {
                    var user = await _userManager.FindByNameAsync(userName);

                    await _statementService.CreateStatement(statement, user);

                    //_statementService.WorkWithDocFile(statement);

                    return(RedirectToAction(nameof(Index)));
                }
            }

            return(View(statement));
        }
Пример #4
0
 public StatementWithAllStatuses()
 {
     Statement         = new ApplicationStatement();
     CurrentStatus     = new ApplicationCurrentStatus();
     HistoryOfStatuses = new List <ApplicationHistoryOfStatus>();
 }
Пример #5
0
 public async Task EditItemAsync(ApplicationStatement statement)
 {
     _context.Update(statement);
     await _context.SaveChangesAsync();
 }