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();
}
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));
}
public StatementWithAllStatuses()
{
Statement = new ApplicationStatement();
CurrentStatus = new ApplicationCurrentStatus();
HistoryOfStatuses = new List <ApplicationHistoryOfStatus>();
}
public async Task EditItemAsync(ApplicationStatement statement)
{
_context.Update(statement);
await _context.SaveChangesAsync();
}