public void SendEmailSolicitante(client cliente)
{
var configurations = (from c in sql.configurations
select c).First();
if ((Boolean)configurations.smtp_enabled)
{
if (cliente.status.Contains("FINISHED") || cliente.status.Contains("DESAPPROVED"))
{
try
{
MailMessage Email = new MailMessage();
Email.To.Add(cliente.solicitante);
HttpContext _context = System.Web.HttpContext.Current;
String body = getHtmlFromTemplate(_context.Server.MapPath("/") + "/Views/templates/template_solicitante.htm");
body = body.Replace("{CLIENT_NAME}", cliente.razon_social);
if (cliente.status.Contains("DESAPPROVED"))
{
body = body.Replace("{CLIENT_STATUS}", "fué rechazada.<br/>Observació: " + cliente.observacion_desapproved);
Email.Subject = "Clientes Abbottlab - ALTA RECHAZADA";
}
else
{
body = body.Replace("{CLIENT_STATUS}", "fué aprovada rechazada.");
Email.Subject = "Clientes Abbottlab - ALTA SATISFACTORIA FINALIZADA";
}
Email.Body = body;
Email.From = new MailAddress(configurations.smtp_from);
Email.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = configurations.smtp_host;
smtp.Send(Email);
}
catch (Exception ex)
{
ReportError(ex.ToString());
}
}
}
}
private void detach_clients(client entity)
{
this.SendPropertyChanging();
entity.term = null;
}
public void SendEmail(String role, String division, String fileTemplate, String subject, client cliente)
{
var configurations = (from c in sql.configurations
select c).First();
if ((Boolean)configurations.smtp_enabled)
{
try
{
IQueryable<user> users;
if (role != "DISTRIBUCION" && role != "REGULATORIOS")
{
users = (from u in sql.users
where u.role == role
select u);
}
else
{
users = (from u in sql.users
where u.role == role && (u.division.Contains(division) || u.division == null)
select u);
}
MailMessage Email = new MailMessage();
if (users.Count() > 0)
{
foreach (user userEmail in users)
{
if (!String.IsNullOrEmpty(userEmail.email))
{
Email.To.Add(userEmail.email);
}
}
HttpContext _context = System.Web.HttpContext.Current;
String body = getHtmlFromTemplate(_context.Server.MapPath("/") + "/Views/templates/template_" + fileTemplate + ".htm");
body = body.Replace("{CLIENT_NAME}", cliente.razon_social);
if (cliente.status.Contains("DESAPPROVED"))
{
body = body.Replace("{CLIENT_STATUS}", "rechazado");
}
else if (cliente.status.Contains("APPROVED"))
{
body = body.Replace("{CLIENT_STATUS}", "aprobado");
}
Email.Subject = subject;
Email.Body = body;
Email.From = new MailAddress(configurations.smtp_from);
Email.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = configurations.smtp_host;
//smtp.Port = Convert.ToInt32(configurations.smtp_port);
smtp.Send(Email);
}
}
catch(Exception ex)
{
ReportError(ex.ToString());
}
}
}
partial void Deleteclient(client instance);
private void attach_clients(client entity)
{
this.SendPropertyChanging();
entity.term = this;
}
partial void Insertclient(client instance);
partial void Updateclient(client instance);
private void attach_clients(client entity)
{
this.SendPropertyChanging();
entity.division1 = this;
}
private void detach_clients(client entity)
{
this.SendPropertyChanging();
entity.warehouse1 = null;
}
private void attach_clients(client entity)
{
this.SendPropertyChanging();
entity.warehouse1 = this;
}
public ActionResult Edit(client clientEdited)
{
user userSession = (user)Session["user"];
if (Request.Files["documentacion_impositiva"] != null)
{
HttpPostedFileBase file = Request.Files["documentacion_impositiva"];
if (file.ContentLength > 0)
{
string fileName = DateTime.Now.Ticks.ToString() + "_" + Path.GetFileName(file.FileName);
string filePath = Path.Combine(HttpContext.Server.MapPath("/Uploads"), fileName);
file.SaveAs(filePath);
clientEdited.documentacion_impositiva = fileName;
}
}
if (!(clientEdited.id > 0))
{
if (Request.Form["client_type"] == "entity")
{
clientEdited.client_parent = null;
}
else
{
clientEdited.client_parent = Convert.ToInt64(Request.Form["clientParent"]);
}
sql.clients.InsertOnSubmit(clientEdited);
}
else
{
var clientEdit = (from c in sql.clients
where c.id == Convert.ToInt64(Request.Form["id"])
select c).First();
clientEdit.limite_credito = clientEdited.limite_credito;
clientEdit.moneda = clientEdited.moneda;
clientEdit.calle_nro = clientEdited.calle_nro;
clientEdit.codigo_abc = clientEdited.codigo_abc;
clientEdit.codigo_comision = clientEdited.codigo_comision;
clientEdit.codigo_descuento = clientEdited.codigo_descuento;
clientEdit.codigo_grupo1 = clientEdited.codigo_grupo1;
clientEdit.codigo_grupo2 = clientEdited.codigo_grupo2;
clientEdit.codigo_postal = clientEdited.codigo_postal;
clientEdit.codigo_region = clientEdited.codigo_region;
clientEdit.codigo_sucursal = clientEdited.codigo_sucursal;
clientEdit.codigo_venta = clientEdited.codigo_venta;
clientEdit.compania = clientEdited.compania;
clientEdit.condicion_venta = clientEdited.condicion_venta;
clientEdit.dias_credito = clientEdited.dias_credito;
clientEdit.division = clientEdited.division;
clientEdit.email_2_cobranzas = clientEdited.email_2_cobranzas;
clientEdit.email_cobranzas = clientEdited.email_cobranzas;
clientEdit.email_otro = clientEdited.email_otro;
clientEdit.empresa_cobranza = clientEdited.empresa_cobranza;
clientEdit.estado_cuenta = clientEdited.estado_cuenta;
clientEdit.exento_impuestos = clientEdited.exento_impuestos;
clientEdit.forma_pago = clientEdited.forma_pago;
clientEdit.nro_consolidador = clientEdited.nro_consolidador;
clientEdit.nro_cuit = clientEdited.nro_cuit;
clientEdit.nro_iibb = clientEdited.nro_iibb;
clientEdit.observacion_razon_social = clientEdited.observacion_razon_social;
clientEdit.politica_falta_producto = clientEdited.politica_falta_producto;
clientEdit.provincia = clientEdited.provincia;
clientEdit.razon_social = clientEdited.razon_social;
clientEdit.responsable_cuenta = clientEdited.responsable_cuenta;
clientEdit.tax_code = clientEdited.tax_code;
clientEdit.telefono = clientEdited.telefono;
clientEdit.terms_code = clientEdited.terms_code;
clientEdit.via_despacho = clientEdited.via_despacho;
clientEdit.warehouse = clientEdited.warehouse;
clientEdit.zona_reparto = clientEdited.zona_reparto;
clientEdit.solicitante = clientEdited.solicitante;
clientEdit.contacto_comercial = clientEdited.contacto_comercial;
clientEdit.participe = clientEdited.participe;
clientEdit.codigo_gln = clientEdited.codigo_gln;
clientEdit.pais = clientEdited.pais;
clientEdit.client_type = (String.IsNullOrEmpty(Request["tipo_cliente"]) ? null : (from ct in sql.client_types where ct.type == Convert.ToInt16(Request["tipo_cliente"]) select ct).Single());
if (!String.IsNullOrEmpty(clientEdited.documentacion_impositiva))
{
clientEdit.documentacion_impositiva = clientEdited.documentacion_impositiva;
}
switch (userSession.role)
{
case "COMERCIAL":
clientEdit.observaciones_comercial = clientEdited.observaciones_comercial;
break;
case "DISTRIBUCION":
clientEdit.observaciones_distribucion = clientEdited.observaciones_distribucion;
break;
case "REGULATORIOS":
clientEdit.observaciones_regulatorios = clientEdited.observaciones_regulatorios;
break;
case "IMPUESTOS":
clientEdit.observaciones_impuestos = clientEdited.observaciones_impuestos;
break;
case "BEX":
clientEdit.observaciones_bex = clientEdited.observaciones_bex;
break;
}
}
sql.SubmitChanges();
return Approve(clientEdited.id.ToString());
}
public String getHtmlInfo(client clientData, String status)
{
StringBuilder sb = new StringBuilder();
sb.Append("<tr><td colspan='6' style='border-bottom:1px solid #999;'> </td></tr>");
sb.Append("<tr><td colspan='6'><strong>DATOS DEL CLIENTE:</strong></td></tr>");
sb.Append("<tr><td colspan='6'> </td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Razón Social:</strong></td><td colspan='5' style='text-align:left;'>" + clientData.razon_social + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Observaciones razón social:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.observacion_razon_social) ? "-" : clientData.observacion_razon_social) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Calle y nro:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.calle_nro) ? "-" : clientData.calle_nro.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Provincia/País:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.provincia) ? "-" : clientData.provincia.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Código postal:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.codigo_postal) ? "-" : clientData.codigo_postal.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Código país:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.pais) ? "-" : clientData.pais.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Código provincia/sucursal:</strong></td><td colspan='5' style='text-align:left;'>" + clientData.codigo_sucursal + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Teléfono:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.telefono) ? "-" : clientData.telefono.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Email ventas:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.email_cobranzas) ? "-" : clientData.email_cobranzas) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Email 2 cobranzas:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.email_2_cobranzas) ? "-" : clientData.email_2_cobranzas) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Email 3 otros:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.email_otro) ? "-" : clientData.email_otro) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Código ABC:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.codigo_abc) ? "-" : clientData.codigo_abc.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Días crédito:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.dias_credito) ? "-" : clientData.dias_credito.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Estado de cuenta:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.estado_cuenta) ? "-" : clientData.estado_cuenta.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Límite de crédito:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.limite_credito) ? "-" : clientData.limite_credito.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Compañia:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.compania) ? "-" : clientData.compania.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Moneda:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.moneda) ? "-" : clientData.moneda.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Tipo de cliente:</strong></td><td colspan='5' style='text-align:left;'>" + clientData.client_type.description + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Nro. consolidador:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.nro_consolidador) ? "-" : clientData.nro_consolidador.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Código comisión:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.codigo_comision) ? "-" : clientData.codigo_comision.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Warehouse:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.warehouse) ? "-" : clientData.warehouse1.description.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Polit. falta de prod.:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.politica_falta_producto) ? "-" : clientData.politica_falta_producto.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Responsable de cuenta:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.responsable_cuenta) ? "-" : clientData.responsable_cuenta.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Código descuento:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.codigo_descuento) ? "-" : clientData.codigo_descuento.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Condición de venta:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.condicion_venta) ? "-" : clientData.condicion_venta.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>División:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.division) ? "-" : clientData.division.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Forma de pago:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.forma_pago) ? "-" : clientData.forma_pago.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Código región:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.codigo_region) ? "-" : clientData.codigo_region.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Código grupo 1:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.codigo_grupo1) ? "-" : clientData.codigo_grupo1.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Código grupo 2:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.codigo_grupo2) ? "-" : clientData.codigo_grupo2.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Terms code:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.terms_code) ? "-" : clientData.term.description.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Empresa de cobranza:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.empresa_cobranza) ? "-" : clientData.empresa_cobranza.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Nro. de CUIT:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.nro_cuit) ? "-" : clientData.nro_cuit.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Tax code:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.tax_code) ? "-" : clientData.tax_code.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Exento de impuestos:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.exento_impuestos) ? "-" : clientData.exento_impuestos.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Nro. IIBB:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.nro_iibb) ? "-" : clientData.nro_iibb.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Zona de reparto:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.zona_reparto) ? "-" : clientData.zona_reparto.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Via despacho:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.via_despacho) ? "-" : clientData.via_despacho.ToUpper()) + "<br/></td></tr>");
sb.Append("<tr><td style='text-align:left;'><strong>Código GLN:</strong></td><td colspan='5' style='text-align:left;'>" + (String.IsNullOrEmpty(clientData.codigo_gln) ? "-" : clientData.codigo_gln.ToUpper()) + "<br/></td></tr>");
if (!String.IsNullOrEmpty(clientData.observaciones_comercial))
{
sb.Append("<tr><td style='text-align:left;'><strong>Observaciones Créditos:</strong></td><td colspan='5' style='text-align:left;'>" + clientData.observaciones_comercial + "<br/></td></tr>");
}
if (!String.IsNullOrEmpty(clientData.observaciones_regulatorios))
{
sb.Append("<tr><td style='text-align:left;'><strong>Observaciones Regulatorios:</strong></td><td colspan='5' style='text-align:left;'>" + clientData.observaciones_regulatorios + "<br/></td></tr>");
}
if (!String.IsNullOrEmpty(clientData.observaciones_impuestos))
{
sb.Append("<tr><td style='text-align:left;'><strong>Observaciones Impuestos:</strong></td><td colspan='5' style='text-align:left;'>" + clientData.observaciones_impuestos + "<br/></td></tr>");
}
if (!String.IsNullOrEmpty(clientData.observaciones_distribucion))
{
sb.Append("<tr><td style='text-align:left;'><strong>Observaciones Créditos:</strong></td><td colspan='5' style='text-align:left;'>" + clientData.observaciones_distribucion + "<br/></td></tr>");
}
if (!String.IsNullOrEmpty(clientData.observaciones_bex))
{
sb.Append("<tr><td style='text-align:left;'><strong>Observaciones Compliance:</strong></td><td colspan='5' style='text-align:left;'>" + clientData.observaciones_bex + "<br/></td></tr>");
}
if (!String.IsNullOrEmpty(clientData.observacion_desapproved) && status == "DESAPPROVED")
{
sb.Append("<tr><td style='text-align:left;'><strong>Observaciones de desaprovación:</strong></td><td colspan='5' style='text-align:left;'>" + clientData.observacion_desapproved + "<br/></td></tr>");
}
sb.Append("<tr><td colspan='6'> </td></tr>");
sb.Append("<tr><td colspan='6'><strong>PARTICIPANTES:</strong></td></tr>");
sb.Append("<tr><td colspan='6'> </td></tr>");
return sb.ToString();
}