public async Task <ActionResult <VendorDocument> > Update([FromBody] VendorDocument _VendorDocument)
{
VendorDocument _VendorDocumentq = _VendorDocument;
try
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
_VendorDocumentq = await(from c in _context.VendorDocument
.Where(q => q.VendorDocumentId == _VendorDocument.VendorDocumentId)
select c
).FirstOrDefaultAsync();
_context.Entry(_VendorDocumentq).CurrentValues.SetValues((_VendorDocument));
await _context.SaveChangesAsync();
//await _context.SaveChangesAsync();
BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora
{
IdOperacion = _VendorDocumentq.VendorDocumentId,
DocType = "VendorDocument",
ClaseInicial =
Newtonsoft.Json.JsonConvert.SerializeObject(_VendorDocumentq, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
ResultadoSerializado = Newtonsoft.Json.JsonConvert.SerializeObject(_VendorDocumentq, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
Accion = "Actualizar",
FechaCreacion = DateTime.Now,
FechaModificacion = DateTime.Now,
UsuarioCreacion = _VendorDocumentq.CreatedUser,
UsuarioModificacion = _VendorDocumentq.ModifiedUser,
UsuarioEjecucion = _VendorDocumentq.ModifiedUser,
});
await _context.SaveChangesAsync();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
throw ex;
// return BadRequest($"Ocurrio un error:{ex.Message}");
}
}
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}")));
}
return(await Task.Run(() => Ok(_VendorDocumentq)));
}
/// <summary>
/// Get File Name By Id
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public VendorDocument GetFileNameById(Int64 ID)
{
VendorDocument vm = new VendorDocument();
RepositoryService <VendorDocument> objVendorDocument = new RepositoryService <VendorDocument>(_vContext);
vm = objVendorDocument.GetByID(ID);
return(vm);
}
public static TModel FromVendorDocument <TModel>(VendorDocument vendorDocument) where
TModel : VendorDocumentApiModel, new()
{
var model = new TModel();
model.Id = vendorDocument.Id;
model.TenantId = vendorDocument.TenantId;
model.CompletionDate = vendorDocument.CompletionDate;
model.Document = DocumentApiModel.FromDocument(vendorDocument.Document);
return(model);
}
// GET: /VendorDocument/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(RedirectToAction("BadRequest", "Error"));
}
VendorDocument vendordocument = db.VendorDocuments.Find(id);
if (vendordocument == null)
{
return(RedirectToAction("NotFound", "Error"));
}
return(View(vendordocument));
}
public ActionResult Upload(int vendorId)
{
try
{
ViewBag.DocumentTypes = new SelectList(db.DocumentTypes.Where(d => d.DocumentGroup == (int)DocumentGroup.VendorDocument).OrderBy(d => d.Name), "DocumentTypeId", "Name");
var vendorDoc = new VendorDocument();
vendorDoc.VendorId = vendorId;
return(View(vendorDoc));
}
catch (Exception exp)
{
Logger.LogException(exp);
return(RedirectToAction("AppError", "Error"));
}
}
/// <summary>
/// Remove vendor document reocrd from db
/// </summary>
/// <param name="vendorDocument"></param>
/// <returns></returns>
public int DeleteVendorDocRecord(VendorDocument vendorDocument)
{
int result = 0;
try
{
RepositoryService <VendorDocument> objVendorDocument = new RepositoryService <VendorDocument>(_vContext);
result = objVendorDocument.Delete(vendorDocument);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public ActionResult Upload([Bind(Include = "VendorDocumentId,VendorId,DocumentTypeId,Description")] VendorDocument vendordocument)
{
try
{
if (ModelState.IsValid)
{
if (Request.Files.Count > 0)
{
foreach (string fileName in Request.Files)
{
HttpPostedFileBase file = file = Request.Files[fileName];
if (file != null && file.ContentLength > 0)
{
var allowedExtensions = new Utility().DocumentExtensions;
var extension = Path.GetExtension(file.FileName);
if (!allowedExtensions.Contains(extension))
{
ModelState.AddModelError("FilePath", "The extension " + extension + " files are not allowed.");
ViewBag.DocumentTypes = new SelectList(db.DocumentTypes, "DocumentTypeId", "Name", vendordocument.DocumentTypeId);
return(View(vendordocument));
}
string path = vendordocument.DocumentPath + vendordocument.VendorId.ToString() + "_" + vendordocument.DocumentTypeId.ToString() + "_"
+ DateTime.Now.ToString("MMddyyyyhhmmss") + "_" + Path.GetFileName(file.FileName);
string savedFileName = Path.Combine(Server.MapPath("~" + path));
file.SaveAs(savedFileName);
vendordocument.ContentType = file.ContentType;
vendordocument.FilePath = path;
vendordocument.FileName = file.FileName;
vendordocument.UploadedBy = User.Identity.GetUserId();
vendordocument.UploadedTimestamp = DateTime.Now;
db.VendorDocuments.Add(vendordocument);
db.SaveChanges();
return(RedirectToAction("Index", new { vendorId = vendordocument.VendorId }));
}
}
}
}
ViewBag.DocumentTypes = new SelectList(db.DocumentTypes.Where(d => d.DocumentGroup == (int)DocumentGroup.VendorDocument).OrderBy(d => d.Name), "DocumentTypeId", "Name");
return(View(vendordocument));
}
catch (Exception exp)
{
Logger.LogException(exp);
return(RedirectToAction("AppError", "Error"));
}
}
// GET: /VendorDocument/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(RedirectToAction("BadRequest", "Error"));
}
VendorDocument vendordocument = db.VendorDocuments.Find(id);
if (vendordocument == null)
{
return(RedirectToAction("NotFound", "Error"));
}
ViewBag.DocumentTypeId = new SelectList(db.DocumentTypes, "DocumentTypeId", "Name", vendordocument.DocumentTypeId);
ViewBag.VendorId = new SelectList(db.Vendors, "VendorId", "Name", vendordocument.VendorId);
return(View(vendordocument));
}
public async Task <IActionResult> GetVendorDocumentById(Int64 VendorDocumentId)
{
VendorDocument Items = new VendorDocument();
try
{
Items = await _context.VendorDocument.Where(q => q.VendorDocumentId == VendorDocumentId).FirstOrDefaultAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(Items)));
}
public ActionResult DeleteConfirmed(int id)
{
try
{
VendorDocument vendordocument = db.VendorDocuments.Find(id);
string path = Request.MapPath(vendordocument.FilePath);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
db.VendorDocuments.Remove(vendordocument);
db.SaveChanges();
return(RedirectToAction("Index", new { vendorId = vendordocument.VendorId }));
}
catch (Exception exp)
{
Logger.LogException(exp);
return(RedirectToAction("AppError", "Error"));
}
}
public ActionResult Edit([Bind(Include = "VendorDocumentId,VendorId,DocumentTypeId,FilePath,Description,FileName,ContentType,UploadedBy,UploadedTimestamp")] VendorDocument vendordocument)
{
try
{
if (ModelState.IsValid)
{
db.Entry(vendordocument).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DocumentTypeId = new SelectList(db.DocumentTypes, "DocumentTypeId", "Name", vendordocument.DocumentTypeId);
ViewBag.VendorId = new SelectList(db.Vendors, "VendorId", "Name", vendordocument.VendorId);
return(View(vendordocument));
}
catch (Exception exp)
{
Logger.LogException(exp);
return(RedirectToAction("AppError", "Error"));
}
}
/// <summary>
/// GetFileNameById
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public bool ValidateVendorUser(Int32?UserID, string FileName)
{
bool IsValidUser = false;
try
{
VendorDocument vendorDocument = new VendorDocument();
RepositoryService <VendorDocument> objVendorDocument = new RepositoryService <VendorDocument>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@UserID", UserID, System.Data.SqlDbType.Int));
parameters.Add(SQLHelper.SqlInputParam("@FileName", FileName, System.Data.SqlDbType.VarChar));
var data = objVendorDocument.ExecWithStoreProcedure("proc_GetVendorDocUser @UserID,@FileName", parameters.ToArray());
IEnumerable <VendorDocument> lstVendorDocUser = data.ToList();
if (lstVendorDocUser.Count() > 0)
{
IsValidUser = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(IsValidUser);
}
public void AddDocument(VendorDocument vendorDocument)
{
var res = _dbContext.Add(vendorDocument);
}
public static VendorDocumentApiModel FromVendorDocument(VendorDocument vendorDocument) => FromVendorDocument <VendorDocumentApiModel>(vendorDocument);
