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;
}
}
