private void button5_Click(object sender, EventArgs e)
{
//Add new master
CrewDetailsForm form = new CrewDetailsForm();
var rslt = form.ShowDialog();
if (rslt == DialogResult.OK)
{
fillMasters();
String searchValue = form.crewName;
int rowIndex = -1;
foreach (DataGridViewRow dgRow in adgvMasters.Rows)
{
if (dgRow.Cells["CREW_NAME"].Value.ToString().Equals(searchValue))
{
rowIndex = dgRow.Index;
break;
}
}
if (rowIndex >= 0)
{
adgvMasters.CurrentCell = adgvMasters[1, rowIndex];
}
}
}
private void editMaster()
{
if (adgvMasters.Rows.Count == 0)
{
return;
}
Guid crewGuid = MainForm.StrToGuid(adgvMasters.CurrentRow.Cells["CREW_GUID"].Value.ToString());
CrewDetailsForm form = new CrewDetailsForm();
form.crewGuid = crewGuid;
var rslt = form.ShowDialog();
if (rslt == DialogResult.OK)
{
if (form.wasChanged)
{
int visibleRow = adgvMasters.FirstDisplayedScrollingRowIndex;
int curRow = adgvMasters.CurrentCell.RowIndex;
int curCol = adgvMasters.CurrentCell.ColumnIndex;
fillMasters();
adgvMasters.FirstDisplayedScrollingRowIndex = visibleRow;
adgvMasters.CurrentCell = adgvMasters[curCol, curRow];
}
}
}
private void btnAddMaster_Click(object sender, EventArgs e)
{
//Add new master
CrewDetailsForm form = new CrewDetailsForm();
var rslt = form.ShowDialog();
if (rslt == DialogResult.OK)
{
fillMasters();
}
}
private void btnEditMaster_Click(object sender, EventArgs e)
{
//Edit master
if (cbMasterName.SelectedValue == null)
{
MessageBox.Show("You are able to edit just registered master record", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Guid masterGuid = MainForm.StrToGuid(cbMasterName.SelectedValue.ToString());
CrewDetailsForm form = new CrewDetailsForm();
form.crewGuid = masterGuid;
OleDbCommand cmd = new OleDbCommand("", connection);
cmd.CommandText =
"select * \n" +
"from CREW \n" +
"where CREW_GUID=" + MainForm.GuidToStr(masterGuid);
OleDbDataReader reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
reader.Close();
MessageBox.Show("Master with GUID=" + masterGuid.ToString() + " was not found in database", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
reader.Close();
var rslt = form.ShowDialog();
if (rslt == DialogResult.OK)
{
if (form.wasChanged)
{
fillMasters();
cbMasterName.Text = form.crewName;
}
}
}
private void btnInfo_Click(object sender, EventArgs e)
{
if (!CheckCrewExists())
{
MessageBox.Show("Unable to show details for \"" + cbCrewmember.Text + "\"", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
OleDbCommand cmd = new OleDbCommand("", MainForm.connection);
//Проверяем наличие имени в списке
cmd.CommandText =
"select Count(CREW_GUID) \n" +
"from CREW \n" +
"where \n" +
"CREW_NAME like '" + MainForm.StrToSQLStr(cbCrewmember.Text) + "' \n" +
"and CREW_POSITION_GUID=" + MainForm.GuidToStr(_positionGuid);
int recCount = (int)cmd.ExecuteScalar();
if (recCount == 0)
{
return;
}
if (_crewGuid == MainForm.zeroGuid)
{
if (recCount == 1)
{
cmd.CommandText =
"select CREW_GUID \n" +
"from CREW \n" +
"where \n" +
"CREW_NAME like '" + MainForm.StrToSQLStr(cbCrewmember.Text) + "' \n" +
"and CREW_POSITION_GUID=" + MainForm.GuidToStr(_positionGuid);
object x = cmd.ExecuteScalar();
try
{
_crewGuid = (Guid)x;
}
catch
{
MessageBox.Show("Unable to get crewmember GUID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
else
{
FormSelectCrewmemberFromList form = new FormSelectCrewmemberFromList();
form.crewmemberName = cbCrewmember.Text;
form.positionGuid = _positionGuid;
if (form.ShowDialog() == DialogResult.OK)
{
}
}
}
if (cbCrewmember.SelectedValue.ToString().Length > 0)
{
this.Cursor = Cursors.WaitCursor;
CrewDetailsForm form = new CrewDetailsForm();
//form.positionGuid = _positionGuid;
form.crewGuid = MainForm.StrToGuid(cbCrewmember.SelectedValue.ToString());
//form.crewmemberName = cbCrewmember.Text;
var rslt = form.ShowDialog();
if (rslt == DialogResult.OK)
{
FillCrewmembers(_positionGuid);
//Записываем имя в поле
cbCrewmember.Text = form.crewName;
}
this.Cursor = Cursors.Default;
}
}
