public void register(persona user)
{
ORMDataContext BD = new ORMDataContext();
BD.persona.InsertOnSubmit(user);
BD.SubmitChanges();
}
public void FinalidadCita(int id_cita)
{
ORMDataContext BD = new ORMDataContext();
var citaf = from per in BD.cita
where per.id_cita == id_cita
select per;
cita objCita = new cita();
foreach (var item in citaf)
{
objCita.id_cita = id_cita + 600;
objCita.id_persona = item.id_persona;
objCita.id_especialista = item.id_especialista;
objCita.fecha_cita = item.fecha_cita;
objCita.hora_cita = item.hora_cita;
objCita.calificacion = item.calificacion;
}
BD.cita.InsertOnSubmit(objCita);//Insertar
cita citaR = (from per in BD.cita
where per.id_cita == id_cita
select per).FirstOrDefault();
citaR.id_persona = null;
BD.SubmitChanges();
}
public void register(especialista especialidadP)
{
ORMDataContext BD = new ORMDataContext();
BD.especialista.InsertOnSubmit(especialidadP);
BD.SubmitChanges();
}
public void register(cita citaObject)
{
ORMDataContext BD = new ORMDataContext();
BD.cita.InsertOnSubmit(citaObject);
BD.SubmitChanges();
}
public object findAll()
{
ORMDataContext BD = new ORMDataContext();
return(from c in BD.ciudad
select c);
}
public void register(ente_salud entesalud)
{
ORMDataContext BD = new ORMDataContext();
BD.ente_salud.InsertOnSubmit(entesalud);
BD.SubmitChanges();
}
private void button1_Click(object sender, EventArgs e)
{
using (ORMDataContext dbContext = new ORMDataContext())
{
var dd = dbContext.FixedSalaries.AsNoTracking().ToList();
}
}
public void asignar(int especialidadP, string entidad)
{
ORMDataContext BD = new ORMDataContext();
var query = (from c in BD.especialista
where c.id_especialista == especialidadP
select c).FirstOrDefault();
query.id_ente_salud = entidad;
BD.SubmitChanges();
}
public object findRepre(string id)
{
ORMDataContext BD = new ORMDataContext();
return(from c in BD.ente_salud
where c.representante == id
select new
{
nit = c.nit,
});
}
public object findAll()
{
ORMDataContext BD = new ORMDataContext();
return(from c in BD.ente_salud
select new
{
nit = c.nit,
razon_social = c.razon_social,
});
}
public void calificar(int id_cita, string calificacion)
{
ORMDataContext BD = new ORMDataContext();
cita citCalificar = (from per in BD.cita
where per.id_cita == id_cita
select per).FirstOrDefault();
citCalificar.id_cita = id_cita;
citCalificar.calificacion = int.Parse(calificacion);
BD.SubmitChanges();
}
public object finddl()
{
ORMDataContext BD = new ORMDataContext();
return(from c in BD.especialista
where c.ente_salud == null
select new
{
id_especialista = c.id_especialista,
nombre = c.persona.nombre + " " + c.persona.apellido + " (" + c.especialidad + ")",
});
}
public String findEntity(int id)
{
ORMDataContext BD = new ORMDataContext();
ente_salud ent = (from per in BD.ente_salud
where per.representante == id.ToString()
select per).FirstOrDefault();
String repre = ent.representante;
return(repre);
}
public Object ConsultarTodos(int id)
{
ORMDataContext BD = new ORMDataContext();
return(from per in BD.enfermedad_sintoma
where per.id_enfermedad == id
select new
{
sin = per.sintoma.sintoma_texto,
}
);
}
public String obtenerDescripcion(int id)
{
ORMDataContext BD = new ORMDataContext();
enfermedad enfe = (from per in BD.enfermedad
where per.id_enfermedad == id
select per).FirstOrDefault();
String descp = enfe.descripcion;
return(descp);
}
public Object ConsultarTodos(int id)
{
ORMDataContext BD = new ORMDataContext();
return(from per in BD.recomendacion
where per.id_enfermedad == id
select new
{
nmb = per.recomendacion_texto,
}
);
}
internal string Insertdata(string nama, string phone, string email, string company, string country, string zip, string state, string city)
{
string response = "";
#region Insert_MST_Spreed
Helper Help = new Helper();
ORMDataContext db = new ORMDataContext(Help.conStrODBC);
db.Connection.Open();
person = new Contact_person()
{
Nama = nama,
Phone = phone,
Email = email,
Company = company,
Country = country,
Zip_code = zip,
State_ = state,
City = city
};
var txOptions = new System.Transactions.TransactionOptions();
txOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
using (var tran = new TransactionScope(TransactionScopeOption.Required, txOptions))
{
try
{
db.Contact_persons.InsertOnSubmit(person);
db.SubmitChanges();
tran.Complete();
response = "Sukses";
}
catch (Exception ex)
{
Console.WriteLine("==> Error Data Insert MST_Spreed " + ex.Message);
string data = ex.Message;
tran.Dispose();
response = "Error : " + data;
}
}
db.Connection.Close();
return(response);
#endregion
}
public void AsignarCita(int id, string id_persona)
{
ORMDataContext BD = new ORMDataContext();
string mensaje = string.Empty;
cita citAgendar = (from per in BD.cita
where per.id_cita == id
select per).FirstOrDefault();
citAgendar.id_persona = id_persona;
BD.SubmitChanges();
}
public Object ConsultarTodos()
{
ORMDataContext BD = new ORMDataContext();
return(from per in BD.enfermedad
select new
{
nombre = per.nombre,
id_sintoma = per.id_enfermedad,
desc = per.descripcion,
}
);
}
//lita de lo que ve el especialista
public Object MisCitasEspecialista(string id_persona)
{
ORMDataContext BD = new ORMDataContext();
return(from per in BD.cita
where per.id_especialista == int.Parse(id_persona)
select new
{
cita = per.id_cita,
hora = per.hora_cita,
Dia = per.fecha_cita
}
);
}
public object findAll()
{
ORMDataContext BD = new ORMDataContext();
return(from c in BD.especialista
select new
{
nombreddl = c.persona.nombre + " " + c.persona.apellido + " (" + c.especialidad + ")",
id_especialista = c.id_especialista,
espe = c.especialidad,
nombre = c.persona.nombre + " " + c.persona.apellido,
id = c.persona.cedula,
ciudad = c.ciudad.ciudad1,
entidad = c.ente_salud.razon_social,
});
}
public Object findAll()
{
ORMDataContext BD = new ORMDataContext();
return(from per in BD.persona
select new
{
nombre = per.nombre + " " + per.apellido,
niup = per.cedula,
celular = per.celular,
correo = per.correo,
pass = per.password,
rol = per.rol.rol1,
}
);
}
public object findGv()
{
ORMDataContext BD = new ORMDataContext();
return(from c in BD.ente_salud
select new
{
nit = c.nit,
razon_social = c.razon_social,
repre = c.persona.nombre + " " + c.persona.apellido,
razon = c.razon_social,
telefono = c.telefono,
capacidad = c.capacidad_pacientes,
sitio = c.sitio_web,
ciudad = c.ciudad.ciudad1,
});
}
public persona login(string id, string pass)
{
ORMDataContext BD = new ORMDataContext();
var personaLogin = BD.sp_login(id, pass);
persona objPersona = new persona();
foreach (var item in personaLogin)
{
objPersona.cedula = item.cedula;
objPersona.id_rol = item.id_rol;
objPersona.cedula = item.cedula;
objPersona.nombre = item.nombre;
objPersona.apellido = item.correo;
objPersona.correo = item.correo;
objPersona.cedula = item.cedula;
}
return(objPersona);
}
internal string Updatedata(string nama, string phone, string email, string company, string country, string zip, string state, string city)
{
string respon = "";
Helper Help = new Helper();
ORMDataContext db = new ORMDataContext(Help.conStrODBC);
db.Connection.Open();
var txOptions = new System.Transactions.TransactionOptions();
txOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
using (var tran = new TransactionScope(TransactionScopeOption.Required, txOptions))
{
try
{
person = (from q in db.Contact_persons
where q.Nama == nama
select q).Take(1).FirstOrDefault();
person.Nama = nama;
person.Phone = phone;
person.Email = email;
person.Company = company;
person.Country = country;
person.Zip_code = zip;
person.State_ = state;
person.City = city;
db.SubmitChanges();
tran.Complete();
respon = "Sukses";
}
catch (Exception ex)
{
string data = ex.Message;
tran.Dispose();
respon = "Error : " + data;
}
}
db.Connection.Close();
return(respon);
}
//lita de lo que ve la persona (el que aplico la cita) para calificar
public Object findNotNote(string id_persona)
{
ORMDataContext BD = new ORMDataContext();
return(from per in BD.cita
where per.id_persona == id_persona
where per.calificacion == null
select new
{
id = per.id_cita,
hora = per.hora_cita,
dia = per.fecha_cita,
especialidad = per.especialista.especialidad,
entidad = per.especialista.ente_salud.razon_social,
espe = per.especialista.persona.nombre + " " + per.especialista.persona.apellido,
city = per.especialista.ente_salud.ciudad.ciudad1,
}
);
}
public Object findByEntity(string entesalud)
{
ORMDataContext BD = new ORMDataContext();
return(from c in BD.especialista
where c.ente_salud.representante == entesalud
select new
{
nombreddl = c.persona.nombre + " " + c.persona.apellido + " (" + c.especialidad + ")",
id_especialista = c.id_especialista,
espe = c.especialidad,
nombre = c.persona.nombre + " " + c.persona.apellido,
id = c.persona.cedula,
ciudad = c.ciudad.ciudad1,
entidad = c.ente_salud.razon_social,
});
;
}
internal List <DataFile> GenerateFile(string response)
{
Helper help = new Helper();
List_file = new List <DataFile>();
ORMDataContext db = new ORMDataContext(help.conStrODBC);
db.Connection.Open();
if (response == "")
{
var persons = (from q in db.Contact_persons
select q).AsQueryable().ToList();
foreach (var item in persons)
{
string _Nama = item.Nama;
string _Phone = item.Phone;
string _Email = item.Email;
string _Company = item.Company;
string _Country = item.Country;
string _Zip_code = item.Zip_code;
string _State = item.State_;
string _City = item.City;
List_file.Add(new DataFile
{
Nama = _Nama,
Phone = _Phone,
Email = _Email,
Company = _Company,
Country = _Country,
Zip_code = _Zip_code,
State = _State,
City = _City
});
}
}
else
{
var persons = (from q in db.Contact_persons where q.Nama == response
select q).AsQueryable().ToList();
foreach (var item in persons)
{
string _Nama = item.Nama;
string _Phone = item.Phone;
string _Email = item.Email;
string _Company = item.Company;
string _Country = item.Country;
string _Zip_code = item.Zip_code;
string _State = item.State_;
string _City = item.City;
List_file.Add(new DataFile
{
Nama = _Nama,
Phone = _Phone,
Email = _Email,
Company = _Company,
Country = _Country,
Zip_code = _Zip_code,
State = _State,
City = _City
});
}
}
db.Connection.Close();
return(List_file);
}
