public ActionResult saveConnectionId(string conId, int userId)
{
try {
var user = db.users.Where(e => e.userId == userId).First();
user.connectionid = conId;
user.status = "online";
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
var userInfo = db.users.Where(x => x.userId == userId).Select(e => new { e.userId, e.firstname, e.middlename, e.lastname, e.profpath, e.coverpath, e.status, e.username, e.connectionid }).ToList();
return(Json(userInfo, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json("Failed", JsonRequestBehavior.AllowGet));
}
}
public ActionResult updateProject(project project, int[] users, int[] Rusers)
{
//try {
db.Entry(project).State = EntityState.Modified;
db.SaveChanges();
if (users != null)
{
for (int i = 0; i < users.Length; i++)
{
int userId = users[i];
var pps = db.participants.Where(e => e.projId == project.projId && e.userId == userId).ToList();
if (pps.Count() == 1)
{
participant pp = pps[0];
pp.status = "Active";
db.Entry(pp).State = EntityState.Modified;
db.SaveChanges();
}
else
{
participant pp = new participant();
pp.projId = project.projId;
pp.userId = users[i];
pp.status = "Active";
db.participants.Add(pp);
db.SaveChanges();
}
}
}
if (Rusers != null)
{
for (int i = 0; i < Rusers.Length; i++)
{
var userId = Rusers[i];
var participant = db.participants.Where(e => e.projId == project.projId && e.userId == userId).First();
participant.status = "Removed";
db.Entry(participant).State = EntityState.Modified;
db.SaveChanges();
}
}
return(Json("Success", JsonRequestBehavior.AllowGet));
//}
//catch (Exception e)
//{
// return Json("Success", JsonRequestBehavior.AllowGet);
//}
}
public void UpdatePatient(Patient patient)
{
_pmisEntities.Patients.Attach(patient);
_pmisEntities.Entry(patient).State = EntityState.Modified;
}
public void UpdateMedicalRecord(MedicalRecord record)
{
_pmisEntities.MedicalRecords.Attach(record);
_pmisEntities.Entry(record).State = EntityState.Modified;
}
public void UpdatePhysician(Physician physician)
{
_pmisEntities.Physicians.Attach(physician);
_pmisEntities.Entry(physician).State = EntityState.Modified;
}
public void UpdatePrescription(Prescription prescription)
{
_pmisEntities.Prescriptions.Attach(prescription);
_pmisEntities.Entry(prescription).State = EntityState.Modified;
}
public void ModifyAppointment(Appointment appointment)
{
_pmisEntities.Appointments.Attach(appointment);
_pmisEntities.Entry(appointment).State = EntityState.Modified;
}