public ActionResult Delete(BancosModel model)
{
if (sesion == null)
{
sesion = SessionDB.start(Request, Response, false, db);
}
model.sesion = sesion;
if (!sesion.permisos.havePermission(Privileges[0].Permiso))
{
return(Json(new { msg = Notification.notAccess() }));
}
try
{
if (model.Delete())
{
Log.write(this, "Delete", LOG.BORRADO, "SQL:" + model.sql, sesion);
return(Json(new { msg = Notification.Succes("Banco ELIMINADO con exito: " + model.Banco) }));
}
else
{
Log.write(this, "Delete", LOG.ERROR, "SQL:" + model.sql, sesion);
return(Json(new { msg = Notification.Error(" Error al Eliminar: " + model.Banco) }));
}
}
catch (Exception e)
{
return(Json(new { msg = Notification.Error(e.Message) }));
}
}
public ActionResult Add(BancosModel model)
{
if (sesion == null)
{
sesion = SessionDB.start(Request, Response, false, db);
}
model.sesion = sesion;
if (!sesion.permisos.havePermission(Privileges[0].Permiso))
{
return(Json(new { msg = Notification.notAccess() }));
}
try
{
if (model.Add())
{
Log.write(this, "Add", LOG.REGISTRO, "SQL:" + model.sql, sesion);
return(Json(new { msg = Notification.Succes("Registro agregado con exito: " + model.Banco) }));
}
else
{
Log.write(this, "Add", LOG.ERROR, "SQL:" + model.sql, sesion);
return(Json(new { msg = Notification.Error(" Error al agregar: " + model.Banco) }));
}
}
catch (Exception e)
{
return(Json(new { msg = Factory.Notification.Error(e.Message) }));
}
}
public ActionResult Save(BancosModel model)
{
if (sesion == null)
{
sesion = SessionDB.start(Request, Response, false, db);
}
model.sesion = sesion;
if (!sesion.permisos.havePermission(Privileges[0].Permiso))
{
return(Json(new { msg = Notification.notAccess() }));
}
try
{
if (model.Save())
{
Log.write(this, "Save", LOG.EDICION, "SQL:" + model.sql, sesion);
return(Json(new { msg = Notification.Succes("Banco guardado con exito: " + model.Banco) }));
}
else
{
Log.write(this, "Save", LOG.ERROR, "SQL:" + model.sql, sesion);
return(Json(new { msg = Notification.Error(" Error al GUARDAR: " + model.Banco) }));
}
}
catch (Exception e)
{
return(Json(new { msg = Notification.Error(e.Message) }));
}
}
public ActionResult Edit(BancosModel model)
{
if (model.Edit())
{
return(Json(new JavaScriptSerializer().Serialize(model)));
}
return(View());
}
private void CrearBanco(string linea)
{
var vector = linea.Split(';');
var model = new BancosModel()
{
Id = vector[0],
Nombre = vector[1],
Bic = vector[2]
};
_tablasVariasService.create(model);
}
public async Task <IHttpActionResult> ActualizarBancos(BancosModel bancosModel)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Bancos updatePago = new Bancos()
{
idBancos = bancosModel.idBancos,
tipo = 1,
numeroCheque = bancosModel.numeroCheque,
fechaPago = DateTime.ParseExact(bancosModel.fechaPago, "dd/MM/yyyy", new CultureInfo("es-MX")),
proveedor = bancosModel.proveedor,
numeroFactura = bancosModel.numeroFactura,
fechaFactura = DateTime.ParseExact(bancosModel.fechaFactura, "dd/MM/yyyy", new CultureInfo("es-MX")),
referenciaDepositos = string.Empty,
depositos = 0.00m,
cargos = bancosModel.cargos,
fechaModificacion = DateTime.Now,
idUsuarioModificacion = bancosModel.idUsuarioModificacion,
estatus = 1,
uuid = bancosModel.uuid
};
using (ReventonERPRepository _repo = new ReventonERPRepository())
{
int result = await _repo.UpdateBancoAsync(updatePago);
if (result == 0)
{
return(InternalServerError(new Exception("No se pudo actualizar el pago. Intente más tarde")));
}
return(Ok("success"));
}
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public async Task <IHttpActionResult> RegistrarDeposito(BancosModel bancosModel)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Bancos newDeposito = new Bancos()
{
idBancos = bancosModel.idBancos,
tipo = 2,
fechaPago = DateTime.ParseExact(bancosModel.fechaPago, "dd/MM/yyyy", new CultureInfo("es-MX")),
proveedor = bancosModel.proveedor,
referenciaDepositos = bancosModel.referenciaDepositos,
depositos = bancosModel.depositos,
fechaAlta = DateTime.Now,
idUsuarioAlta = bancosModel.idUsuarioAlta,
fechaModificacion = DateTime.Now,
idUsuarioModificacion = bancosModel.idUsuarioModificacion,
estatus = 1,
uuid = bancosModel.uuid
};
using (ReventonERPRepository _repo = new ReventonERPRepository())
{
int result = await _repo.RegisterBancoAsync(newDeposito);
if (result == 0)
{
return(InternalServerError(new Exception("No se pudo registrar el deposito. Intente más tarde")));
}
return(Ok("success"));
}
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public string getBanco(string idBanco = "")
{
BancosModel model = new BancosModel();
SessionDB sesion = SessionDB.start(Request, Response, false, model.db, SESSION_BEHAVIOR.AJAX);
if (sesion == null)
{
return("");
}
StringBuilder sb = new StringBuilder();
string selected = "";
// sb.Append("<option></option>");
foreach (KeyValuePair <string, string> pair in model.getBanco())
{
selected = (idBanco == pair.Value) ? "selected" : "";
// sb.Append("<option value=\"").Append(pair.Key).Append("\">").Append(pair.Value).Append("</option>\n");
sb.Append("<option value=\"").Append(pair.Key).Append("\" ").Append(selected).Append(">").Append(pair.Value).Append("</option>\n");
selected = "";
}
return(sb.ToString());
}
