public ActionResult PendingExpertRequestDetails([Bind(Exclude = "OrcaUserName,FirstName,LastName,Email,PhoneNumber", Include = "OrcaUserID, ExpertStatus")] PendingExpertRequest pendingExpertRequest) { int oid = pendingExpertRequest.OrcaUserID; if (ModelState.IsValid) { OrcaContext db = new OrcaContext(); ExpertConsultant expToUpdate = db.ExpertConsultants.Find(pendingExpertRequest.OrcaUserID); expToUpdate.ExpertStatus = pendingExpertRequest.ExpertStatus; db.Entry(expToUpdate).State = EntityState.Modified; db.SaveChanges(); //OrcaUserType.Consultant if (pendingExpertRequest.ExpertStatus == ExpertStatus.Approved) { OrcaUser requestingUser = db.OrcaUsers.Find(pendingExpertRequest.OrcaUserID); requestingUser.UserType = OrcaUserType.Consultant; db.Entry(requestingUser).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("PendingExpertRequests")); } return(View(pendingExpertRequest)); }
public ActionResult ChangeExpert([Bind(Exclude = "OrcaUserName,FirstName,LastName,Email,PhoneNumber", Include = "OrcaUserID,UserType,IsActive,IsAccountDeactivated")] ChangeExpert expToChange) { if (ModelState.IsValid) { OrcaContext db = new OrcaContext(); int oid = expToChange.OrcaUserID; OrcaUser changeUser = db.OrcaUsers.Find(oid); changeUser.UserType = expToChange.UserType; changeUser.IsAccountDeactivated = expToChange.IsAccountDeactivated; db.Entry(changeUser).State = EntityState.Modified; db.SaveChanges(); ExpertConsultant expCon = db.ExpertConsultants.Find(oid); expCon.IsActive = expToChange.IsActive; db.Entry(expCon).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("CurrentExperts")); } return(View()); }
public ActionResult RemoveConsultantFromTicket(int consultantId, int ticketId) { ////System.Diagnostics.Debug.WriteLine("consultantId = " + consultantId + " | ticketId = " + ticketId); OrcaContext db = new OrcaContext(); // find the ticket expert associated with the ticket TicketExpert gettingId = (from exp in db.TicketExperts where exp.ExpertForThisTicket == consultantId && exp.TicketID == ticketId select exp).First(); int ticexpid = gettingId.TicketExpertID; TicketExpert expertToRemove = db.TicketExperts.Find(ticexpid); // disable expert on this ticket if (expertToRemove != null) { expertToRemove.TicketActivityState = ActivityState.Inactive; // update database update db db.Entry(expertToRemove).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("EditConsultationTicket", new { ticketId, id = ticketId })); }
public ActionResult AddConToTic(int id, int ticketId) { OrcaContext db = new OrcaContext(); List <TicketExpert> ticketExperts = db.TicketExperts.Where(ticEx => ticEx.TicketID == ticketId).ToList(); if (ticketExperts.Any(tic => tic.ExpertForThisTicket == id)) { TicketExpert expToEdit = new TicketExpert(); int ticExpId = ticketExperts.First(ticExp => ticExp.ExpertForThisTicket == id).TicketExpertID; expToEdit = db.TicketExperts.Find(ticExpId); expToEdit.TicketActivityState = ActivityState.Active; db.Entry(expToEdit).State = EntityState.Modified; db.SaveChanges(); } else { TicketExpert ticketExpert = new TicketExpert(); ticketExpert.TicketID = ticketId; ticketExpert.ExpertForThisTicket = id; ticketExpert.TicketActivityState = ActivityState.Active;// need to change db.TicketExperts.Add(ticketExpert); db.SaveChanges(); } return(RedirectToAction("EditConsulTationTicket", new { ticketId = ticketId })); }
public static PasswordChangeStatus ChangePassword(int OrcaUserID, PasswordChange passwordChange) { OrcaContext db = new OrcaContext(); OrcaPassword userPasswordQuery = null; // get the password from Passwords db table try { //OrcaPassword userPasswordQuery = (from user in db.OrcaPasswords // where user.OrcaUserID == OrcaUserID // select user).First(); userPasswordQuery = db.OrcaPasswords.AsQueryable().First(user => user.OrcaUserID == OrcaUserID); } catch (Exception)// if the OrcaUserID could not be found, return INVALID_USER { return(PasswordChangeStatus.INVALID_USER); } // make sure the proper original password was entered if (userPasswordQuery.Password == passwordChange.CurrentPassword) { // change the password userPasswordQuery.Password = passwordChange.Password; // update the database db.Entry(userPasswordQuery).State = EntityState.Modified; db.SaveChanges(); return(PasswordChangeStatus.SUCCESS); } return(PasswordChangeStatus.INVALID_PASSWORD); }
public ActionResult Edit([Bind(Include = "OrcaUserID,OrcaUserName,FirstName,LastName,Email,PhoneNumber,IsAccountDeactivated,UserType")] OrcaUser orcaUser) { if (ModelState.IsValid) { db.Entry(orcaUser).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(orcaUser)); }
public ActionResult Edit([Bind(Include = "OrcaUserID,ExpertStatus,IsActive,TitleDegree,KeyWordList")] ExpertConsultant expertConsultant) { if (ModelState.IsValid) { db.Entry(expertConsultant).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.OrcaUserID = new SelectList(db.OrcaUsers, "OrcaUserID", "OrcaUserName", expertConsultant.OrcaUserID); return(View(expertConsultant)); }
public ActionResult Edit([Bind(Include = "OrcaUserID,Password")] OrcaPassword orcaPassword) { if (ModelState.IsValid) { db.Entry(orcaPassword).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.OrcaUserID = new SelectList(db.OrcaUsers, "OrcaUserID", "OrcaUserName", orcaPassword.OrcaUserID); return(View(orcaPassword)); }
public ActionResult Edit([Bind(Include = "TicketEntryID,TicketID,OrcaUserID,EntryDTStamp,EntryText")] TicketEntry ticketEntry) { if (ModelState.IsValid) { db.Entry(ticketEntry).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.OrcaUserID = new SelectList(db.OrcaUsers, "OrcaUserID", "OrcaUserName", ticketEntry.OrcaUserID); ViewBag.TicketID = new SelectList(db.Tickets, "TicketID", "DescriptionName", ticketEntry.TicketID); return(View(ticketEntry)); }
public ActionResult Edit([Bind(Include = "TicketID,OrcaUserID,OrcaUserIDLastReplied,DTStamp,DescriptionName,IsTicketOpen")] Ticket ticket) { if (ModelState.IsValid) { db.Entry(ticket).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.OrcaUserID = new SelectList(db.OrcaUsers, "OrcaUserID", "OrcaUserName", ticket.OrcaUserID); ViewBag.OrcaUserIDLastReplied = new SelectList(db.OrcaUsers, "OrcaUserID", "OrcaUserName", ticket.OrcaUserIDLastReplied); return(View(ticket)); }
public ActionResult Edit([Bind(Include = "ConsultantExpertiseID,OrcaUserID,FieldOfExpertise")] ConsultantExpertise consultantExpertise) { if (ModelState.IsValid) { db.Entry(consultantExpertise).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.OrcaUserID = new SelectList(db.ExpertConsultants, "OrcaUserID", "TitleDegree", consultantExpertise.OrcaUserID); ViewBag.OrcaUserID = new SelectList(db.OrcaUsers, "OrcaUserID", "OrcaUserName", consultantExpertise.OrcaUserID); return(View(consultantExpertise)); }
public ActionResult Edit([Bind(Include = "TicketExpertID,TicketID,ExpertForThisTicket,TicketActivityState")] TicketExpert ticketExpert) { if (ModelState.IsValid) { db.Entry(ticketExpert).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ExpertForThisTicket = new SelectList(db.ExpertConsultants, "OrcaUserID", "TitleDegree", ticketExpert.ExpertForThisTicket); ViewBag.ExpertForThisTicket = new SelectList(db.OrcaUsers, "OrcaUserID", "OrcaUserName", ticketExpert.ExpertForThisTicket); ViewBag.TicketID = new SelectList(db.Tickets, "TicketID", "DescriptionName", ticketExpert.TicketID); return(View(ticketExpert)); }
public ActionResult AddConsultantToTicket(int consultantId, int ticketId, string sortOrder, string searchString) { OrcaContext db = new OrcaContext(); List <TicketExpert> ticketExperts = db.TicketExperts.Where(ticEx => ticEx.TicketID == ticketId).ToList(); //System.Diagnostics.Debug.WriteLine("AddConsultantToTicket ticketExperts.count = " + ticketExperts.Count); if (ticketExperts.Any(tic => tic.ExpertForThisTicket == consultantId)) { TicketExpert expToEdit = new TicketExpert(); int ticExpId = ticketExperts.First(ticExp => ticExp.ExpertForThisTicket == consultantId).TicketExpertID; expToEdit = db.TicketExperts.Find(ticExpId); expToEdit.TicketActivityState = ActivityState.Active; db.Entry(expToEdit).State = EntityState.Modified; db.SaveChanges(); //System.Diagnostics.Debug.WriteLine("AddConsultantToTicket UDATED expToEdit.TicketActivityState "); } else { TicketExpert ticketExpert = new TicketExpert(); ticketExpert.TicketID = ticketId; ticketExpert.ExpertForThisTicket = consultantId; ticketExpert.TicketActivityState = ActivityState.Active;// need to change db.TicketExperts.Add(ticketExpert); db.SaveChanges(); //System.Diagnostics.Debug.WriteLine("AddConsultantToTicket ADDED ticketExpert"); } return(RedirectToAction("EditConsulTationTicket", new { ticketId = ticketId })); }
public static UserProfile ChangeUserProfileInfo(UserProfile profileChanges) { OrcaContext db = new OrcaContext(); OrcaUser orcaUser = db.OrcaUsers.Find(profileChanges.OrcaUserID); if (orcaUser != null) { // update any allowed changes that may have been made orcaUser.FirstName = profileChanges.FirstName; orcaUser.LastName = profileChanges.LastName; orcaUser.Email = profileChanges.Email; orcaUser.PhoneNumber = profileChanges.PhoneNumber; // update the database db.Entry(orcaUser).State = EntityState.Modified; db.SaveChanges(); if (orcaUser.UserType == OrcaUserType.Consultant || orcaUser.UserType == OrcaUserType.ConsultantAdmin) { ExpertConsultant expertConsultant = db.ExpertConsultants.Find(orcaUser.OrcaUserID); if (expertConsultant != null) { // update any allowed changes that may have been made expertConsultant.TitleDegree = profileChanges.TitleDegree; expertConsultant.KeyWordList = profileChanges.KeyWordList; // IsActive is done this way to allow a drop down list for the profile view if (profileChanges.IsActive == ActiveStatus.Yes) { expertConsultant.IsActive = true; } else { expertConsultant.IsActive = false; } // update the database db.Entry(expertConsultant).State = EntityState.Modified; db.SaveChanges(); // this isn't pretty, but i was doing it this way while trying to figure out where a problem was occuring. since its done, i'll leave it alone for now, after all, it is a prototype // add the new field of expertise if it is entered if (!(String.IsNullOrEmpty(profileChanges.FieldToAdd) || String.IsNullOrWhiteSpace(profileChanges.FieldToAdd)))// make sure something was entered in FieldToAdd { // get a list of current expertises List <ConsultantExpertise> userExpertises = (from expertise in db.ConsultantExpertises where expertise.OrcaUserID == profileChanges.OrcaUserID select expertise).ToList(); if (userExpertises.Count() <= 0 || userExpertises.All(ex => ex.FieldOfExpertise != profileChanges.FieldToAdd))// make sure that we aren't duplicating any expertises { ConsultantExpertise newField = new ConsultantExpertise(); newField.OrcaUserID = profileChanges.OrcaUserID; newField.FieldOfExpertise = profileChanges.FieldToAdd; db.ConsultantExpertises.Add(newField); db.SaveChanges(); } } } } } return(profileChanges); }