/// <summary>
/// Pasing data to data access layer for inserting richieste retrieved from controller end.
/// </summary>
/// <param name="richiesteDto"></param>
/// <returns></returns>
public async Task <string> InsertAsync(ClaimsPrincipal User, RichiesteDto richiesteDto)
{
try
{
//map dto to table richieste
Richieste richieste = _mapper.Map <RichiesteDto, Richieste>(richiesteDto);
richieste.RichInsTimestamp = DateTime.Now;
richieste.RichModTimestamp = DateTime.Now;
richieste.RichData = DateTime.Now;
richieste.RichInsUteId = User.Claims.FirstOrDefault(x => x.Type.Equals("http://schemas.xmlsoap.org/ws/2005/05/identity/claims/nameidentifier"))?.Value;
richieste.RichModUteId = User.Claims.FirstOrDefault(x => x.Type.Equals("http://schemas.xmlsoap.org/ws/2005/05/identity/claims/nameidentifier"))?.Value;
richieste.RichCliId = User.Claims.FirstOrDefault(x => x.Type.Equals("http://schemas.xmlsoap.org/ws/2005/05/identity/claims/sid"))?.Value;
richieste.RichAttiva = "S";
// Passing data to dal
var richId = await _unitOfWork.Richieste.InsertRichieste(richieste);
return(richId);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Get single row data by predicate where clause.
/// </summary>
/// <param name="richid"></param>
/// <returns></returns>
public async Task <RichiesteDetailDto> FindByRichIdAsync(string richid)
{
try
{
Richieste richieste = await _unitOfWork.Richieste.FirstOrDefaultAsync(c => c.RichId.Equals(richid));
Aziende aziende = await _unitOfWork.Aziende.FirstOrDefaultAsync(x => x.AzId.Equals(richieste.RichAzId));
RichiesteDetailDto richiesteDetailDto = _mapper.Map <Richieste, RichiesteDetailDto>(richieste);
richiesteDetailDto.AzRagSociale = aziende.AzRagSociale;
return(richiesteDetailDto);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Pasing data to data access layer for deleting richieste retrieved from controller end.
/// </summary>
/// <param name="richid"></param>
/// <returns></returns>
public async Task <string> DeleteAsync(string richid)
{
try
{
Richieste richieste = await _unitOfWork.Richieste
.FirstOrDefaultAsync(c => c.RichId.Equals(richid));
// Here changing the status 'S' to 'N' rather than deleting the record.
richieste.RichStato = "N";
await _unitOfWork.CompleteAsync();
return(richieste.RichId);
}
catch (Exception)
{
throw;
}
}
public async Task <string> CloneAsync(string richid)
{
try
{
Richieste richieste = await _unitOfWork.Richieste.FirstOrDefaultAsync(c => c.RichId == richid);
richieste.RichInsTimestamp = DateTime.Now;
richieste.RichModTimestamp = DateTime.Now;
richieste.RichData = DateTime.Now;
var richId = await _unitOfWork.Richieste.InsertRichieste(richieste);
return(richId);
}
catch (Exception)
{
throw;
}
}
public async Task <IActionResult> RequestTrasf()
{
await Task.Delay(0);
string ids = this.userid;
TempData["Id"] = ids;
Account account = await accountHelper.GetById(acccountId);
ViewBag.accountType = account.AccountType.ToString();
// RichiestaTrasf rich = new RichiestaTrasf();
// ICollection<Request> list = await requestHelper.RequestsAsync();
//ViewBag.lista = list;
List <Richieste> ric = new List <Richieste>();
Richieste richiestaTrasf = new Richieste();
richiestaTrasf.AccountId = ids;
ric.Add(richiestaTrasf);
return(View(ric));
}
public async Task <IActionResult> NewRequestView(Richieste richiesta)
{
Account account = await accountHelper.GetById(acccountId);
ViewBag.accountType = account.AccountType.ToString();
RequestAssignement request = new RequestAssignement();
request.Account = await accountHelper.GetById(this.acccountId);
request.Request = await requestHelper.RetrieveByType(richiesta.RequestType.ToString());
request.Note = richiesta.Note;
request.From = richiesta.StartDate;
request.To = richiesta.To;
request.IsValid = request.IsValid;
if (ModelState.IsValid)
{
var all = await requestHelper.SaveRequestAssignement(request);
return(RedirectToAction("NewRequest"));
}
return(View());
}
/// <summary>
/// Pasing data to data access layer for updating richieste retrieved from controller end.
/// </summary>
/// <param name="richiesteDto"></param>
/// <returns></returns>
public async Task <string> UpdateAsync(ClaimsPrincipal User, RichiesteDto richiesteDto)
{
try
{
//map dto dto to table termini
Richieste richieste = await _unitOfWork.Richieste
.FirstOrDefaultAsync(c => c.RichId.Equals(richiesteDto.RichId) &&
c.RichCliId.Equals(richiesteDto.RichCliId));
_mapper.Map(richiesteDto, richieste);
richieste.RichModTimestamp = DateTime.Now;
richieste.RichModUteId = User.Claims.FirstOrDefault(x => x.Type.Equals("http://schemas.xmlsoap.org/ws/2005/05/identity/claims/nameidentifier"))?.Value;
await _unitOfWork.CompleteAsync();
return(richieste.RichId);
}
catch (Exception ex)
{
throw ex;
}
}
