public async Task <IActionResult> Create([Bind("PlcModelID,Name,DataCreation,IsEnable,Ip,Rack,Slot")] PlcModel plcModel)
{
if (ModelState.IsValid)
{
_context.Add(plcModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(plcModel));
}
private async Task <ResultCrmDb> AddOrEditModel <TModel, TModelEdit>(TModelEdit modelDto, DbSet <TModel> models)
where TModel : BaseModel
where TModelEdit : IBaseModel
{
var result = new ResultCrmDb();
try
{
var model = await models.FirstOrDefaultAsync(f => f.Id == modelDto.Id);
model = modelDto.Map(model);
if (model.Id == 0)
{
_reportDbContext.Add(model);
}
else
{
_reportDbContext.Update(model);
}
await _reportDbContext.SaveChangesAsync();
}
catch (Exception e)
{
Console.WriteLine(e);
result.AddError(ErrorCode.NoCode.ToString(), e.Message);
}
return(result);
}
/// <summary>
/// Добавить роль для пользователя
/// </summary>
/// <returns></returns>
public async Task <ResultCrmDb> AddToRoleByUser(string userName, string roleName)
{
var result = new ResultCrmDb();
var user = await _userManager.FindByNameAsync(userName);
if (user == null)
{
result.Succeeded = false;
result.AddError("crm002", "Пользователя с таким аакаунтом не существует");
return(result);
}
var resultIdentity = await _userManager.AddToRoleAsync(user, roleName);
if (resultIdentity.Succeeded)
{
return(result);
}
result.Succeeded = false;
foreach (var error in resultIdentity.Errors)
{
result.AddError(error.Code, error.Description);
}
var userCrm = await _crmDbContext.User.FirstOrDefaultAsync(f => f.Account == userName);
var roleCrm = await _crmDbContext.UserRole.FirstOrDefaultAsync(f => f.Sysname == roleName);
var link = await _crmDbContext.UserLinkRole.FirstOrDefaultAsync(
f => f.User == userCrm && f.UserRole == roleCrm);
if (link != null)
{
return(result);
}
link = new UserLinkRole()
{
User = userCrm, UserRole = roleCrm
};
_crmDbContext.Add(link);
await _crmDbContext.SaveChangesAsync();
return(result);
}
public async Task <IActionResult> Create([Bind("AntrenamentModelID,Data,OraStart,OraStop,IsPersonalTraining,Grupa")] AntrenamentModel antrenamentModel)
{
if (ModelState.IsValid)
{
_context.Add(antrenamentModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(IndexZilnic)));
}
return(View(antrenamentModel));
}
public async Task <IActionResult> Create([Bind("ResponsabilModelID,Nume,Prenume,Email,Functie,Departament")] ResponsabilModel responsabilModel)
{
if (ModelState.IsValid)
{
_context.Add(responsabilModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(responsabilModel));
}
public async Task <IActionResult> Create([Bind("UtilajModelID,Utilaj,ZonaUtilaj")] UtilajModel utilajModel)
{
if (ModelState.IsValid)
{
_context.Add(utilajModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(utilajModel));
}
public async Task <IActionResult> Create([Bind("TipAbonamentModelID,Denumire,NrTotalSedinte,IsPersonalTraining,Pret")] TipAbonamentModel tipAbonamentModel)
{
if (ModelState.IsValid)
{
_context.Add(tipAbonamentModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tipAbonamentModel));
}
public async Task <IActionResult> UploadDataFromFile(List <IFormFile> files)
{
// Verificam daca lista de fisiera incarcata are 0 elemente si returnam msj
if (files.Count == 0)
{
ViewBag.Hidden = "";
ViewBag.Mesaj = "Fisierul nu s-a incarcat";
return(View());
}
// Cream fisier din primul lelement din lista de fisiere
IFormFile formFile = files[0];
// Verificam daca fisierul are extensia .xlsx
if (!formFile.FileName.EndsWith(".xlsx"))
{
ViewBag.Hidden = "";
ViewBag.Mesaj = "Fisierul nu are extensia .xlsx!";
return(View());
}
//Cream lista de Index din fisier excel
List <IndexModel> lista = await _reportService.GetBlumsListFromExcelFileBySarjaAsync(formFile);
//Actualizam baza de date cu lista de blumuri din fisier
if (lista != null)
{
foreach (var item in lista)
{
_context.Add(item);
_context.SaveChanges();
}
}
// Redirection la Index
return(RedirectToAction("Indexes", "Home"));
}
/// <summary>
/// Генерация полей для режима на основании схемы БД
/// </summary>
/// <param name="formModelId"></param>
/// <returns></returns>
public async Task GenerateField(int formModelId)
{
var formModel = await _reportDbContext.FormModel.FirstOrDefaultAsync(f => f.Id == formModelId);
if (formModel == null)
{
return;
}
if (formModel.TableName == null)
{
throw new UserMessageException("Не удалось определить таблицу");
}
using (MySqlConnection connection = new MySqlConnection(_dataBaseMain.ConntectionString))
{
int i = 10;
var reuslt =
await connection.QueryAsync <ColumnTable>(string.Format(SelectField, connection.Database, formModel.TableName));
foreach (var columnTable in reuslt)
{
var field = await _reportDbContext.Field.FirstOrDefaultAsync(f => f.FormModelId == formModel.Id && f.Name == columnTable.ColumnName);
if (field != null)
{
continue;
}
field = new Field();
field.Name = columnTable.ColumnName;
field.FormModel = formModel;
field.MaxLength = columnTable.Maxlength;
field.Order = i;
field.OrderDetail = i;
field.DisplayName = columnTable.ColumnName;
field.TypeControl = GetTypeControl(columnTable.DataType);
field.TypeField = TypeField.ListAndEdit;
field.DefaultTypeAccec = TypeAccec.Full;
field.IsKey = !string.IsNullOrEmpty(columnTable.ColumnKey);
field.IsVisibleList = false;
field.WidthList = 20;
field.IsDetail = true;
field.TypeGroup = TypeGroup.None;
i = i + 10;
_reportDbContext.Add(field);
}
await _reportDbContext.SaveChangesAsync();
}
}
public async Task <IActionResult> Create([Bind("PersoanaModelID,Nume,Prenume,Email,Telefon,DataNastere,Sex,IsAcordGDPR")] PersoanaModel persoanaModel)
{
if (ModelState.IsValid)
{
PersoanaModel isRegistredPers = _context.PersoanaModels.FirstOrDefault(pers => pers.Email == persoanaModel.Email);
if (isRegistredPers != null)
{
ModelState.AddModelError($"User:"******"Email inregistrat pe numele {isRegistredPers.NumeComplet}");
return(View(persoanaModel));
}
_context.Add(persoanaModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(persoanaModel));
}
public async Task <IActionResult> Create([Bind("ActiuneModelID,Descriere,Tip,IsUseInputText,InputText,UtilajModelID")] ActiuneModel actiuneModel)
{
ViewData["UtilajModelID"] = new SelectList(_context.UtilajModels, "UtilajModelID", "Utilaj", actiuneModel.UtilajModelID);
try
{
if (ModelState.IsValid)
{
_context.Add(actiuneModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
catch
{
return(View(actiuneModel));
}
return(View(actiuneModel));
}
public async Task <IActionResult> Create([Bind("ProblemaModelID,DataIntroducere,UtilajModelID,ProblemaDescriere,ComentariuMentenanta,LastPersonUpdateRow")] ProblemaModel problemaModel)
{
if (ModelState.IsValid)
{
problemaModel.ComentariuMentenanta = "-";
problemaModel.Stare = Status.Nerezolvat;
_context.Add(problemaModel);
await _context.SaveChangesAsync();
// Send Mail
string filePathMailModel = Path.Combine(_env.WebRootPath, "Fisiere\\MailDate.JSON");
MailModel mailModel = _emailSender.GetMailModelAsync(filePathMailModel).Result;
UtilajModel utilajName = _context.UtilajModels.FirstOrDefault(utilaj => utilaj.UtilajModelID == problemaModel.UtilajModelID);
await _emailSender.SendEmailAsync(mailModel.FromAdress, mailModel.ToAddress, mailModel.Subjsect, problemaModel.LastPersonUpdateRow + mailModel.Messaege + problemaModel.ProblemaDescriere + $" la utilajul: {utilajName.Utilaj}");
return(RedirectToAction(nameof(Index)));
}
ViewData["ResponsabilModelID"] = new SelectList(_context.ResponsabilModel, "ResponsabilModelID", "Email", problemaModel.ResponsabilModelID);
ViewData["UtilajModelID"] = new SelectList(_context.UtilajModels, "UtilajModelID", "Utilaj", problemaModel.UtilajModelID);
return(View(problemaModel));
}
public async Task <IActionResult> Create([Bind("AbonamentModelID,DataStart,TipAbonamentModelID,PersoanaModelID")] AbonamentModel abonamentModel)
{
ViewData["TipAbonamentModelID"] = new SelectList(_context.TipAbonamentModels, "TipAbonamentModelID", "Denumire", abonamentModel.TipAbonamentModelID);
ViewData["PersoanaModelID"] = new SelectList(_context.PersoanaModels, "PersoanaModelID", "NumeComplet", abonamentModel.PersoanaModelID);
if (ModelState.IsValid)
{
TipAbonamentModel tipAb = _context.TipAbonamentModels.FirstOrDefault(a => a.TipAbonamentModelID == abonamentModel.TipAbonamentModelID);
abonamentModel.DataStop = abonamentModel.DataStart.AddDays(31);
abonamentModel.StareAbonament = StareAbonament.Activ;
abonamentModel.NrSedinteEfectuate = 0;
if (tipAb.NrTotalSedinte == 1) // Daca facem 1 abonament cu o singura sedinta il incheiem pe loc, nu mai e nevoie
// sa il incheiem din antrenament
{
abonamentModel.DataStop = abonamentModel.DataStart;
abonamentModel.StareAbonament = StareAbonament.Finalizat;
abonamentModel.NrSedinteEfectuate = 1;
}
// Daca persoana nu are atrenament Finalizat nu putem sa o adaugam pe un alt abonament
AbonamentModel isAbExpiredPers = _context.AbonamentModels.Include(p => p.PersoanaModel)
.Include(t => t.TipAbonament).FirstOrDefault(ab => ab.PersoanaModelID == abonamentModel.PersoanaModelID);
List <AbonamentModel> listOfAbForThisPerson = _context.AbonamentModels.Include(p => p.PersoanaModel).Include(t => t.TipAbonament).Where(ab => ab.PersoanaModelID == abonamentModel.PersoanaModelID).ToList();
isAbExpiredPers = listOfAbForThisPerson.LastOrDefault();
if (isAbExpiredPers != null)
{
if (isAbExpiredPers.StareAbonament == StareAbonament.Activ || isAbExpiredPers.StareAbonament == StareAbonament.Extins)
{
ModelState.AddModelError($"User:"******"{isAbExpiredPers.PersoanaModel.NumeComplet} are abonament: {isAbExpiredPers.StareAbonament} si expira pe: " +
isAbExpiredPers.DataStop.ToString("dd.MM.yyyy"));
return(View(abonamentModel));
}
}
_context.Add(abonamentModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(abonamentModel));
}
// Add New Check
public async Task AddNewCheck(ActionCheckModel check)
{
_context.Add(check);
await _context.SaveChangesAsync();
}
