public ActionResult Create(Cliente cliente, string dtDetalle)
{
if (ModelState.IsValid)
{
db.Clientes.Add(cliente);
db.SaveChanges();
if (!string.IsNullOrEmpty(dtDetalle))
{
List <ClienteDetalle> jarray = JsonConvert.DeserializeObject <List <ClienteDetalle> >(dtDetalle);
foreach (var item in jarray)
{
int?idHeader = String.IsNullOrEmpty(db.ClienteDetalle.Max(u => (int?)u.detalleClienteID).ToString()) ? 1 : db.ClienteDetalle.Max(u => (int?)u.detalleClienteID).Value + 1;
var detalle = new ClienteDetalle()
{
ClienteID = cliente.ClienteId,
detalleClienteID = int.Parse(idHeader.ToString()),
Nombre = item.Nombre,
Parentezco = item.Parentezco,
OtrosDatos = item.OtrosDatos
};
db.ClienteDetalle.Add(detalle);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
ViewBag.PlanId = new SelectList(db.Plans, "PlanId", "descripcion", cliente.PlanId);
ViewBag.SucursalId = new SelectList(db.Sucursals, "SucursalId", "Nombre", cliente.SucursalId);
return(View(cliente));
}
private void DgBtnEditar_Click(object sender, RoutedEventArgs e)
{
var selected = ClientesDataGrid.SelectedItem as ClienteModel;
var detalle = new ClienteDetalle(selected, true);
detalle.ShowDialog();
}
protected void collback_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e)
{
switch (e.Parameter.Split('|')[0])
{
case "GuardarDetalle": var clienteDetalle = new ClienteDetalle();
clienteDetalle.CUSTOMER = int.Parse(Session["CodigoClienteScounting"].ToString());
clienteDetalle.SALE_ROUTE = UiListaRuta.Value?.ToString() ?? "";
clienteDetalle.REFERENCE_CBC = UiListaCheckRefereciaCVC.Items[0].Selected ? "L" : "";
clienteDetalle.REFERENCE_CBC += UiListaCheckRefereciaCVC.Items[1].Selected ? "M" : "";
clienteDetalle.REFERENCE_CBC += UiListaCheckRefereciaCVC.Items[2].Selected ? "R" : "";
clienteDetalle.REFERENCE_CBC += UiListaCheckRefereciaCVC.Items[3].Selected ? "J" : "";
clienteDetalle.REFERENCE_CBC += UiListaCheckRefereciaCVC.Items[4].Selected ? "V" : "";
clienteDetalle.VISIT_DAY = UiListaCheckDiaVisita.Items[0].Selected ? "L" : "";
clienteDetalle.VISIT_DAY += UiListaCheckDiaVisita.Items[1].Selected ? "M" : "";
clienteDetalle.VISIT_DAY += UiListaCheckDiaVisita.Items[2].Selected ? "R" : "";
clienteDetalle.VISIT_DAY += UiListaCheckDiaVisita.Items[3].Selected ? "J" : "";
clienteDetalle.VISIT_DAY += UiListaCheckDiaVisita.Items[4].Selected ? "V" : "";
clienteDetalle.VISIT_FRECUENCY = UiListaCheckFrecuenciaVisita.Items[0].Selected ? "L" : "";
clienteDetalle.VISIT_FRECUENCY += UiListaCheckFrecuenciaVisita.Items[1].Selected ? "M" : "";
clienteDetalle.VISIT_FRECUENCY += UiListaCheckFrecuenciaVisita.Items[2].Selected ? "R" : "";
clienteDetalle.VISIT_FRECUENCY += UiListaCheckFrecuenciaVisita.Items[3].Selected ? "J" : "";
clienteDetalle.VISIT_FRECUENCY += UiListaCheckFrecuenciaVisita.Items[4].Selected ? "V" : "";
clienteDetalle.TIME_DELIVER_DAYS = Int16.Parse(UiSpinTiempoEntrega.Value.ToString());
clienteDetalle.BRANCH = UiTextoRamo.Text;
clienteDetalle.SERVICE_WINDOW = UiTextoVentaServicio.Text;
clienteDetalle.SALE_POINT_COMPLEMENT_DIRECTION = UiDireccionPuntoVenta.Text;
clienteDetalle.INVOICE_ADRESS_COMPLEMENT = UiDireccionFacturacion.Text;
clienteDetalle.DEPARTMENT = UiListaDepartamentos.Value?.ToString() ?? "";
clienteDetalle.MUNICIPALITY = UiListaMunicipio.Value?.ToString() ?? "";
clienteDetalle.CREDIT_LIMIT = UiSpinLimiteCredito.Number;
clienteDetalle.CODE_BUSINESS_GYRE = UiTextoCodigoGiroNegocio.Text;
clienteDetalle.BUSINESS_GYRE_DENOMINATION = UiTextoDenominacionGiroNegocio.Text;
clienteDetalle.CREDIT_CONTROL_AREA = UiTextoAreaControlNegocio.Text;
clienteDetalle.FORM_PAY_AUTHORIZATION = UiTextoFormaPagoAutorizada.Text;
clienteDetalle.CURRENCY = UiListaMoneda.Value?.ToString() ?? "";
clienteDetalle.ASSOCIATED_ACCOUNTANT_CREDIT_COUNT = UiTextoCuentaContableCreditoAsociada.Text;
clienteDetalle.PAY_CONDITION = UiListaCondicionPago.Value?.ToString() ?? "";
clienteDetalle.CREDIT_BLOCKADE = UiCheckBloqueoCredito.Checked ? "1":"0";
clienteDetalle.LAST_UPDATED_BY = Session["USER"].ToString();
clienteDetalle.COMMENTS = UiMemoObservaciones.Text;
UsuarioDesesaGuardarDetalle?.Invoke(sender, new ScoutingArgumento {
ClienteDetalle = clienteDetalle
});
break;
case "LimpiarControles":
LimpiarControles();
collback.JSProperties.Add("cpCerrarPop", "Enabled");
break;
}
}
private void GuardarDatosAdicionalesDeScouting(object sender, string codeCustomer, int customerId)
{
var cliente = new Cliente();
cliente.CODE_CUSTOMER = codeCustomer;
var clienteDetalle = new ClienteDetalle();
clienteDetalle.CUSTOMER = customerId;
clienteDetalle.SALE_ROUTE = UiListaRuta.Value?.ToString() ?? "";
clienteDetalle.REFERENCE_CBC = UiListaCheckRefereciaCVC.Items[0].Selected ? "L" : "";
clienteDetalle.REFERENCE_CBC += UiListaCheckRefereciaCVC.Items[1].Selected ? "M" : "";
clienteDetalle.REFERENCE_CBC += UiListaCheckRefereciaCVC.Items[2].Selected ? "R" : "";
clienteDetalle.REFERENCE_CBC += UiListaCheckRefereciaCVC.Items[3].Selected ? "J" : "";
clienteDetalle.REFERENCE_CBC += UiListaCheckRefereciaCVC.Items[4].Selected ? "V" : "";
clienteDetalle.VISIT_DAY = UiListaCheckDiaVisita.Items[0].Selected ? "L" : "";
clienteDetalle.VISIT_DAY += UiListaCheckDiaVisita.Items[1].Selected ? "M" : "";
clienteDetalle.VISIT_DAY += UiListaCheckDiaVisita.Items[2].Selected ? "R" : "";
clienteDetalle.VISIT_DAY += UiListaCheckDiaVisita.Items[3].Selected ? "J" : "";
clienteDetalle.VISIT_DAY += UiListaCheckDiaVisita.Items[4].Selected ? "V" : "";
clienteDetalle.VISIT_FRECUENCY = UiListaCheckFrecuenciaVisita.Items[0].Selected ? "L" : "";
clienteDetalle.VISIT_FRECUENCY += UiListaCheckFrecuenciaVisita.Items[1].Selected ? "M" : "";
clienteDetalle.VISIT_FRECUENCY += UiListaCheckFrecuenciaVisita.Items[2].Selected ? "R" : "";
clienteDetalle.VISIT_FRECUENCY += UiListaCheckFrecuenciaVisita.Items[3].Selected ? "J" : "";
clienteDetalle.VISIT_FRECUENCY += UiListaCheckFrecuenciaVisita.Items[4].Selected ? "V" : "";
clienteDetalle.TIME_DELIVER_DAYS = Int16.Parse(UiSpinTiempoEntrega.Value.ToString());
clienteDetalle.BRANCH = UiTextoRamo.Text;
clienteDetalle.SERVICE_WINDOW = UiTextoVentaServicio.Text;
clienteDetalle.SALE_POINT_COMPLEMENT_DIRECTION = UiDireccionPuntoVenta.Text;
clienteDetalle.INVOICE_ADRESS_COMPLEMENT = UiDireccionFacturacion.Text;
clienteDetalle.DEPARTMENT = UiListaDepartamentos.Value?.ToString() ?? "";
clienteDetalle.MUNICIPALITY = UiListaMunicipio.Value?.ToString() ?? "";
clienteDetalle.CREDIT_LIMIT = UiSpinLimiteCredito.Number;
clienteDetalle.CODE_BUSINESS_GYRE = UiTextoCodigoGiroNegocio.Text;
clienteDetalle.BUSINESS_GYRE_DENOMINATION = UiTextoDenominacionGiroNegocio.Text;
clienteDetalle.CREDIT_CONTROL_AREA = UiTextoAreaControlNegocio.Text;
clienteDetalle.FORM_PAY_AUTHORIZATION = UiTextoFormaPagoAutorizada.Text;
clienteDetalle.CURRENCY = UiListaMoneda.Value?.ToString() ?? "";
clienteDetalle.ASSOCIATED_ACCOUNTANT_CREDIT_COUNT = UiTextoCuentaContableCreditoAsociada.Text;
clienteDetalle.PAY_CONDITION = UiListaCondicionPago.Value?.ToString() ?? "";
clienteDetalle.CREDIT_BLOCKADE = UiCheckBloqueoCredito.Checked ? "1" : "0";
clienteDetalle.LAST_UPDATED_BY = Session["USER"].ToString();
clienteDetalle.COMMENTS = UiMemoObservaciones.Text;
UsuarioDeseaGuardarDatosAdicionalesDeScouting?.Invoke(sender, new ScoutingArgumento {
ClienteDetalle = clienteDetalle, Cliente = cliente
});
}
/// <summary>
/// Actualiza la informacion del cliente
/// </summary>
/// <param name="idCliente">Identificador del cliente</param>
/// <param name="cliente">Objeto con la informacion del cliente</param>
/// <returns></returns>
public async Task <(bool, string)> AtualziarClienteAsync(Guid idCliente, ClienteDetalle cliente)
{
var(statusCode, resultado) = await ClientesApi.ActualziarClienteAsync(idCliente, cliente);
if (statusCode == HttpStatusCode.OK && !string.IsNullOrEmpty(resultado.ESTATUS) && resultado.ESTATUS.Equals("OK"))
{
return(true, "Datos actualizados correctamente");
}
else
{
return(false, "Ocurrio un problema al actualizar la informacion, intente más tarde");
}
}
public ActionResult Edit(Cliente cliente, string dtDetalle)
{
if (ModelState.IsValid)
{
db.Entry(cliente).State = EntityState.Modified;
List <ClienteDetalle> detalle = db.ClienteDetalle.Where(x => x.ClienteID == cliente.ClienteId).ToList();
if (detalle.Count != 0)
{
for (int i = 0; i < detalle.Count; i++)
{
db.ClienteDetalle.Remove(detalle[i]);
db.SaveChanges();
}
}
if (!string.IsNullOrEmpty(dtDetalle))
{
List <ClienteDetalle> jarray = JsonConvert.DeserializeObject <List <ClienteDetalle> >(dtDetalle);
foreach (var item in jarray)
{
int?idHeader = String.IsNullOrEmpty(db.ClienteDetalle.Max(u => (int?)u.detalleClienteID).ToString()) ? 1 : db.ClienteDetalle.Max(u => (int?)u.detalleClienteID).Value + 1;
var detalles = new ClienteDetalle()
{
ClienteID = cliente.ClienteId,
detalleClienteID = int.Parse(idHeader.ToString()),
Nombre = item.Nombre,
Parentezco = item.Parentezco,
OtrosDatos = item.OtrosDatos
};
db.ClienteDetalle.Add(detalles);
db.SaveChanges();
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PlanId = new SelectList(db.Plans, "PlanId", "descripcion", cliente.PlanId);
ViewBag.SucursalId = new SelectList(db.Sucursals, "SucursalId", "Nombre", cliente.SucursalId);
return(View(cliente));
}
/// <summary>
/// Guarda la informacion de un Scouting
/// </summary>
/// <param name="cliente"></param>
/// <returns></returns>
public Operacion Guardar(ClienteDetalle cliente)
{
BaseDeDatosServicio.BeginTransaction();
try
{
DbParameter[] parameters =
{
new OAParameter
{
ParameterName = "@CUSTOMER",
Value = cliente.CUSTOMER
},
new OAParameter
{
ParameterName = "@SALE_ROUTE",
Value = cliente.SALE_ROUTE
},
new OAParameter
{
ParameterName = "@REFERENCE_CBC",
Value = cliente.REFERENCE_CBC
},
new OAParameter
{
ParameterName = "@VISIT_DAY",
Value = cliente.VISIT_DAY
},
new OAParameter
{
ParameterName = "@VISIT_FRECUENCY",
Value = cliente.VISIT_FRECUENCY
},
new OAParameter
{
ParameterName = "@TIME_DELIVER_DAYS",
Value = cliente.TIME_DELIVER_DAYS
},
new OAParameter
{
ParameterName = "@BRANCH",
Value = cliente.BRANCH
},
new OAParameter
{
ParameterName = "@SERVICE_WINDOW",
Value = cliente.SERVICE_WINDOW
},
new OAParameter
{
ParameterName = "@SALE_POINT_COMPLEMENT_DIRECTIONC",
Value = cliente.SALE_POINT_COMPLEMENT_DIRECTION
},
new OAParameter
{
ParameterName = "@INVOICE_ADRESS_COMPLEMENT",
Value = cliente.INVOICE_ADRESS_COMPLEMENT
},
new OAParameter
{
ParameterName = "@MUNICIPALITY",
Value = cliente.MUNICIPALITY
},
new OAParameter
{
ParameterName = "@DEPARTMENT",
Value = cliente.DEPARTMENT
},
new OAParameter
{
ParameterName = "@CREDIT_LIMIT",
Value = cliente.CREDIT_LIMIT
},
new OAParameter
{
ParameterName = "@CODE_BUSINESS_GYRE",
Value = cliente.CODE_BUSINESS_GYRE
},
new OAParameter
{
ParameterName = "@BUSINESS_GYRE_DENOMINATION",
Value = cliente.BUSINESS_GYRE_DENOMINATION
},
new OAParameter
{
ParameterName = "@CREDIT_CONTROL_AREA",
Value = cliente.CREDIT_CONTROL_AREA
},
new OAParameter
{
ParameterName = "@FORM_PAY_AUTHORIZATION",
Value = cliente.FORM_PAY_AUTHORIZATION
},
new OAParameter
{
ParameterName = "@CURRENCY",
Value = cliente.CURRENCY
},
new OAParameter
{
ParameterName = "@ASSOCIATED_ACCOUNTANT_CREDIT_COUNT",
Value = cliente.ASSOCIATED_ACCOUNTANT_CREDIT_COUNT
},
new OAParameter
{
ParameterName = "@PAY_CONDITION",
Value = cliente.PAY_CONDITION
},
new OAParameter
{
ParameterName = "@CREDIT_BLOCKADE",
Value = cliente.CREDIT_BLOCKADE
},
new OAParameter
{
ParameterName = "@LAST_UPDATED_BY",
Value = cliente.LAST_UPDATED_BY
},
new OAParameter
{
ParameterName = "@COMMENTS",
Value = cliente.COMMENTS
}
};
var op = BaseDeDatosServicio.ExecuteQuery <Operacion>("SWIFT_SP_INSERT_CUSTOMER_NEW_DETAIL", CommandType.StoredProcedure, parameters).ToList()[0];
BaseDeDatosServicio.Commit();
return(op);
}
catch (DbException e)
{
BaseDeDatosServicio.Rollback();
return(new Operacion
{
Codigo = e.ErrorCode,
Mensaje = e.Message,
Resultado = Tipos.ResultadoOperacionTipo.Error
});
}
catch (Exception ex)
{
BaseDeDatosServicio.Rollback();
return(new Operacion
{
Codigo = -1,
Mensaje = ex.Message,
Resultado = ResultadoOperacionTipo.Error
});
}
}
