public static MessageCustom DeletedServiceOrderDetail(string serviceOrderDetail, int userId)
{
MessageCustom msg = new MessageCustom();
var ok = ServiceOrderDal.DeletedServiceOrderDetail(serviceOrderDetail, userId);
if (!ok)
{
msg.Error = true;
msg.Message = "Sucedió un error al eliminar el detalle, por favor vuelva intentar.";
msg.Status = (int)HttpStatusCode.Conflict;
}
else
{
msg.Error = false;
msg.Message = "Se eliminó correctamente.";
msg.Status = (int)HttpStatusCode.OK;
}
return(msg);
}
public static MessageCustom AddServiceOrder(BoardServiceOrder data, int userId, int nodeId)
{
MessageCustom msg = new MessageCustom();
try
{
using (var ts = new TransactionScope())
{
#region Entities
ServiceOrderBE oServiceOrderBE = new ServiceOrderBE();
oServiceOrderBE.v_ServiceOrderId = data.EntityserviceOrder.v_ServiceOrderId;
oServiceOrderBE.v_CustomServiceOrderId = data.EntityserviceOrder.v_CustomServiceOrderId;
oServiceOrderBE.v_Description = data.EntityserviceOrder.v_Description;
oServiceOrderBE.v_Comentary = data.EntityserviceOrder.v_Comentary;
oServiceOrderBE.i_NumberOfWorker = data.EntityserviceOrder.i_NumberOfWorker;
oServiceOrderBE.r_TotalCost = data.EntityserviceOrder.r_TotalCost;
oServiceOrderBE.d_DeliveryDate = data.EntityserviceOrder.d_DeliveryDate;
oServiceOrderBE.i_ServiceOrderStatusId = data.EntityserviceOrder.i_ServiceOrderStatusId;
oServiceOrderBE.i_LineaCreditoId = data.EntityserviceOrder.i_LineaCreditoId;
oServiceOrderBE.i_MostrarPrecio = data.EntityserviceOrder.i_MostrarPrecio;
oServiceOrderBE.i_EsProtocoloEspecial = data.EntityserviceOrder.i_EsProtocoloEspecial;
List <ServiceOrderDetailBE> ListServiceOrderDetailBE = new List <ServiceOrderDetailBE>();
var iter = 0;
foreach (var obj in data.ListEntityServiceOrder)
{
iter++;
ProtocolList _prot = new ProtocolList();
_prot.v_ProtocolId = obj.v_ProtocolId;
bool existName = true;
while (existName)
{
_prot.v_Name = data.EntityserviceOrder.v_OrganizationName + "-" + obj.v_ProtocolTypeName + "-" + iter + "-" + obj.v_GesoName;
MessageCustom resultVerify = ProtocolDal.VerifyExistsProtocol(_prot.v_Name);
if (resultVerify.Id == null)
{
existName = false;
}
else
{
iter++;
}
}
_prot.v_CustomerOrganizationId = data.EntityserviceOrder.v_OrganizationId + "|" + data.EntityserviceOrder.v_LocationId;
_prot.v_IntermediaryOrganization = data.EntityserviceOrder.v_OrganizationId + "|" + data.EntityserviceOrder.v_LocationId;
_prot.v_WorkingOrganizationId = data.EntityserviceOrder.v_OrganizationId + "|" + data.EntityserviceOrder.v_LocationId;
_prot.v_Geso = obj.v_GroupOccupationId;
_prot.i_IsActive = 1;
_prot.i_EsoTypeId = obj.i_ProtocolType;
_prot.i_ServiceTypeId = 1; //Empresarial
_prot.i_MasterServiceId = 2; //Examen de salud ocupacional
_prot.ListComponents = obj.ProtocolComponents;
var result = ProtocolBL.SaveProtocols(_prot, userId, nodeId);
if (result.Error)
{
throw new Exception(result.Message);
}
obj.v_ProtocolId = result.Id;
ServiceOrderDetailBE oServiceOrderDetailBE = new ServiceOrderDetailBE();
oServiceOrderDetailBE.v_ServiceOrderDetailId = obj.v_ServiceOrderDetailId;
oServiceOrderDetailBE.v_ServiceOrderId = obj.v_ServiceOrderId;
oServiceOrderDetailBE.v_ProtocolId = obj.v_ProtocolId;
oServiceOrderDetailBE.r_ProtocolPrice = obj.r_ProtocolPrice;
oServiceOrderDetailBE.i_NumberOfWorkerProtocol = obj.i_NumberOfWorkerProtocol;
oServiceOrderDetailBE.r_Total = obj.r_Total;
ListServiceOrderDetailBE.Add(oServiceOrderDetailBE);
}
#endregion
string ServiceOrderId = ServiceOrderDal.AddServiceOrder(oServiceOrderBE, ListServiceOrderDetailBE, userId, nodeId);
msg.Error = false;
msg.Id = ServiceOrderId ?? throw new Exception("Sucedió un error al grabar las ordenes, por favor actualice y vuelva a intentar.");
msg.Message = "Se guardó correctamente.";
msg.Status = (int)HttpStatusCode.Created;
ts.Complete();
return(msg);
}
}
catch (Exception ex)
{
msg.Message = ex.Message;
msg.Error = true;
msg.Status = (int)HttpStatusCode.Conflict;
return(msg);
}
}
public static List <ServiceOrderDetailCustom> GetServicesOrderDetail(string serviceOrderId)
{
return(ServiceOrderDal.GetServicesOrderDetail(serviceOrderId));
}
public static MessageCustom SendEmail(EmailModel model)
{
MessageCustom msg = new MessageCustom();
try
{
List <string> ListPath = new List <string>();
var MedicalCenter = new ServiceDal().GetInfoMedicalCenter();
var ServiceOrder = ServiceOrderDal.GetOrganizationByServiceOrderId(model.ServiceOrderId);
var ListServiceOrderDetail = ServiceOrderDal.GetServicesOrderDetail(model.ServiceOrderId);
var ruta = HttpContext.Current.Server.MapPath("~/" + System.Configuration.ConfigurationManager.AppSettings["rutaReporteServiceOrder"]);
var pathFile = string.Format("{0}.pdf", Path.Combine(ruta, model.ServiceOrderId + "-" + "Report"));
if (model.TypeEmail == (int)TypeEmail.Ordenservicio)//OrdenServicio
{
var result = Report_ServiceOrderConsolidate.GenerateOrderService(ListServiceOrderDetail, MedicalCenter, ServiceOrder, pathFile);
if (!result)
{
throw new Exception("Sucedió un error generando el reporte, por favor vuelva a intentar");
}
ListPath.Add(pathFile);
}
else
{
var result = Report_ServiceOrderConsolidate.GenerateCotizacion(ListServiceOrderDetail, MedicalCenter, ServiceOrder, pathFile);
if (!result)
{
throw new Exception("Sucedió un error generando el reporte, por favor vuelva a intentar");
}
ListPath.Add(pathFile);
}
using (MailMessage mm = new MailMessage("*****@*****.**", model.To))
{
mm.Subject = model.Subject;
mm.Body = model.Body;
foreach (var path in ListPath)
{
mm.Attachments.Add(new Attachment(path));
}
mm.IsBodyHtml = false;
using (SmtpClient smtp = new SmtpClient())
{
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", "74390363991646704");
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
smtp.Send(mm);
}
}
msg.Error = false;
msg.Status = (int)HttpStatusCode.OK;
msg.Message = "El mensaje se envió correctamente";
return(msg);
}
catch (Exception ex)
{
msg.Error = false;
msg.Status = (int)HttpStatusCode.OK;
msg.Message = ex.Message;
return(msg);
}
}
