//Обновление строки private void UpdateDisability() { if (dgvDisability.CurrentRow == null) { return; } Disability disability = dgvDisability.CurrentRow.DataBoundItem as Disability; if (disability == null) { MessageBox.Show("Не знайдений рядок для оновлення", "Помилка"); return; } fmPersCardDisabilityEdit fmCardDisabilityEdit = new fmPersCardDisabilityEdit(EnumFormMode.Edit, "Зміна інтервалу"); fmCardDisabilityEdit.AddControlPeriod(disabilities); fmCardDisabilityEdit.SetData(disability); if (fmCardDisabilityEdit.ShowDialog() == DialogResult.OK) { disability = fmCardDisabilityEdit.GetData(); Disability findDisability = disabilities.FirstOrDefault(rec => rec.Disability_Id == disability.Disability_Id); if (findDisability == null) { MessageBox.Show("Не знайдений рядок для оновлення", "Помилка"); return; } findDisability.Disability_PerBeg = disability.Disability_PerBeg; findDisability.Disability_PerEnd = disability.Disability_PerEnd; findDisability.Disability_Attr = disability.Disability_Attr; RefreshTableDisability(); } }
//Создать строку вставки интервала инвалидности public string CreateStrInsertDisability(Disability disability) { if (disability == null) { return(string.Empty); } StringBuilder sql = new StringBuilder(); sql.Append(@"Insert into Disability (Disability_PersCard_Id"); if (disability.Disability_PerBeg != DateTime.MinValue) { sql.Append(@",Disability_PerBeg"); } if (disability.Disability_PerEnd != DateTime.MinValue) { sql.Append(@",Disability_PerEnd"); } sql.Append(@",Disability_Attr) values ("); sql.Append(disability.Disability_PersCard_Id); if (disability.Disability_PerBeg != DateTime.MinValue) { sql.AppendFormat(", {{d'{0}'}}", disability.Disability_PerBeg.ToString("yyyy-MM-dd")); } if (disability.Disability_PerEnd != DateTime.MinValue) { sql.AppendFormat(", {{d'{0}'}}", disability.Disability_PerEnd.ToString("yyyy-MM-dd")); } sql.AppendFormat(", {0} );", disability.Disability_Attr); return(sql.ToString()); }
private void ButtonAddDisability_Click(object sender, RoutedEventArgs e) { AreButtonsEnabled = false; string name = TextBoxDisabilityName.Text; if (string.IsNullOrEmpty(name) || string.IsNullOrWhiteSpace(name)) { MessageBox.Show("Debe ingresar un nombre", "Error", MessageBoxButton.OK, MessageBoxImage.Error); AreButtonsEnabled = true; return; } Disability disability = new Disability() { Name = name }; App.DbContext.Disabilities.Add(disability); try { App.DbContext.SaveChanges(); } catch { MessageBox.Show("No se pudieron guardar los cambios en la base de datos", "Error", MessageBoxButton.OK, MessageBoxImage.Error); AreButtonsEnabled = true; return; } MessageBox.Show("Discapacidad agregada con éxito", "Éxito", MessageBoxButton.OK, MessageBoxImage.Information); TextBoxDisabilityName.Text = string.Empty; Disabilities.Add(disability); AreButtonsEnabled = true; }
private void FillDataRec(SqlDataReader reader, Disability Disability) { int resInt = 0; DateTime resDate = DateTime.MinValue; if (int.TryParse(reader["Disability_Id"].ToString(), out resInt)) { Disability.Disability_Id = resInt; } if (int.TryParse(reader["Disability_PersCard_Id"].ToString(), out resInt)) { Disability.Disability_PersCard_Id = resInt; } if (DateTime.TryParse(reader["Disability_PerBeg"].ToString(), out resDate)) { Disability.Disability_PerBeg = resDate; } if (DateTime.TryParse(reader["Disability_PerEnd"].ToString(), out resDate)) { Disability.Disability_PerEnd = resDate; } if (int.TryParse(reader["Disability_Attr"].ToString(), out resInt)) { Disability.Disability_Attr = resInt; } }
public ActionResult DeleteConfirmed(int id) { Disability disability = db.Disabilities.Find(id); db.Disabilities.Remove(disability); db.SaveChanges(); return(RedirectToAction("Index")); }
public static DisabilityModel ToModel(this Disability entity) { return(new DisabilityModel { Id = entity.Id, Title = entity.Title }); }
public async Task <ActionResult> DeleteConfirmed(int id) { Disability disability = await _ctx.Disabilities.FindAsync(id); _ctx.Disabilities.Remove(disability); await _ctx.SaveChangesAsync(); return(RedirectToAction("Default")); }
public ActionResult Edit([Bind(Include = "ID,Disability1,DisabilityDescription,Remedies")] Disability disability) { if (ModelState.IsValid) { db.Entry(disability).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(disability)); }
public ActionResult Create([Bind(Include = "ID,Disability1,DisabilityDescription,Remedies")] Disability disability) { if (ModelState.IsValid) { db.Disabilities.Add(disability); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(disability)); }
public async Task <ActionResult> Edit(Disability disability) { if (ModelState.IsValid) { _ctx.Entry(disability).State = EntityState.Modified; await _ctx.SaveChangesAsync(); return(RedirectToAction("Default")); } return(View(disability)); }
private void InsertUpdate() { Disability objDisability = new Disability(); objDisability.DisablityId = ID; objDisability.Diablity = tbxName.Text; objDisability.Description = tbxDescription.Text; new bllDisablity().InsertUpdate(objDisability); new bllAudit().Insert("Setup", "InsertUpdate Disability", "Disability: " + tbxName.Text, User.Identity.Name); MessageController.Show("Saved successfully.", MessageType.Information, Page); }
public async Task <ActionResult> Create(Disability disability) { if (ModelState.IsValid) { _ctx.Disabilities.Add(disability); await _ctx.SaveChangesAsync(); return(RedirectToAction("Default")); } return(View(disability)); }
public void SetData(Disability disability) { _id = disability.Disability_Id; if (disability.Disability_PerBeg != DateTime.MinValue) { tbPerBeg.Text = disability.Disability_PerBeg.ToShortDateString(); } if (disability.Disability_PerEnd != DateTime.MinValue) { tbPerEnd.Text = disability.Disability_PerEnd.ToShortDateString(); } tbAttr.Text = disability.Disability_Attr.ToString(); }
// GET: Admin/DisabilityManagement/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Disability disability = await _ctx.Disabilities.FindAsync(id); if (disability == null) { return(HttpNotFound()); } return(View(disability)); }
// GET: Disabilities/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Disability disability = db.Disabilities.Find(id); if (disability == null) { return(HttpNotFound()); } return(View(disability)); }
//Получить интервалы инвалидности по параметрам public List <Disability> GetDisabilitiesByParams(int persCard_Id, out string error) { error = string.Empty; if (conn == null) { error = "conn == null"; return(null); } if (persCard_Id == 0) { error = "Не задані вхідні параметри"; return(null); } List <Disability> disabilities = new List <Disability>(); SqlCommand command = new SqlCommand(spDisabilitySelect, conn); command.CommandType = System.Data.CommandType.StoredProcedure; command.Connection = conn; command.Parameters.AddWithValue("@inDisability_PersCard_Id", persCard_Id); SqlDataReader reader = null; try { reader = command.ExecuteReader(); while (reader.Read()) { Disability disability = new Disability(); FillDataRec(reader, disability); disabilities.Add(disability); } } catch (Exception ex) { error = ex.Message; disabilities = null; } finally { if (reader != null) { reader.Close(); } } return(disabilities); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Disability = await _context.Disability.FirstOrDefaultAsync(m => m.DisabilityID == id); if (Disability == null) { return(NotFound()); } return(Page()); }
//Добавить интервал инвалидности public int AddDisability(Disability disability, out string error) { error = string.Empty; if (disability == null) { error = "disability == null"; return(0); } if (conn == null) { error = "conn == null"; return(0); } SqlCommand command = new SqlCommand(spDisabilityInsert, conn); command.CommandType = System.Data.CommandType.StoredProcedure; command.Connection = conn; command.Parameters.AddWithValue("@inDisability_PersCard_Id", disability.Disability_PersCard_Id == 0 ? Convert.DBNull : disability.Disability_PersCard_Id); command.Parameters.AddWithValue("@inDisability_PerBeg", disability.Disability_PerBeg == DateTime.MinValue ? Convert.DBNull : disability.Disability_PerBeg); command.Parameters.AddWithValue("@inDisability_PerEnd", disability.Disability_PerEnd == DateTime.MinValue ? Convert.DBNull : disability.Disability_PerEnd); command.Parameters.AddWithValue("@inDisability_Attr", disability.Disability_Attr); // определяем выходной параметр SqlParameter outId = new SqlParameter { ParameterName = "outId", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int }; command.Parameters.Add(outId); try { command.ExecuteNonQuery(); } catch (Exception ex) { error = ex.Message; return(0); } int id = 0; int.TryParse(command.Parameters["outId"].Value.ToString(), out id); return(id); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } Disability = await _context.Disability.FindAsync(id); if (Disability != null) { _context.Disability.Remove(Disability); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
/// <summary> /// Save the disabilities/support needs of the user for their application. /// </summary> /// <param name="application"></param> /// <param name="disabilities"></param> /// <param name="_ctx"></param> /// <returns></returns> public async Task SaveDisabilities(Application application, List <Disability> disabilities, StudentPortalContext _ctx) { await RemoveOldDisabilities(application, _ctx); foreach (var disability in disabilities) { if (disability.HasDisability) { Disability dis = await _ctx.Disabilities .FirstOrDefaultAsync(d => d.Name == disability.Name); _ctx.UserDisabilities.Add(new UserDisability { Disability = dis.Id, Application = application }); } } }
//Физическое удаление строки private void DeleteDisability() { if (dgvDisability.CurrentRow == null) { return; } if (MessageBox.Show("Ви впевнені, що бажаєте видалити обраний рядок?", "Видалення", MessageBoxButtons.YesNo) == DialogResult.No) { return; } Disability disability = dgvDisability.CurrentRow.DataBoundItem as Disability; if (disability == null) { MessageBox.Show("Не знайдений рядок для видалення", "Помилка"); return; } disabilities.Remove(disability); RefreshTableDisability(); }
//Получить интервалы инвалидности public List <Disability> GetAllDisabilities(out string error) { error = string.Empty; List <Disability> disabilities = new List <Disability>(); if (conn == null) { error = "conn == null"; return(disabilities); } SqlCommand command = new SqlCommand(spDisabilitySelect, conn); command.CommandType = CommandType.StoredProcedure; SqlDataReader reader = null; try { reader = command.ExecuteReader(); while (reader.Read()) { Disability Disability = new Disability(); FillDataRec(reader, Disability); disabilities.Add(Disability); } } catch (Exception exc) { error = exc.Message; } finally { if (reader != null) { reader.Close(); } } return(disabilities); }
//============================================================================================================================= // Инвалидность //============================================================================================================================= //Вставка строки private void InsertDisability() { fmPersCardDisabilityEdit fmDisabilityEdit = new fmPersCardDisabilityEdit(EnumFormMode.Insert, "Створення інтервалу"); fmDisabilityEdit.AddControlPeriod(disabilities); if (fmDisabilityEdit.ShowDialog() == DialogResult.OK) { Disability getDisability = fmDisabilityEdit.GetData(); if (disabilities.Count == 0) { getDisability.Disability_Id = 1; } else { getDisability.Disability_Id = disabilities.Max(rec => rec.Disability_Id) + 1; } getDisability.Disability_PersCard_Id = id; disabilities.Add(getDisability); RefreshTableDisability(); } }
public Task <int> PostDisability(Disability disability) { int result = 0; try { using (IDbConnection db = GetConnection()) { db.Open(); var p = new DynamicParameters(); p.Add("@AnyDisabilityId", disability.AnyDisabilityId, DbType.Int32, ParameterDirection.Input); p.Add("@AnyDisabilityOrNot", disability.AnyDisabilityOrNot, DbType.Boolean, ParameterDirection.Input); p.Add("@AnyDisabilityCreatedDate", disability.AnyDisabilityCreatedDate, DbType.Int32, ParameterDirection.Input); p.Add("@AnyDisabilityCreatedBy", disability.AnyDisabilityCreatedBy, DbType.Int32, ParameterDirection.Input); p.Add("@AnyDisabilityModifiedDate", disability.AnyDisabilityModifiedDate, DbType.DateTime, ParameterDirection.Input); p.Add("@AnyDisabilityModifiedBy", disability.AnyDisabilityModifiedBy, DbType.Int32, ParameterDirection.Input); p.Add("AnyDisabilityStatus", Convert.ToInt32(RecordStatus.Active), DbType.Int32, ParameterDirection.Input); if (disability.AnyDisabilityId == 0) { p.Add("@ActionType", Convert.ToInt32(ActionType.Add.ToString()), DbType.String, ParameterDirection.Input); } else { p.Add("@ActionType", Convert.ToInt32(ActionType.Update.ToString()), DbType.String, ParameterDirection.Input); } p.Add("@OutputData", disability.AnyDisabilityId, DbType.Int32, ParameterDirection.Input); result = db.Execute("usp_CRED_Disability", p, commandType: CommandType.StoredProcedure); } return(Task.FromResult(result)); } catch (Exception) { throw; } }
public Disability GetData() { Disability disability = new Disability(); disability.Disability_Id = _id; DateTime perBeg; DateTime.TryParse(tbPerBeg.Text, out perBeg); disability.Disability_PerBeg = perBeg; DateTime perEnd; DateTime.TryParse(tbPerEnd.Text, out perEnd); disability.Disability_PerEnd = perEnd; int attr = 0; int.TryParse(tbAttr.Text, out attr); disability.Disability_Attr = attr; return(disability); }
/// <summary> /// Pre-select any disabilities the user has identified in their application. /// </summary> /// <param name="application"></param> /// <param name="_ctx"></param> /// <returns></returns> public async Task <List <Disability> > SelectDisabilities(Application application, StudentPortalContext _ctx) { // List of available disabilities List <Disability> disabilities = await _ctx.Disabilities.ToListAsync(); // List of disabilities identified in the user's application List <UserDisability> userDisabilities = await _ctx.UserDisabilities .Where(u => u.Application.Id == application.Id) .ToListAsync(); // Flag any disabilities that the user has identified foreach (var disability in userDisabilities) { Disability dis = disabilities.FirstOrDefault(d => d.Id == disability.Disability); if (dis != null) { dis.HasDisability = true; } } return(disabilities); }
private void ButtonDeleteDisability_Click(object sender, RoutedEventArgs e) { AreButtonsEnabled = false; Button button = ((Button)sender); Disability disability = (Disability)button.DataContext; App.DbContext.Disabilities.Remove(disability); try { App.DbContext.SaveChanges(); MessageBox.Show("Discapacidad eliminada con éxito", "Éxito", MessageBoxButton.OK, MessageBoxImage.Information); } catch { MessageBox.Show("No se pudieron guardar los cambios en la base de datos", "Error", MessageBoxButton.OK, MessageBoxImage.Error); AreButtonsEnabled = true; return; } Disabilities.Remove(disability); AreButtonsEnabled = true; }
//Изменить интервал инвалидности public bool ModifyDisability(Disability disability, out string error) { error = string.Empty; if (conn == null) { error = "conn == null"; return(false); } if (disability == null) { error = "disability == null"; return(false); } SqlCommand command = new SqlCommand(spDisabilityUpdate, conn); command.CommandType = System.Data.CommandType.StoredProcedure; command.Connection = conn; command.Parameters.AddWithValue("@inDisability_Id", disability.Disability_Id); command.Parameters.AddWithValue("@inDisability_PersCard_Id", disability.Disability_PersCard_Id == 0 ? Convert.DBNull : disability.Disability_PersCard_Id); command.Parameters.AddWithValue("@inDisability_PerBeg", disability.Disability_PerBeg == DateTime.MinValue ? Convert.DBNull : disability.Disability_PerBeg); command.Parameters.AddWithValue("@inDisability_PerEnd", disability.Disability_PerEnd == DateTime.MinValue ? Convert.DBNull : disability.Disability_PerEnd); command.Parameters.AddWithValue("@inDisability_Attr", disability.Disability_Attr); try { command.ExecuteNonQuery(); } catch (Exception ex) { error = ex.Message; return(false); } return(true); }
public void Add(Student student) { lock (student) { if (Count == StudentId.Length) { var newLength = StudentId.Length + 1000; var _StudentId = new string[newLength]; StudentId.CopyTo(_StudentId); StudentId = _StudentId; var _IndexNumber = new string[newLength]; IndexNumber.CopyTo(_IndexNumber); IndexNumber = _IndexNumber; var _ReferenceNumber = new string[newLength]; ReferenceNumber.CopyTo(_ReferenceNumber); ReferenceNumber = _ReferenceNumber; var _Surname = new string[newLength]; Surname.CopyTo(_Surname); Surname = _Surname; var _Othernames = new string[newLength]; Othernames.CopyTo(_Othernames); Othernames = _Othernames; var _Title = new string[newLength]; Title.CopyTo(_Title); Title = _Title; var _Gender = new string[newLength]; Gender.CopyTo(_Gender); Gender = _Gender; var _MaritalStatus = new string[newLength]; MaritalStatus.CopyTo(_MaritalStatus); MaritalStatus = _MaritalStatus; var _DateofBirth = new string[newLength]; DateofBirth.CopyTo(_DateofBirth); DateofBirth = _DateofBirth; var _Disability = new bool[newLength]; Disability.CopyTo(_Disability); Disability = _Disability; var _Country = new string[newLength]; Country.CopyTo(_Country); Country = _Country; var _Region = new string[newLength]; Region.CopyTo(_Region); Region = _Region; var _HomeTown = new string[newLength]; HomeTown.CopyTo(_HomeTown); HomeTown = _HomeTown; var _Address1 = new string[newLength]; Address1.CopyTo(_Address1); Address1 = _Address1; var _Address2 = new string[newLength]; Address2.CopyTo(_Address2); Address2 = _Address2; var _Contact1 = new string[newLength]; Contact1.CopyTo(_Contact1); Contact1 = _Contact1; var _Contact2 = new string[newLength]; Contact2.CopyTo(_Contact2); Contact2 = _Contact2; var _PersonalEmail = new string[newLength]; PersonalEmail.CopyTo(_PersonalEmail); PersonalEmail = _PersonalEmail; var _UniversityEmail = new string[newLength]; UniversityEmail.CopyTo(_UniversityEmail); UniversityEmail = _UniversityEmail; var _ResidentialStatus = new string[newLength]; ResidentialStatus.CopyTo(_ResidentialStatus); ResidentialStatus = _ResidentialStatus; var _ProgramOfStudy = new string[newLength]; ProgramOfStudy.CopyTo(_ProgramOfStudy); ProgramOfStudy = _ProgramOfStudy; var _Specialization = new string[newLength]; Specialization.CopyTo(_Specialization); Specialization = _Specialization; var _ProgramStatus = new string[newLength]; ProgramStatus.CopyTo(_ProgramStatus); ProgramStatus = _ProgramStatus; var _Level = new string[newLength]; Level.CopyTo(_Level); Level = _Level; var _StudentType = new string[newLength]; StudentType.CopyTo(_StudentType); StudentType = _StudentType; var _EnrollmentOption = new string[newLength]; EnrollmentOption.CopyTo(_EnrollmentOption); EnrollmentOption = _EnrollmentOption; var _RegistrationStatus = new string[newLength]; RegistrationStatus.CopyTo(_RegistrationStatus); RegistrationStatus = _RegistrationStatus; var _DateOfEntry = new System.DateTime[newLength]; DateOfEntry.CopyTo(_DateOfEntry); DateOfEntry = _DateOfEntry; var _DateOfCompletion = new System.DateTime[newLength]; DateOfCompletion.CopyTo(_DateOfCompletion); DateOfCompletion = _DateOfCompletion; var _Results = new StudentResultDM[newLength];; Results.CopyTo(_Results); Results = _Results; var _RegisteredCourses = new RegisteredCourseDM[newLength]; RegisteredCourses.CopyTo(_RegisteredCourses); RegisteredCourses = _RegisteredCourses; var _EmergencyContact = new EmergencyContactDM[newLength]; EmergencyContact.CopyTo(_EmergencyContact); EmergencyContact = _EmergencyContact; var _Owning = new bool[newLength]; //Owning.CopyTo(_Owning); //Owning = _Owning; //var _FeesBalance = new string[newLength]; //FeesBalance.CopyTo(_FeesBalance); //FeesBalance = _FeesBalance; var _PamentOption = new string[newLength]; PamentOption.CopyTo(_PamentOption); PamentOption = _PamentOption; var _DepartmentId = new string[newLength]; DepartmentId.CopyTo(_DepartmentId); DepartmentId = _DepartmentId; var _State = new int[newLength]; State.CopyTo(_State); State = _State; } StudentId.Span[Count] = student.StudentId; IndexNumber.Span[Count] = student.IndexNumber; ReferenceNumber.Span[Count] = student.ReferenceNumber; Surname.Span[Count] = student.Surname; Othernames.Span[Count] = student.Othernames; Title.Span[Count] = student.Title; Gender.Span[Count] = student.Gender; MaritalStatus.Span[Count] = student.MaritalStatus; DateofBirth.Span[Count] = student.DateofBirth; Disability.Span[Count] = student.Disability; Country.Span[Count] = student.Country; Region.Span[Count] = student.Region; HomeTown.Span[Count] = student.HomeTown; Address1.Span[Count] = student.Address1; Address2.Span[Count] = student.Address2; Contact1.Span[Count] = student.Contact1; Contact2.Span[Count] = student.Contact2; PersonalEmail.Span[Count] = student.PersonalEmail; UniversityEmail.Span[Count] = student.UniversityEmail; ResidentialStatus.Span[Count] = student.ResidentialStatus; ProgramOfStudy.Span[Count] = student.ProgramOfStudy; Specialization.Span[Count] = student.Specialization; ProgramStatus.Span[Count] = student.ProgramStatus; Level.Span[Count] = student.Level; StudentType.Span[Count] = student.StudentType; EnrollmentOption.Span[Count] = student.EnrollmentOption; RegistrationStatus.Span[Count] = student.RegistrationStatus; DateOfEntry.Span[Count] = student.DateOfEntry; DateOfCompletion.Span[Count] = student.DateOfCompletion; //Owning.Span[Count] = student.Owning; //FeesBalance.Span[Count] = student.FeesBalance; PamentOption.Span[Count] = student.PamentOption; DepartmentId.Span[Count] = student.DepartmentId; State.Span[Count]++; Count++; Results.Span[Count] = new StudentResultDM(length); if (student.Results?.Count > 0) { foreach (var t in student.Results) { Results.Span[Count].Add(t); } } EmergencyContact.Span[Count] = new EmergencyContactDM(length); if (student.EmergencyContact?.Count > 0) { foreach (var t in student.EmergencyContact) { EmergencyContact.Span[Count].Add(t); } } RegisteredCourses.Span[Count] = new RegisteredCourseDM(length); if (student.RegisteredCourses?.Count > 0) { foreach (var t in student.RegisteredCourses) { RegisteredCourses.Span[Count].Add(t); } } } }
/// <summary> /// Initializes a new instance of the <see cref="PatientDisability"/> class. /// </summary> /// <param name="disability">The disability.</param> public PatientDisability( Disability disability ) { Check.IsNotNull ( disability, "Disability is required." ); _disability = disability; }
/// <summary> /// Initializes a new instance of the <see cref="PatientDisability"/> class. /// </summary> /// <param name="disability">The disability.</param> public PatientDisability(Disability disability) { Check.IsNotNull(disability, "Disability is required."); _disability = disability; }