public static decimal GetUnpaid(ServiceNote sn, AriClinicContext ctx)
{
decimal amount = sn.Tickets.Sum(t => t.Amount);
decimal paid = sn.Tickets.Sum(t => t.Paid);
return(amount - paid);
}
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 == "visitreason"
select p).FirstOrDefault<Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["VisitReasonId"] != null)
{
visitReasonId = Int32.Parse(Request.QueryString["VisitReasonId"]);
visitReason = CntAriCli.GetVisitReason(visitReasonId, ctx);
LoadData(visitReason);
}
}
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.GetProfessionalTickets(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();
serieItem.YValue = (from tic in item.Tickets
where tic.TicketDate >= fromDate && tic.TicketDate <= toDate
select tic).ToList<Ticket>().Count();
serieItem.Name = item.FullName;
serieItem.Label.TextBlock.Text = item.Tickets.Count.ToString();
serieItem.Appearance.Exploded = true;
chartSeries1.Items.Add(serieItem);
}
chart1.Series.Clear();
chart1.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] { chartSeries1 });
}
public static void BigDelete(AriClinicContext ctx)
{
ctx.Delete(ctx.InvoiceLines);
ctx.Delete(ctx.Invoices);
ctx.SaveChanges();
ctx.Delete(ctx.AppointmentInfos);
ctx.Delete(ctx.AppointmentTypes);
ctx.Delete(ctx.Diaries);
ctx.SaveChanges();
ctx.Delete(ctx.Payments);
ctx.Delete(ctx.Tickets);
ctx.Delete(ctx.ServiceNotes);
ctx.Delete(ctx.Policies);
ctx.Delete(ctx.Insurances);
ctx.Delete(ctx.InsuranceServices);
ctx.SaveChanges();
ctx.Delete(ctx.Services);
ctx.Delete(ctx.ServiceCategories);
ctx.Delete(ctx.TaxTypes);
ctx.Delete(ctx.Addresses); // eliminar direcciones.
ctx.Delete(ctx.Emails); // eliminar correos electrónicos
ctx.Delete(ctx.Telephones); // eliminar teléfonos.
ctx.Delete(ctx.Policies); // eliminar las pólizas.
ctx.Delete(ctx.PaymentMethods);
ctx.SaveChanges();
}
public static void DeleteVisit(AriClinicContext ctx)
{
ctx.Delete(ctx.OphthalmologicVisits);
ctx.Delete(ctx.BaseVisits);
ctx.Delete(ctx.VisitReasons);
ctx.SaveChanges();
}
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);
}
}
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);
}
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 == "policy"
select p).FirstOrDefault<Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["CustomerId"] != null)
{
patientId = Int32.Parse(Request.QueryString["CustomerId"]);
pat = CntAriCli.GetCustomer(patientId, ctx);
txtCustomer.Text = pat.FullName;
}
//
if (Request.QueryString["PolicyId"] != null)
{
policyId = Int32.Parse(Request.QueryString["PolicyId"]);
pol = CntAriCli.GetPolicy(policyId, ctx);
LoadData(pol);
}
else
{
LoadTypeCombo(null);
LoadInsuranceCombo(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 == "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["PrescriptionGlasses"] != null)
prescriptionGlasses = CntAriCli.GetPrescriptionGlasses(int.Parse(Request.QueryString["PrescriptionGlasses"]), 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 == "usergroup"
select p).FirstOrDefault<Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["UserGroupId"] != null)
{
userGroupId = Int32.Parse(Request.QueryString["UserGroupId"]);
UserGroup ug = (from usg in ctx.UserGroups
where usg.UserGroupId == userGroupId
select usg).FirstOrDefault<UserGroup>();
LoadData(ug);
}
}
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 == "servicesubcategory"
select p).FirstOrDefault<Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["ServiceSubCategoryId"] != null)
{
serviceSubCategoryId = Int32.Parse(Request.QueryString["ServiceSubCategoryId"]);
serSub = CntAriCli.GetServiceSubcategory(serviceSubCategoryId, ctx);
LoadData(serSub);
}
else
{
LoadServiceCategory(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 == "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);
LoadClinic(null);
}
}
public RptTicket(int idticket, AriClinicContext ctx1)
: this()
{
ctx1 = new AriClinicContext("AriClinicContext");
companyname = CntAriCli.GetHealthCompany(ctx1).Name;
this.DataSource = CntAriCli.GetTicket(idticket, ctx1);
}
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["GlassesTestId"] != null)
{
id = Int32.Parse(Request.QueryString["GlassesTestId"]);
glassesTest = CntAriCli.GetGlassesTest(id, ctx);
refractometry = glassesTest.Refractometry;
LoadData(glassesTest);
}
if (Request.QueryString["RefractometryId"] != null)
{
id = int.Parse(Request.QueryString["RefractometryId"]);
refractometry = (Refractometry)CntAriCli.GetExaminationAssigned(id, 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 == "Estimate"
select p).FirstOrDefault<Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
LoadComboInsurance();
//
if (Request.QueryString["EstimateId"] != null)
{
estId = Int32.Parse(Request.QueryString["EstimateId"]);
est = CntAriCli.GetEstimate(estId, ctx);
}
//
if (Request.QueryString["EstimateLineId"] != null)
{
estlId = Int32.Parse(Request.QueryString["EstimateLineId"]);
estl = CntAriCli.GetEstimateLine(estlId, ctx);
LoadData(estl);
}
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, This is a general view accesible for all
// Do you want to see a Diary?
if (Request.QueryString["DiaryId"] != null)
{
diaryId = int.Parse(Request.QueryString["DiaryId"]);
diary = CntAriCli.GetDiary(diaryId, ctx);
if (diary != null)
{
lblTitle.Text = diary.Name;
this.Title = diary.Name;
}
}
else
{
// this view is only for specific agendas
Response.Redirect("Default.aspx");
}
// Do you want to see a Professional?
if (Request.QueryString["ProfessionalId"] != null)
{
professionalId = int.Parse(Request.QueryString["ProfessionalId"]);
professional = CntAriCli.GetProfessional(professionalId, ctx);
if (professional != null)
lblTitle.Text = professional.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 == "policy"
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 the realated patient
if (Request.QueryString["PatientId"] != null)
{
patientId = Int32.Parse(Request.QueryString["PatientId"]);
pat = CntAriCli.GetPatient(patientId, ctx);
cus = pat.Customer;
}
if (Request.QueryString["CustomerId"] != null)
{
customerId = Int32.Parse(Request.QueryString["CustomerId"]);
cus = CntAriCli.GetCustomer(customerId, ctx);
}
// translate filters
CntWeb.TranslateRadGridFilters(RadGrid1);
}
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 == "request"
select p).FirstOrDefault<Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["RequestId"] != null)
{
requestId = Int32.Parse(Request.QueryString["RequestId"]);
request = CntAriCli.GetRequest(requestId, ctx);
if (request != null)
{
string person = "";
if (request.Patient != null)
person = request.Patient.FullName;
else
person = request.FullName;
lblRequestPerson.Text = String.Format("INTERESADO: {0}", person);
string service = "";
if (request.Service != null)
{
service = request.Service.Name;
rdcService.Items.Clear();
rdcService.Items.Add(new RadComboBoxItem(request.Service.Name,request.Service.ServiceId.ToString()));
rdcService.SelectedValue = request.Service.ServiceId.ToString();
}
lblRequestService.Text = String.Format("SERVICIO: {0}", service);
lblRequestComments.Text = String.Format("OBSERVACIONES: {0}", request.Comments);
}
}
//
if (Request.QueryString["ReplayId"] != null)
{
replayId = Int32.Parse(Request.QueryString["ReplayId"]);
replay = CntAriCli.GetReplay(replayId, ctx);
LoadData(replay);
}
else
{
// default values for a new request
rdtReplayDate.SelectedDate = DateTime.Now;
}
//
if (Request.QueryString["Caller"] != null)
{
caller = Request.QueryString["Caller"];
}
}
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);
}
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;
}
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 == "policy"
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 the realated patient
if (Request.QueryString["PatientId"] != null)
{
patientId = Int32.Parse(Request.QueryString["PatientId"]);
pat = CntAriCli.GetPatient(patientId, ctx);
cus = pat.Customer;
}
// read passed customer if any
if (Request.QueryString["CustomerId"] != null)
{
customerId = Int32.Parse(Request.QueryString["CustomerId"]);
cus = CntAriCli.GetCustomer(customerId, ctx);
}
//
if (type == "InTab")
{
HtmlControl tt = (HtmlControl)this.FindControl("TitleArea");
tt.Attributes["class"] = "ghost";
// hide patient column
RadGrid1.Columns.FindByDataField("Ticket.Policy.Customer.FullName").Visible = false;
}
if (Request.QueryString["ServiceNoteId"] != null)
{
serviceNoteId = int.Parse(Request.QueryString["ServiceNoteId"]);
serviceNote = CntAriCli.GetServiceNote(serviceNoteId, ctx);
HtmlControl tt = (HtmlControl)this.FindControl("TitleArea");
tt.Attributes["class"] = "ghost";
RadGrid1.Columns.FindByDataField("ServiceNote.Customer.FullName").Visible = false;
// Ticket.Description
RadGrid1.Columns.FindByDataField("Ticket.Description").Visible = false;
// Ticket.Amount
RadGrid1.Columns.FindByDataField("Ticket.Amount").Visible = false;
//Ticket.Paid
RadGrid1.Columns.FindByDataField("Ticket.Paid").Visible = false;
// to fit in iframe space
RadGrid1.PageSize = 3;
RadGrid1.AllowFilteringByColumn = false;
}
// translate filters
CntWeb.TranslateRadGridFilters(RadGrid1);
}
public static void GeneralPaymentDelete(GeneralPayment gp, AriClinicContext ctx)
{
foreach (Payment p in gp.Payments)
{
PaymentDelete(p, ctx);
}
ctx.Delete(gp);
ctx.SaveChanges();
}
public static void GeneralPaymentDelete(GeneralPayment gp, AriClinicContext ctx)
{
foreach (Payment p in gp.Payments)
{
PaymentDelete(p, ctx);
}
ctx.Delete(gp);
ctx.SaveChanges();
}
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 == "ticket"
select p).FirstOrDefault<Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
if (Request.QueryString["CustomerId"] != null)
{
customerId = Int32.Parse(Request.QueryString["CustomerId"]);
cus = CntAriCli.GetCustomer(customerId, ctx);
//txtCustomerId.Text = cus.PersonId.ToString();
rdcComercialName.Items.Clear();
rdcComercialName.Items.Add(new RadComboBoxItem(cus.FullName, cus.PersonId.ToString()));
rdcComercialName.SelectedValue = cus.PersonId.ToString();
rdcComercialName.Enabled = false;
btnCustomerId.Visible = false;
}
else
{
LoadClinicCombo(null);
}
if (Session["Clinic"] != null)
cl = (Clinic)Session["Clinic"];
//
if (Request.QueryString["AnestheticServiceNoteId"] != null)
{
anestheticServiceNoteId = Int32.Parse(Request.QueryString["AnestheticServiceNoteId"]);
asn = CntAriCli.GetAnestheticServiceNote(anestheticServiceNoteId, ctx);
cus = asn.Customer;
customerId = cus.PersonId;
if(!IsPostBack)
LoadData(asn);
// Load internal frame
HtmlControl frm = (HtmlControl)this.FindControl("ifTickets");
frm.Attributes["src"] = String.Format("TicketGrid.aspx?AnestheticServiceNoteId={0}", anestheticServiceNoteId);
}
else
{
// If there isn't a ticket the default date must be today
rddpServiceNoteDate.SelectedDate = DateTime.Now;
LoadClinicCombo(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 = (User)Session["User"];
user = CntAriCli.GetUser(user.UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "procedureassigned"
select p).FirstOrDefault<Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["ProcedureAssignedId"] != null)
{
procedureAssignedId = Int32.Parse(Request.QueryString["ProcedureAssignedId"]);
procedureAssigned = CntAriCli.GetProcedureAssigned(procedureAssignedId, ctx);
LoadData(procedureAssigned);
}
else
{
rdpProcedureDate.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;
//
rdpProcedureDate.SelectedDate = visit.VisitDate;
}
}
public static decimal GetInvoiceAmount(int invoiceId)
{
decimal total = 0;
using (AriClinicContext ctx = new AriClinicContext("AriClinicContext"))
{
ProfessionalInvoice pInvoice = CntAriCli.GetProfessionalInvoice(invoiceId, ctx);
if (pInvoice != null) total = pInvoice.Amount;
}
return total;
}
public static void PaymentDelete(Payment pay, AriClinicContext ctx)
{
// minus paid in ticket
if (pay.Ticket != null)
{
pay.Ticket.Paid = pay.Ticket.Paid - pay.Amount;
}
ctx.Delete(pay);
ctx.SaveChanges();
}
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 static void ApplyRisk(AnestheticServiceNote asn, AriClinicContext ctx)
{
if (asn.Chk3)
{
foreach (AnestheticTicket atck in asn.AnestheticTickets)
{
atck.Amount = atck.Amount * 1.5M;
}
ctx.SaveChanges();
}
}
public static void ApplyPCA(AnestheticServiceNote asn, AriClinicContext ctx)
{
// Read parameters
AriCliModel.Parameter parameter = GetParameter(ctx);
Service painPump = parameter.PainPump;
// Do we need check pain pump?
if (painPump != null && asn.Chk1)
{
// Is there a pain pump assigned?
var rs = from t in asn.AnestheticTickets
where t.InsuranceService.Service.ServiceId == painPump.ServiceId
select t;
if (rs.Count() == 0)
{
// Does this customer have a primary policy with that service?
Policy pol = PrimaryPolicy(asn.Customer);
if (pol == null)
{
throw new AriCliException(1, "There isn't a primary policy for this customer");
}
// Does this policy (insurance) includes a pain pump service?
InsuranceService ins = PolicyIncludesService(pol, painPump);
if (ins == null)
{
throw new AriCliException(2, "The insurance company have not the pain pump service assigned");
}
// More expensive procedure
AnestheticTicket aatck = asn.AnestheticTickets.OrderByDescending(x => x.Amount).FirstOrDefault <AnestheticTicket>();
if (aatck != null)
{
Procedure proc = aatck.Procedure;
// Everything seems ok, we can add the ticket
AnestheticTicket atck = new AnestheticTicket()
{
TicketDate = asn.ServiceNoteDate,
Description = String.Format("{0} ({1})", proc.Name, ins.Service.Name),
Amount = ins.Price,
Policy = pol,
InsuranceService = ins,
User = asn.User,
Clinic = asn.Clinic,
Professional = asn.Professional,
Surgeon = asn.Surgeon,
Procedure = proc,
AnestheticServiceNote = asn
};
ctx.Add(atck);
ctx.SaveChanges();
}
}
}
}
public static void ApplyMultiTicket(AnestheticServiceNote asn, AriClinicContext ctx)
{
bool first = true;
if (asn.AnestheticTickets.Count > 1)
{
foreach (AnestheticTicket atck in asn.AnestheticTickets.OrderByDescending(x => x.Amount))
{
if (!first)
{
atck.Amount = atck.Amount / 2;
atck.Comments = "-50%";
ctx.SaveChanges();
}
first = false;
}
}
}
public static void CheckTickets(AnestheticServiceNote asn, bool[] lschk, AriClinicContext ctx)
{
int i = 0;
int lenght = lschk.Count();
foreach (AnestheticTicket actk in asn.AnestheticTickets)
{
if (asn.Chk2)
{
actk.Checked = true;
}
else
{
if (i < lenght)
{
actk.Checked = lschk[i];
}
}
i++;
}
ctx.SaveChanges();
}
public static void CreateAssociateTickets(AnestheticServiceNote asn, AriClinicContext ctx)
{
// Does this customer have a primary policy with that service?
Policy pol = PrimaryPolicy(asn.Customer);
if (pol == null)
{
throw new AriCliException(1, "There isn't a primary policy for this customer");
}
// Delete all tickets
ctx.Delete(asn.AnestheticTickets);
foreach (Procedure proc in asn.Procedures)
{
// Does this policy includes related (from procedure) services
InsuranceService ins = PolicyIncludesService(pol, proc.Service);
if (ins == null)
{
throw new AriCliException(3, "The insurance company have not the nomenclator service assigned");
}
// Everything seems ok, we can add anesthetic ticket
AnestheticTicket atck = new AnestheticTicket()
{
TicketDate = asn.ServiceNoteDate,
Description = String.Format("{0} ({1})", proc.Name, ins.Service.Name),
Amount = ins.Price,
Policy = pol,
InsuranceService = ins,
User = asn.User,
Clinic = asn.Clinic,
Professional = asn.Professional,
Surgeon = asn.Surgeon,
Procedure = proc,
AnestheticServiceNote = asn
};
ctx.Add(atck);
ctx.SaveChanges();
}
}
public static GeneralPayment GeneralPaymentNew(Clinic clinic, ServiceNote sn, decimal amount, PaymentMethod payMethod, DateTime payDate, string description, AriClinicContext ctx)
{
var rs = from t in sn.Tickets
where t.Amount > t.Paid
select t;
GeneralPayment gp = new GeneralPayment();
gp.ServiceNote = sn;
gp.PaymentDate = payDate;
gp.Description = description;
gp.PaymentMethod = payMethod;
gp.Amount = amount;
gp.Clinic = clinic;
ctx.Add(gp);
foreach (Ticket t in rs.OrderByDescending(tk => tk.Amount - tk.Paid))
{
Payment pay = new Payment();
pay.PaymentMethod = payMethod;
pay.PaymentDate = payDate;
pay.Ticket = t;
pay.GeneralPayment = gp;
pay.Description = description;
pay.Clinic = clinic;
decimal dif = t.Amount - t.Paid;
if (dif <= amount)
{
pay.Amount = dif;
amount = amount - dif;
t.Paid = t.Paid + dif;
}
else
{
pay.Amount = amount;
t.Paid = t.Paid + amount;
amount = 0;
}
ctx.Add(pay);
if (amount == 0)
{
break;
}
}
ctx.SaveChanges();
return(gp);
}
public static bool UpdateRelatedTckV2(AnestheticServiceNote asn, bool[] lschk, AriClinicContext ctx)
{
bool res = true;
try
{
CreateAssociateTickets(asn, ctx);
ApplyMultiTicket(asn, ctx);
ApplyPCA(asn, ctx);
ApplyRisk(asn, ctx);
CheckTickets(asn, lschk, ctx);
}
catch (AriCliException ex)
{
res = false;
}
return(res);
}