public IHttpActionResult Delete(MovementViewModel pMovement)
{
try
{
using (DB_FleetServiceEntities db = new DB_FleetServiceEntities())
{
var rta = new ResponseApiViewModel();
var oMovementDB = db.Movement.Where(mv => mv.m_id == pMovement.id).FirstOrDefault();
oMovementDB.m_state = false;
oMovementDB.m_deleteDate = DateTime.Now;
db.SaveChanges();
rta.response = true;
rta.message = "Se ha eliminado el movimiento: " + pMovement.name;
return(Ok(rta));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
// GET: Movement/Edit/5
public ActionResult Edit(int id)
{
if (ModelState.IsValid)
{
try
{
MovementViewModel movModel = new MovementViewModel();
var serviceNomina = GetService.nominaService;
var mov = serviceNomina.GetMovientoById(id);
movModel.CopyPropertiesFrom(mov);
movModel.Empleado = new EmployeeViewModel();
movModel.Empleado.CopyPropertiesFrom(mov.Empleado);
movModel.EmpleadoSelect = movModel.Empleado.Id.ToString() + " - " + movModel.Empleado.Nombre + " [" + movModel.Empleado.getDescripcionRol() + "]";
return(View(movModel));
}
catch (Exception ex)
{
return(Json(new { isError = true, isWarning = false, isSuccess = false, msj = ex.Message }));
}
}
else
{
return(Json(new { isError = false, isWarning = true, isSuccess = false, msj = Errors.getModelError(ModelState) }));
}
}
public void MovementAndNotificationIsNull()
{
var result = new MovementViewModel(null,
null,
null,
null,
new DateTimeFormatter(),
new QuantityFormatter(),
new PhysicalCharacteristicsFormatter(),
new PackagingTypesFormatter());
new ExpectedMovementViewModel
{
ActualCubicMetres = string.Empty,
ActualDate = string.Empty,
ActualKilograms = string.Empty,
ActualLitres = string.Empty,
ActualTonnes = string.Empty,
IsNotSpecialHandling = false,
IsSpecialHandling = false,
NotificationNumber = string.Empty,
Number = string.Empty,
PhysicalCharacteristics = string.Empty
}.Evaluate(result);
}
public ActionResult Edit(MovementViewModel model)
{
try
{
if (ModelState.IsValid)
{
try
{
Service.Movement mov = new Services.Nomina.Movement();
mov.CopyPropertiesFrom(model);
var idEmp = model.EmpleadoSelect.Split('-');
mov.Empleado = new Services.Nomina.Employee();
mov.Empleado.Id = Convert.ToInt32(idEmp[0].Trim());
var serviceNomina = GetService.nominaService;
serviceNomina.AddUpdateMovimientos(mov);
return(Json(new { isError = false, isWarning = false, isSuccess = true, msj = "¡Los datos fueron Actualizados correctamente!", newurl = Url.Action("Index", "Movement", new { fechaInicio = DateTime.Now.AddDays(-DateTime.Now.Day + 1).Date, fechaFin = DateTime.Now.AddDays(-DateTime.Now.Day).AddMonths(1), idEmpleado = 0 }) }));
}
catch (Exception ex)
{
return(Json(new { isError = true, isWarning = false, isSuccess = false, msj = ex.Message }));
}
}
else
{
return(Json(new { isError = false, isWarning = true, isSuccess = false, msj = Errors.getModelError(ModelState) }));
}
//return RedirectToAction("Index");
}
catch
{
return(View());
}
}
public ActionResult Create(MovementViewModel model)
{
try
{
if (ModelState.IsValid)
{
try
{
Service.Movement mov = new Services.Nomina.Movement();
mov.CopyPropertiesFrom(model);
var idEmp = model.EmpleadoSelect.Split('-');
mov.Empleado = new Services.Nomina.Employee();
mov.Empleado.Id = Convert.ToInt32(idEmp[0].Trim());
var serviceNomina = GetService.nominaService;
serviceNomina.AddUpdateMovimientos(mov);
return(Json(new { isError = false, isWarning = false, isSuccess = true, msj = "¡Los datos fueron guardados correctamente!", newurl = "" }));
}
catch (Exception ex)
{
return(Json(new { isError = true, isWarning = false, isSuccess = false, msj = ex.Message }));
}
}
else
{
return(Json(new { isError = false, isWarning = true, isSuccess = false, msj = Errors.getModelError(ModelState) }));
}
//return RedirectToAction("Index");
}
catch
{
return(View());
}
}
public async Task <IActionResult> WithDraw(MovementViewModel model)
{
if (!ModelState.IsValid)
{
return(RedirectToAction("Index", "Client"));
}
var product = await _productsService.GetProductDetailById(model.Products.Id);
if (product == null)
{
return(RedirectToAction("Index"));
}
else
{
var movement = new Movements
{
amount = -model.amount,
date = DateTime.Now,
Products = await _productsService.GetProductDetailById(model.Products.Id),
MovementsType = await _movementTypeService.GetByType(2),
status = 1
};
var successful = await _movementService.AddAsync(movement);
if (!successful)
{
return(BadRequest("No se pudo efectuar la Extracción."));
}
_productsService.UpdateProductBalanceById(model.Products.Id, -model.amount);
return(RedirectToAction("Index", "Products", new { ClientId = product.Client.Id, product.Id }));
}
}
public async Task <IActionResult> Deposit(int ProductId)
{
var model = new MovementViewModel
{
ProductId = ProductId,
ProductTypes = await _productTypeService.GetAll()
};
return(View(model));
}
public IHttpActionResult GetTodayTransactions()
{
try
{
using (DB_FleetServiceEntities db = new DB_FleetServiceEntities())
{
var rowsTransactionsDB = db.STRPRC_GET_TRANSACTIONS_TODAY1();
List <TransactionViewModel> lsTransactions = new List <TransactionViewModel>();
foreach (var trxDB in rowsTransactionsDB)
{
TransactionViewModel transaction = new TransactionViewModel();
var clientTmp = new ClientViewModel();
clientTmp.id = trxDB.cli_id;
clientTmp.document = trxDB.cli_document;
clientTmp.name = trxDB.cli_name;
clientTmp.phone = trxDB.cli_phone;
clientTmp.cellphone = trxDB.cli_cellphone;
clientTmp.website = trxDB.cli_website;
clientTmp.city = (trxDB.cty_id != null) ? new CityViewModel {
id = trxDB.cty_id
} : null;
var movementTmp = new MovementViewModel();
movementTmp.id = trxDB.m_id;
movementTmp.name = trxDB.m_name;
var trxState = new TransactionStateViewModel();
trxState.id = trxDB.trxst_id;
trxState.name = trxDB.trxst_name;
transaction.id = trxDB.trx_id;
transaction.code = trxDB.trx_code;
transaction.consecutive = trxDB.trx_consecutive;
transaction.client = clientTmp;
transaction.movement = movementTmp;
transaction.transactionState = trxState;
transaction.value = Double.Parse(trxDB.trx_value.ToString());
transaction.registrationDate = trxDB.trx_registrationDate;
transaction.user = new UserAccessViewModel();
transaction.user.id_user = trxDB.usu_id;
transaction.user.name = trxDB.usu_name;
transaction.user.lastName = trxDB.usu_lastName;
lsTransactions.Add(transaction);
}
return(Ok(lsTransactions));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public void Evaluate(MovementViewModel model)
{
Assert.Equal(ActualCubicMetres, model.ActualCubicMetres);
Assert.Equal(ActualDate, model.ActualDate);
Assert.Equal(ActualKilograms, model.ActualKilograms);
Assert.Equal(ActualLitres, model.ActualLitres);
Assert.Equal(ActualTonnes, model.ActualTonnes);
Assert.Equal(NotificationNumber, model.NotificationNumber);
Assert.Equal(Number, model.Number);
Assert.Equal(PhysicalCharacteristics, model.PhysicalCharacteristics);
Assert.Equal(IsNotSpecialHandling, model.IsNotSpecialHandling);
Assert.Equal(IsSpecialHandling, model.IsSpecialHandling);
Assert.Equal(CA, model.CA);
}
private void setDataMovement(MovementViewModel pMovement, string transactionType, ref Movement movementDB)
{
if (transactionType == "INSERT")
{
movementDB.m_registrationDate = DateTime.Now;
movementDB.m_state = true;
}
else if (transactionType == "UPDATE")
{
movementDB.m_id = (int)pMovement.id;
movementDB.m_updateDate = DateTime.Now;
}
movementDB.m_name = pMovement.name;
movementDB.m_description = pMovement.description;
movementDB.mtp_id = pMovement.type.id;
}
public MovementBlock(IList<MergeField> mergeFields,
Movement movement,
MovementDetails movementDetails,
NotificationApplication notification,
ShipmentInfo shipmentInfo)
{
CorrespondingMergeFields = MergeFieldLocator.GetCorrespondingFieldsForBlock(mergeFields, TypeName);
data = new MovementViewModel(
movement,
movementDetails,
notification,
shipmentInfo,
new DateTimeFormatter(),
new QuantityFormatter(),
new PhysicalCharacteristicsFormatter(),
new PackagingTypesFormatter());
}
public MovementBlock(IList <MergeField> mergeFields,
Movement movement,
MovementDetails movementDetails,
NotificationApplication notification,
ShipmentInfo shipmentInfo)
{
CorrespondingMergeFields = MergeFieldLocator.GetCorrespondingFieldsForBlock(mergeFields, TypeName);
data = new MovementViewModel(
movement,
movementDetails,
notification,
shipmentInfo,
new DateTimeFormatter(),
new QuantityFormatter(),
new PhysicalCharacteristicsFormatter(),
new PackagingTypesFormatter());
}
/// <summary>
/// Shows movement dialog
/// </summary>
public MovementModel ShowMovementDialog(MovementModel movementModel)
{
ModalDialog modalDialog = new ModalDialog();
if (_parentWindow != null)
{
modalDialog.Owner = _parentWindow;
}
MovementModel movementModelCopy = new MovementModel(movementModel);
MovementViewModel movementViewModel = new MovementViewModel(movementModelCopy);
MovementView movementView = new MovementView(movementViewModel);
modalDialog.WindowTitle = "Movement";
modalDialog.Body = movementView;
modalDialog.Confirmation = movementView.ViewModel;
bool?result = ShowDialog(modalDialog);
return(result == true ? movementModelCopy : null);
}
public IHttpActionResult Update(MovementViewModel pMovement)
{
try
{
using (DB_FleetServiceEntities db = new DB_FleetServiceEntities())
{
var transactionType = "UPDATE";
var rta = new ResponseApiViewModel();
var oMovementDB = db.Movement.Where(mv => mv.m_id == pMovement.id).FirstOrDefault();
this.setDataMovement(pMovement, transactionType, ref oMovementDB);
db.SaveChanges();
rta.response = true;
rta.message = "Se ha actualizado el movimiento: " + pMovement.name;
return(Ok(rta));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
// GET: Movement
public ActionResult Index(DateTime fechaInicio, DateTime fechaFin, int idEmpleado)
{
List <MovementViewModel> lstMovModel = new List <MovementViewModel>();
MovementViewModel movModel = null;
try
{
List <Services.Nomina.Movement> lstMov;
var serviceNomina = GetService.nominaService;
if (idEmpleado == 0)
{
lstMov = serviceNomina.GetMovimientos(fechaInicio, fechaFin).ToList();
}
else
{
lstMov = serviceNomina.GetMovimientosByEmpleado(new Services.Nomina.Employee()
{
Id = idEmpleado
}, fechaInicio, fechaFin).ToList();
}
foreach (var mov in lstMov)
{
movModel = new MovementViewModel();
movModel.CopyPropertiesFrom(mov);
movModel.Empleado = new EmployeeViewModel();
movModel.Empleado.CopyPropertiesFrom(mov.Empleado);
lstMovModel.Add(movModel);
}
return(View(lstMovModel));
}
catch (Exception ex)
{
return(Json(new { isWarning = false, isSuccess = false, msj = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public IHttpActionResult Insert(MovementViewModel pMovement)
{
try
{
using (DB_FleetServiceEntities db = new DB_FleetServiceEntities())
{
var transactionType = "INSERT";
var rta = new ResponseApiViewModel();
var oMovementDB = new Movement();
this.setDataMovement(pMovement, transactionType, ref oMovementDB);
db.Movement.Add(oMovementDB);
db.SaveChanges();
rta.response = true;
rta.message = "Se ha insertado el movimiento: " + pMovement.name;
return(Ok(rta));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public ActionResult GetMovement([DataSourceRequest] DataSourceRequest request, MovementViewModel VM)
{
DateTime date1 = Convert.ToDateTime(VM.DATE1);
DateTime date2 = Convert.ToDateTime(VM.DATE2);
string startdate = date1.ToString("yyyy-MMM-dd");
string enddate = date2.ToString("yyyy-MMM-dd");
DataTable dt = repo.GetMovementList(startdate, enddate, VM.WHNO);
var result = dt;
return(Json(result.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Creates an instance of <see cref="MovementView"/>
/// </summary>
public MovementView(MovementViewModel movementViewModel)
{
InitializeComponent();
DataContext = movementViewModel;
}
public MovementView()
{
InitializeComponent();
DataContext = new MovementViewModel();
}
public void Evaluate(MovementViewModel model)
{
Assert.Equal(ActualCubicMetres, model.ActualCubicMetres);
Assert.Equal(ActualDate, model.ActualDate);
Assert.Equal(ActualKilograms, model.ActualKilograms);
Assert.Equal(ActualLitres, model.ActualLitres);
Assert.Equal(ActualTonnes, model.ActualTonnes);
Assert.Equal(NotificationNumber, model.NotificationNumber);
Assert.Equal(Number, model.Number);
Assert.Equal(PhysicalCharacteristics, model.PhysicalCharacteristics);
Assert.Equal(IsNotSpecialHandling, model.IsNotSpecialHandling);
Assert.Equal(IsSpecialHandling, model.IsSpecialHandling);
}
public ActionResult UpdateMovement([DataSourceRequest] DataSourceRequest request, MovementViewModel mov)
{
var result = db.WMS_MOVE_HEAD.SingleOrDefault(b => b.DOCNO == mov.DOCNO);
if (result != null)
{
result.USERID = mov.USERID;
db.SaveChanges();
}
return(Json(new[] { mov }.ToDataSourceResult(request, ModelState)));
}
