protected bool CreateChange()
{
if (!DataOk())
{
return(false);
}
if (sn == null)
{
firstTime = true;
sn = new ServiceNote();
UnloadData(sn);
ctx.Add(sn);
}
else
{
sn = CntAriCli.GetServiceNote(serviceNoteId, ctx);
UnloadData(sn);
}
ctx.SaveChanges();
// control that this note have lines
if (firstTime && sn.Tickets.Count() == 0)
{
firstTime = false;
string command = String.Format("ariDialog('{0}','{1}','warning',null,0,0);"
, Resources.GeneralResource.Warning
, Resources.GeneralResource.ServiceNoteLinesNedeed);
RadAjaxManager1.ResponseScripts.Add(command);
Session["LinkId"] = sn.ServiceNoteId;
return(false);
}
return(true);
}
protected void LoadClinicCombo(ServiceNote sn)
{
// clear previous items
rdcbClinic.Items.Clear();
foreach (Clinic c in ctx.Clinics)
{
rdcbClinic.Items.Add(new RadComboBoxItem(c.Name, c.ClinicId.ToString()));
}
if (sn != null && sn.Clinic != null)
{
rdcbClinic.SelectedValue = sn.Clinic.ClinicId.ToString();
}
else
{
if (cl != null)
{
rdcbClinic.SelectedValue = cl.ClinicId.ToString();
}
else
{
rdcbClinic.Items.Add(new RadComboBoxItem(" ", ""));
rdcbClinic.SelectedValue = "";
}
}
}
protected void RadAjaxManager1_AjaxRequest(object sender, AjaxRequestEventArgs e)
{
RadGrid1.Rebind();
if (e.Argument == "new")
{
RadGrid1.CurrentPageIndex = RadGrid1.PageCount - 1;
RadGrid1.Rebind();
}
if (e.Argument == "yes")
{
if (Session["DeleteId"] != null)
{
try
{
serviceNoteId = (int)Session["DeleteId"];
ServiceNote sn = CntAriCli.GetServiceNote(serviceNoteId, ctx);
CntAriCli.DeleteServiceNote(sn, ctx);
RadGrid1.Rebind();
Session["DeleteId"] = null;
}
catch (Exception ex)
{
Session["Exception"] = ex;
string command = String.Format("showDialog('Error','{0}','error',null, 0, 0)"
, Resources.GeneralResource.DeleteRecordFail);
RadAjaxManager1.ResponseScripts.Add(command);
}
}
}
}
public RptServNote(int idservnote, AriClinicContext ctx1)
: this()
{
ctx1 = new AriClinicContext("AriClinicContext");
companyname = CntAriCli.GetHealthCompany(ctx1).Name;
ServiceNote servNote = CntAriCli.GetServiceNote(idservnote, ctx1);
this.DataSource = servNote;
//this.subReport1.ReportSource.DataSource = servNote.Tickets;
this.subReport1.Report.DataSource = servNote.Tickets;
}
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 == "payment"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
if (Session["Clinic"] != null)
{
cl = (Clinic)Session["Clinic"];
}
//
//
if (Request.QueryString["ServiceNoteId"] != null)
{
serviceNoteId = int.Parse(Request.QueryString["ServiceNoteId"]);
snote = CntAriCli.GetServiceNote(serviceNoteId, ctx);
// calcute total amount and total payments
//txtServiceNoteData.Text = String.Format("ID:{0} Fecha:{1:dd/MM/yy} Total:{2} Pagado:{3}",
// snote.ServiceNoteId,
// snote.ServiceNoteDate,
// CntAriCli.GetServiceNoteAmount(snote),
// CntAriCli.GetServiceNoteAmountPay(snote));
txtServiceNoteData.Text = String.Format("{0} ({1:dd/MM/yy}) T:{2:0.00} P:{3:0.00}", snote.Customer.ComercialName, snote.ServiceNoteDate, snote.Total, snote.Paid);
txtAmount.Value = (double)CntAriCli.GetUnpaid(snote, ctx);
//txtAmount.Text = string.Format("{0:#.#}", CntAriCli.GetUnpaid(snote, ctx));
SetFocus(rdcbClinic);
}
if (Request.QueryString["GeneralPaymentId"] != null)
{
paymentId = Int32.Parse(Request.QueryString["GeneralPaymentId"]);
gpay = CntAriCli.GetGeneralPayment(paymentId, ctx);
LoadData(gpay);
}
else
{
rddpGeneralPaymentDate.SelectedDate = DateTime.Now;
LoadPaymentMethodCombo(null);
LoadClinicCombo(null);
}
}
protected void UnloadData(GeneralPayment pay)
{
if (pay != null)
{
serviceNote = pay.ServiceNote;
CntAriCli.GeneralPaymentDelete(pay, ctx);
}
Clinic clinic = CntAriCli.GetClinic(int.Parse(rdcbClinic.SelectedValue), ctx);
PaymentMethod payMethod = CntAriCli.GetPaymentMethod(int.Parse(rdcbPaymentMethod.SelectedValue), ctx);
DateTime payDate = (DateTime)rddpGeneralPaymentDate.SelectedDate;
Decimal amount = (decimal)txtAmount.Value;
string description = txtComments.Text;
pay = CntAriCli.GeneralPaymentNew(clinic, serviceNote, amount, payMethod, payDate, description, ctx);
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
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 == "payment"
select p).FirstOrDefault <Process>();
permission = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = permission.Modify;
}
if (Session["Clinic"] != null)
{
clinic = (Clinic)Session["Clinic"];
}
if (Request.QueryString["ServiceNoteId"] != null)
{
serviceNoteId = int.Parse(Request.QueryString["ServiceNoteId"]);
serviceNote = CntAriCli.GetServiceNote(serviceNoteId, ctx);
txtServiceNoteData.Text = String.Format("{0} ({1:dd/MM/yy}) T:{2:0.00} P:{3:0.00}", serviceNote.Customer.ComercialName, serviceNote.ServiceNoteDate, serviceNote.Total, serviceNote.Paid);
txtAmount.Value = (double)CntAriCli.GetUnpaid(serviceNote, ctx);
if (serviceNote.Clinic != null)
{
clinic = serviceNote.Clinic;
}
SetFocus(rdcbClinic);
}
if (Request.QueryString["GeneralPaymentId"] != null)
{
generalPaymentId = Int32.Parse(Request.QueryString["GeneralPaymentId"]);
generalPayment = CntAriCli.GetGeneralPayment(generalPaymentId, ctx);
serviceNote = generalPayment.ServiceNote;
LoadData(generalPayment);
}
else
{
rddpGeneralPaymentDate.SelectedDate = DateTime.Now;
LoadPaymentMethodCombo(null);
LoadClinicCombo(clinic);
}
}
public static void LoadTicketsAndServiceNotes(RdcModel ctxRid, AriClinicContext ctx)
{
int numr = ctxRid.Acto_medico_asgs.Count(); int r = 0;
DateTime fechaAnt = new DateTime(1, 1, 1);
int idHistoriaAnt = 0;
ServiceNote sn = null;
foreach (Acto_medico_asg asg in (from ams in ctxRid.Acto_medico_asgs
orderby ams.Fecha, ams.Id_historia
select ams))
{
Console.WriteLine("Tickest & Service notes -> {1:000000}/{2:000000} {0:dd/MM/yyyy} ", asg.Fecha, ++r, numr);
Patient patient = (from p in ctx.Patients
where p.OftId == asg.Id_historia
select p).FirstOrDefault <Patient>();
if (asg.Fecha != fechaAnt || asg.Id_historia != idHistoriaAnt)
{
// al cambiar la fecha o el paciente creamos una nueva nota de servicio
sn = new ServiceNote();
sn.Customer = patient.Customer;
sn.ServiceNoteDate = asg.Fecha;
ctx.Add(sn);
ctx.SaveChanges();
fechaAnt = asg.Fecha;
idHistoriaAnt = (int)asg.Id_historia;
}
// montamos el ticket de hoy
Ticket tck = new Ticket();
tck.ServiceNote = sn;
InsuranceService isrv = (from ins in ctx.InsuranceServices
where ins.OftId == asg.Id_acto_medico_asc
select ins).FirstOrDefault <InsuranceService>();
tck.InsuranceService = isrv;
tck.TicketDate = asg.Fecha;
tck.Policy = patient.Customer.Policies.FirstOrDefault <Policy>();
tck.Amount = 1;
tck.Comments = asg.Observaciones;
tck.Description = isrv.Service.Name;
tck.Checked = asg.Comunicado;
ctx.Add(tck);
ctx.SaveChanges();
}
}
protected void UnloadData(ServiceNote sn)
{
sn.ServiceNoteDate = (DateTime)rddpServiceNoteDate.SelectedDate;
clinicId = Int32.Parse(rdcbClinic.SelectedValue);
sn.Clinic = CntAriCli.GetClinic(clinicId, ctx);
sn.User = CntAriCli.GetUser(user.UserId, ctx);
//
sn.Total = sn.Tickets.Sum(t => t.Amount);
sn.Paid = sn.GeneralPayments.Sum(gp => gp.Amount);
//
customerId = Int32.Parse(rdcComercialName.SelectedValue);
sn.Customer = CntAriCli.GetCustomer(customerId, ctx);
if (rdcProfessionalName.SelectedValue != "")
{
professionalId = Int32.Parse(rdcProfessionalName.SelectedValue);
sn.Professional = CntAriCli.GetProfessional(professionalId, ctx);
}
else
{
sn.Professional = null;
}
}
protected void LoadData(ServiceNote sn)
{
txtServiceNoteId.Text = sn.ServiceNoteId.ToString();
//txtCustomerId.Text = sn.Customer.PersonId.ToString();
rdcComercialName.Items.Clear();
rdcComercialName.Items.Add(new RadComboBoxItem(sn.Customer.FullName, sn.Customer.PersonId.ToString()));
rdcComercialName.SelectedValue = sn.Customer.PersonId.ToString();
//txtComercialName.Text = sn.Customer.FullName;
rddpServiceNoteDate.SelectedDate = sn.ServiceNoteDate;
LoadClinicCombo(sn);
txtTotal.Text = String.Format("{0:0.00}", sn.Total);
txtPaid.Text = String.Format("{0:0.00}", sn.Paid);
if (sn.Professional != null)
{
//txtProfessionalId.Text = sn.Professional.PersonId.ToString();
rdcProfessionalName.Items.Clear();
rdcProfessionalName.Items.Add(new RadComboBoxItem(sn.Professional.FullName, sn.Professional.PersonId.ToString()));
rdcProfessionalName.SelectedValue = sn.Professional.PersonId.ToString();
//txtProfessionalName.Text = sn.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;
}
// read passed customer if any
if (Request.QueryString["CustomerId"] != null)
{
customerId = Int32.Parse(Request.QueryString["CustomerId"]);
cus = CntAriCli.GetCustomer(customerId, ctx);
}
//
if (Request.QueryString["NotPaid"] != null)
{
notPaid = true;
}
//
if (type == "InTab")
{
HtmlControl tt = (HtmlControl)this.FindControl("TitleArea");
tt.Attributes["class"] = "ghost";
// hide patient column
RadGrid1.Columns.FindByDataField("Policy.Customer.FullName").Visible = false;
//
RadGrid1.PageSize = 6;
}
else
{
}
if (Request.QueryString["AnestheticServiceNoteId"] != null)
{
anestheticServiceNoteId = Int32.Parse(Request.QueryString["AnestheticServiceNoteId"]);
asn = CntAriCli.GetAnestheticServiceNote(anestheticServiceNoteId, ctx);
HtmlControl tt = (HtmlControl)this.FindControl("TitleArea");
tt.Attributes["class"] = "ghost";
// here the fields that must be hidden
RadGrid1.Columns.FindByDataField("TicketDate").Visible = false;
RadGrid1.Columns.FindByDataField("Policy.Customer.FullName").Visible = false;
RadGrid1.Columns.FindByDataField("Checked").Visible = false;
RadGrid1.Columns.FindByDataField("Clinic.Name").Visible = false;
}
if (Request.QueryString["ServiceNoteId"] != null)
{
serviceNoteId = int.Parse(Request.QueryString["ServiceNoteId"]);
sn = CntAriCli.GetServiceNote(serviceNoteId, ctx);
HtmlControl tt = (HtmlControl)this.FindControl("TitleArea");
tt.Attributes["class"] = "ghost";
// here the fields that must be hidden
RadGrid1.Columns.FindByDataField("TicketDate").Visible = false;
RadGrid1.Columns.FindByDataField("Policy.Customer.FullName").Visible = false;
RadGrid1.Columns.FindByDataField("Checked").Visible = false;
RadGrid1.Columns.FindByDataField("Clinic.Name").Visible = false;
RadGrid1.Columns.FindByDataField("Paid").Visible = false;
}
// 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 == "ticket"
select p).FirstOrDefault <Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
if (user.Professionals.Count > 0)
{
prof = user.Professionals[0];
txtProfessionalId.Text = prof.PersonId.ToString();
txtProfessionalName.Text = prof.FullName;
}
}
//
if (Request.QueryString["CustomerId"] != null)
{
customerId = Int32.Parse(Request.QueryString["CustomerId"]);
cus = CntAriCli.GetCustomer(customerId, ctx);
txtCustomerId.Text = cus.PersonId.ToString();
txtComercialName.Text = cus.FullName;
// if a patient has been passed we can not touch it
txtCustomerId.Enabled = false;
txtComercialName.Enabled = false;
btnCustomerId.Visible = false;
LoadPolicyCombo(null);
}
else
{
LoadPolicyCombo(null);
LoadClinicCombo(null);
}
if (Session["Clinic"] != null)
{
cl = (Clinic)Session["Clinic"];
}
//
if (Request.QueryString["ServiceNoteId"] != null)
{
serviceNoteId = int.Parse(Request.QueryString["ServiceNoteId"]);
sn = CntAriCli.GetServiceNote(serviceNoteId, ctx);
// disable select fields
cus = sn.Customer;
txtCustomerId.Text = cus.PersonId.ToString(); txtCustomerId.Enabled = false;
txtComercialName.Text = cus.FullName; txtComercialName.Enabled = false;
cl = sn.Clinic;
prof = sn.Professional;
if (prof != null)
{
txtProfessionalId.Text = prof.PersonId.ToString(); txtProfessionalId.Enabled = false;
txtProfessionalName.Text = prof.FullName; txtProfessionalName.Enabled = false;
}
rddpTicketDate.SelectedDate = sn.ServiceNoteDate;
}
//
if (Request.QueryString["TicketId"] != null)
{
ticketId = Int32.Parse(Request.QueryString["TicketId"]);
tck = CntAriCli.GetTicket(ticketId, ctx);
cus = tck.Policy.Customer;
customerId = cus.PersonId;
if (tck.ServiceNote != null)
{
sn = tck.ServiceNote;
serviceNoteId = sn.ServiceNoteId;
}
LoadData(tck);
}
else
{
// If there isn't a ticket the default date must be today
rddpTicketDate.SelectedDate = DateTime.Now;
if (sn != null)
{
rddpTicketDate.SelectedDate = sn.ServiceNoteDate;
}
LoadPolicyCombo(null);
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 = 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["PatientId"] != null)
{
patientId = Int32.Parse(Request.QueryString["PatientId"]);
pat = CntAriCli.GetPatient(patientId, ctx);
cus = pat.Customer;
}
if (Request.QueryString["CustomerId"] != null || cus != null)
{
if (cus == 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();
//txtComercialName.Text = cus.FullName;
// if a patient has been passed we can not touch it
//txtCustomerId.Enabled = false;
btnCustomerId.Visible = false;
}
else
{
LoadClinicCombo(null);
}
if (Session["Clinic"] != null)
{
cl = (Clinic)Session["Clinic"];
}
//
if (Request.QueryString["ServiceNoteId"] != null)
{
serviceNoteId = Int32.Parse(Request.QueryString["ServiceNoteId"]);
sn = CntAriCli.GetServiceNote(serviceNoteId, ctx);
cus = sn.Customer;
customerId = cus.PersonId;
LoadData(sn);
// Load internal frame
HtmlControl frm = (HtmlControl)this.FindControl("ifTickets");
frm.Attributes["src"] = String.Format("TicketGrid.aspx?ServiceNoteId={0}", serviceNoteId);
frm = (HtmlControl)this.FindControl("ifGeneralPayments");
frm.Attributes["src"] = String.Format("GeneralPaymentGrid.aspx?ServiceNoteId={0}", serviceNoteId);
}
else
{
// If there isn't a ticket the default date must be today
rddpServiceNoteDate.SelectedDate = DateTime.Now;
LoadClinicCombo(null);
firstTime = true;
btnInvoice.Visible = false;
}
}
