private void iniChart(AriClinicContext ctx1)
{
ctx1 = new AriClinicContext("AriClinicContext");
IList <Professional> prof = ctx1.Professionals.ToList <Professional>();
chart1.PlotArea.XAxis.AutoScale = true;
chart1.PlotArea.XAxis.Items.Clear();
chart1.AutoLayout = true;
chart1.ChartTitle.TextBlock.Visible = false;//.Text = "Servicios por profesional.";
chart1.PlotArea.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Solid;
chart1.PlotArea.Appearance.FillStyle.MainColor = Color.Transparent;
ChartSeries chartSeries1 = new ChartSeries();
chartSeries1.Type = ChartSeriesType.Pie;
chartSeries1.Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.ItemLabels;
foreach (Professional item in prof)
{
ChartSeriesItem serieItem = new ChartSeriesItem();
int num = (from inv in item.ProfessionalInvoices
where inv.InvoiceDate >= fromDate && inv.InvoiceDate <= toDate
select inv).ToList <ProfessionalInvoice>().Count();
if (num > 0)
{
serieItem.YValue = num;
serieItem.Name = item.FullName;
serieItem.Label.TextBlock.Text = num.ToString();
serieItem.Appearance.Exploded = true;
chartSeries1.Items.Add(serieItem);
}
}
chart1.Series.Clear();
chart1.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] { chartSeries1 });
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = CntAriCli.GetUser((Session["User"] as User).UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "scat"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
}
// cheks if is call from another form
if (Request.QueryString["Type"] != null)
{
type = Request.QueryString["Type"];
}
// read patient information
if (Request.QueryString["CustomerId"] != null)
{
customerId = Int32.Parse(Request.QueryString["CustomerId"]);
cus = CntAriCli.GetCustomer(customerId, ctx);
lblTitle.Text = String.Format("Historial administrativo: {0}", cus.FullName);
this.Title = String.Format("Historial administrativo: {0}", cus.FullName);
}
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = CntAriCli.GetUser((Session["User"] as User).UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "professional"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["ProfessionalId"] != null)
{
professionalId = Int32.Parse(Request.QueryString["ProfessionalId"]);
prof = CntAriCli.GetProfessional(professionalId, ctx);
LoadData(prof);
}
else
{
LoadUserCombo(null);
LoadTypeCombo(null);
LoadTaxWithholdingTypeCombo(null);
}
}
private void iniChart(AriClinicContext ctx1)
{
ctx1 = new AriClinicContext("AriClinicContext");
IList <Invoice> invoices = CntAriCli.GetInvoices(fromDate, toDate, ctx1);
chart1.PlotArea.XAxis.AutoScale = true;
chart1.PlotArea.XAxis.Items.Clear();
chart1.AutoLayout = true;
chart1.ChartTitle.TextBlock.Visible = false;
chart1.PlotArea.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Solid;
//chart1.PlotArea.Appearance.FillStyle.MainColor = Color.Transparent;
ChartSeries chartSeries1 = new ChartSeries();
chartSeries1.Type = ChartSeriesType.Bar;
chartSeries1.Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.ItemLabels;
ChartSeriesItem serieItem = new ChartSeriesItem();
var rs = from inv in (List <Invoice>)invoices
where inv.InvoiceDate >= fromDate && inv.InvoiceDate <= toDate
group inv by new { inv.InvoiceDate.Year, inv.InvoiceDate.Month } into g
select new { Datos = g.Key, Total = g.Sum(inv => inv.Total) };
foreach (var item in rs)
{
serieItem.YValue = (double)item.Total;
serieItem.Name = item.Datos.Month + "/" + item.Datos.Year;
serieItem.Label.TextBlock.Text = item.Total.ToString();
serieItem.Appearance.Exploded = true;
chartSeries1.Items.Add(serieItem);
}
chart1.Series.Clear();
chart1.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] { chartSeries1 });
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = CntAriCli.GetUser((Session["User"] as User).UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "ser"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["InsuranceId"] != null)
{
insuranceId = Int32.Parse(Request.QueryString["InsuranceId"]);
ins = CntAriCli.GetInsurance(insuranceId, ctx);
txtInsurance.Text = ins.Name;
}
//
if (Request.QueryString["InsuranceServiceId"] != null)
{
insuranceServiceId = Int32.Parse(Request.QueryString["InsuranceServiceId"]);
inser = CntAriCli.GetInsuranceService(insuranceServiceId, ctx);
LoadData(inser);
}
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = CntAriCli.GetUser((Session["User"] as User).UserId, ctx);
user = CntAriCli.GetUser(user.UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "agenda"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
}
// cheks if is call from another form
if (Request.QueryString["Type"] != null)
{
type = Request.QueryString["Type"];
}
// translate filters
CntWeb.TranslateRadGridFilters(RadGrid1);
}
private static void FixAnestheticNotes(AriClinicContext ctx)
{
foreach (AnestheticServiceNote asn in ctx.AnestheticServiceNotes)
{
CntAriCli.CheckAnestheticServiceNoteTickets(asn, ctx);
}
}
private void HealthcareCompanyData(AriClinicContext ctx1)
{
HealthcareCompany healthcare = CntAriCli.GetHealthCompany(ctx1);
companyname = healthcare.Name;
foreach (Address item in healthcare.Addresses)
{
if (item.Type == "Primary")
{
companyaddress = item;
}
}
foreach (Telephone item in healthcare.Telephones)
{
if (item.Type == "Primary")
{
companytelf = item;
}
}
foreach (Email item in healthcare.Emails)
{
if (item.Type == "Primary")
{
companyemail = item;
}
}
companynif = healthcare.VATIN;
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = CntAriCli.GetUser((Session["User"] as User).UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "user"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
// special for this form
ddlGroup.Enabled = per.Create;
}
//
if (Request.QueryString["UserId"] != null)
{
userId = Int32.Parse(Request.QueryString["UserId"]);
User usr = (from u in ctx.Users
where u.UserId == userId
select u).FirstOrDefault <User>();
LoadData(usr);
}
else
{
LoadGroupCombo(null);
LoadBaseVisitType(null);
}
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = CntAriCli.GetUser((Session["User"] as User).UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "usergroup"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["HcId"] != null)
{
hcID = Int32.Parse(Request.QueryString["HcId"]);
HealthcareCompany hc = CntAriCli.GetHealthCompany(ctx);
LoadData(hc);
}
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = CntAriCli.GetUser((Session["User"] as User).UserId, ctx);
user = CntAriCli.GetUser(user.UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "apptype"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
if (Request.QueryString["AppointmentTypeId"] != null)
{
appTypeId = int.Parse(Request.QueryString["AppointmentTypeId"]);
apptype = CntAriCli.GetAppointmentType(appTypeId, ctx);
}
LoadData(apptype);
}
public RptTicket(int idticket, AriClinicContext ctx1)
: this()
{
ctx1 = new AriClinicContext("AriClinicContext");
companyname = CntAriCli.GetHealthCompany(ctx1).Name;
this.DataSource = CntAriCli.GetTicket(idticket, ctx1);
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = (User)Session["User"];
user = CntAriCli.GetUser(user.UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "examination"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["ExaminationId"] != null)
{
examinationId = Int32.Parse(Request.QueryString["ExaminationId"]);
examination = CntAriCli.GetExamination(examinationId, ctx);
LoadData(examination);
}
LoadExaminationTypeCombo(examination);
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = CntAriCli.GetUser((Session["User"] as User).UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "ins"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
}
if (Request.QueryString["InsuranceId"] != null)
{
insuranceId = Int32.Parse(Request.QueryString["InsuranceId"]);
insurance = CntAriCli.GetInsurance(insuranceId, ctx);
string aux = String.Format("{0}: Servicios asignados", insurance.Name);
this.Title = aux;
lblTitle.Text = aux;
}
}
public RptTicketsNoPaid(DateTime fDate, DateTime tDate, int insuranceId, AriClinicContext ctx)
: this()
{
ctx = new AriClinicContext("AriClinicContext");
fromDate = fDate; toDate = tDate;
this.DataSource = CntAriCli.GetTickets(fDate, tDate, insuranceId, "NP", ctx);
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = (User)Session["User"];
user = CntAriCli.GetUser(user.UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "examinationassigned"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["CycloplegiaId"] != null)
{
id = Int32.Parse(Request.QueryString["CycloplegiaId"]);
Cycloplegia = CntAriCli.GetCycloplegia(id, ctx);
refractometry = Cycloplegia.Refractometry;
LoadData(Cycloplegia);
}
if (Request.QueryString["RefractometryId"] != null)
{
id = int.Parse(Request.QueryString["RefractometryId"]);
refractometry = (Refractometry)CntAriCli.GetExaminationAssigned(id, ctx);
}
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = CntAriCli.GetUser((Session["User"] as User).UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "scat"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
}
//cheks if is call from customer form tabs
if (type == "InTab")
{
HtmlControl tt = (HtmlControl)this.FindControl("TitleArea");
tt.Attributes["class"] = "ghost";
// hide patient column
RadGrid1.Columns.FindByDataField("Patient.FullName").Visible = false;
}
// cheks if is call from another form
if (Request.QueryString["Type"] != null)
{
type = Request.QueryString["Type"];
}
// translate filters
CntWeb.TranslateRadGridFilters(RadGrid1);
}
public RptPayments(DateTime fDate, DateTime tDate, int clinicId, AriClinicContext ctx)
: this()
{
ctx = new AriClinicContext("AriClinicContext");
fromDate = fDate; toDate = tDate;
this.DataSource = CntAriCli.GetPayments(fDate, tDate, clinicId, ctx);
}
private void iniChart(AriClinicContext ctx1)
{
ctx1 = new AriClinicContext("AriClinicContext");
IList <Professional> prof = CntAriCli.GetSurgeonTickets(fromDate, toDate, ctx1);
chart1.PlotArea.XAxis.AutoScale = true;
chart1.PlotArea.XAxis.Items.Clear();
chart1.AutoLayout = true;
chart1.ChartTitle.TextBlock.Visible = false;//.Text = "Servicios por profesional.";
chart1.PlotArea.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Solid;
chart1.PlotArea.Appearance.FillStyle.MainColor = Color.Transparent;
ChartSeries chartSeries1 = new ChartSeries();
chartSeries1.Type = ChartSeriesType.Pie;
chartSeries1.Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.ItemLabels;
foreach (Professional item in prof)
{
ChartSeriesItem serieItem = new ChartSeriesItem();
int num = CntAriCli.GetTicketsByCirujano(fromDate, toDate, item.PersonId.ToString(), ctx1).Count;
if (num > 0)
{
serieItem.YValue = num;
serieItem.Name = item.FullName;
serieItem.Label.TextBlock.Text = num.ToString();
serieItem.Appearance.Exploded = true;
chartSeries1.Items.Add(serieItem);
}
}
chart1.Series.Clear();
chart1.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] { chartSeries1 });
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = CntAriCli.GetUser((Session["User"] as User).UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "rtickets"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
}
// cheks if is call from another form
if (Request.QueryString["Report"] != null)
{
report = Request.QueryString["Report"];
}
if (Request.QueryString["FDate"] != null)
{
fDate = CntWeb.ParseUrlDate(Request.QueryString["FDate"]);
}
if (Request.QueryString["TDate"] != null)
{
tDate = CntWeb.ParseUrlDate(Request.QueryString["TDate"]);
}
if (Request.QueryString["Diary"] != null)
{
diary = CntAriCli.GetDiary(int.Parse(Request.QueryString["Diary"]), ctx);
}
if (Request.QueryString["Visit"] != null)
{
visit = CntAriCli.GetVisit(int.Parse(Request.QueryString["Visit"]), ctx);
}
if (Request.QueryString["Treatment"] != null)
{
treatment = CntAriCli.GetTreatment(int.Parse(Request.QueryString["Treatment"]), ctx);
}
if (Request.QueryString["Invoice"] != null)
{
invoice = CntAriCli.GetInvoice(int.Parse(Request.QueryString["Invoice"]), ctx);
}
if (Request.QueryString["AmendmentInvoice"] != null)
{
aInvoice = CntAriCli.GetAmendementInvoice(int.Parse(Request.QueryString["AmendmentInvoice"]), ctx);
}
if (Request.QueryString["PrescriptionGlasses"] != null)
{
prescriptionGlasses = CntAriCli.GetPrescriptionGlasses(int.Parse(Request.QueryString["PrescriptionGlasses"]), ctx);
}
if (Request.QueryString["Estimate"] != null)
{
estimate = CntAriCli.GetEstimate(int.Parse(Request.QueryString["Estimate"]), ctx);
}
}
public RptServCategory(DateTime fDate, DateTime tDate, AriClinicContext ctx1)
: this()
{
ctx1 = new AriClinicContext("AriClinicContext");
fromDate = fDate; toDate = tDate;
companyname = CntAriCli.GetHealthCompany(ctx1).Name;
this.DataSource = CntAriCli.GetTickets(fromDate, toDate, ctx1);
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
user = (User)Session["User"];
user = CntAriCli.GetUser(user.UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "examinationassigned"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["ExaminationAssignedId"] != null)
{
examinationAssignedId = Int32.Parse(Request.QueryString["ExaminationAssignedId"]);
paquimetry = (Paquimetry)CntAriCli.GetExaminationAssigned(examinationAssignedId, ctx);
LoadData(paquimetry);
}
else
{
rdpExaminationDate.SelectedDate = DateTime.Now;
}
//
if (Request.QueryString["PatientId"] != null)
{
patientId = int.Parse(Request.QueryString["PatientId"]);
patient = CntAriCli.GetPatient(patientId, ctx);
// fix rdc with patient
rdcPatient.Items.Clear();
rdcPatient.Items.Add(new RadComboBoxItem(patient.FullName, patient.PersonId.ToString()));
rdcPatient.SelectedValue = patient.PersonId.ToString();
rdcPatient.Enabled = false;
}
//
if (Request.QueryString["VisitId"] != null)
{
visitId = int.Parse(Request.QueryString["VisitId"]);
visit = CntAriCli.GetVisit(visitId, ctx);
patientId = visit.Patient.PersonId;
patient = CntAriCli.GetPatient(patientId, ctx);
// fix rdc with patient
rdcPatient.Items.Clear();
rdcPatient.Items.Add(new RadComboBoxItem(patient.FullName, patient.PersonId.ToString()));
rdcPatient.SelectedValue = patient.PersonId.ToString();
rdcPatient.Enabled = false;
//
rdpExaminationDate.SelectedDate = visit.VisitDate;
}
}
public RptNomenclator(AriClinicContext ctx1)
: this()
{
ctx1 = new AriClinicContext("AriClinicContext");
companyname = CntAriCli.GetHealthCompany(ctx1).Name;
IList <Procedure> listProc = (from p in ctx1.Procedures select p).ToList <Procedure>();
this.DataSource = listProc;
}
public RptParamTickets(DateTime fDate, DateTime tDate, AriClinicContext ctx1)
: this()
{
ctx1 = new AriClinicContext("AriClinicContext");
fromDate = fDate;
toDate = tDate;
iniChartWeekProfessional(ctx1);
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
if (Session["User"] == null)
{
Response.Redirect("Default.aspx");
}
User u = CntAriCli.GetUser((Session["User"] as User).UserId, ctx);
u = CntAriCli.GetUser(u.UserId, ctx);
// controla that root docs folder exists
if (!CntDocs.DocsExists(this))
{
CntDocs.CreateDocs(this);
}
// patient passed by url
if (Request.QueryString["PatientId"] != null)
{
patientId = int.Parse(Request.QueryString["PatientId"]);
patient = CntAriCli.GetPatient(patientId, ctx);
}
// 2 possibilities
// patient == null (All docs)
// patine != null (Patient's docs)
if (patient == null)
{
paths[0] = "/docs";
}
else
{
if (!CntDocs.PatientFolderExists(patient, this))
{
CntDocs.CreatePatientFolder(patient, this);
}
paths[0] = String.Format("/docs/{0}", patient.FullName);
}
RadFileExplorer1.Configuration.ViewPaths = paths;
RadFileExplorer1.Configuration.DeletePaths = paths;
RadFileExplorer1.Configuration.UploadPaths = paths;
//
string maxFileSize = ConfigurationManager.AppSettings["MaxFileSize"];
if (maxFileSize != null)
{
RadFileExplorer1.Configuration.MaxUploadFileSize = int.Parse(maxFileSize);
}
// cheks if he's called from another form
if (Request.QueryString["Type"] != null)
{
type = Request.QueryString["Type"];
}
if (type == "InTab")
{
HtmlControl tt = (HtmlControl)this.FindControl("TitleArea");
tt.Attributes["class"] = "ghost";
}
}
public RptPatientDebt(AriClinicContext ctx1)
: this()
{
ctx1 = new AriClinicContext("AriClinicContext");
companyname = CntAriCli.GetHealthCompany(ctx1).Name;
IList <Ticket> tickets = CntAriCli.GetTickets(true, ctx1);//.GetInvoicesByCustomer(ffin, idCustomer, ctx1);
this.DataSource = tickets;
//this.subReport2.ReportSource.DataSource = GetInvoideLines(invoices);
}
public RptBombaDolor(DateTime fDate, DateTime tDate, AriClinicContext ctx1)
: this()
{
ctx1 = new AriClinicContext("AriClinicContext");
fromDate = fDate; toDate = tDate;
companyname = CntAriCli.GetHealthCompany(ctx1).Name;
List <AnestheticTicket> tickets = CntAriCli.GetAnestheticServiceTicketsBomba(fDate, tDate, ctx1);
this.DataSource = tickets;
}
static void Main(string[] args)
{
ctx = new AriClinicContext("AriClinicContext");
Console.WriteLine("-- Begin program --");
FixAnestheticNotes(ctx);
Console.WriteLine("-- End program. Press <ENTER> to exit --");
Console.ReadLine();
}
public static void LoadInsurance(Aseguradora aseg, RdcModel ctxRid, AriClinicContext ctxAri)
{
Insurance insurance = new Insurance();
insurance.InsuranceId = aseg.Id_aseguradora;
insurance.Name = aseg.Nom_aseguradora;
insurance.OftId = aseg.Id_aseguradora;
ctxAri.Add(insurance);
ctxAri.SaveChanges();
}
