public async Task <Document> ToTransferred(int id_interno)
{
using (var transaction = _dbContext.Database.CurrentTransaction ?? _dbContext.Database.BeginTransaction())
{
try
{
var doc = await _dbContext.documento.FirstOrDefaultAsync(doci => doci.id_interno.Equals(id_interno));
doc.usuario_modificacion = "ByEmail";
doc.fecha_transferencia = DateTime.Now;
doc.ultima_modificacion = DateTime.Now;
if (doc == null || doc?.id_interno == 0)
{
return(null);
}
doc.id_tipo_documento_estado = 2;
doc.ultima_modificacion = DateTime.Now;
await _dbContext.SaveChangesAsync();
transaction.Commit();
return(_mapper.Map <Document>(doc));
}
catch (Exception err)
{
transaction.Rollback();
throw err;
}
}
}
public async Task <ActionResult <Contracts> > PostProducts(Contracts contracts)
{
//
var oCustomerDoc = new Contracts();
oCustomerDoc.CustomerName = contracts.CustomerName;
oCustomerDoc.CustomerAddress = contracts.CustomerAddress;
oCustomerDoc.CustomerCountry = contracts.CustomerCountry;
oCustomerDoc.CustomerDOB = contracts.CustomerDOB;
oCustomerDoc.CustomerGender = contracts.CustomerGender;
oCustomerDoc.SaleDate = contracts.SaleDate;
var coverplan = (from cover in _context.CoveragePlans where cover.EligibilityCountry == contracts.CustomerCountry select cover.CoveragePlanName).FirstOrDefault();
oCustomerDoc.CoveragePlan = coverplan;
int age = 0;
DateTime dobcurrent = Convert.ToDateTime(contracts.CustomerDOB);
age = DateTime.Now.Year - dobcurrent.Year;
if (DateTime.Now.DayOfYear < dobcurrent.DayOfYear)
{
age = age - 1;
}
var netprice = (from rate in _context.RateCharts where rate.CoveragePlanName == coverplan && rate.CustomerGender == contracts.CustomerGender && rate.CustomerAge == Convert.ToString(age) select rate.NetPrice).FirstOrDefault();
oCustomerDoc.NetPrice = netprice;
_context.Contracts.Add(oCustomerDoc);
await _context.SaveChangesAsync();
return(oCustomerDoc);
}
public async Task <IActionResult> Create([Bind("AnimalId,AnimalName,AnimalDescription")] Animals animals)
{
if (ModelState.IsValid)
{
_context.Add(animals);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(animals));
}
public async Task <IActionResult> Create([Bind("AboutZooID,Description,Date")] AboutZoo aboutZoo)
{
if (ModelState.IsValid)
{
_context.Add(aboutZoo);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(aboutZoo));
}
public async Task <IActionResult> Create([Bind("Id,Title,CreateTime,LastUpdateTime")] CompetitionField competitionField)
{
if (ModelState.IsValid)
{
competitionField.CreateTime = DateTime.Now;
_context.Add(competitionField);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(competitionField));
}
public async Task <IActionResult> Create([Bind("StatusId,Title,CreateTime,LastUpdateTime,Editable")] Status status)
{
if (ModelState.IsValid)
{
status.CreateTime = DateTime.Now;
_context.Add(status);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(status));
}
public async Task <IActionResult> Create([Bind("Id,FullName,PhoneNumber,PhoneNumberConfirmed,Email,EmailConfirmed,PhoneNumberVerifyCode,EmailVerifyCode,Password,Avatar,Role,AccessFailedCount,CreateTime,LastUpdateTime,IsDeleted,IsActive")] User user)
{
if (ModelState.IsValid)
{
user.Id = Guid.NewGuid();
_context.Add(user);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(user));
}
public async Task <IActionResult> Create([Bind("AnnouncementId,AnnouncementTitle,AnnouncementText,Date")] Announcements announcements)
{
if (ModelState.IsValid)
{
announcements.Date = DateTime.Now;
_context.Add(announcements);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(announcements));
}
public async Task <IActionResult> Create([Bind("Name,Quantity,Price,ProductTypeId,Id,CreatedOnUtc")] Product product)
{
if (ModelState.IsValid)
{
_context.Add(product);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ProductTypeId"] = new SelectList(_context.Set <ProductType>(), "Id", "Name", product.ProductTypeId);
return(View(product));
}
public async Task <IActionResult> Create([Bind("Id,Title,CreateTime,LastUpdateTime,CompetitionBranchId,UserId")] CompetitionSubject competitionSubject)
{
if (ModelState.IsValid)
{
competitionSubject.CreateTime = DateTime.Now;
_context.Add(competitionSubject);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CompetitionBranchId"] = new SelectList(_context.CompetitionBranchs, "Id", "Title", competitionSubject.CompetitionBranchId);
return(View(competitionSubject));
}
public async Task <IActionResult> Create([Bind("Id,Subject,StatusId")] Ticket ticket)
{
if (ModelState.IsValid)
{
ticket.Id = (Guid.NewGuid()).ToString();
_context.Add(ticket);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["StatusId"] = new SelectList(_context.Statues, "StatusId", "Title", ticket.StatusId);
return(View(ticket));
}
public async Task <IActionResult> Create(IFormCollection formCollection, CreateParticipantViewModel participant)
{
Participant participantToAdd = new Participant();
if (ModelState.IsValid)
{
participantToAdd.Id = (Guid.NewGuid()).ToString();
participantToAdd.CreateTime = DateTime.Now;
participantToAdd.Subject = participant.Subject;
participantToAdd.StatusId = 1;
participantToAdd.Description = participant.Description;
participantToAdd.UserId = HttpContext.User.Identity.Name;
participantToAdd.CompetitionSubjectId = participant.CompetitionSubjectId;
if (formCollection.Files != null)
{
foreach (var file in formCollection.Files)
{
var fileContent = ContentDispositionHeaderValue.Parse(file.ContentDisposition);
//var id = HttpContext.User.Identity.Name;
// Some browsers send file names with full path.
// We are only interested in the file name.
var format = Path.GetExtension(fileContent.FileName.ToString().Trim('"'));
var filename = Guid.NewGuid().ToString() + format;
var physicalPath = Path.Combine(Directory.GetCurrentDirectory(), @"wwwroot\uploads\" + HttpContext.User.Identity.Name, filename);
var path = Path.Combine(Directory.GetCurrentDirectory(), @"wwwroot\uploads\" + HttpContext.User.Identity.Name);
bool exists = Directory.Exists(path);
if (!exists)
{
Directory.CreateDirectory(path);
}
using (var fileStream = new FileStream(physicalPath, FileMode.Create))
{
await file.CopyToAsync(fileStream);
}
participantToAdd.AttachedFile = filename;
}
}
_context.Add(participantToAdd);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(participantToAdd));
}
public async Task <IActionResult> Edit(Guid id, [Bind("Id,FullName,PhoneNumber,PhoneNumberConfirmed,Email,EmailConfirmed,PhoneNumberVerifyCode,Role,AccessFailedCount,CreateTime,LastUpdateTime,IsActive")] UserViewModel user)
{
if (id != user.Id)
{
return(NotFound());
}
var userToEdit = _context.Users.Find(user.Id);
userToEdit.FullName = user.FullName;
userToEdit.PhoneNumber = user.PhoneNumber;
userToEdit.IsActive = user.IsActive;
userToEdit.Email = user.Email;
userToEdit.PhoneNumberConfirmed = user.PhoneNumberConfirmed;
userToEdit.EmailConfirmed = user.EmailConfirmed;
userToEdit.LastUpdateTime = DateTime.Now;
if (ModelState.IsValid)
{
try
{
_context.Update(userToEdit);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UserExists(user.Id))
{
return(NotFound());
}
else
{
throw;
}
}
if (user.Role == "Participant")
{
return(RedirectToAction(nameof(Participants)));
}
else if (user.Role == "Expert")
{
return(RedirectToAction(nameof(Experts)));
}
else
{
return(RedirectToAction(nameof(Supporters)));
}
}
return(View(user));
}
public async Task <string> DeleteDocumentAsync(DocumentViewModel document)
{
var documentToDelete = await _dbContext.Documents.FindAsync(document.Id);
_dbContext.Documents.Remove(documentToDelete);
await _dbContext.SaveChangesAsync();
return("success");
}
public async Task <IActionResult> PostUser([FromBody] User user)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Users.Add(user);
await _context.SaveChangesAsync();
var options = new PusherOptions();
options.Cluster = "ap1";
var pusher = new Pusher("649204", "068d00130871386d6b37", "59c57f8ff64c56f95886", options);
ITriggerResult result = await pusher.TriggerAsync("asp_channel", "asp_event", user);
return(Content("ok"));
}
public async Task <ActionResult <Person> > Post([FromBody] Person person)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid request object"));
}
else
{
await _dbContext.Persons.AddAsync(person);
await _dbContext.SaveChangesAsync();
return(Created($"https://azwebapiexample20190910011131.azurewebsites.net/api/person/{person.ID}", person));
}
}
catch (Exception ex)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, $"Person not created. {ex.StackTrace}"));
}
}
public string GetUser(string userId, string avatarUrl)
{
var user = (from u in _dbContext.Users
where u.Id == Guid.Parse(userId)
select u).FirstOrDefault();
if (user != null)
{
user.Avatar = avatarUrl;
_dbContext.Update(user);
_dbContext.SaveChangesAsync();
return("success");
}
else
{
return("fail");
}
}
public async Task <IActionResult> UserContributionEdit(string id, UserContributionEditViewModel participant, IFormCollection formCollection)
{
if (id != participant.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
var participantToUpdate = await _context.Participants.FindAsync(id);
participantToUpdate.LastUpdateTime = DateTime.Now;
participantToUpdate.CompetitionSubjectId = participant.CompetitionSubjectId;
participantToUpdate.Description = participant.Description;
participantToUpdate.Subject = participant.Subject;
participantToUpdate.StatusId = participant.StatusId;
participantToUpdate.LastStatusTime = DateTime.Now;
if (formCollection.Files != null)
{
foreach (var file in formCollection.Files)
{
var fileContent = ContentDispositionHeaderValue.Parse(file.ContentDisposition);
var userId = HttpContext.User.Identity.Name;
// Some browsers send file names with full path.
// We are only interested in the file name.
var format = Path.GetExtension(fileContent.FileName.ToString().Trim('"'));
var filename = Guid.NewGuid().ToString() + format;
var physicalPath = Path.Combine(Directory.GetCurrentDirectory(), @"wwwroot\uploads\" + userId, filename);
var path = Path.Combine(Directory.GetCurrentDirectory(), @"wwwroot\uploads\" + userId);
bool exists = Directory.Exists(path);
if (!exists)
{
Directory.CreateDirectory(path);
}
// The files are not actually saved in this demo
using (var fileStream = new FileStream(physicalPath, FileMode.Create))
{
await file.CopyToAsync(fileStream);
}
participantToUpdate.AttachedFile = filename;
}
}
_context.Update(participantToUpdate);
await _context.SaveChangesAsync();
var userPhoneNumber = (from u in _userManager.Users
where u.Id == participantToUpdate.UserId
select u.PhoneNumber).FirstOrDefault();
var statusTitle = (from s in _context.Statues
where s.StatusId == participant.StatusId
select s.Title).FirstOrDefault();
Classes.SendSmsAsync(userPhoneNumber, "مشارکت", statusTitle, "changestatus");
}
catch (DbUpdateConcurrencyException)
{
if (!ParticipantExists(participant.Id))
{
return(NotFound());
}
else
{
throw;
}
}
var url = "/ParticipantUsers/UserContributions/" + participant.UserId;
return(Redirect(url));
}
return(View(participant));
}
private async Task <Document> InsertDocument(documento new_documento)
{
using (var transaction = _dbContext.Database.CurrentTransaction ?? _dbContext.Database.BeginTransaction())
{
try
{
int last_id = _dbContext.documento.Max(doc => doc.id_interno);
new_documento.id_interno = last_id + 1;
_dbContext.documento.Add(new_documento);
await _dbContext.SaveChangesAsync();
// Insert a row
OrdenesCompra purcharseOrder = _dbContext.ordenes_compra.
Where(po => po.id_orden_compra == new_documento.id_orden_compra &&
po.ruc_empresa_cliente == new_documento.ruc_empresa_cliente).
FirstOrDefault();
//throw new Exception();
if ((purcharseOrder != null) ? !purcharseOrder.id_orden_compra.Equals("--") : false)
{
var empresa = _dbContext.empresas.FirstOrDefault(ent => ent.ruc_empresa.Equals(purcharseOrder.ruc_empresa_cliente));
purcharseOrder = Tolerance.ToleranceCalculate(purcharseOrder, empresa, new_documento);
await _dbContext.SaveChangesAsync();
}
transaction.Commit();
return(_mapper.Map <Document>(new_documento));
}
catch (Exception err)
{
transaction.Rollback();
throw err;
}
finally
{
transaction.Dispose();
}
}
//OrdenesCompra purcharseOrder = _dbContext.ordenes_compra.
// Where(po => po.id_orden_compra == new_documento.id_orden_compra &&
// po.ruc_empresa_cliente == new_documento.ruc_empresa_cliente).
// FirstOrDefault();
/*PurcharseOrder pox = _mapper.Map<PurcharseOrder>(purcharseOrder);
* OrdenesCompra purcharseOrdernew = _mapper.Map<OrdenesCompra>(pox);*/
//var purcharseOrdernew = new OrdenesCompra();
/*if ((purcharseOrder != null) ? !purcharseOrder.id_orden_compra.Equals("--") : false)
* {
* var empresa = _dbContext.empresas.FirstOrDefault(ent => ent.ruc_empresa.Equals(purcharseOrder.ruc_empresa_cliente));
*
* purcharseOrdernew.monto_acumulado = 455879;
* var tenp = "klkss";
* //purcharseOrdernew = Tolerance.ToleranceCalculate(purcharseOrder, empresa, new_documento);
* var temp = AuditoriaHelper.OrdenDeCompraAuditorias(purcharseOrder, purcharseOrdernew);
* }*/
/*
* using (var context = _dbContext)
* {
* using (var transaction = _dbContext.Database.BeginTransaction())
* {
* try
* {
* //documento nuevo
* _dbContext.documento.Add(new_documento);
*
* await _dbContext.SaveChangesAsync();
*
* OrdenesCompra purcharseOrder = _dbContext.ordenes_compra.
* Where(po => po.id_orden_compra == new_documento.id_orden_compra &&
* po.ruc_empresa_cliente == new_documento.ruc_empresa_cliente).
* FirstOrDefault();
*
* if ((purcharseOrder != null) ? !purcharseOrder.id_orden_compra.Equals("--") : false)
* {
* var empresa = _dbContext.empresas.FirstOrDefault(ent => ent.ruc_empresa.Equals(purcharseOrder.ruc_empresa_cliente));
* purcharseOrder = Tolerance.ToleranceCalculate(purcharseOrder, empresa, new_documento);
* await _dbContext.SaveChangesAsync();
* }
*
* var document = _mapper.Map<documento>(new_documento);
*
*
* transaction.Commit();
* }
* catch (Exception err)
* {
* transaction.Rollback();
* throw err;
* }
* finally
* {
* transaction.Dispose();
* context.Dispose();
* //transaction.Commit();
* }
* }
* }*/
}
