public async Task <ActionResult <EmergencyContact> > PostEmergencyContact(EmergencyContact emergencyContact) { _context.EmergencyContacts.Add(emergencyContact); await _context.SaveChangesAsync(); return(CreatedAtAction("GetEmergencyContact", new { id = emergencyContact.Id }, emergencyContact)); }
public async Task <IActionResult> PutEmergencyContact(int id, EmergencyContact emergencyContact) { if (id != emergencyContact.EmergencyContactId) { return(StatusCode(StatusCodes.Status500InternalServerError, new Response { Status = "Error", Message = "El ID que intenta actualizar no existe" })); } try { await _emergencyContactDAO.UpdateAsync(emergencyContact); return(Ok(new Response { Status = "OK", Message = "Se ha actualizado correctamentee" })); } catch (DbUpdateConcurrencyException) { if (!await _emergencyContactDAO.ExistAsync(id)) { return(StatusCode(StatusCodes.Status500InternalServerError, new Response { Status = "Error", Message = "El ID que intenta actualizar no existe" })); } else { return(StatusCode(StatusCodes.Status500InternalServerError, new Response { Status = "Error", Message = "favor de verificar los campos" })); } } }
public override void Add(object objetType) { if (objetType is Doctor) { Doctor doctor = (Doctor)objetType; Student.Doctors.Add(doctor); } if (objetType is NextOfKin) { NextOfKin nextOfKin = (NextOfKin)objetType; Student.NextOfKin.Add(nextOfKin); } if (objetType is EmergencyContact) { EmergencyContact emergencyContact = (EmergencyContact)objetType; Student.EmergencyContacts.Add(emergencyContact); } if (objetType is MedicalCondition) { MedicalCondition medicalCondition = (MedicalCondition)objetType; Student.MedicalConditions.Add(medicalCondition); } if (objetType is StudentNote) { StudentNote studentNote = (StudentNote)objetType; Student.StudentNotes.Add(studentNote); } }
public ActionResult Create([Bind(Include = "ID,ContactID,EmployeeID,QualificationsID,Name,Password,Position,StaffType,EmailAddress,BranchName,ContactInformation,EmergencyContact")] Employee employee, EmployeeContacts employeeContact, EmergencyContact emergencyContact, EmployeeQualifications qualify, Schedules schedule, string[] Qualifications, string ID, string Name) { if (ModelState.IsValid) { for (int i = 0; i < Qualifications.Length; i++) { string results = Qualifications[i]; qualify.Qualifications = results; qualify.EmployeeID = ID; db.EmployeeQualifications.Add(qualify); db.SaveChanges(); } employeeContact.EmployeeID = ID; emergencyContact.EmployeeID = ID; //schedule.EmpId = Convert.ToInt32(ID); db.SaveChanges(); db.Employees.Add(employee); db.EmployeeContacts.Add(employeeContact); db.EmergencyContact.Add(emergencyContact); db.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }
public async Task <EmergencyContactResponse> UpdateAsync(int id, EmergencyContact emergencyContact) { var existingEmergencyContact = await _emergencyContactRepository.FindByIdAsync(id); if (existingEmergencyContact == null) { return(new EmergencyContactResponse("EmergencyContact not found")); } var bookingExists = await _emergencyContactRepository.BookingExists(emergencyContact.BookingID); if (!bookingExists) { return(new EmergencyContactResponse($"Booking ID:{ emergencyContact.BookingID } does not exist")); } existingEmergencyContact.BookingID = emergencyContact.BookingID; existingEmergencyContact.Name = emergencyContact.Name; existingEmergencyContact.LastName = emergencyContact.LastName; existingEmergencyContact.PhoneNumber = emergencyContact.PhoneNumber; try { _emergencyContactRepository.Update(existingEmergencyContact); await _unitOfWork.CompleteAsync(); return(new EmergencyContactResponse(existingEmergencyContact)); } catch (Exception e) { //TODO - log the exception return(new EmergencyContactResponse($"An error ocurred while updating the EmergencyContact: " + $"{ e.Message } { e.InnerException?.Message }")); } }
public async Task <IActionResult> Edit(int id, [Bind("EmergencyContactId,PrimaryOrSecondaryContact,EmerContactFirstName,EmerContactLastName,RelationshipToPatient,EmerContactDayPhone,EmerContactEveningPhone,EmerContactCellPhone,EmerContactEmail,EmerContactStreetAddress,EmerContactCity,EmerContactStateProvince,EmerContactZip,EmerContactCountry")] EmergencyContact emergencyContact) { if (id != emergencyContact.EmergencyContactId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(emergencyContact); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!EmergencyContactExists(emergencyContact.EmergencyContactId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(emergencyContact)); }
public async Task <IActionResult> PutEmergencyContact([FromRoute] int id, [FromBody] EmergencyContact emergencyContact) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != emergencyContact.Id) { return(BadRequest()); } _context.Entry(emergencyContact).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!EmergencyContactExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
protected void btnEmergDelete_Click(object sender, EventArgs e) { try { _presenter.CurrentAppUser.Employee.RemoveEmergencyContact(Convert.ToInt32(Session["emergContId"])); EmergencyContact delEmergContact = _presenter.GetEmergencyContact(Convert.ToInt32(Session["emergContId"])); if (delEmergContact != null) { _presenter.DeleteEmergencyContact(delEmergContact); } _presenter.SaveOrUpdateEmployee(_presenter.CurrentAppUser); Session["emergContId"] = null; //Clear the fields clearEmergencyContacts(); BindEmergencyContacts(); btnEmergDelete.Enabled = false; Master.ShowMessage(new AppMessage("Emergency Contact Information Is Successfully Deleted!", RMessageType.Info)); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "movetoemergency();", true); } catch (Exception ex) { Master.ShowMessage(new AppMessage("Error: While Deleting Emergency Contact!", RMessageType.Error)); ExceptionUtility.LogException(ex, ex.Source); ExceptionUtility.NotifySystemOps(ex, _presenter.CurrentUser().FullName); } }
public int AddEmergencyContacts(EmergencyContact emergency) { try { string query = string.Empty; using (IDbConnection connection = OpenConnection()) { var param = new DynamicParameters(); if (emergency != null) { query = StoredProcedure.AddEmergencyContacts; } // param.Add("@Retval", dbType: DbType.Int32, direction: ParameterDirection.ReturnValue); // param.Add("@Name", dbType: DbType.String); // param.Add("@employeeid", dbType: DbType.String, re); return(connection.Execute(query, emergency, commandType: CommandType.StoredProcedure)); } } catch (Exception ex) { return(0); } }
public ActionResult SubmitEmergencyContact(EmergencyContact contact) { Guid UserID = Guid.Parse(HttpContext.User.Identity.GetUserId()); using (UserContext db = new UserContext()) { var data = db.Users .Include(u => u.EmergencyContacts.Select(n => n.Name)) .Include(u => u.EmergencyContacts.Select(p => p.PhoneOne)) .Include(u => u.EmergencyContacts.Select(p => p.PhoneTwo)) .Where(u => u.UserID == UserID) .FirstOrDefault <UserModel>(); if (data.EmergencyContacts == null) { data.EmergencyContacts = new List <EmergencyContact>(); } contact.UserID = UserID; contact.Name.UserID = UserID; contact.PhoneOne.UserID = UserID; contact.PhoneTwo.UserID = UserID; data.EmergencyContacts.Add(contact); db.SaveChanges(); return(GetEmergencyContactsPartial(data.EmergencyContacts)); } }
public static bool addEmergencyContact(EmergencyContact ec) { DBConnector dbcon = new DBConnector(); //try //{ if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO emergency_contact (salutation, full_name, relation, nic_no, personal_address, official_address, personal_tp, official_tp, mobile_no, employee_no, int_ext, priority, employee_idemployee) VALUES (N'" + ec.salutation + "', N'" + ec.full_name + "', N'" + ec.relation + "', '" + ec.nic_no + "', N'" + ec.personal_address + "', N'" + ec.official_address + "', N'" + ec.personal_tp + "', N'" + ec.office_tp + "', N'" + ec.mobile_no + "', N'" + ec.employee_no + "', N'" + ec.int_ext + "', N'" + ec.priority + "', " + Employee.employee_id + ")"; cmd.Connection = dbcon.connection; cmd.Prepare(); cmd.ExecuteNonQuery(); dbcon.closeConnection(); return true; } else { dbcon.closeConnection(); return false; } //} //catch (MySqlException e) //{ //int errorcode = e.Number; //dbcon.closeConnection(); //return false; //} }
public IHttpActionResult PutEmergencyContactMaster(EmergencyContact emergencycontact) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { EmergencyContact objGen = new EmergencyContact(); objGen = objEntity.EmergencyContacts.Find(emergencycontact.EmergencyID); if (objGen != null) { objGen.EmergencyName = emergencycontact.EmergencyName; objGen.EmergencyContactNumber = emergencycontact.EmergencyContactNumber; objGen.EmergencyEmail = emergencycontact.EmergencyEmail; objGen.EmergencyAddress = emergencycontact.EmergencyAddress; } int i = objEntity.SaveChanges(); } catch (Exception) { throw; } return(Ok(emergencycontact)); }
private void SaveEmergencyContact(object sender, EventArgs e) { if (btnDeleteEmergencyContact.Text == "Edit") { var exisitngEmergencyContact = emergencyContactRepository.GetByPatientId(patientId); exisitngEmergencyContact.PatientId = Convert.ToInt32(txtPatientIdEmergencyContact.Text); exisitngEmergencyContact.FirstName = txtEcFirstname.Text; exisitngEmergencyContact.LastName = txtECLastName.Text; exisitngEmergencyContact.ContactNumber = txtECContactNumber.Text; if (emergencyContactRepository.Update(exisitngEmergencyContact) > 0) { MessageBox.Show("Updated Successfully"); } } else { var emergencyContact = new EmergencyContact(); emergencyContact.PatientId = Convert.ToInt32(txtPatientIdEmergencyContact.Text); emergencyContact.FirstName = txtEcFirstname.Text; emergencyContact.LastName = txtECLastName.Text; emergencyContact.ContactNumber = txtECContactNumber.Text; if (emergencyContactRepository.Add(emergencyContact) > 0) { MessageBox.Show("Saved Successfully."); } } FillDataGridView(); }
public async Task <EmergencyContact> UpdateAsync(EmergencyContact emergencyContact) { this.context.emergencyContacts.Update(emergencyContact); await SaveAllAsync(emergencyContact); return(emergencyContact); }
public async Task <EmergencyContact> CreateAsync(EmergencyContact emergencyContact) { await this.context.emergencyContacts.AddAsync(emergencyContact); await SaveAllAsync(emergencyContact); return(emergencyContact); }
public void DeleteEmergencyContact(EmergencyContact contact, out string errorMessage) { errorMessage = String.Empty; using (SqlConnection connection = new SqlConnection(LoginCredentials.ConnectionString)) { try { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "dbo.EmergencyContactDelete"; cmd.Parameters.AddWithValue("@EmergencyContactID", contact.EmergencyContactID); cmd.Connection = connection; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Connection.Open(); cmd.ExecuteScalar(); } } catch (Exception e) { errorMessage = "Error while deleting Emergency Contact: " + e.Message; } finally { connection.Close(); } } }
public async Task <IActionResult> Edit(int id, [Bind("Id,PetId,FirstName,LastName,HomePhone,CellPhone,WorkPhone")] EmergencyContact emergencyContact) { if (id != emergencyContact.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(emergencyContact); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!EmergencyContactExists(emergencyContact.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(emergencyContact)); }
public IHttpActionResult PutEmergencyContact(int id, EmergencyContact emergencyContact) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != emergencyContact.EmergencyContacts_id) { return(BadRequest()); } db.Entry(emergencyContact).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!EmergencyContactExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult Edit(ContactEditModel theContact) { Reply reply = new Reply(); String json = ""; var userID = User.Identity.GetUserId(); //get user ID UserEmergency userEmergency = new UserEmergency(); userEmergency.UserProfileId = userID; userEmergency.EmergencyContactPhone = theContact.pre.EmergencyContactPhone; userEmergency.ECname = theContact.pre.ECname; UserEmergency newContact = new UserEmergency(); newContact.UserProfileId = userID; newContact.EmergencyContactPhone = theContact.now.EmergencyContactPhone; newContact.ECname = theContact.now.ECname; if (ModelState.IsValid) { //Check does the phone exist if not store Contactphone to table EmergencyContacts EmergencyContact thisContact = db.EmergencyContact.Find(newContact.EmergencyContactPhone); if (thisContact == null) { createNewContact(newContact.EmergencyContactPhone); } //Check whether old userEmergency exist var result = db.UserEmergency.Find(userEmergency.EmergencyContactPhone, userEmergency.UserProfileId); if (result == null) { reply.result = "failed"; reply.errors = "Contact do not exist"; return(BadRequest(JsonConvert.SerializeObject(reply))); } var checkNew = db.UserEmergency.Find(newContact.EmergencyContactPhone, newContact.UserProfileId); if (checkNew != null && newContact.EmergencyContactPhone != userEmergency.EmergencyContactPhone) { reply.result = "failed"; reply.errors = "The contact phone number already exist"; return(BadRequest(JsonConvert.SerializeObject(reply))); } db.UserEmergency.Remove(result); db.UserEmergency.Add(newContact); db.SaveChanges(); reply.result = "Edit success"; json = JsonConvert.SerializeObject(reply); reply.result = "contact create, edit success"; json = JsonConvert.SerializeObject(reply); return(Ok(json)); } reply.result = "failed"; reply.errors = "Data Type not validate"; json = JsonConvert.SerializeObject(reply); return(Ok(json)); }
public static EmergencyContact getEmergencyContact() { //try //{ DBConnector dbcon = new DBConnector(); if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM emergency_contact WHERE employee_idemployee=" + Employee.employee_id; cmd.Connection = dbcon.connection; MySqlDataReader reader = cmd.ExecuteReader(); Console.Write(Employee.employee_id + "\n"); EmergencyContact ec = null; if (reader.Read()) { ec = new EmergencyContact(); ec.ec_id = int.Parse(reader["idemergency_contact"].ToString()); ec.full_name = reader["full_name"].ToString(); ec.int_ext = reader["int_ext"].ToString(); ec.mobile_no = reader["mobile_no"].ToString(); ec.nic_no = reader["nic_no"].ToString(); ec.office_tp = reader["official_tp"].ToString(); ec.official_address = reader["official_address"].ToString(); ec.personal_address = reader["personal_address"].ToString(); ec.personal_tp = reader["personal_tp"].ToString(); ec.priority = reader["priority"].ToString(); ec.relation = reader["relation"].ToString(); ec.salutation = reader["salutation"].ToString(); ec.employee_no = reader["employee_no"].ToString(); } reader.Close(); dbcon.closeConnection(); return ec; } else { return null; } //} //catch (MySqlException e) //{ //int errorcode = e.Number; //return null; //} }
public ActionResult DeleteConfirmed(string id) { EmergencyContact emergencyContact = db.EmergencyContact.Where(x => x.EmployeeID == id).FirstOrDefault(); db.EmergencyContact.Remove(emergencyContact); db.SaveChanges(); return(RedirectToAction("Index/" + emergencyContact.EmployeeID)); }
EmergencyContact ParseEmergencyContact(string contact) { EmergencyContact result = null; result = JsonConvert.DeserializeObject <EmergencyContact>(contact); return(result); }
public ActionResult EditEmergencyContacts(Int64 EmployeeNumber, EmergencyContact updateemergency) { EmergencyContactsService empService = new EmergencyContactsService(); String message = empService.UpdateEmergencyContactsDetails(updateemergency); return(RedirectToAction("GetAllEmployees", new { message })); }
public ActionResult DeleteConfirmed(int id) { EmergencyContact emergencyContact = db.EmergencyContacts.Find(id); db.EmergencyContacts.Remove(emergencyContact); db.SaveChanges(); return(RedirectToAction("Index")); }
// Delete Person by Id public void DeleteEmContactById(int id) { using (MyDbContext db = new MyDbContext()) { EmergencyContact emContactToGo = db.EmergencyContacts.Find(id); db.EmergencyContacts.Remove(emContactToGo); db.SaveChanges(); } }
public ActionResult GetAddEmergencyContact() { EmergencyContact contact = new EmergencyContact(); contact.Name = new Name(); contact.PhoneOne = new Phone(); contact.PhoneTwo = new Phone(); return(PartialView("_AddEmergencyContact", contact)); }
// Add Person public EmergencyContact AddNewEmContact(EmergencyContact person) { using (MyDbContext db = new MyDbContext()) { person = db.EmergencyContacts.Add(person); db.SaveChanges(); return(person); } }
public ActionResult Edit(EmergencyContact emergencyContact) { if (ModelState.IsValid) { emergencyContact = HRBusinessService.UpdateEmergencyContact(UserOrganisationId, emergencyContact); return(RedirectToAction("Profile", "Personnel", new { id = emergencyContact.PersonnelId })); } return(View(emergencyContact)); }
public ActionResult Update(EmergencyContactModel vm) { ApiResult <EmergencyContact> apiResult; if (ModelState.IsValid) { if (vm.Id > 0) { apiResult = TryExecute(() => { var emergencyContact = new EmergencyContact { Name = vm.Name, Relationship = vm.Relationship, Phone = vm.Phone, EmployeeId = vm.EmployeeId, Mobile = vm.Mobile, WorkPhone = vm.WorkPhone, Address = vm.Address, Email = vm.Email, Id = vm.Id, }; _emergencyContactRepository.Update(emergencyContact); _unitOfWork.Commit(); return(emergencyContact); }, "Emergency Contact updated sucessfully"); } else { apiResult = TryExecute(() => { var emergencyContact = new EmergencyContact { Name = vm.Name, Relationship = vm.Relationship, Phone = vm.Phone, EmployeeId = vm.EmployeeId, Mobile = vm.Mobile, WorkPhone = vm.WorkPhone, Address = vm.Address, Email = vm.Email, Id = vm.Id }; _emergencyContactRepository.Create(emergencyContact); _unitOfWork.Commit(); return(emergencyContact); }, "Emergency Contact created sucessfully"); } } else { apiResult = ApiResultFromModelErrors <EmergencyContact>(); } return(Json(apiResult, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit([Bind(Include = "ID,Name,Surname,CellNum")] EmergencyContact emergencyContact) { if (ModelState.IsValid) { db.Entry(emergencyContact).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(emergencyContact)); }
public ActionResult CreateEmergencyContacts(EmergencyContact emergency) { EmergencyContactsService emergencyService = new EmergencyContactsService(); emergency.EmployeeNumber = (Int64)Session["empId"]; //Employee employee = new Employee(); emergencyService.SaveEmergencyContacts(emergency); return(Json(emergency.EmployeeNumber)); }
public ActionResult Edit([Bind(Include = "Id,FirstName,LastName,StreetAddress,City,State,ZipCode,PhoneNumber")] EmergencyContact emergencyContact) { if (ModelState.IsValid) { db.Entry(emergencyContact).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(emergencyContact)); }
private void btnSave4_Click(object sender, EventArgs e) { //Save emergency contact details EmergencyContact ec = new EmergencyContact(); ec.employee_no = emg_employee_no.Text; ec.full_name = emg_full_name.Text; ec.int_ext = emg_int_ext.Text; ec.mobile_no = emg_mobile_no.Text; ec.nic_no = emg_nic_no.Text; ec.office_tp = emg_office_tp.Text; ec.official_address = emg_official_address.Text; ec.personal_address = emg_personal_address.Text; ec.personal_tp = emg_personal_tp.Text; ec.priority = emg_priority.Text; ec.relation = emg_relation.Text; ec.salutation = emg_salutation.Text; bool status = EmergencyContactHandler.addEmergencyContact(ec); if (status) { MessageBox.Show("Emergency contact added successfully...!"); btnSave5.Enabled = true; } else { MessageBox.Show("Failed to add emergency contact...!"); } }
public void updateEmergencyContact() { EmergencyContact ec = new EmergencyContact(); ec.ec_id = this.ec_id; ec.employee_no = this.emg_employee_no.Text; ec.full_name = this.emg_full_name.Text; ec.int_ext = this.emg_int_ext.Text; ec.mobile_no = this.emg_mobile_no.Text; ec.nic_no = this.emg_nic_no.Text; ec.office_tp = this.emg_office_tp.Text; ec.official_address = this.emg_official_address.Text; ec.personal_address = this.emg_personal_address.Text; ec.personal_tp = this.emg_personal_tp.Text; ec.priority = this.emg_priority.Text; ec.relation = this.emg_relation.Text; ec.salutation = this.emg_salutation.Text; bool state = EmergencyContactHandler.updateEmergencyContact(ec); Console.Write(state + "\n"); }
public static bool updateEmergencyContact(EmergencyContact ec) { //try //{ DBConnector dbcon = new DBConnector(); if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "UPDATE emergency_contact SET salutation=N'" + ec.salutation + "', full_name=N'" + ec.full_name + "', relation=N'" + ec.relation + "', nic_no=N'" + ec.nic_no + "', personal_address=N'" + ec.personal_address + "', official_address=N'" + ec.official_address + "', personal_tp=N'" + ec.personal_tp + "', official_tp=N'" + ec.office_tp + "', mobile_no=N'" + ec.mobile_no + "', employee_no=N'" + ec.employee_no + "', int_ext=N'" + ec.int_ext + "', priority=N'" + ec.priority + "' WHERE employee_idemployee=" + Employee.employee_id + " AND idemergency_contact=" + ec.ec_id; cmd.Connection = dbcon.connection; cmd.Prepare(); cmd.ExecuteNonQuery(); dbcon.closeConnection(); return true; } else { return false; } //} //catch (MySqlException e) //{ //int errorcode = e.Number; //return false; //} }