public async Task <IActionResult> Create(
[Bind(
"Name,Code,CountChanel,IsActiv,IsCommunicationDevice,NumberConnectionPoints,Description,CreatedDate,Id")]
ModuleType moduleType)
{
if (ModelState.IsValid)
{
if (moduleType.IsActiv && !moduleType.IsCommunicationDevice)
{
var result = _context.ModulesTypes.Any(x => x.IsActiv && !x.IsCommunicationDevice);
if (result)
{
ModelState.AddModelError(string.Empty, "Уже существует действующий модуль LPBS");
return(View(moduleType));
}
}
if (moduleType.IsCommunicationDevice)
{
moduleType.NumberConnectionPoints = 0;
}
_context.Add(moduleType);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(moduleType));
}
public async Task <T> Add(T entity)
{
_context.Entry(entity).State = EntityState.Added;
await _context.SaveChangesAsync();
return(entity);
}
public async Task <IActionResult> Create([Bind("FirstName,MiddleName,LastName,Phone,DepartmentId,Id")]
EmployeeCreateEditViewModel employee)
{
if (ModelState.IsValid)
{
var employeeIns = _mapper.Map <EmployeeCreateEditViewModel, Employee>(employee);
try
{
_context.Add(employeeIns);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch (DbUpdateException dbUpdateException)
{
_logger.LogError("{ExceptionMessage}", dbUpdateException.Message);
ModelState.AddModelError(String.Empty, "Ошибка при сохранении");
//return View(employee);
}
catch (Exception e)
{
_logger.LogError("{ExceptionMessage}", e.Message);
}
}
ViewData["DepartmentId"] = new SelectList(_context.Departments, "Id", "Name", employee.DepartmentId);
return(View(employee));
}
public async Task <TEntity> AddAsync(TEntity entity)
{
_dbContext.Set <TEntity>().Add(entity);
await _dbContext.SaveChangesAsync();
return(entity);
}
public async Task <IActionResult> Create([Bind("Id,Name,Description")] Contractor contractor)
{
if (ModelState.IsValid)
{
if (_context.Statuses.Any(x => String.Equals(x.Name, contractor.Name)))
{
ModelState.AddModelError("Name", "Уже существует");
}
if (ModelState.IsValid)
{
try
{
_context.Add(contractor);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch (DbUpdateException e)
{
var exception = e.InnerException;
if (exception != null && exception.Message.Contains("IX_Contractors_Name"))
{
ModelState.AddModelError("Name", "Контрагент уже существует");
}
}
}
}
return(View(contractor));
}
public async Task <IActionResult> Create([Bind("Id,Name,Description,IsResponsibleProjectsAndSubProjects,IsResponsibleDesignWork")]
Department department)
{
//IX_Departments_Name
if (ModelState.IsValid)
{
if (_context.Departments.Any(x => String.Equals(x.Name, department.Name)))
{
ModelState.AddModelError("Name", "Отдел уже существует");
}
if (ModelState.IsValid)
{
try
{
_context.Add(department);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch (DbUpdateException e)
{
var exception = e.InnerException;
if (exception != null && exception.Message.Contains("IX_Departments_Name"))
{
ModelState.AddModelError("Name", "Отдел уже существует");
}
}
}
}
return(View(department));
}
protected virtual Task <int> DeleteOneAsync(int id)
{
return(Task.Run(async() =>
{
var obj = await GetOneAsync(id);
_efDbContext.Set <T>().Remove(obj);
return await _efDbContext.SaveChangesAsync();
}));
}
public async Task AddMuseumAsync(EntityMuseum entityMuseum)
{
var model = new TableMuseum
{
Id = Guid.NewGuid().GetGuidStr(),
Name = entityMuseum.Name
};
await _context.Museums.AddAsync(model);
await _context.SaveChangesAsync();
}
public async Task <ActionResult> Create([Bind(Include = "Id,Name,AddressLine1,AddressLine2,City,State,Country,Pin")] Agency agency)
{
if (ModelState.IsValid)
{
db.Agencies.Add(agency);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(agency));
}
public async Task <ActionResult> Create([Bind(Include = "ID,Title,ReleaseDate,Price")] DemoModel demoModel)
{
if (ModelState.IsValid)
{
db.DemoModels.Add(demoModel);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(demoModel));
}
public async Task <ActionResult> Create(Order order)
{
if (ModelState.IsValid)
{
db.Orders.Add(order);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(order));
}
public async Task <ActionResult> Create([Bind(Include = "ID,Name,Date,Amount,Comments,IsPrepared,IsVerified,IsPassed")] VehicleBill vehicleBill)
{
if (ModelState.IsValid)
{
db.VehicleBills.Add(vehicleBill);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(vehicleBill));
}
public async Task SetCompletedAsync(string messageId, CancellationToken cancellationToken = default)
{
var outboxMessage = await _dbContext.Set <OutboxMessage>()
.FirstOrDefaultAsync(m => m.Id == messageId, cancellationToken: cancellationToken);
if (outboxMessage == null)
{
return;
}
outboxMessage.SetCompleted();
await _dbContext.SaveChangesAsync(cancellationToken);
}
public async Task <ActionResult> Create([Bind(Include = "ID,No,Description,Date,AgencyId")] LoaPackage loaPackage)
{
if (ModelState.IsValid)
{
db.LoaPackages.Add(loaPackage);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.AgencyId = new SelectList(db.Agencies, "ID", "Name", loaPackage.AgencyId);
return(View(loaPackage));
}
public async Task <ActionResult> Create([Bind(Include = "ID,LoaPackageId,Name,Date")] LoaAmendment loaAmendment)
{
if (ModelState.IsValid)
{
db.LoaAmendments.Add(loaAmendment);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.LoaPackageId = new SelectList(db.LoaPackages, "ID", "No", loaAmendment.LoaPackageId);
return(View(loaAmendment));
}
public async Task <bool> AddStudentAsync(AddStudentModel profile)
{
try
{
DbUser user = new DbUser
{
UserName = profile.Email /*profile.UserName*/,
Email = profile.Email,
PhoneNumber = profile.PhoneNumber,
};
BaseProfile prof = new BaseProfile
{
Name = profile.Name,
LastName = profile.LastName,
Surname = profile.Surname,
Adress = profile.Adress,
DateOfBirth = Convert.ToDateTime(profile.DateOfBirth),
PassportString = profile.PassportString,
IdentificationCode = profile.IdentificationCode
};
string password = PasswordGenerator.GenerationPassword();
await _userManager.CreateAsync(user, password);
await _userManager.AddToRoleAsync(user, "Student");
prof.Id = user.Id;
await _context.BaseProfiles.AddAsync(prof);
await _context.SaveChangesAsync();
await _context.StudentProfiles.AddAsync(new StudentProfile { Id = prof.Id });
await _context.SaveChangesAsync();
if (profile.GroupId != 0)
{
await _context.GroupsToStudents.AddAsync(new GroupToStudent
{
GroupId = profile.GroupId,
StudentId = user.Id
});
await _context.SaveChangesAsync();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public async Task <IActionResult> Create(
[Bind(
"Name,SerialNum,CertifiedNum,ProductTypeId,SubProjectId,IsFormed,ManufacturingDate,ShippedDate,OrderDate,ShippedDate,Id,Description")]
ProductCreateViewModel productDto)
{
if (ModelState.IsValid)
{
if (_context.Products.Any(x => x.SerialNum == productDto.SerialNum &&
x.SerialNum != null))
{
ModelState.AddModelError("SerialNum", "Серийный номер уже существует");
}
if (_context.Products.Any(x => x.CertifiedNum == productDto.CertifiedNum &&
x.CertifiedNum != null))
{
ModelState.AddModelError("CertifiedNum", "Код уже используется");
}
if (ModelState.IsValid)
{
var product = _mapper.Map <ProductCreateViewModel, Product>(productDto);
_context.Add(product);
try
{
await _context.SaveChangesAsync();
return(RedirectToAction("GetProductsForSubProject", new { subProjectId = product.SubProjectId }));
}
catch (DbUpdateException e)
{
var exception = e.InnerException;
if (exception != null && exception.Message.Contains("IX_Products_SerialNum"))
{
ModelState.AddModelError("SerialNum", "Такой номер уже используется");
}
if (exception != null && exception.Message.Contains("IX_Products_CertifiedNum"))
{
ModelState.AddModelError("CertifiedNum", "Такой номер уже используется");
}
}
}
}
ViewData["ProductTypeId"] =
new SelectList(_context.ProductTypes, "Id", "Name", productDto.ProductTypeId);
// ViewData["SubProjectId"] =
// new SelectList(_context.SubProjects, "Id", "Name", productDto.SubProjectId);
return(View(productDto));
}
/// <summary>
/// Thực hiện nhập khẩu nhân viên
/// </summary>
/// <param name="keyImport">Key xác định lấy dữ liệu để nhập khẩu từ cache</param>
/// <param name="overriderData">Có cho phép ghi đè hay không (true- ghi đè dữ liệu trùng lặp trong db)</param>
/// <param name="cancellationToken">Tham số tùy chọn xử lý đa luồng (hiện tại chưa sử dụng)</param>
/// <returns>ActionServiceResult(với các thông tin tương ứng tùy thuộc kết nhập khẩu)</returns>
/// CreatedBy: NVMANH (10/10/2020)
public override async Task <ActionServiceResult> Import(string importKey, bool overriderData, CancellationToken cancellationToken)
{
var employees = ((List <Employee>)CacheGet(importKey)).Where(e => e.ImportValidState == ImportValidState.Valid || (overriderData && e.ImportValidState == ImportValidState.DuplicateInDb)).ToList();;
using var dbContext = new EfDbContext();
// Danh sách các vị trí/ chức vụ mới:
var newPositons = ((List <Position>)CacheGet(string.Format("Position_{0}", importKey)));
await dbContext.Position.AddRangeAsync(newPositons);
// Danh sách nhân viên thêm mới:
var newEmployees = employees.Where(e => e.ImportValidState == Core.Enumeration.ImportValidState.Valid).ToList();
await dbContext.Employee.AddRangeAsync(newEmployees);
// Danh sách nhân viên thực hiện ghi đè:
var modifiedEmployees = employees.Where(e => e.ImportValidState == Core.Enumeration.ImportValidState.DuplicateInDb).ToList();
foreach (var emp in modifiedEmployees)
{
dbContext.Entry(emp).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
var pbd = dbContext.EmployeeFamily.Where(e => e.EmployeeId == emp.EmployeeId);
dbContext.EmployeeFamily.AddRange(emp.EmployeeFamily);
dbContext.EmployeeFamily.RemoveRange(pbd);
}
//dbContext.Employee.UpdateRange(modifiedEmployees);
await dbContext.SaveChangesAsync();
return(new ActionServiceResult(true, Resources.Msg_ImportSuccess, MISACode.Success, employees));
}
public async Task <dynamic> Post([FromBody] UpdateStatus command)
{
try
{
if (ModelState.IsValid)
{
Status status = _mapper.Map <UpdateStatus, Status>(command);
_dbContext.Add(status);
int result = await _dbContext.SaveChangesAsync();
// send event
StatusReceived message = Mapper.Map <StatusReceived>(command);
await _messagePublisher.PublishMessageAsync(message.MessageType, message, "StatusReceived");
//return result
return(result > 0 ? new
{
Saved = true,
}
: new
{
Saved = false,
});
}
return(BadRequest());
}
catch (DbUpdateException)
{
ModelState.AddModelError("", "Unable to save changes. " +
"Try again, and if the problem persists " +
"see your system administrator.");
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
public async Task <IActionResult> Edit(int id,
[Bind(
"ModuleTypeId,DestinationOrderCardId,SerialNumber,Place,FirmwareVersion,EmployeeId,ActualOrderCardId,ManufacturingData,Id")]
ModuleCreateEditViewModel moduleVm)
{
if (id != moduleVm.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
var module = _mapper.Map <ModuleCreateEditViewModel, Module>(moduleVm);
try
{
_context.Update(module);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ModuleExists(module.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(GetModulesForCardOrder),
new { cardOrderId = moduleVm.DestinationOrderCardId }));
}
ViewData["EmployeeId"] = new SelectList(_context.Employees
.Where(x => x.Department.IsResponsibleDesignWork), "Id", "GetFullName");
ViewData["ActualOrderCardId"] =
new SelectList(_context.OrderCards, "Id", "Name", moduleVm.ActualOrderCardId);
ViewData["DestinationOrderCardId"] =
new SelectList(_context.OrderCards, "Id", "Name", moduleVm.DestinationOrderCardId);
ViewData["ModuleTypeId"] = new SelectList(_context.ModulesTypes, "Id", "Code", moduleVm.ModuleTypeId);
return(View(moduleVm));
}
public async Task AcquireStatus(UpdateStatus command)
{
Status status = _mapper.Map <UpdateStatus, Status>(command);
_dbContext.Add(status);
int result = await _dbContext.SaveChangesAsync();
// send event
StatusReceived message = Mapper.Map <StatusReceived>(command);
await _messagePublisher.PublishMessageAsync(message.MessageType, message, "StatusReceived");
}
public async Task <T> Add(T domainObject)
{
if (_service.Set <T>().Any(x => x.UserId == domainObject.UserId))
{
throw new Exception("User already exist");
}
await _service.Set <T>().AddAsync(domainObject);
await _service.SaveChangesAsync();
return(domainObject);
}
public static async Task Initialize(EfDbContext context)
{
context.Database.EnsureCreated();
if (context.Products.Count() == 0)
{
//First product
Product product = new Product();
List <Size> size = new List <Size>();
size.Add(new Size(SizeOfPruduct.M, 1));
size.Add(new Size(SizeOfPruduct.L, 1));
size.Add(new Size(SizeOfPruduct.XL, 1));
size.Add(new Size(SizeOfPruduct.XXL, 1));
List <Photos> photosList = new List <Photos>();
photosList.Add(new Photos(@"\Upload\Photos\2d79fb18-0341-4a14-8da1-f7f3edb90a49.jpg"));
photosList.Add(new Photos(@"\Upload\Photos\5fb493c8-04b7-4e3d-97d7-bc1cb69dc10a.jpg"));
product.Photos = photosList;
product.Name = "Jeansy damskie Rocks";
product.Price = 299;
product.Description = "Spodnie damskie Rocks<br />Skład:Bawełna<br /><br />Idealnie dopasowane";
product.Gender = Gender.Woman;
product.Group = Group.Spodnie;
product.Sizes = size;
product.Table = @"\Upload\Tables\92e81a01-5c46-4687-8a53-5aa182821760.jpg";
context.Add(product);
//Second product
Product product1 = new Product();
List <Size> size1 = new List <Size>();
size1.Add(new Size(SizeOfPruduct.M, 1));
size1.Add(new Size(SizeOfPruduct.L, 1));
size1.Add(new Size(SizeOfPruduct.XL, 1));
size1.Add(new Size(SizeOfPruduct.XXL, 1));
List <Photos> photosList1 = new List <Photos>();
photosList1.Add(new Photos(@"\Upload\Photos\4c44be83-44bd-4e89-b2e9-5ebb2b41eded.jpg"));
photosList1.Add(new Photos(@"\Upload\Photos\41efc1cd-a190-4e7b-a7bd-1e51fcd038db.jpg"));
photosList1.Add(new Photos(@"\Upload\Photos\87c39856-4d41-494f-beda-a84d3db48857.jpg"));
product1.Photos = photosList1;
product1.Name = "Marynarka męska";
product1.Price = 299;
product1.Description = "Marynarka męska<br />Skład:Bawełna";
product1.Gender = Gender.Men;
product1.Group = Group.Kurtki;
product1.Sizes = size1;
product1.Table = @"\Upload\Tables\92e81a01-5c46-4687-8a53-5aa182821760.jpg";
context.Add(product1);
await context.SaveChangesAsync();
}
}
public async Task <JsonResult> AddNewProduct([FromBody] AddProduct productToAdd)
{
if (ModelState.IsValid)
{
List <Size> sizes = new List <Size>();
Product product = new Product();
var quantityWithoutNull = productToAdd.Quantity.Where(x => x != String.Empty).ToArray();
for (int i = 0; i < productToAdd.Size.Length; i++)
{
sizes.Add(new Size((SizeOfPruduct)Convert.ToInt32(productToAdd.Size[i]), Convert.ToInt32(quantityWithoutNull[i])));
}
product.Name = productToAdd.Name;
product.Price = Convert.ToInt32(productToAdd.Price);
product.Description = productToAdd.Description;
product.Gender = (Gender)Convert.ToInt32(productToAdd.Gender);
product.Group = (Group)Convert.ToInt32(productToAdd.Group);
product.Sizes = sizes;
List <Photos> photos = new List <Photos>();
foreach (var item in productToAdd.Photos)
{
photos.Add(new Photos(item));
}
product.Photos = photos;
product.Table = productToAdd.Table;
_context.Add(product);
await _context.SaveChangesAsync();
return(Json(new { success = true, responseText = "Your message successfuly sent!" }));
}
else
{
return(Json(new { success = false, responseText = "Your message not sent!" }));
}
}
public async Task <int> CommitAsync()
{
try
{
// Transaction işlemleri burada ele alınabilir veya Identity Map kurumsal tasarım kalıbı kullanılarak
// sadece değişen alanları güncellemeyide sağlayabiliriz.
return(await _context.SaveChangesAsync());
}
catch
{
// Burada DbEntityValidationException hatalarını handle edebiliriz.
throw;
}
}
public async Task <IActionResult> PutPerson(int id, Person person)
{
person.id = id;
_context.Entry(person).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PersonExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> Create([Bind("Id,Name,OwnerId,Code,EmployeeId,Description")]
ProjectCreateViewModel projectVM)
{
if (ModelState.IsValid)
{
var project = _mapper.Map <ProjectCreateViewModel, Project>(projectVM);
_context.Add(project);
try
{
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch (DbUpdateException e)
{
var exception = e.InnerException;
if (exception != null && exception.Message.Contains("IX_Projects_Name"))
{
ModelState.AddModelError("Name", "Проект уже существует");
}
if (exception != null && exception.Message.Contains("IX_Projects_Code"))
{
ModelState.AddModelError("Code", "Такой код уже используется");
}
}
}
ViewData["EmployeeId"] = new SelectList(_context.Employees
.Where(x => x.Department.IsResponsibleProjectsAndSubProjects),
"Id", "GetFullName");
ViewData["OwnerId"] = new SelectList(_context.Owners,
"Id", "Name",
projectVM.OwnerId);
return(View(projectVM));
}
public async Task <IActionResult> Create([Bind("Id,Name,StatusTypeId")] Status status)
{
//IX_Statuses_Name
if (ModelState.IsValid)
{
if (_context.Statuses.Any(x =>
String.Equals(x.Name, status.Name) &&
x.StatusTypeId == status.StatusTypeId))
{
ModelState.AddModelError("Name", "Такой статус уже существует");
}
if (ModelState.IsValid)
{
_context.Add(status);
try
{
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch (DbUpdateException e)
{
var exception = e.InnerException;
if (exception != null && exception.Message.Contains("IX_Statuses_Name"))
{
ModelState.AddModelError("Name", "Статус уже существует");
}
}
}
}
ViewData["StatusTypeId"] =
new SelectList(_context.StatusTypes, "Id", "StatusTypeName", status.StatusTypeId);
return(View(status));
}
public async Task <IActionResult> Create([Bind("Name,ProductSubTypeId,Description,Id")]
ProductType productType)
{
if (ModelState.IsValid)
{
if (_context.ProductTypes.Any(x =>
String.Equals(x.Name, productType.Name)))
{
ModelState.AddModelError("Name", "Такой тип уже существует");
}
if (ModelState.IsValid)
{
_context.Add(productType);
try
{
_context.Add(productType);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch (DbUpdateException e)
{
var exception = e.InnerException;
if (exception != null && exception.Message.Contains("IX_ProductTypes_Name"))
{
ModelState.AddModelError("Name", "Тип уже существует");
}
}
}
}
ViewData["ProductSubTypeId"] =
new SelectList(_context.ProductSubTypes, "Id", "Name", productType.ProductSubTypeId);
return(View(productType));
}
public async Task <IActionResult> Create(
[Bind("ProjectId,Name,Code,EmployeeId,StatusId,Contract,ContractorId,Description,EndDate")]
SubProjectCreateEditViewModel subProjectDTO)
{
if (ModelState.IsValid)
{
var subProject = _mapper.Map <SubProjectCreateEditViewModel, SubProject>(subProjectDTO);
_context.Add(subProject);
try
{
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(GetSubProject), new { projectId = subProjectDTO.ProjectId }));
}
catch (DbUpdateException e)
{
var exception = e.InnerException;
if (exception != null && exception.Message.Contains("IX_SubProjects_Name"))
{
ModelState.AddModelError("Name", "Подпроект уже существует");
}
if (exception != null && exception.Message.Contains("IX_SubProjects_Code"))
{
ModelState.AddModelError("Code", "Такой код уже используется");
}
}
}
ViewData["EmployeeId"] = new SelectList(_context.Employees
.Where(x => x.Department.IsResponsibleProjectsAndSubProjects), "Id", "GetFullName");
ViewData["StatusId"] = new SelectList(_context.Statuses
.Where(x => x.StatusTypeId == 1), "Id", "Name");
ViewData["ContractorId"] = new SelectList(_context.Contractors, "Id", "Name");
return(View(subProjectDTO));
}