public static string GetName(StaffPosition pos) { switch (pos) { case StaffPosition.None: return("None"); case StaffPosition.Organizer: return("Organizer"); case StaffPosition.HeadJudge: return("Head Judge"); case StaffPosition.AssistantHeadJudge: return("Assistant Head Judge"); case StaffPosition.JudgeTeamLead: return("Floor Judge - Team Lead"); case StaffPosition.Judge: return("Floor Judge"); case StaffPosition.Scorekeeper: return("Scorekeeper"); case StaffPosition.EventManager: return("Event Manager"); case StaffPosition.EventStaff: return("Event Staff"); default: return(string.Empty); } }
private void gridView1_KeyDown(object sender, KeyEventArgs e) { StaffPosition staffPosition = utility.GetSelectedItem <StaffPosition>(); if (staffPosition == null) { return; } DialogResult result = FormUtility.MsgDelete(); if (result == DialogResult.Yes) { try { using (IUnitOfWork uow = new UnitOfWork()) { uow.StaffPositionRepository.Remove(staffPosition); uow.Commit(); } labelNotify1.SetText(UI.removesuccess, ToolBoxCS.LabelNotify.EnumStatus.Success); gridView1.DeleteSelectedRows(); } catch { labelNotify1.SetText(UI.removefailed, ToolBoxCS.LabelNotify.EnumStatus.Failed); } } }
public void Add(StaffPosition entity) { if (entity == null) { throw new ArgumentNullException("entity"); } Connection.Query("insert into StaffPosition(StaffPositionCode,StaffPositionName) values (@StaffPositionCode,@StaffPositionName)", entity, transaction: Transaction); }
public static StaffPosition GetById(Guid id) { using (DataContext db = new DataContext()) { StaffPosition model = db.StaffPositions.Find(id); return(model); } }
public double StaffPositionToYOffset(StaffPosition position) { var middleLinePosition = 4 * Metrics.HalfSpace; var offset = position.VerticalOffset * Metrics.HalfSpace; var cleffOffset = position.Clef == Clef.Bass ? Metrics.GrandStaffOffset : 0.0; return(middleLinePosition + cleffOffset - offset); }
public void Remove(StaffPosition entity) { if (entity == null) { throw new ArgumentNullException("entity"); } Remove(entity.StaffPositionId); //Delete(entity); }
protected void btnApply_Click(object sender, EventArgs e) { clsStaffCollection Staff = new clsStaffCollection(); StaffPosition.ReportByStaffPosition(txtFilter.Text); lstStaffList.DataSource = Staff.StaffList; lstStaffList.DataValueField = "StaffID"; lstStaffList.DataTextField = "StaffPosition"; lstStaffList.DataBind(); }
SymbolObject CreateNoteSymbol(StaffPosition notePosition, Duration duration, double tickOffset, bool highlighted = false) { //var secondOffset = notePosition.HorisontalOffset ? Metrics.SecondNoteOffset : 0.0; var secondOffset = 0.0; var y = VerticalLayout.StaffPositionToYOffset(notePosition); var xOffset = tickOffset + secondOffset; var noteOrigin = new Point(xOffset, y); var symbol = GetNoteheadSymbol(duration); return(new SymbolObject(noteOrigin, symbol, Metrics.GlyphSize, highlighted)); }
public void Update(StaffPosition entity) { if (entity == null) { throw new ArgumentNullException("entity"); } string update = string.Format(@"update StaffPosition set StaffPositionCode= @StaffPositionCode,StaffPositionName= @StaffPositionName where StaffPositionId = @StaffPositionId"); Connection.Execute(update, entity, transaction: Transaction); //Edit(entity); }
private void InsertOrUpdate(StaffPosition staffPosition, CRUD crud) { if (crud == CRUD.Insert) { utility.AddNewRow(staffPosition); } else { utility.UpdateRow(staffPosition); } gridView1.RefreshData(); }
public async Task <ActionResult <Staff> > PostStaff(Staff staff) { ClockStatus clockStatus = _context.ClockStatus.Find(staff.ClockStatus.Id); StaffPosition staffPosition = _context.StaffPosition.Find(staff.StaffPosition.Id); staff.ClockStatus = clockStatus; staff.StaffPosition = staffPosition; _context.Staff.Add(staff); await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(GetStaff), new { id = staff.Id }, staff)); }
public bool AddStaff(string name, string surname, DateTime dateOfBirth, StaffPosition position) { var staffPerson = new Person(name, surname, dateOfBirth); if (!_personRepo.AddPerson(staffPerson)) { return(false); } _context.Staff.Add(new Staff(_context.Persons.Find(staffPerson.PersonId), position)); _context.SaveChanges(); return(true); }
private void Fill() { StaffPositionsLogic positions = new StaffPositionsLogic(manager); StaffPosition position = positions.Get(Convert.ToInt32(id)); if (position != null) { NameTB.Text = position.Name; ActiveCB.Checked = position.Active; } //StaffTeam team = teams.Get(Convert.ToInt32(id)); //NameTB.Text = team.Name; }
public void StaffIDExtremeMax() { //create an instance of the class we want to create clsStaff AnStaff = new clsStaff(); //String variable to store an error message String Error = ""; //create some test data to pass to the method string StaffID = ""; StaffPosition = StaffPosition.PadRight(500, 'a'); // should fail //invoke the method Error = AnStaff.Valid(StaffPosition, StaffID, FirstName, StartDate, DateOfBirth); //test to see that the result is correct Assert.AreNotEqual(Error, ""); }
private void gridView1_DoubleClick(object sender, EventArgs e) { GridView gridView = sender as GridView; GridHitInfo hitInfo = gridView1.CalcHitInfo(gridView1.GridControl.PointToClient(MousePosition)); if (hitInfo.InRow || hitInfo.InRowCell) { StaffPosition staffPosition = utility.GetSelectedItem <StaffPosition>(); if (staffPosition == null) { return; } frmEditStaffPosition obj = new frmEditStaffPosition(staffPosition); obj.update = InsertOrUpdate; obj.ShowDialog(); } }
private void FillPositions() { StaffPositionsLogic positions = new StaffPositionsLogic(manager); PositionsCB.ValueMember = "ID"; PositionsCB.DisplayMember = "Name"; PositionsCB.DropDownStyle = ComboBoxStyle.DropDownList; StaffPosition none = new StaffPosition(); //none.ID = -1; none.Name = "- не вибрано -"; List <StaffPosition> list = new List <StaffPosition>(); list.Add(none); int StructureObjectId = Convert.ToInt32(PositionsCB.SelectedValue); list.AddRange(positions.GetAll()); PositionsCB.DataSource = list; }
public Staff(int staff_id, int person_id, string login, string pwd, int staff_position_id, int field_id, int costcentre_id, bool is_contractor, string tfn, string provider_number, bool is_fired, bool is_commission, decimal commission_percent, bool is_stakeholder, bool is_master_admin, bool is_admin, bool is_principal, bool is_provider, bool is_external, DateTime staff_date_added, DateTime start_date, DateTime end_date, string comment, int num_days_to_display_on_booking_screen, bool show_header_on_booking_screen, int bk_screen_field_id, bool bk_screen_show_key, bool enable_daily_reminder_sms, bool enable_daily_reminder_email, bool hide_booking_notes) { this.staff_id = staff_id; this.person = new Person(person_id); this.login = login; this.pwd = pwd; this.staffPosition = new StaffPosition(staff_position_id); this.field = new IDandDescr(field_id); this.costCentre = new CostCentre(costcentre_id); this.is_contractor = is_contractor; this.tfn = tfn; this.provider_number = provider_number; this.is_fired = is_fired; this.is_commission = is_commission; this.commission_percent = commission_percent; this.is_stakeholder = is_stakeholder; this.is_master_admin = is_master_admin; this.is_admin = is_admin; this.is_principal = is_principal; this.is_provider = is_provider; this.is_external = is_external; this.staff_date_added = staff_date_added; this.start_date = start_date; this.end_date = end_date; this.comment = comment; this.num_days_to_display_on_booking_screen = num_days_to_display_on_booking_screen; this.show_header_on_booking_screen = show_header_on_booking_screen; this.bk_screen_field = bk_screen_field_id == -1 ? null : new IDandDescr(bk_screen_field_id); this.bk_screen_show_key = bk_screen_show_key; this.enable_daily_reminder_sms = enable_daily_reminder_sms; this.enable_daily_reminder_email = enable_daily_reminder_email; this.hide_booking_notes = hide_booking_notes; }
private void btnSave_Click(object sender, EventArgs e) { StaffPosition staffPosition = new StaffPosition(); CoverObjectUtility.GetAutoBindingData(this, staffPosition); try { using (IUnitOfWork uow = new UnitOfWork()) { uow.StaffPositionRepository.Add(staffPosition); uow.Commit(); } if (insert != null) { insert(staffPosition, CRUD.Insert); } Close(); } catch { labelNotify1.SetText(UI.createfailed, ToolBoxCS.LabelNotify.EnumStatus.Failed); } }
private void FillPositions() { StaffPositionsLogic positions = new StaffPositionsLogic(manager); PositionsCB.ValueMember = "ID"; PositionsCB.DisplayMember = "Name"; PositionsCB.DropDownStyle = ComboBoxStyle.DropDownList; StaffPosition none = new StaffPosition(); //none.ID = -1; none.Name = "- не вибрано -"; List<StaffPosition> list = new List<StaffPosition>(); list.Add(none); int StructureObjectId = Convert.ToInt32(PositionsCB.SelectedValue); list.AddRange(positions.GetAll()); PositionsCB.DataSource = list; }
public AuthenicationAttribute(StaffPosition staffPosition) { _staffPosition = staffPosition; }
public Staff(Person person, StaffPosition position) { Person = person; Position = position; }
public bool EditStaff(int staffId, string name, string surname, DateTime dateOfBirth, StaffPosition position) { var staffFound = GetStaff(staffId); if (staffFound == null) { return(false); } if (_context.Staff.Count(stff => stff.Person.Name == name && stff.Person.Surname == surname && stff.Person.DateOfBirth.Value == dateOfBirth && stff.StaffId != staffId) >= 1) { return(false); } staffFound.Person.Name = name; staffFound.Person.Surname = surname; staffFound.Person.DateOfBirth = dateOfBirth; staffFound.Position = position; _context.SaveChanges(); return(true); }
public frmEditStaffPosition(StaffPosition staffPosition) { InitializeComponent(); this.staffPosition = staffPosition; }
// Удаление строки void RemoveRow() { var page = TabMain.SelectedTab; var grid = (DataGridView)page.Controls[0]; string table = page.Name.Split('_')[1]; /* Если выбелено более одной строки */ if (grid.SelectedRows.Count > 1) { // Получаем индексы выделенных ячеек int[] indexes = new int[grid.SelectedRows.Count]; for (int i = 0; i < grid.SelectedRows.Count; i++) { indexes[i] = grid.SelectedRows[i].Cells[0].Value.exToInt(); } if (new Remove(indexes, table, CheckMoreRelationships(table, indexes)).ShowDialog() == DialogResult.OK) { Base.RemoveRows(table, indexes); UpdateData(ROW_INDEX, true, true); // Обновление стобца } } /* Если выделена всего одна строка */ else { if (new Remove(CheckRelationships(table, ID)).ShowDialog() == DialogResult.OK) { try { switch (page.Name) { case "FPage_CarBrand": CarBrand.RemoveRow(ID); break; case "FPage_CarModel": CarModel.RemoveRow(ID); break; case "FPage_Cars": Cars.RemoveRow(ID); break; case "FPage_CarType": CarType.RemoveRow(ID); break; case "FPage_Drivers": Drivers.RemoveRow(ID); break; case "FPage_Organizations": Organisations.RemoveRow(ID); break; case "FPage_Staff": Staff.RemoveRow(ID); break; case "FPage_StaffPosition": StaffPosition.RemoveRow(ID); break; } UpdateData(ROW_INDEX, true); // Обновление стобца } catch (Exception e) { MessageBox.Show(e.Message, "Ошибка при удалении", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } } bool CheckRelationships(string initialTable, int id) { DataTable checkingTable = new DataTable(); OleDbDataAdapter adapter; // Проверка связанных таблиц using (var connection = new OleDbConnection(Base.DB_CONNECTION_STRING)) { /* +--------------------------------------------------+ * | NOTE | * +--------------------------------------------------+ * | | * | | * | Имеют связь и требуют обработки | * +--------------------------------------------------+ * | CarType -> Cars -> [TrackingLists] | * | CarBrand -> CarModel -> Cars -> [TrackingLists] | * | StaffPosition -> Staff -> [TrackingLists] | * | | * | Не имеют особой связи, и не требуют обработки | * +--------------------------------------------------+ * | Estimate -> [TrackingLists] | * | Drivers -> [TrackingLists] | * | organisations -> [TrackingLists] | * | | * | | * +--------------------------------------------------+ * | END NOTE | * +--------------------------------------------------+ */ connection.Open(); // Выборка из БД, в зависимости от активной таблицы switch (page.Name) { case "FPage_CarBrand": adapter = new OleDbDataAdapter($"SELECT * FROM CarModel WHERE Carmodel_brand={id}", connection); adapter.Fill(checkingTable); break; case "FPage_CarModel": adapter = new OleDbDataAdapter($"SELECT * FROM Cars WHERE Car_model={id}", connection); adapter.Fill(checkingTable); break; case "FPage_Cars": adapter = new OleDbDataAdapter($"SELECT * FROM Trackinglists WHERE Trackinglist_transport={id}", connection); adapter.Fill(checkingTable); break; case "FPage_CarType": adapter = new OleDbDataAdapter($"SELECT * FROM Cars WHERE Car_type={id}", connection); adapter.Fill(checkingTable); break; case "FPage_Drivers": adapter = new OleDbDataAdapter($"SELECT * FROM Trackinglists WHERE Trackinglist_driver={id}", connection); adapter.Fill(checkingTable); break; case "FPage_Organizations": adapter = new OleDbDataAdapter($"SELECT * FROM Trackinglists WHERE " + $"Trackinglist_organization={id} OR Trackinglist_organization_2={id}", connection); adapter.Fill(checkingTable); break; case "FPage_Staff": adapter = new OleDbDataAdapter($"SELECT * FROM Trackinglists WHERE " + $"Trackinglist_dispatcher={id} OR Trackinglist_medic={id} OR Trackinglist_mechanic={id}", connection); adapter.Fill(checkingTable); break; case "FPage_StaffPosition": adapter = new OleDbDataAdapter($"SELECT * FROM Staff WHERE Staff_position={id}", connection); adapter.Fill(checkingTable); break; } } if (checkingTable.Rows.Count != 0) { return(true); // Если есть строки то true } else { return(false); // Если нет строк то false } } bool CheckMoreRelationships(string initialTable, int[] values) { DataTable checkingTable = new DataTable(); OleDbDataAdapter adapter; #region Созданние строки запроса string CONDITION = ""; string CONDITION_COLUMN = "", CONDITION_COLUMN2 = "", CONDITION_COLUMN3 = ""; switch (page.Name) { case "FPage_CarBrand": CONDITION_COLUMN = "Carmodel_brand"; break; case "FPage_CarModel": CONDITION_COLUMN = "Car_model"; break; case "FPage_Cars": CONDITION_COLUMN = "Trackinglist_transport"; break; case "FPage_CarType": CONDITION_COLUMN = "Car_type"; break; case "FPage_Drivers": CONDITION_COLUMN = "Trackinglist_driver"; break; case "FPage_Organizations": CONDITION_COLUMN = "Trackinglist_organization"; CONDITION_COLUMN2 = "Trackinglist_organization_2"; break; case "FPage_Staff": CONDITION_COLUMN = "Trackinglist_dispatcher"; CONDITION_COLUMN2 = "Trackinglist_medic"; CONDITION_COLUMN3 = "Trackinglist_mechanic"; break; case "FPage_StaffPosition": CONDITION_COLUMN = "Staff_position"; break; } // Если в выборке только одно поле if (CONDITION_COLUMN2 == "" && CONDITION_COLUMN3 == "") { for (int i = 0; i < values.Length; i++) { CONDITION += CONDITION_COLUMN + "=" + values[i] + " OR "; } CONDITION = CONDITION.Remove(CONDITION.Length - 4); } // Если в выборке 2 поля else if (CONDITION_COLUMN2 != "" && CONDITION_COLUMN3 == "") { for (int i = 0; i < values.Length; i++) { CONDITION += CONDITION_COLUMN + "=" + values[i] + " OR "; } for (int i = 0; i < values.Length; i++) { CONDITION += CONDITION_COLUMN2 + "=" + values[i] + " OR "; } CONDITION = CONDITION.Remove(CONDITION.Length - 4); } // Если в выборке 3 поля else if (CONDITION_COLUMN2 != "" && CONDITION_COLUMN3 != "") { for (int i = 0; i < values.Length; i++) { CONDITION += CONDITION_COLUMN + "=" + values[i] + " OR "; } for (int i = 0; i < values.Length; i++) { CONDITION += CONDITION_COLUMN2 + "=" + values[i] + " OR "; } for (int i = 0; i < values.Length; i++) { CONDITION += CONDITION_COLUMN3 + "=" + values[i] + " OR "; } CONDITION = CONDITION.Remove(CONDITION.Length - 4); } #endregion // Проверка связанных таблиц using (var connection = new OleDbConnection(Base.DB_CONNECTION_STRING)) { /* +--------------------------------------------------+ * | NOTE | * +--------------------------------------------------+ * | | * | | * | Имеют связь и требуют обработки | * +--------------------------------------------------+ * | CarType -> Cars -> [TrackingLists] | * | CarBrand -> CarModel -> Cars -> [TrackingLists] | * | StaffPosition -> Staff -> [TrackingLists] | * | | * | Не имеют особой связи, и не требуют обработки | * +--------------------------------------------------+ * | Estimate -> [TrackingLists] | * | Drivers -> [TrackingLists] | * | organisations -> [TrackingLists] | * | | * | | * +--------------------------------------------------+ * | END NOTE | * +--------------------------------------------------+ */ connection.Open(); // Выборка из БД, в зависимости от активной таблицы switch (page.Name) { case "FPage_CarBrand": adapter = new OleDbDataAdapter($"SELECT * FROM CarModel WHERE {CONDITION}", connection); adapter.Fill(checkingTable); break; case "FPage_CarModel": adapter = new OleDbDataAdapter($"SELECT * FROM Cars WHERE {CONDITION}", connection); adapter.Fill(checkingTable); break; case "FPage_Cars": adapter = new OleDbDataAdapter($"SELECT * FROM Trackinglists WHERE {CONDITION}", connection); adapter.Fill(checkingTable); break; case "FPage_CarType": adapter = new OleDbDataAdapter($"SELECT * FROM Cars WHERE {CONDITION}", connection); adapter.Fill(checkingTable); break; case "FPage_Drivers": adapter = new OleDbDataAdapter($"SELECT * FROM Trackinglists WHERE {CONDITION}", connection); adapter.Fill(checkingTable); break; case "FPage_Organizations": adapter = new OleDbDataAdapter($"SELECT * FROM Trackinglists WHERE {CONDITION}", connection); adapter.Fill(checkingTable); break; case "FPage_Staff": adapter = new OleDbDataAdapter($"SELECT * FROM Trackinglists WHERE {CONDITION}", connection); adapter.Fill(checkingTable); break; case "FPage_StaffPosition": adapter = new OleDbDataAdapter($"SELECT * FROM Staff WHERE {CONDITION}", connection); adapter.Fill(checkingTable); break; } } if (checkingTable.Rows.Count != 0) { return(true); // Если есть строки то true } else { return(false); // Если нет строк то false } } }
// +---------------------------------------------------+ // | ОБНОВЛЕНИЕ ДАННЫХ | // +---------------------------------------------------+ private void Button_Save_Click(object sender, EventArgs e) { switch (TabMain.SelectedTab.Name) { case "FPage_CarBrand": CarBrand carBrand = new CarBrand { BrandName = textBox1.Text }; carBrand.EditRow(ID); break; case "FPage_CarModel": CarModel carModel = new CarModel { Brand = comboBox1.SelectedValue.ToString(), ModelName = textBox2.Text }; carModel.EditRow(ID); break; case "FPage_Cars": Cars cars = new Cars { Model = comboBox2.SelectedValue.ToString(), Number = textBox3.Text, InvNumber = textBox4.Text, Type = comboBox3.SelectedValue.ToString() }; cars.EditRow(ID); break; case "FPage_CarType": CarType carType = new CarType { TypeCode = textBox5.Text, TypeName = textBox6.Text, Capacity = textBox7.Text, InWorkRate = textBox33.Text, InWaitRate = textBox32.Text }; carType.EditRow(ID); break; case "FPage_Drivers": Drivers drivers = new Drivers { FirstName = textBox9.Text, LastName = textBox8.Text, ThirdName = textBox10.Text, Licence = textBox11.Text, Class = textBox16.Text }; drivers.EditRow(ID); break; case "FPage_Estimate": Estimate estimate = new Estimate { PacketNumber = textBox13.Text, Order = textBox14.Text, TrackinglistNum = comboBox4.SelectedValue.ToString(), TrackinglistDate = dateTimePicker1.Value.ToShortDateString(), Lot = textBox15.Text, Duration = textBox12.Text, InWorkTime = textBox24.Text, InWorkRate = textBox25.Text, InWorkHols = textBox26.Text, InWorkPrice = textBox31.Text, InWaitTime = textBox29.Text, InWaitRate = textBox30.Text, InWaitHols = textBox27.Text, InWaitPrice = textBox28.Text, FinalPrice = textBox35.Text }; estimate.EditRow(ID); break; case "FPage_Organizations": Organisations organisations = new Organisations { Name = textBox17.Text, Ratio = comboBox5.SelectedIndex.ToString() }; organisations.EditRow(ID); break; case "FPage_Staff": Staff staff = new Staff { FirstName = textBox20.Text, LastName = textBox21.Text, ThirdName = textBox19.Text, Position = comboBox6.SelectedValue.ToString() }; staff.EditRow(ID); break; case "FPage_StaffPosition": StaffPosition staffPosition = new StaffPosition { PositionName = textBox18.Text }; staffPosition.EditRow(ID); break; case "FPage_Trackinglists": Trackinglists trackinglists = new Trackinglists { Series = textBox22.Text, Number = textBox23.Text, Date = dateTimePicker2.Value.ToShortDateString(), Organization = comboBox7.SelectedValue.ToString(), Transport = comboBox8.SelectedValue.ToString(), Driver = comboBox9.SelectedValue.ToString(), Dispatcher = comboBox10.SelectedValue.ToString(), Medic = comboBox11.SelectedValue.ToString(), Mechanic = comboBox12.SelectedValue.ToString(), Organization_2 = comboBox13.SelectedValue.ToString(), Organization_3 = comboBox14.SelectedValue.ToString() }; trackinglists.EditRow(ID); break; } }