private void simpleButton1_Click(object sender, EventArgs e)
{
int j = gridView2.DataRowCount + 1;
for (int i = 0; i < j; i++)
{
gridView2.MoveFirst();
gridView2.DeleteRow(gridView2.FocusedRowHandle);
}
foreach (int val in gridView1.GetSelectedRows())
{
gridView2.AddNewRow();
gridView2.SetFocusedRowCellValue("CODE", ImageComboBoxEditCopyCode.EditValue);
gridView2.SetFocusedRowCellValue("STATUS", gridView1.GetRowCellValue(val, "STATUS"));
gridView2.SetFocusedRowCellValue("CAT", gridView1.GetRowCellValue(val, "CAT"));
gridView2.SetFocusedRowCellValue("DATE", gridView1.GetRowCellValue(val, "DATE"));
gridView2.SetFocusedRowCellValue("LAST_UPD", gridView1.GetRowCellValue(val, "LAST_UPD"));
gridView2.SetFocusedRowCellValue("UPD_BY", gridView1.GetRowCellValue(val, "UPD_BY"));
}
gridView2.Focus();
gridView1.Focus();
if (checkEdit1.Checked)
{
if (MessageBox.Show("Are you sure you want to delete the original records?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
gridView1.DeleteSelectedRows();
context.SaveChanges();
}
}
}
private void grdSelDel_Click(object sender, EventArgs e)
{
int handle = gridView1.FocusedRowHandle;
BookSelBindingSource.RemoveAt(handle);
context.SaveChanges();
//gridView1.DeleteRow(handle);
}
private bool SaveRecord(bool prompt)
{
try
{
if (_selectedRecord == null)
{
return(true);
}
FinalizeBindings();
bool newRec = _selectedRecord.IsNew();
bool modified = newRec || IsModified(_selectedRecord);
if (modified)
{
if (prompt)
{
DialogResult result = DisplayHelper.QuestionYesNoCancel(this, "Do you want to save these changes?");
if (result == DialogResult.No)
{
if (newRec)
{
RemoveRecord();
}
else
{
RefreshRecord();
}
return(true);
}
else if (result == DialogResult.Cancel)
{
return(false);
}
}
if (!ValidateAll())
{
return(false);
}
if (_selectedRecord.EntityState == EntityState.Detached)
{
_context.PACKTYPE.AddObject(_selectedRecord);
}
_context.SaveChanges();
ShowActionConfirmation("Record Saved");
}
return(true);
}
catch (Exception ex)
{
DisplayHelper.DisplayError(this, ex);
RefreshRecord(); //pull it back from db because that is its current state
//We must also Load and rebind the related entities from the db because context.Refresh doesn't do that
SetBindings();
return(false);
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
int j = gridView2.DataRowCount + 1;
for (int i = 0; i < j; i++)
{
gridView2.MoveFirst();
gridView2.DeleteRow(gridView2.FocusedRowHandle);
}
foreach (int val in gridView1.GetSelectedRows())
{
gridView2.AddNewRow();
gridView2.SetFocusedRowCellValue("CODE", ImageComboBoxEditLoadCode.EditValue);
gridView2.SetFocusedRowCellValue("AGENCY", gridView1.GetRowCellValue(val, "AGENCY"));
gridView2.SetFocusedRowCellValue("CAT", gridView1.GetRowCellValue(val, "CAT"));
gridView2.SetFocusedRowCellValue("ID", gridView1.GetRowCellValue(val, "ID"));
gridView2.SetFocusedRowCellValue("START_DATE", gridView1.GetRowCellValue(val, "START_DATE"));
gridView2.SetFocusedRowCellValue("END_DATE", gridView1.GetRowCellValue(val, "END_DATE"));
gridView2.SetFocusedRowCellValue("YEAR", gridView1.GetRowCellValue(val, "YEAR"));
gridView2.SetFocusedRowCellValue("H_L", gridView1.GetRowCellValue(val, "H_L"));
gridView2.SetFocusedRowCellValue("OFF", gridView1.GetRowCellValue(val, "OFF"));
gridView2.SetFocusedRowCellValue("LAST_UPD", gridView1.GetRowCellValue(val, "LAST_UPD"));
gridView2.SetFocusedRowCellValue("UPD_INIT", gridView1.GetRowCellValue(val, "UPD_INIT"));
gridView2.SetFocusedRowCellValue("DESCRIPTION", gridView1.GetRowCellValue(val, "DESCRIPTION"));
gridView2.SetFocusedRowCellValue("GWKLY_RATE", gridView1.GetRowCellValue(val, "GWKLY_RATE"));
gridView2.SetFocusedRowCellValue("GDAY_RATE", gridView1.GetRowCellValue(val, "GDAY_RATE"));
gridView2.SetFocusedRowCellValue("GXTRA_RATE", gridView1.GetRowCellValue(val, "GXTRA_RATE"));
gridView2.SetFocusedRowCellValue("GADNL_DRVR", gridView1.GetRowCellValue(val, "GADNL_DRVR"));
gridView2.SetFocusedRowCellValue("GUNDR_AGE", gridView1.GetRowCellValue(val, "GUNDR_AGE"));
gridView2.SetFocusedRowCellValue("NWKLY_RATE", gridView1.GetRowCellValue(val, "NWKLY_RATE"));
gridView2.SetFocusedRowCellValue("NDAY_RATE", gridView1.GetRowCellValue(val, "NDAY_RATE"));
gridView2.SetFocusedRowCellValue("NXTRA_RATE", gridView1.GetRowCellValue(val, "NXTRA_RATE"));
gridView2.SetFocusedRowCellValue("NADNL_DRVR", gridView1.GetRowCellValue(val, "NADNL_DRVR"));
gridView2.SetFocusedRowCellValue("NUNDR_AGE", gridView1.GetRowCellValue(val, "NUNDR_AGE"));
gridView2.SetFocusedRowCellValue("WKMIN_DAYS", gridView1.GetRowCellValue(val, "WKMIN_DAYS"));
gridView2.SetFocusedRowCellValue("WKMAX_DAYS", gridView1.GetRowCellValue(val, "WKMAX_DAYS"));
gridView2.SetFocusedRowCellValue("COMM_FLG", gridView1.GetRowCellValue(val, "COMM_FLG"));
gridView2.SetFocusedRowCellValue("COMM_PCT", gridView1.GetRowCellValue(val, "COMM_PCT"));
}
gridView2.Focus();
gridView1.Focus();
if (checkEdit1.Checked)
{
if (MessageBox.Show("Are you sure you want to delete the original records?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
gridView1.DeleteSelectedRows();
context.SaveChanges();
}
}
}
private void menuConfigParentBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure you want to save these changes?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
menuConfigParentBindingSource.EndEdit();
context.SaveChanges();
panelControlStatus.Visible = true;
LabelStatus.Text = "Record Saved";
rowStatusSave = new Timer();
rowStatusSave.Interval = 3000;
rowStatusSave.Start();
rowStatusSave.Tick += TimedEventSave;
}
}
private void DeleteRecord()
{
if (_selectedRecord == null)
{
return;
}
try {
if (DisplayHelper.QuestionYesNo(this, "Are you sure you want to delete this record?") == DialogResult.Yes)
{
//ignoreLeaveRow and ignorePositionChange are set because when removing a record, the bindingsource_currentchanged
//and gridview_beforeleaverow events will fire as the current record is removed out from under them.
//We do not want these events to perform their usual code of checking whether there are changes in the active
//record that should be saved before proceeding, because we know we have just deleted the active record.
_ignoreLeaveRow = true;
_ignorePositionChange = true;
RemoveRecord();
if (!_selectedRecord.IsNew())
{
//Apparently a record which has just been added is not flagged for deletion by BindingSource.RemoveCurrent,
//(the EntityState remains unchanged). It seems like it is not tracked by the context even though it is, because
//the EntityState changes for modification. So if this is a deletion and the entity is not flagged for deletion,
//delete it manually.
if (_selectedRecord != null && (_selectedRecord.EntityState & EntityState.Deleted) != EntityState.Deleted)
{
_context.CITYCOD.DeleteObject(_selectedRecord);
}
_context.SaveChanges();
}
if (GridViewLookup.DataRowCount == 0)
{
ClearBindings();
}
_ignoreLeaveRow = false;
_ignorePositionChange = false;
SetBindings();
EntityInstantFeedbackSource.Refresh();
ShowActionConfirmation("Record Deleted");
}
}
catch (Exception ex) {
DisplayHelper.DisplayError(this, ex);
_ignoreLeaveRow = false;
_ignorePositionChange = false;
RefreshRecord(); //pull it back from db because that is it's current state
//We must also Load and rebind the related entities from the db because context.Refresh doesn't do that
SetBindings();
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
int j = gridView2.DataRowCount + 1;
for (int i = 0; i < j; i++)
{
gridView2.MoveFirst();
gridView2.DeleteRow(gridView2.FocusedRowHandle);
}
foreach (int val in gridView1.GetSelectedRows())
{
gridView2.AddNewRow();
gridView2.SetFocusedRowCellValue("TYPE", tYPEComboBoxEdit.Text);
gridView2.SetFocusedRowCellValue("CODE", copyCodeSearch.Text);
gridView2.SetFocusedRowCellValue("CAT", gridView1.GetRowCellValue(val, "CAT"));
gridView2.SetFocusedRowCellValue("TP", gridView1.GetRowCellValue(val, "TP"));
gridView2.SetFocusedRowCellValue("DATE", gridView1.GetRowCellValue(val, "DATE"));
gridView2.SetFocusedRowCellValue("UPD_DATE", DateTime.Now);
gridView2.SetFocusedRowCellValue("UPD_BY", username);
gridView2.SetFocusedRowCellValue("ORIG_AMT", gridView1.GetRowCellValue(val, "ORIG_AMT"));
gridView2.SetFocusedRowCellValue("AV_AMT", gridView1.GetRowCellValue(val, "AV_AMT"));
gridView2.SetFocusedRowCellValue("AV", gridView1.GetRowCellValue(val, "AV"));
gridView2.SetFocusedRowCellValue("MIN", gridView1.GetRowCellValue(val, "MIN"));
gridView2.SetFocusedRowCellValue("CANC", gridView1.GetRowCellValue(val, "CANC"));
gridView2.SetFocusedRowCellValue("REL", gridView1.GetRowCellValue(val, "REL"));
gridView2.SetFocusedRowCellValue("AGENCY", gridView1.GetRowCellValue(val, "AGENCY"));
gridView2.SetFocusedRowCellValue("RELCODE", gridView1.GetRowCellValue(val, "RELCODE"));
gridView2.SetFocusedRowCellValue("RELCAT", gridView1.GetRowCellValue(val, "RELCAT"));
gridView2.SetFocusedRowCellValue("RELTYP", gridView1.GetRowCellValue(val, "RELTYP"));
gridView2.SetFocusedRowCellValue("RELAGY", gridView1.GetRowCellValue(val, "RELAGY"));
gridView2.SetFocusedRowCellValue("ALLOCTD", gridView1.GetRowCellValue(val, "ALLOCTD"));
gridView2.SetFocusedRowCellValue("HOLD", gridView1.GetRowCellValue(val, "HOLD"));
gridView2.SetFocusedRowCellValue("MIN_BK_DAYS", gridView1.GetRowCellValue(val, "MIN_BK_DAYS"));
gridView2.SetFocusedRowCellValue("MAX", gridView1.GetRowCellValue(val, "MAX"));
gridView2.SetFocusedRowCellValue("Requestable", gridView1.GetRowCellValue(val, "Requestable"));
}
gridView2.Focus();
gridView1.Focus();
if (checkEdit1.Checked)
{
if (MessageBox.Show("Are you sure you want to delete the original records?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
gridView1.DeleteSelectedRows();
context.SaveChanges();
}
}
}
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
{
if (DeptBindingSource.Current == null)
{
return;
}
GridViewDept.CloseEditor();
if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
modified = false;
newRec = false;
DeptBindingSource.RemoveCurrent();
errorProvider1.Clear();
context.SaveChanges();
panelControlStatus.Visible = true;
LabelStatus.Text = "Record Deleted";
rowStatusDelete = new Timer();
rowStatusDelete.Interval = 3000;
rowStatusDelete.Start();
rowStatusDelete.Tick += new EventHandler(TimedEventDelete);
}
//ockGrid(true);
setReadOnly(true);
codeTextBox.Focus();
currentVal = codeTextBox.Text;
modified = false;
newRec = false;
}
private void digItmSav_Click(object sender, EventArgs e)
{
DigItmBindingSource.EndEdit();
context.SaveChanges();
this.Close();
//regular save button routine
}
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
{
if (DigHdrBindingSource.Current == null)
{
return;
}
gridView1.CloseEditor();
if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
modified = false;
newRec = false;
DigHdrBindingSource.RemoveCurrent();
errorProvider1.Clear();
context.SaveChanges();
agencySearch.ButtonEdit.Properties.ReadOnly = true;
cOUP_RESTextEdit.Properties.ReadOnly = true;
panelControlStatus.Visible = true;
LabelStatus.Text = "Record Deleted";
rowStatusDelete = new Timer();
rowStatusDelete.Interval = 3000;
rowStatusDelete.Start();
rowStatusDelete.Tick += new EventHandler(TimedEventDelete);
}
agencySearch.Focus();
}
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
{
if (BusTableBindingSource.Current == null)
{
return;
}
GridViewBusTable.CloseEditor();
if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
modified = false;
newRec = false;
BusTableBindingSource.RemoveCurrent();
errorProvider1.Clear();
context.SaveChanges();
panelControlStatus.Visible = true;
LabelStatus.Text = "Record Deleted";
rowStatusDelete = new Timer();
rowStatusDelete.Interval = 3000;
rowStatusDelete.Start();
rowStatusDelete.Tick += new EventHandler(TimedEventDelete);
}
currentVal = ImageComboBoxEditCode.EditValue.ToString();
modified = false;
newRec = false;
}
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
{
if (VoucherBindingSource.Current == null)
{
return;
}
GridViewVouch.CloseEditor();
if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
modified = false;
newRec = false;
VoucherBindingSource.RemoveCurrent();
errorProvider1.Clear();
context.SaveChanges();
//agyNoTextEdit.Properties.ReadOnly = true;
//gridView1.Columns.ColumnByName(colName1).OptionsColumn.AllowEdit = false;
panelControlStatus.Visible = true;
LabelStatus.Text = "Record Deleted";
rowStatusDelete = new Timer();
rowStatusDelete.Interval = 3000;
rowStatusDelete.Start();
rowStatusDelete.Tick += new EventHandler(TimedEventDelete);
}
currentVal = TextEditAgyNo.Text;
}
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
{
if (CarRateBindingSource.Current == null)
{
return;
}
if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
modified = false;
newRec = false;
CarRateBindingSource.RemoveCurrent();
errorProvider1.Clear();
context.SaveChanges();
sTART_DATEDateEdit.Properties.ReadOnly = true;
setReadOnly(true);
panelControlStatus.Visible = true;
LabelStatus.Text = "Record Deleted";
rowStatusDelete = new Timer();
rowStatusDelete.Interval = 3000;
rowStatusDelete.Start();
rowStatusDelete.Tick += new EventHandler(TimedEventDelete);
}
ImageComboBoxEditCode.Focus();//currentVal
currentVal = ImageComboBoxEditCode.Text;
modified = false;
newRec = false;
}
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
{
if (UsersBindingSource.Current == null)
{
return;
}
GridViewUsers.CloseEditor();
if (XtraMessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
ignoreLeaveRow = true;
RemoveRecord();
errorProvider1.Clear();
if (!newRec)
{
context.SaveChanges();
}
ignoreLeaveRow = false;
modified = false;
newRec = false;
setReadOnly(true);
panelControlStatus.Visible = true;
LabelStatus.Text = "Record Deleted";
rowStatusDelete = new Timer();
rowStatusDelete.Interval = 3000;
rowStatusDelete.Start();
rowStatusDelete.Tick += new EventHandler(TimedEventDelete);
}
currentVal = TextEditUser.Text;
}
private void simpleButton1_Click(object sender, EventArgs e)
{
int j = gridView2.DataRowCount + 1;
for (int i = 0; i < j; i++)
{
gridView2.MoveFirst();
gridView2.DeleteRow(gridView2.FocusedRowHandle);
}
foreach (int val in gridView1.GetSelectedRows())
{
gridView2.AddNewRow();
gridView2.SetFocusedRowCellValue("CODE", ImageComboBoxEditCopyCode.EditValue);
gridView2.SetFocusedRowCellValue("AGENCY", gridView1.GetRowCellValue(val, "AGENCY"));
gridView2.SetFocusedRowCellValue("CAT", gridView1.GetRowCellValue(val, "CAT"));
gridView2.SetFocusedRowCellValue("START_DATE", gridView1.GetRowCellValue(val, "START_DATE"));
gridView2.SetFocusedRowCellValue("END_DATE", gridView1.GetRowCellValue(val, "END_DATE"));
gridView2.SetFocusedRowCellValue("YEAR", gridView1.GetRowCellValue(val, "YEAR"));
gridView2.SetFocusedRowCellValue("H_L", gridView1.GetRowCellValue(val, "H_L"));
gridView2.SetFocusedRowCellValue("SEG", gridView1.GetRowCellValue(val, "SEG"));
gridView2.SetFocusedRowCellValue("DESC", gridView1.GetRowCellValue(val, "DESC"));
gridView2.SetFocusedRowCellValue("LAST_UPD", DateTime.Today);
gridView2.SetFocusedRowCellValue("UPD_INIT", username);
gridView2.SetFocusedRowCellValue("ADG_RATE", gridView1.GetRowCellValue(val, "ADG_RATE"));
gridView2.SetFocusedRowCellValue("ADN_RATE", gridView1.GetRowCellValue(val, "ADN_RATE"));
gridView2.SetFocusedRowCellValue("COMMENT1", gridView1.GetRowCellValue(val, "COMMENT1"));
gridView2.SetFocusedRowCellValue("COMMENT2", gridView1.GetRowCellValue(val, "COMMENT2"));
gridView2.SetFocusedRowCellValue("OPERATOR", gridView1.GetRowCellValue(val, "OPERATOR"));
gridView2.SetFocusedRowCellValue("COMM_FLG", gridView1.GetRowCellValue(val, "COMM_FLG"));
gridView2.SetFocusedRowCellValue("COMM_PCT", gridView1.GetRowCellValue(val, "COMM_PCT"));
}
if (checkEdit1.Checked)
{
if (MessageBox.Show("Are you sure you want to delete the original records?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
gridView1.DeleteSelectedRows();
context.SaveChanges();
}
}
}
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
{
if (OperatorBindingSource.Current == null)
{
return;
}
GridViewOper.CloseEditor();
if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
modified = false;
newRec = false;
IEnumerable <CONTACT> contactRecs = from contact in context.CONTACT where contact.LINK_VALUE == TextEditCode.Text select contact;
foreach (CONTACT rec in contactRecs)
{
context.DeleteObject(rec);
}
IEnumerable <RptContact> rptContactRecs = from contact in context.RptContact where contact.Code == TextEditCode.Text select contact;
foreach (RptContact rec in rptContactRecs)
{
context.DeleteObject(rec);
}
OperatorBindingSource.RemoveCurrent();
errorProvider1.Clear();
context.SaveChanges();
setReadOnly(true);
panelControlStatus.Visible = true;
LabelStatus.Text = "Record Deleted";
rowStatusDelete = new Timer();
rowStatusDelete.Interval = 3000;
rowStatusDelete.Start();
rowStatusDelete.Tick += new EventHandler(TimedEventDelete);
}
TextEditCode.Focus();
currentVal = TextEditCode.Text;
modified = false;
newRec = false;
}
private void simpleButton1_Click(object sender, EventArgs e)
{
int j = gridView2.DataRowCount + 1;
for (int i = 0; i < j; i++)
{
gridView2.MoveFirst();
gridView2.DeleteRow(gridView2.FocusedRowHandle);
}
foreach (int val in gridView1.GetSelectedRows())
{
//gridView2.AddNewRow();
//gridView2.SetFocusedRowCellValue("CODE", copyCodeSearch.Text);
//gridView2.SetFocusedRowCellValue("TYPE", gridView1.GetRowCellValue(val, "TYPE"));
gridView2.SetFocusedRowCellValue("PUP_DRP", gridView1.GetRowCellValue(val, "PUP_DRP"));
gridView2.SetFocusedRowCellValue("DATE", gridView1.GetRowCellValue(val, "DATE"));
gridView2.SetFocusedRowCellValue("LOCATION", gridView1.GetRowCellValue(val, "LOCATION"));
gridView2.SetFocusedRowCellValue("TIME", gridView1.GetRowCellValue(val, "TIME"));
gridView2.SetFocusedRowCellValue("IN_OUT", gridView1.GetRowCellValue(val, "IN_OUT"));
gridView2.SetFocusedRowCellValue("EndDate", gridView1.GetRowCellValue(val, "EndDate"));
gridView2.SetFocusedRowCellValue("LocationType", gridView1.GetRowCellValue(val, "LocationType"));
gridView2.SetFocusedRowCellValue("CarOffice", gridView1.GetRowCellValue(val, "CarOffice"));
gridView2.SetFocusedRowCellValue("EndTime", gridView1.GetRowCellValue(val, "EndTime"));
gridView2.SetFocusedRowCellValue("Exclusion", gridView1.GetRowCellValue(val, "Exclusion"));
gridView2.SetFocusedRowCellValue("LAST_UPD", DateTime.Today);
gridView2.SetFocusedRowCellValue("UPD_INIT", username);
}
if (checkEdit1.Checked)
{
if (MessageBox.Show("Are you sure you want to delete the original records?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
gridView1.DeleteSelectedRows();
context.SaveChanges();
}
}
}
private void copyButton_Click(object sender, EventArgs e)
{
int j = gridView2.DataRowCount + 1;
for (int i = 0; i < j; i++)
{
gridView2.MoveFirst();
gridView2.DeleteRow(gridView2.FocusedRowHandle);
}
foreach (int val in gridView1.GetSelectedRows())
{
gridView2.AddNewRow();
gridView2.SetFocusedRowCellValue("CODE", ImageComboBoxEditCopyCode.EditValue);
gridView2.SetFocusedRowCellValue("TYPE", gridView1.GetRowCellValue(val, "TYPE"));
gridView2.SetFocusedRowCellValue("AGENCY", gridView1.GetRowCellValue(val, "AGENCY"));
gridView2.SetFocusedRowCellValue("START_DATE", gridView1.GetRowCellValue(val, "START_DATE"));
gridView2.SetFocusedRowCellValue("END_DATE", gridView1.GetRowCellValue(val, "END_DATE"));
gridView2.SetFocusedRowCellValue("CXL_DATE", gridView1.GetRowCellValue(val, "CXL_DATE"));
gridView2.SetFocusedRowCellValue("NTS_PRIOR", gridView1.GetRowCellValue(val, "NTS_PRIOR"));
gridView2.SetFocusedRowCellValue("CAT", gridView1.GetRowCellValue(val, "CAT"));
gridView2.SetFocusedRowCellValue("NBR_NTS", gridView1.GetRowCellValue(val, "NBR_NTS"));
gridView2.SetFocusedRowCellValue("PCT_AMT", gridView1.GetRowCellValue(val, "PCT_AMT"));
gridView2.SetFocusedRowCellValue("FLAT_FEE", gridView1.GetRowCellValue(val, "FLAT_FEE"));
gridView2.SetFocusedRowCellValue("LAST_UPD", DateTime.Today);
gridView2.SetFocusedRowCellValue("UPD_INIT", username);
}
if (checkEdit1.Checked)
{
if (MessageBox.Show("Are you sure you want to delete the original records?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
gridView1.DeleteSelectedRows();
context.SaveChanges();
}
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
int j = gridView2.DataRowCount + 1;
for (int i = 0; i < j; i++)
{
gridView2.MoveFirst();
gridView2.DeleteRow(gridView2.FocusedRowHandle);
}
foreach (int val in gridView1.GetSelectedRows())
{
gridView2.AddNewRow();
gridView2.SetFocusedRowCellValue("AGENCY", copyAgencySearch.Text);
gridView2.SetFocusedRowCellValue("YEAR", gridView1.GetRowCellValue(val, "YEAR"));
gridView2.SetFocusedRowCellValue("ITEM#", gridView1.GetRowCellValue(val, "ITEM#"));
gridView2.SetFocusedRowCellValue("START_DATE", gridView1.GetRowCellValue(val, "START_DATE"));
gridView2.SetFocusedRowCellValue("END_DATE", gridView1.GetRowCellValue(val, "END_DATE"));
gridView2.SetFocusedRowCellValue("FROM_AMT", gridView1.GetRowCellValue(val, "FROM_AMT"));
gridView2.SetFocusedRowCellValue("TO_AMT", gridView1.GetRowCellValue(val, "TO_AMT"));
gridView2.SetFocusedRowCellValue("PREMIUM", gridView1.GetRowCellValue(val, "PREMIUM"));
gridView2.SetFocusedRowCellValue("COMM_FLG", gridView1.GetRowCellValue(val, "COMM_FLG"));
gridView2.SetFocusedRowCellValue("COMM_PCT", gridView1.GetRowCellValue(val, "COMM_PCT"));
gridView2.SetFocusedRowCellValue("LAST_UPD", gridView1.GetRowCellValue(val, "LAST_UPD"));
gridView2.SetFocusedRowCellValue("UPD_INIT", gridView1.GetRowCellValue(val, "UPD_INIT"));
}
gridView2.Focus();
gridView1.Focus();
if (checkEdit1.Checked)
{
if (MessageBox.Show("Are you sure you want to delete the original records?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
gridView1.DeleteSelectedRows();
context.SaveChanges();
}
}
}
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
{
if (LookupBindingSource.Current == null)
{
return;
}
if (MessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
modified = false;
newRec = false;
LookupBindingSource.RemoveCurrent();
errorProvider1.Clear();
context.SaveChanges();
panelControlStatus.Visible = true;
LabelStatus.Text = "Record Deleted";
rowStatusDelete = new Timer();
rowStatusDelete.Interval = 3000;
rowStatusDelete.Start();
rowStatusDelete.Tick += new EventHandler(TimedEventDelete);
}
//currentVal = gridSearchControl1.Text;
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (modified)
{
DialogResult select = DevExpress.XtraEditors.XtraMessageBox.Show("Do you want to confirm these changes?", Name, MessageBoxButtons.YesNoCancel);
if (select == DialogResult.Yes)////keep changes
{
modified = false;
modifiedSvcCode = string.Empty;
modifiedRecs.Clear();
}
else if (select == DialogResult.No)
{
modified = false;
foreach (string val in modifiedRecs)
{
var unwanted = from amen in context.AMENASSGN where amen.SVC_CODE == modifiedSvcCode && amen.CODE == val select amen;
foreach (AMENASSGN record in unwanted)
{
context.AMENASSGN.DeleteObject(record);
}
}
context.SaveChanges();
modifiedSvcCode = string.Empty;
modifiedRecs.Clear();
}
}
string code = string.Empty;
if (!string.IsNullOrWhiteSpace(ImageComboBoxEditCode.Text))
{
code = ImageComboBoxEditCode.EditValue.ToString();
}
string cat = string.Empty;
if (!string.IsNullOrWhiteSpace(ImageComboBoxEditCategory.Text))
{
cat = ImageComboBoxEditCategory.EditValue.ToString();
}
checkRequired(code, cat);
loadTreelist(code, cat);
}
private void _bgWorker_DoWork(object sender, DoWorkEventArgs e)
{
BackgroundWorker worker = sender as BackgroundWorker;
string fileName = e.Argument.ToString();
FileInfo file = new FileInfo(fileName);
_someRates = false;
using (ExcelPackage xl = new ExcelPackage(file)) {
var ws = xl.Workbook.Worksheets[1];
string special = ws.Cells[4, 1].GetValue <string>();
for (int col = 4; col < int.MaxValue; col += 4)
{
if (worker.CancellationPending)
{
return;
}
string hotelName = ws.Cells[4, col].GetValue <string>();
if (string.IsNullOrEmpty(hotelName))
{
break;
}
//We don't know how many hotels there are in the spreadsheet, so we can't report a percentage,
// but we can display the hotel name
worker.ReportProgress(0, $"Reading {hotelName}...");
var mappings = _context.ImportMapping.Where(f => f.NameInSpreadsheet.ToLower() == hotelName.ToLower() &&
!f.Inactive).ToList();
if (mappings?.Count > 0)
{
string hotelCode = mappings.First().HOTEL.CODE;
var markups = _context.COMPROD2.Where(c =>
c.ImportRule && c.CODE == hotelCode && c.TYPE == "HTL" && !(bool)c.Inactive &&
c.RecType == "M").ToList();
double dateNum = ws.Cells[6, 1].GetValue <double>();
DateTime date = DateTime.FromOADate(dateNum);
//Get matching existing rate sheets that will need to be deactivated
var rates = _context.HRATES.Where(h => !h.Inactive && h.CODE == hotelCode &&
h.START_DATE >= date && h.ID > 0).ToList();
for (int row = 6; row < int.MaxValue; row++)
{
dateNum = ws.Cells[row, 1].GetValue <double>();
if (dateNum == 0)
{
string dateText = ws.Cells[row, 1].Text;
if (!DateTime.TryParse(dateText, out date))
{
break;
}
}
else
{
date = DateTime.FromOADate(dateNum);
}
bool stopSell = false;
//Try to handle whether the spreadsheet has rates formatted as number or currency
var usCulture = CultureInfo.CreateSpecificCulture("en-US");
if (!decimal.TryParse(ws.Cells[row, col].Text, out decimal currentRate))
{
decimal.TryParse(ws.Cells[row, col].Text, NumberStyles.Currency, usCulture, out currentRate);
}
if (!decimal.TryParse(ws.Cells[row, col + 2].Text, out decimal newRate))
{
if (!decimal.TryParse(ws.Cells[row, col + 2].Text, NumberStyles.Currency, usCulture, out newRate))
{
//If there is some text in the cell but it is not a number, then treat it as a stopsell
if (!string.IsNullOrEmpty(ws.Cells[row, col + 2].Text))
{
stopSell = true;
}
}
}
if (currentRate > 0 || newRate > 0)
{
_someRates = true;
ImportRate(worker, mappings, rates, markups, special, date, currentRate, newRate, stopSell);
}
}
}
}
worker.ReportProgress(0, "Creating rates, please be patient...");
//Starting with EF6 SaveChanges includes a transaction
_context.SaveChanges();
worker.ReportProgress(0, "Done");
e.Result = true; //if you don't set e.Result to something, RunWorkerCompleted event is never called
}
}
private void AddButton_Click(object sender, EventArgs e)
{
int rowsAdded = 0;
for (int x = 0; x < GridViewAddToReports.RowCount; x++)
{
short position = 0;
string selection = GridViewAddToReports.GetRowCellDisplayText(x, "Selected");
int ID = (int)GridViewAddToReports.GetRowCellValue(x, ColumnIDAddToReports);
string strPos = (string)GridViewAddToReports.GetRowCellValue(x, GridColumnPosition);
if ((selection == "Checked") && (!string.IsNullOrEmpty(strPos)))
{
object strPosition = GridViewAddToReports.GetRowCellValue(x, GridColumnPosition); //Get the selection from position combobox
//If selection is First
if (strPosition == (object)("First"))
{
if ((from mRptItem in context.MediaRptItem where mRptItem.REPORT_ID == ID orderby mRptItem.POSITION select mRptItem).Count() > 0)
{
//Bring the data from mediaRptItem with the selected reportID and increment the positions of remaining rows by 1
var items = context.MediaRptItem
.Include(mri => mri.MEDIARPT)
.Where(mri => mri.REPORT_ID == ID);
foreach (MediaRptItem mRptItem in items)
{
mRptItem.MEDIARPT.ChgDate = DateTime.Now;
mRptItem.POSITION = (Int16)(mRptItem.POSITION++);
}
}
position = 1; //Newly added row is set at the top position
}
//If selection is last
else if (strPosition == (object)("Last"))
{
int positionMax = Convert.ToInt32((from mRptItem in context.MediaRptItem where mRptItem.REPORT_ID == ID orderby mRptItem.POSITION select mRptItem.POSITION).Max());
//Set the position to the highest value
position = (short)(positionMax + 1);
}
//If selection is <enter any number>
else
{
try
{
short pos = short.Parse((GridViewAddToReports.GetRowCellValue(x, GridColumnPosition)).ToString());
int positionMax = Convert.ToInt32((from mRptItem in context.MediaRptItem where mRptItem.REPORT_ID == ID orderby mRptItem.POSITION select mRptItem.POSITION).Max());
//if entered number is larger than the max position in MediaRptItem set the position to the highest value
if (pos > positionMax)
{
GridViewAddToReports.SetRowCellValue(x, GridColumnPosition, positionMax + 1);
}
else
//Otherwise set the position value to the entered number
{
//Bring the data from mediaRptItem with rows having position equal to or greater than the entered position and increment their positions by 1
var items = context.MediaRptItem
.Include(mri => mri.MEDIARPT)
.Where(mri => mri.REPORT_ID == ID && mri.POSITION >= pos);
foreach (MediaRptItem mRptItem in items)
{
mRptItem.MEDIARPT.ChgDate = DateTime.Now;
mRptItem.POSITION = (Int16)(mRptItem.POSITION++);
}
GridViewAddToReports.SetRowCellValue(x, GridColumnPosition, pos);
}
position = pos;
}
catch (Exception ex)
{
MessageBox.Show("Please! Enter a position value to add the report");
}
}
if (position > 0)
{
MediaRptItem item = new MediaRptItem();
int reportId = (int)(GridViewAddToReports.GetRowCellValue(x, "ID"));
item.REPORT_ID = reportId;
item.SECTION_ID = mediaInfoSectID;
item.POSITION = (short)position;
context.AddToMediaRptItem(item);
var rpt = context.MEDIARPT.FirstOrDefault(mr => mr.ID == reportId);
if (rpt != null)
{
rpt.ChgDate = DateTime.Now;
}
context.SaveChanges();
mediaRptItemBindingSource.ResetBindings(false);
GridViewAddToReports.RefreshData();
rowsAdded++;
}
}
else if ((selection == "Checked") && (string.IsNullOrEmpty(strPos)))
{
MessageBox.Show("If the row is selected or a position is chosen a value must also be entered in the other column.");
}
}
GridViewAddToReports.RefreshData();
if (rowsAdded > 0)
{
List <MEDIARPT> resultList = loadGrid(rcd);
GridControlAddToReports.DataSource = resultList;
}
context.SaveChanges();
mediaRptItemBindingSource.ResetBindings(false);
GridControlAddToReports.Refresh();
GridViewAddToReports.RefreshData();
panelControlStatus.Visible = true;
if (rowsAdded > 1)
{
LabelStatus.Text = rowsAdded + " " + "reports added";
}
else if (rowsAdded == 1)
{
LabelStatus.Text = rowsAdded + " " + "report added";
}
else if (rowsAdded == 0)
{
LabelStatus.Text = "No reports added";
}
rowStatusSave = new Timer();
rowStatusSave.Interval = 3000;
rowStatusSave.Start();
rowStatusSave.Tick += TimedEventSave;
}
private void simpleButton1_Click(object sender, EventArgs e)
{
int j = gridView2.DataRowCount + 1;
for (int i = 0; i < j; i++)
{
gridView2.MoveFirst();
gridView2.DeleteRow(gridView2.FocusedRowHandle);
}
foreach (int val in gridView1.GetSelectedRows())
{
string pkgLoad = ImageComboBoxEditLoadCode.EditValue.ToString();
string cat = (gridView1.GetRowCellValue(val, "CAT")).ToString();
var values = from c in context.PCOMP where c.CODE == pkgLoad && c.CAT == cat select c;
foreach (var load in values)
{
gridView2.AddNewRow();
gridView2.SetFocusedRowCellValue("CODE", ImageComboBoxEditCopyCode.Text);
gridView2.SetFocusedRowCellValue("CAT", load.CAT);
gridView2.SetFocusedRowCellValue("DAY", load.DAY);
gridView2.SetFocusedRowCellValue("LINE", load.LINE);
gridView2.SetFocusedRowCellValue("LAST_UPD", load.LAST_UPD);
gridView2.SetFocusedRowCellValue("UPD_INIT", load.UPD_INIT);
gridView2.SetFocusedRowCellValue("TYPE", load.TYPE);
gridView2.SetFocusedRowCellValue("CODE1", load.CODE1);
gridView2.SetFocusedRowCellValue("CAT1", load.CAT1);
gridView2.SetFocusedRowCellValue("ROOM", load.ROOM);
gridView2.SetFocusedRowCellValue("TOUR_TIME", load.TOUR_TIME);
gridView2.SetFocusedRowCellValue("INV_UPD", load.INV_UPD);
gridView2.SetFocusedRowCellValue("NTS", load.NTS);
gridView2.SetFocusedRowCellValue("CHK_OUT", load.CHK_OUT);
gridView2.SetFocusedRowCellValue("MEALS", load.MEALS);
gridView2.SetFocusedRowCellValue("OPER", load.OPER);
gridView2.SetFocusedRowCellValue("PRV_CAR", load.PRV_CAR);
gridView2.SetFocusedRowCellValue("ARV_FRM", load.ARV_FRM);
gridView2.SetFocusedRowCellValue("ARV_TO", load.ARV_TO);
gridView2.SetFocusedRowCellValue("ARV_FLT", load.ARV_FLT);
gridView2.SetFocusedRowCellValue("ARV_LV_TIME", load.ARV_LV_TIME);
gridView2.SetFocusedRowCellValue("ARV_TIME", load.ARV_TIME);
gridView2.SetFocusedRowCellValue("ARV_TRNFR", load.ARV_TRNFR);
gridView2.SetFocusedRowCellValue("DEP_FRM", load.DEP_FRM);
gridView2.SetFocusedRowCellValue("DEP_TO", load.DEP_TO);
gridView2.SetFocusedRowCellValue("DEP_FLT", load.DEP_FLT);
gridView2.SetFocusedRowCellValue("DEP_TIME", load.DEP_TIME);
gridView2.SetFocusedRowCellValue("DEP_AV_TIME", load.DEP_AV_TIME);
gridView2.SetFocusedRowCellValue("DEP_TRNFR", load.DEP_TRNFR);
gridView2.SetFocusedRowCellValue("CAR_OFF", load.CAR_OFF);
gridView2.SetFocusedRowCellValue("PUP_OFF", load.PUP_OFF);
gridView2.SetFocusedRowCellValue("DRP_OFF)", load.DRP_OFF);
}
}
gridView2.Focus();
gridView1.Focus();
if (checkEdit1.Checked)
{
if (MessageBox.Show("Are you sure you want to delete the original records?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
gridView1.DeleteSelectedRows();
context.SaveChanges();
}
}
}
private bool SaveRecord(bool prompt)
{
try {
if (_selectedRecord == null)
{
return(true);
}
//Call to make sure the modified flag is set, because the Save button doesn't take focus so the Leave event
//won't fire on the active control
SetErrorInfo(null, ActiveControl);
if (_modified || _newRec)
{
if (prompt)
{
DialogResult result = XtraMessageBox.Show("Do you want to confirm these changes?", this.Text, MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
if (result == DialogResult.No)
{
if (_newRec)
{
RemoveRecord();
}
else
{
RefreshRecord();
}
_modified = false;
_newRec = false;
return(true);
}
if (result == DialogResult.Cancel)
{
return(false);
}
}
FinalizeBindings();
if (!ShowMainControlErrors())
{
return(false);
}
if (_selectedRecord.ID == 0)
{
_context.BusRoute.AddObject(_selectedRecord);
}
_context.SaveChanges();
ShowActionConfirmation("Record Saved");
_newRec = false;
_modified = false;
}
return(true);
}
catch (Exception ex) {
string message = ex.Message;
if (message.Contains("inner exception"))
{
message = ex.InnerException.Message;
}
XtraMessageBox.Show(message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
RefreshRecord(); //pull it back from db because that is its current state
//We must also Load and rebind the related entities from the db because context.Refresh doesn't do that
SetBindings();
return(false);
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
//preview
int j = GridViewCopy.DataRowCount + 1;
for (int i = 0; i < j; i++)
{
GridViewCopy.MoveFirst();
GridViewCopy.DeleteRow(GridViewCopy.FocusedRowHandle);
}
foreach (int val in GridViewLoad.GetSelectedRows())
{
GridViewCopy.AddNewRow();
GridViewCopy.SetFocusedRowCellValue("CODE", ImageComboBoxEditCopyCode.EditValue);
GridViewCopy.SetFocusedRowCellValue("AGENCY", GridViewLoad.GetRowCellValue(val, "AGENCY"));
GridViewCopy.SetFocusedRowCellValue("CAT", GridViewLoad.GetRowCellValue(val, "CAT"));
GridViewCopy.SetFocusedRowCellValue("START_DATE", GridViewLoad.GetRowCellValue(val, "START_DATE"));
GridViewCopy.SetFocusedRowCellValue("END_DATE", GridViewLoad.GetRowCellValue(val, "END_DATE"));
GridViewCopy.SetFocusedRowCellValue("YEAR", GridViewLoad.GetRowCellValue(val, "YEAR"));
GridViewCopy.SetFocusedRowCellValue("H_L", GridViewLoad.GetRowCellValue(val, "H_L"));
GridViewCopy.SetFocusedRowCellValue("ID", GridViewLoad.GetRowCellValue(val, "ID"));
GridViewCopy.SetFocusedRowCellValue("ResDate_Start", GridViewLoad.GetRowCellValue(val, "ResDate_Start"));
GridViewCopy.SetFocusedRowCellValue("ResDate_End", GridViewLoad.GetRowCellValue(val, "ResDate_End"));
GridViewCopy.SetFocusedRowCellValue("Inactive", GridViewLoad.GetRowCellValue(val, "Inactive"));
GridViewCopy.SetFocusedRowCellValue("Time", GridViewLoad.GetRowCellValue(val, "Time"));
GridViewCopy.SetFocusedRowCellValue("DESC", GridViewLoad.GetRowCellValue(val, "DESC"));
GridViewCopy.SetFocusedRowCellValue("LAST_UPD", DateTime.Now);
GridViewCopy.SetFocusedRowCellValue("UPD_INIT", username);
GridViewCopy.SetFocusedRowCellValue("PP1", GridViewLoad.GetRowCellValue(val, "PP1"));
GridViewCopy.SetFocusedRowCellValue("PP2", GridViewLoad.GetRowCellValue(val, "PP2"));
GridViewCopy.SetFocusedRowCellValue("PP3", GridViewLoad.GetRowCellValue(val, "PP3"));
GridViewCopy.SetFocusedRowCellValue("PP4", GridViewLoad.GetRowCellValue(val, "PP4"));
GridViewCopy.SetFocusedRowCellValue("PP5", GridViewLoad.GetRowCellValue(val, "PP5"));
GridViewCopy.SetFocusedRowCellValue("PP6", GridViewLoad.GetRowCellValue(val, "PP6"));
GridViewCopy.SetFocusedRowCellValue("PP7", GridViewLoad.GetRowCellValue(val, "PP7"));
GridViewCopy.SetFocusedRowCellValue("PP8", GridViewLoad.GetRowCellValue(val, "PP8"));
GridViewCopy.SetFocusedRowCellValue("PP9", GridViewLoad.GetRowCellValue(val, "PP9"));
GridViewCopy.SetFocusedRowCellValue("PP10", GridViewLoad.GetRowCellValue(val, "PP10"));
GridViewCopy.SetFocusedRowCellValue("GPP1", GridViewLoad.GetRowCellValue(val, "GPP1"));
GridViewCopy.SetFocusedRowCellValue("GPP2", GridViewLoad.GetRowCellValue(val, "GPP2"));
GridViewCopy.SetFocusedRowCellValue("GPP3", GridViewLoad.GetRowCellValue(val, "GPP3"));
GridViewCopy.SetFocusedRowCellValue("GPP4", GridViewLoad.GetRowCellValue(val, "GPP4"));
GridViewCopy.SetFocusedRowCellValue("GPP5", GridViewLoad.GetRowCellValue(val, "GPP5"));
GridViewCopy.SetFocusedRowCellValue("GPP6", GridViewLoad.GetRowCellValue(val, "GPP6"));
GridViewCopy.SetFocusedRowCellValue("GPP7", GridViewLoad.GetRowCellValue(val, "GPP7"));
GridViewCopy.SetFocusedRowCellValue("GPP8", GridViewLoad.GetRowCellValue(val, "GPP8"));
GridViewCopy.SetFocusedRowCellValue("GPP9", GridViewLoad.GetRowCellValue(val, "GPP9"));
GridViewCopy.SetFocusedRowCellValue("GPP10", GridViewLoad.GetRowCellValue(val, "GPP10"));
GridViewCopy.SetFocusedRowCellValue("NPP1", GridViewLoad.GetRowCellValue(val, "NPP1"));
GridViewCopy.SetFocusedRowCellValue("NPP2", GridViewLoad.GetRowCellValue(val, "NPP2"));
GridViewCopy.SetFocusedRowCellValue("NPP3", GridViewLoad.GetRowCellValue(val, "NPP3"));
GridViewCopy.SetFocusedRowCellValue("NPP4", GridViewLoad.GetRowCellValue(val, "NPP4"));
GridViewCopy.SetFocusedRowCellValue("NPP5", GridViewLoad.GetRowCellValue(val, "NPP5"));
GridViewCopy.SetFocusedRowCellValue("NPP6", GridViewLoad.GetRowCellValue(val, "NPP6"));
GridViewCopy.SetFocusedRowCellValue("NPP7", GridViewLoad.GetRowCellValue(val, "NPP7"));
GridViewCopy.SetFocusedRowCellValue("NPP8", GridViewLoad.GetRowCellValue(val, "NPP8"));
GridViewCopy.SetFocusedRowCellValue("NPP9", GridViewLoad.GetRowCellValue(val, "NPP9"));
GridViewCopy.SetFocusedRowCellValue("NPP10", GridViewLoad.GetRowCellValue(val, "NPP10"));
GridViewCopy.SetFocusedRowCellValue("CHD_GRATE", GridViewLoad.GetRowCellValue(val, "CHD_GRATE"));
GridViewCopy.SetFocusedRowCellValue("CHD_NRATE", GridViewLoad.GetRowCellValue(val, "CHD_NRATE"));
GridViewCopy.SetFocusedRowCellValue("CHD_LIMIT", GridViewLoad.GetRowCellValue(val, "CHD_LIMIT"));
GridViewCopy.SetFocusedRowCellValue("JR_LIMIT", GridViewLoad.GetRowCellValue(val, "JR_LIMIT"));
GridViewCopy.SetFocusedRowCellValue("JR_GRATE", GridViewLoad.GetRowCellValue(val, "JR_GRATE"));
GridViewCopy.SetFocusedRowCellValue("JR_NRATE", GridViewLoad.GetRowCellValue(val, "JR_NRATE"));
GridViewCopy.SetFocusedRowCellValue("COMM_FLG", GridViewLoad.GetRowCellValue(val, "COMM_FLG"));
GridViewCopy.SetFocusedRowCellValue("COMM_PCT", GridViewLoad.GetRowCellValue(val, "COMM_PCT"));
GridViewCopy.SetFocusedRowCellValue("Transport_Type", GridViewLoad.GetRowCellValue(val, "Transport_Type"));
GridViewCopy.SetFocusedRowCellValue("Vendor_Code", GridViewLoad.GetRowCellValue(val, "Vendor_Code"));
GridViewCopy.SetFocusedRowCellValue("Unit_Rate", GridViewLoad.GetRowCellValue(val, "Unit_Rate"));
GridViewCopy.SetFocusedRowCellValue("Inhouse", GridViewLoad.GetRowCellValue(val, "Inhouse"));
GridViewCopy.SetFocusedRowCellValue("Vendor_Code_Jr", GridViewLoad.GetRowCellValue(val, "Vendor_Code_Jr"));
GridViewCopy.SetFocusedRowCellValue("Vendor_Code_Chd", GridViewLoad.GetRowCellValue(val, "Vendor_Code_Chd"));
GridViewCopy.SetFocusedRowCellValue("SpecialValue_Code", GridViewLoad.GetRowCellValue(val, "SpecialValue_Code"));
GridViewCopy.SetFocusedRowCellValue("Currency_CodeSheet", GridViewLoad.GetRowCellValue(val, "Currency_CodeSheet"));
GridViewCopy.SetFocusedRowCellValue("Currency_CodePayment", GridViewLoad.GetRowCellValue(val, "Currency_CodePayment"));
GridViewCopy.SetFocusedRowCellValue("ExchangeRate", GridViewLoad.GetRowCellValue(val, "ExchangeRate"));
GridViewCopy.SetFocusedRowCellValue("BusTourDays", GridViewLoad.GetRowCellValue(val, "BusTourDays"));
GridViewCopy.SetFocusedRowCellValue("BusTourStops", GridViewLoad.GetRowCellValue(val, "BusTourStops"));
GridViewCopy.SetFocusedRowCellValue("Comp_Type", GridViewLoad.GetRowCellValue(val, "Comp_Type"));
GridViewCopy.SetFocusedRowCellValue("SeniorAgeLimit", GridViewLoad.GetRowCellValue(val, "SeniorAgeLimit"));
GridViewCopy.SetFocusedRowCellValue("SeniorCost", GridViewLoad.GetRowCellValue(val, "SeniorCost"));
GridViewCopy.SetFocusedRowCellValue("SeniorGross", GridViewLoad.GetRowCellValue(val, "SeniorGross"));
GridViewCopy.SetFocusedRowCellValue("SeniorRetail", GridViewLoad.GetRowCellValue(val, "SeniorRetail"));
GridViewCopy.SetFocusedRowCellValue("Retail1", GridViewLoad.GetRowCellValue(val, "Retail1"));
GridViewCopy.SetFocusedRowCellValue("Retail2", GridViewLoad.GetRowCellValue(val, "Retail2"));
GridViewCopy.SetFocusedRowCellValue("Retail3", GridViewLoad.GetRowCellValue(val, "Retail3"));
GridViewCopy.SetFocusedRowCellValue("Retail4", GridViewLoad.GetRowCellValue(val, "Retail4"));
GridViewCopy.SetFocusedRowCellValue("Retail5", GridViewLoad.GetRowCellValue(val, "Retail5"));
GridViewCopy.SetFocusedRowCellValue("Retail6", GridViewLoad.GetRowCellValue(val, "Retail6"));
GridViewCopy.SetFocusedRowCellValue("Retail7", GridViewLoad.GetRowCellValue(val, "Retail7"));
GridViewCopy.SetFocusedRowCellValue("Retail8", GridViewLoad.GetRowCellValue(val, "Retail8"));
GridViewCopy.SetFocusedRowCellValue("Retail9", GridViewLoad.GetRowCellValue(val, "Retail9"));
GridViewCopy.SetFocusedRowCellValue("Retail10", GridViewLoad.GetRowCellValue(val, "Retail10"));
GridViewCopy.SetFocusedRowCellValue("Retail10", GridViewLoad.GetRowCellValue(val, "Retail10"));
GridViewCopy.SetFocusedRowCellValue("ChildRetail", GridViewLoad.GetRowCellValue(val, "ChildRetail"));
GridViewCopy.SetFocusedRowCellValue("JuniorRetail", GridViewLoad.GetRowCellValue(val, "JuniorRetail"));
}
GridViewCopy.Focus();
GridViewLoad.Focus();
if (checkEdit1.Checked)
{
if (MessageBox.Show("Are you sure you want to delete the original records?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
GridViewLoad.DeleteSelectedRows();
context.SaveChanges();
}
}
}
private void ImportProduct(Item item, BackgroundWorker worker)
{
try {
SupplierProduct suppProd = null;
//Set up the main COMP record
bool productAddedOrNameChanged = false;
var comp = _context.COMP
.Include(c => c.ProductAge)
.Include(c => c.SupplierProductAge)
.Include(c => c.SupplierProduct)
.FirstOrDefault(c => c.CODE == item.InternalCode);
if (comp == null)
{
productAddedOrNameChanged = true;
comp = new COMP()
{
CODE = item.InternalCode,
NAME = item.Name,
RSTR_CDE = "O",
Inactive = "N",
AdminClosed = false,
PickupInfoRequired = false,
DropoffInfoRequired = false,
VendorPrepayReqd = false,
AccountingServiceItem = true,
MealsIncluded = false,
RATE_BASIS = "D",
ProximitySearch = false,
WeightRequired = false,
DOBRequired = false,
Allow_Freesell = false,
Multiple_Times = "0",
SERV_TYPE = searchLookUpEditServiceType.EditValue.ToString(),
CITY = searchLookUpEditCity.EditValue.ToString()
};
_context.COMP.AddObject(comp);
}
else
{
if (comp.AdminClosed || comp.Inactive == "Y")
{
return;
}
suppProd = comp.SupplierProduct.FirstOrDefault(sp => sp.Supplier_GUID == _supplierConnection.Supplier_GUID &&
sp.ProductCodeSupplier == item.Pk.ToString());
}
if (suppProd == null)
{
suppProd = new SupplierProduct()
{
Product_Type = "OPT",
Product_Code_Internal = item.InternalCode,
ProductCodeSupplier = item.Pk.ToString(),
Supplier_GUID = _supplierConnection.Supplier_GUID,
Inactive = false,
};
suppProd.COMP = comp;
_context.SupplierProduct.AddObject(suppProd);
}
suppProd.Custom1 = _company;
suppProd.SupplierCommPct = spinEditCommPct.Value;
suppProd.SupplierCommFlat = spinEditCommFlat.Value;
suppProd.MarkupPct = spinEditMarkupPct.Value;
suppProd.MarkupFlat = spinEditMarkupFlat.Value;
//Don't overwrite name because staff change it manually
//if (comp.NAME != item.Name) {
// productAddedOrNameChanged = true;
//}
//comp.NAME = item.Name;
if (item.Is_pickup_ever_available)
{
comp.PUDRP_REQ = "P";
comp.TRSFR_TYP = "O";
}
else
{
comp.TRSFR_TYP = "N";
}
comp.StartingPrice = item.StartingPrice;
comp.StartingCost = Math.Round(item.StartingPrice * (1 - ((suppProd.SupplierCommPct ?? 0) / 100)), 2) - (suppProd.SupplierCommFlat ?? 0);
comp.StartingAgentNet = Math.Round((comp.StartingCost ?? 0) * (1 + ((suppProd.MarkupPct ?? 0) / 100)), 2) - (suppProd.MarkupFlat ?? 0);
//Other location types seem to be "pre", "start", "end"
//TODO: Each location can also have notes, which are rarely provided and often duplicate other information
//Should the location notes be stored somewhere?
//There is also an item.Location property which holds the whole address as a single string
var mainLocation = item.Locations.FirstOrDefault(l => l.Type == "primary");
if (mainLocation == null)
{
mainLocation = item.Locations.FirstOrDefault();
}
if (mainLocation != null)
{
var address = mainLocation.Address;
comp.ADDR1 = address.Street;
comp.COUNTRY = address.Country;
comp.ZIP = address.Postal_code;
comp.STATE = address.Province;
comp.TOWN = address.City;
if (mainLocation.Latitude != null && mainLocation.Longitude != null)
{
var geo = comp.GeoCode;
if (geo == null)
{
geo = new GeoCode();
_context.GeoCode.AddObject(geo);
comp.GeoCode = geo;
}
geo.AgentInitials = _sys.User.Name;
geo.PushLat = (double)mainLocation.Latitude;
geo.PushLong = (double)mainLocation.Longitude;
}
}
if (Configurator.ImportCancellationPolicies)
{
//Cancellation policy has a type field which so far is only ever "hours-before-start"
int daysPrior = (int)Math.Ceiling(item.Effective_cancellation_policy.Cutoff_hours_before / 24) + (_supplierConnection.ExtraNightsPriorForCxlPolicy ?? 0);
FindOrAddCxlfee(_sys, _context, comp.CODE, daysPrior, 100);
}
//Set up the age mappings
foreach (var custType in item.Customer_prototypes.Where(cp => cp.Selected))
{
SupplierProductAge suppProdAge = null;
ProductAge prodAge = null;
if (custType.InternalId != null)
{
suppProdAge = comp.SupplierProductAge.FirstOrDefault(sp => sp.Id == custType.InternalId);
}
if (suppProdAge == null)
{
suppProdAge = new SupplierProductAge()
{
Product_Code = comp.CODE,
Product_Type = "OPT",
Supplier_GUID = _supplierConnection.Supplier_GUID,
SupplierId = custType.Pk.ToString()
};
_context.SupplierProductAge.AddObject(suppProdAge);
}
else
{
prodAge = suppProdAge.ProductAge;
}
if (prodAge == null)
{
//If there is already a ProductAge record with the same age limits, reuse it rather than creating a new one
prodAge = comp.ProductAge.FirstOrDefault(pa => pa.FromAge == custType.FromAge && pa.ToAge == custType.ToAge);
if (prodAge == null)
{
prodAge = new ProductAge()
{
Product_Type = "OPT",
Product_Code = comp.CODE,
};
comp.ProductAge.Add(prodAge);
_context.ProductAge.AddObject(prodAge);
}
}
suppProdAge.SupplierName = custType.Display_name;
prodAge.FromAge = custType.FromAge;
prodAge.ToAge = custType.ToAge;
prodAge.Description = custType.PaxType;
switch (custType.PaxType.ToLower())
{
case "adult":
prodAge.PluralDescription = "Adults";
break;
case "child":
prodAge.PluralDescription = "Children";
break;
case "junior":
prodAge.PluralDescription = "Juniors";
break;
case "infant":
prodAge.PluralDescription = "Infants";
break;
case "senior":
prodAge.PluralDescription = "Seniors";
break;
}
if (custType.ToAge == null || custType.ToAge >= 18)
{
prodAge.IsAdult = true;
prodAge.TreatAsAdult = true;
}
suppProdAge.ProductAge = prodAge;
}
//Set up the media information
MEDIAINFO mainInfo = MediaHelper.CheckAndCreateNewMediaInfo(_context, _sys.Settings.MainMediaSection, item.Name,
"OPT", comp.CODE, string.Empty, "ENG", Configurator.CreateNewInfoAsInHouse, null);
List <string> texts = new List <string>();
if (!string.IsNullOrEmpty(item.Headline))
{
texts.Add(item.Headline);
}
if (!string.IsNullOrEmpty(item.Description_text))
{
texts.Add(item.Description_text);
}
if (!string.IsNullOrEmpty(item.Description_safe_html))
{
texts.Add(item.Description_safe_html);
}
string.Join("<br/><br/>", texts);
mainInfo.TEXT = item.Headline + item.Description_text + item.Description_safe_html;
string imagePath = MediaHelper.GetOrPutImage(_sys, "OPT", comp.CODE, _prefix, comp.CITY, item.Image_cdn_url, string.Empty, false);
mainInfo.IMAGE1 = imagePath;
imagePath = MediaHelper.GetOrPutImage(_sys, "OPT", comp.CODE, _prefix, comp.CITY, item.Image_cdn_url, "thumb_", true);
mainInfo.IMAGE4 = imagePath;
//Some companies have booking notes that are clearly intended for after making a booking because they say
//"Thank you for your booking". Others have useful info about what to bring and what to expect. We can't tell the difference
//so just always use the booking notes
MEDIAINFO fullInfo = MediaHelper.CheckAndCreateNewMediaInfo(_context, Configurator.FullDescMediaReportSection, _fullDescTitles[0],
"OPT", comp.CODE, string.Empty, "ENG", Configurator.CreateNewInfoAsInHouse, null);
fullInfo.TEXT = CreateBulletList(item.Description_bullets) + item.Booking_notes_safe_html;
MEDIAINFO termsInfo = new MEDIAINFO();
if (!string.IsNullOrEmpty(item.Cancellation_policy_safe_html))
{
termsInfo = MediaHelper.CheckAndCreateNewMediaInfo(_context, Configurator.TermsMediaReportSection, _termsTitles[0],
"OPT", comp.CODE, string.Empty, "ENG", Configurator.CreateNewInfoAsInHouse, null);
termsInfo.TEXT = item.Cancellation_policy_safe_html;
}
//Download the images and attach to the main media section
List <RESOURCE> resources = new List <RESOURCE>();
if (Configurator.DownloadImages)
{
foreach (var image in item.Images)
{
imagePath = MediaHelper.GetOrPutImage(_sys, "OPT", comp.CODE, _prefix, comp.CITY, image.Image_cdn_url, string.Empty, false);
MediaHelper.CheckAndAddResource(_context, resources, mainInfo, imagePath, string.Empty, "1"); //1=medium res
}
}
var rptGeninfo = MediaHelper.CheckAndCreateNewMediaRpt(_context, _sys.Settings.MainMediaReport, "OPT", comp.CODE,
"ENG", null);
var rptVoucher = MediaHelper.CheckAndCreateNewMediaRpt(_context, Configurator.VoucherMediaReportType, "OPT", comp.CODE,
"ENG", null);
if ((!string.IsNullOrEmpty(mainInfo.TEXT) || resources.Count > 0))
{
MediaHelper.CheckAndAddInfoToReports(_context, new MEDIARPT[] { rptGeninfo, rptVoucher }, mainInfo, 0);
if (mainInfo.ID == 0)
{
_context.MEDIAINFO.AddObject(mainInfo);
}
}
if (!string.IsNullOrEmpty(fullInfo.TEXT))
{
MediaHelper.CheckAndAddInfoToReports(_context, new MEDIARPT[] { rptGeninfo }, fullInfo, 1);
if (fullInfo.ID == 0)
{
_context.MEDIAINFO.AddObject(fullInfo);
}
}
if (!string.IsNullOrEmpty(termsInfo.TEXT))
{
MediaHelper.CheckAndAddInfoToReports(_context, new MEDIARPT[] { rptGeninfo, rptVoucher }, termsInfo, 2);
if (termsInfo.ID == 0)
{
_context.MEDIAINFO.AddObject(termsInfo);
}
}
if (rptGeninfo.ID == 0 && rptGeninfo.MediaRptItem.Count > 0)
{
_context.MEDIARPT.AddObject(rptGeninfo);
}
if (rptVoucher.ID == 0 && rptVoucher.MediaRptItem.Count > 0)
{
_context.MEDIARPT.AddObject(rptVoucher);
}
List <MEDIAINFO> infos = new List <MEDIAINFO>()
{
mainInfo, fullInfo, termsInfo
};
MediaHelper.SetMediaInfosChgDate(_context, infos, _update);
MediaHelper.SetServiceChgDate(_context, comp, _update, _sys.User.Name);
_context.SaveChanges();
if (productAddedOrNameChanged)
{
AccountingAPI.InvokeForProduct(_sys.Settings.TourAccountingURL, "OPT", comp.CODE);
}
//Update the image resources with the id of the linked media section
if (resources.Count > 0)
{
foreach (var resource in resources)
{
resource.LINK_VALUE = mainInfo.ID.ToString();
_context.RESOURCE.AddObject(resource);
}
_context.SaveChanges();
}
try {
worker.ReportProgress(0, $"Updating website for {item.Name}");
_context.usp_RefreshSingleProduct("OPT", comp.CODE, _sys.Settings.MainMediaReport, _sys.Settings.FeaturedMediaSection,
_sys.Settings.MainMediaReport, _sys.Settings.MainMediaSection);
}
catch {
NLog.LogManager.GetCurrentClassLogger().Trace(" Refresh Product Failed");
}
}
catch (DbEntityValidationException ex) {
string details = string.Join(Environment.NewLine, ex.EntityValidationErrors.Select(e =>
string.Join(Environment.NewLine, e.ValidationErrors.Select(v =>
string.Format("{0} - {1}", v.PropertyName, v.ErrorMessage)))));
details += Environment.NewLine;
NLog.LogManager.GetCurrentClassLogger().Error(ex, details);
System.Diagnostics.Debugger.Break();
}
catch (Exception ex) {
NLog.LogManager.GetCurrentClassLogger().Error(ex);
System.Diagnostics.Debugger.Break();
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
int j = gridView2.DataRowCount + 1;
for (int i = 0; i < j; i++)
{
gridView2.MoveFirst();
gridView2.DeleteRow(gridView2.FocusedRowHandle);
}
foreach (int val in gridView1.GetSelectedRows())
{
gridView2.AddNewRow();
gridView2.SetFocusedRowCellValue("CODE", ImageComboBoxEditCopyCode.EditValue);
gridView2.SetFocusedRowCellValue("AGENCY", gridView1.GetRowCellValue(val, "AGENCY"));
gridView2.SetFocusedRowCellValue("ITIN", gridView1.GetRowCellValue(val, "ITIN"));
gridView2.SetFocusedRowCellValue("START_DATE", gridView1.GetRowCellValue(val, "START_DATE"));
gridView2.SetFocusedRowCellValue("END_DATE", gridView1.GetRowCellValue(val, "END_DATE"));
gridView2.SetFocusedRowCellValue("YEAR", gridView1.GetRowCellValue(val, "YEAR"));
gridView2.SetFocusedRowCellValue("H_L", gridView1.GetRowCellValue(val, "H_L"));
gridView2.SetFocusedRowCellValue("LAST_UPD", gridView1.GetRowCellValue(val, "LAST_UPD"));
gridView2.SetFocusedRowCellValue("UPD_INIT", gridView1.GetRowCellValue(val, "UPD_INIT"));
gridView2.SetFocusedRowCellValue("TP1", gridView1.GetRowCellValue(val, "TP1"));
gridView2.SetFocusedRowCellValue("TP2", gridView1.GetRowCellValue(val, "TP2"));
gridView2.SetFocusedRowCellValue("TP3", gridView1.GetRowCellValue(val, "TP3"));
gridView2.SetFocusedRowCellValue("TP4", gridView1.GetRowCellValue(val, "TP4"));
gridView2.SetFocusedRowCellValue("TP5", gridView1.GetRowCellValue(val, "TP5"));
gridView2.SetFocusedRowCellValue("TP6", gridView1.GetRowCellValue(val, "TP6"));
gridView2.SetFocusedRowCellValue("TP7", gridView1.GetRowCellValue(val, "TP7"));
gridView2.SetFocusedRowCellValue("TP8", gridView1.GetRowCellValue(val, "TP8"));
gridView2.SetFocusedRowCellValue("TP9", gridView1.GetRowCellValue(val, "TP9"));
gridView2.SetFocusedRowCellValue("TP10", gridView1.GetRowCellValue(val, "TP10"));
gridView2.SetFocusedRowCellValue("TP11", gridView1.GetRowCellValue(val, "TP11"));
gridView2.SetFocusedRowCellValue("TP12", gridView1.GetRowCellValue(val, "TP12"));
gridView2.SetFocusedRowCellValue("DESC1", gridView1.GetRowCellValue(val, "DESC1"));
gridView2.SetFocusedRowCellValue("DESC2", gridView1.GetRowCellValue(val, "DESC2"));
gridView2.SetFocusedRowCellValue("DESC3", gridView1.GetRowCellValue(val, "DESC3"));
gridView2.SetFocusedRowCellValue("DESC4", gridView1.GetRowCellValue(val, "DESC4"));
gridView2.SetFocusedRowCellValue("DESC5", gridView1.GetRowCellValue(val, "DESC5"));
gridView2.SetFocusedRowCellValue("DESC6", gridView1.GetRowCellValue(val, "DESC6"));
gridView2.SetFocusedRowCellValue("DESC7", gridView1.GetRowCellValue(val, "DESC7"));
gridView2.SetFocusedRowCellValue("DESC8", gridView1.GetRowCellValue(val, "DESC8"));
gridView2.SetFocusedRowCellValue("DESC9", gridView1.GetRowCellValue(val, "DESC9"));
gridView2.SetFocusedRowCellValue("DESC10", gridView1.GetRowCellValue(val, "DESC10"));
gridView2.SetFocusedRowCellValue("DESC11", gridView1.GetRowCellValue(val, "DESC11"));
gridView2.SetFocusedRowCellValue("DESC12", gridView1.GetRowCellValue(val, "DESC12"));
gridView2.SetFocusedRowCellValue("GRATE1", gridView1.GetRowCellValue(val, "GRATE1"));
gridView2.SetFocusedRowCellValue("GRATE2", gridView1.GetRowCellValue(val, "GRATE2"));
gridView2.SetFocusedRowCellValue("GRATE3", gridView1.GetRowCellValue(val, "GRATE3"));
gridView2.SetFocusedRowCellValue("GRATE4", gridView1.GetRowCellValue(val, "GRATE4"));
gridView2.SetFocusedRowCellValue("GRATE5", gridView1.GetRowCellValue(val, "GRATE5"));
gridView2.SetFocusedRowCellValue("GRATE6", gridView1.GetRowCellValue(val, "GRATE6"));
gridView2.SetFocusedRowCellValue("GRATE7", gridView1.GetRowCellValue(val, "GRATE7"));
gridView2.SetFocusedRowCellValue("GRATE8", gridView1.GetRowCellValue(val, "GRATE8"));
gridView2.SetFocusedRowCellValue("GRATE9", gridView1.GetRowCellValue(val, "GRATE9"));
gridView2.SetFocusedRowCellValue("GRATE10", gridView1.GetRowCellValue(val, "GRATE10"));
gridView2.SetFocusedRowCellValue("GRATE11", gridView1.GetRowCellValue(val, "GRATE11"));
gridView2.SetFocusedRowCellValue("GRATE12", gridView1.GetRowCellValue(val, "GRATE12"));
gridView2.SetFocusedRowCellValue("NRATE1", gridView1.GetRowCellValue(val, "NRATE1"));
gridView2.SetFocusedRowCellValue("NRATE2", gridView1.GetRowCellValue(val, "NRATE2"));
gridView2.SetFocusedRowCellValue("NRATE3", gridView1.GetRowCellValue(val, "NRATE3"));
gridView2.SetFocusedRowCellValue("NRATE4", gridView1.GetRowCellValue(val, "NRATE4"));
gridView2.SetFocusedRowCellValue("NRATE5", gridView1.GetRowCellValue(val, "NRATE5"));
gridView2.SetFocusedRowCellValue("NRATE6", gridView1.GetRowCellValue(val, "NRATE6"));
gridView2.SetFocusedRowCellValue("NRATE7", gridView1.GetRowCellValue(val, "NRATE7"));
gridView2.SetFocusedRowCellValue("NRATE8", gridView1.GetRowCellValue(val, "NRATE8"));
gridView2.SetFocusedRowCellValue("NRATE9", gridView1.GetRowCellValue(val, "NRATE9"));
gridView2.SetFocusedRowCellValue("NRATE10", gridView1.GetRowCellValue(val, "NRATE10"));
gridView2.SetFocusedRowCellValue("NRA TE11", gridView1.GetRowCellValue(val, "NRATE11"));
gridView2.SetFocusedRowCellValue("NRATE12", gridView1.GetRowCellValue(val, "NRATE12"));
gridView2.SetFocusedRowCellValue("COMM_FLG", gridView1.GetRowCellValue(val, "COMM_FLG"));
gridView2.SetFocusedRowCellValue("COMM_PCT", gridView1.GetRowCellValue(val, "COMM_PCT"));
}
gridView2.Focus();
gridView1.Focus();
if (checkEdit1.Checked)
{
if (MessageBox.Show("Are you sure you want to delete the original records?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
gridView1.DeleteSelectedRows();
context.SaveChanges();
}
}
}
private void searchInvRec_Click(object sender, EventArgs e)
{
while (iNVT2BindingSource.Count > 0)
{
iNVT2BindingSource.RemoveCurrent();
}
context.SaveChanges();
string query = String.Empty;
DateTime dateOne = Convert.ToDateTime(dateEdit1.Text);
DateTime dateTwo = Convert.ToDateTime(dateEdit2.Text);
query = String.Format("it.{0} like '{1}%'", "CODE", codeSearch.Text);
var LinvtMatches = context.INVT.Where(s => s.CODE == codeSearch.Text);
var invtMatches = context.INVT.Where(query);
// where c.TYPE == typeComboBoxEdit.Text && c.CODE == codeSearch.Text.TrimEnd() && c.DATE >= dateOne && c.DATE <= dateTwo
// select c;
if (!string.IsNullOrWhiteSpace(catSearch.Text))
{
query = String.Format("it.{0} like '{1}%'", "CAT", catSearch.Text);
invtMatches = invtMatches.Where(query);
}
if (!string.IsNullOrWhiteSpace(agencySearch.Text))
{
query = String.Format("it.{0} like '{1}%'", "AGENCY", agencySearch.Text);
invtMatches = invtMatches.Where(query);
}
if (!string.IsNullOrWhiteSpace(tpComboBoxEdit.Text))
{
query = String.Format("it.{0} like '{1}%'", "TP", tpComboBoxEdit.Text);
invtMatches = invtMatches.Where(query);
}
if (!string.IsNullOrWhiteSpace(dateEdit1.Text))
{
LinvtMatches = invtMatches.Where(s => s.DATE >= dateOne);
}
if (!string.IsNullOrWhiteSpace(dateEdit2.Text))
{
LinvtMatches = invtMatches.Where(s => s.DATE <= dateTwo);
}
//
// && c.CAT == catSearch.Text.TrimEnd() && c.AGENCY == agencySearch.Text.TrimEnd() && c.TP == tpComboBoxEdit.Text
foreach (var values in LinvtMatches)
{
if (Convert.ToString(checkEdit1.OldEditValue) == "badOnly" && ((values.AV_AMT.Value + values.ALLOCTD.Value != values.ORIG_AMT.Value) || (values.ALLOCTD.Value != values.AV_AMT.Value) || (Convert.ToString(checkEdit1.OldEditValue) != "badOnly")))
{
//load grid with invtMatrches
var resItmMatches = from c in context.RESITM
where c.TYPE == typeComboBoxEdit.Text && c.Inactive == false && (c.Status == "R" || c.Status == " " || c.Status == "O" || c.Status == null) &&
c.CAT == catSearch.Text.TrimEnd() && c.AGENCY == agencySearch.Text.TrimEnd() && c.STRT_DATE <= values.DATE &&
c.CODE == codeSearch.Text.TrimEnd()
select c;
//c.STRT_DATE.Value.AddDays(c.NBR_NIGHTS.Value - 1) >= values.DATE &&
if (resItmMatches.Count() == 0)
{
gridView1.AddNewRow();
gridView1.SetFocusedRowCellValue("TYPE", typeComboBoxEdit.Text);
gridView1.SetFocusedRowCellValue("CODE", values.CODE);
gridView1.SetFocusedRowCellValue("CAT", values.CAT);
gridView1.SetFocusedRowCellValue("AGENCY", values.AGENCY);
gridView1.SetFocusedRowCellValue("TP", values.TP);
gridView1.SetFocusedRowCellValue("DATE", values.DATE);
gridView1.SetFocusedRowCellValue("ALLOCTD", values.ALLOCTD);
gridView1.SetFocusedRowCellValue("AV_AMT", values.AV_AMT);
}
}
}
var resMatches = from c in context.RESITM
where c.TYPE == typeComboBoxEdit.Text && c.Inactive == false && (c.Status == "R" || c.Status == " " || c.Status == "O") &&
c.STRT_DATE >= dateOne && c.STRT_DATE <= dateTwo && c.CAT == catSearch.Text.TrimEnd() &&
c.AGENCY == agencySearch.Text.TrimEnd() && c.CODE == codeSearch.Text.TrimEnd()
select c;
foreach (var results in resMatches)
{
if (results.AGY_INVT.Length != 0)
{
if (string.IsNullOrWhiteSpace(results.Status) || results.Status == "R" || results.Status == "O")
{
gridView1.AddNewRow();
gridView1.SetFocusedRowCellValue("TYPE", typeComboBoxEdit.Text);
gridView1.SetFocusedRowCellValue("CODE", results.CODE);
gridView1.SetFocusedRowCellValue("CAT", results.CAT);
gridView1.SetFocusedRowCellValue("AGENCY", results.AGENCY);
if (defRoom.Length > 0)
{
gridView1.SetFocusedRowCellValue("TP", defRoom);
}
else
{
gridView1.SetFocusedRowCellValue("TP", results.RMCABIN);
}
DateTime D = results.STRT_DATE.Value;
gridView1.SetFocusedRowCellValue("DATE", D);
int avAmt = 0, alloctd = 0;
if (results.NBR_NIGHTS.Value > 0)
{
avAmt += results.NBR_NIGHTS.Value;
if (results.Status == "O")
{
alloctd += results.NBR_NIGHTS.Value;
}
}
if (results.NBR_NIGHTS2.Value > 0)
{
avAmt += results.NBR_NIGHTS2.Value;
if (results.Status == "O")
{
alloctd += results.NBR_NIGHTS2.Value;
}
}
if (results.NBR_NIGHTS3.Value > 0)
{
avAmt += results.NBR_NIGHTS3.Value;
if (results.Status == "O")
{
alloctd += results.NBR_NIGHTS3.Value;
}
}
if (results.NBR_NIGHTS4.Value > 0)
{
avAmt += results.NBR_NIGHTS4.Value;
if (results.Status == "O")
{
alloctd += results.NBR_NIGHTS4.Value;
}
}
gridView1.SetFocusedRowCellValue("ALLOCTD", alloctd);
gridView1.SetFocusedRowCellValue("AV_AMT", avAmt);
}
}
}
}
private bool SaveRecord(bool prompt)
{
try {
if (_selectedRecord == null)
{
return(true);
}
FinalizeBindings();
bool newRec = _selectedRecord.IsNew();
bool modified = newRec || IsModified(_selectedRecord);
if (modified)
{
if (prompt)
{
DialogResult result = DisplayHelper.QuestionYesNoCancel(this, "Do you want to save these changes?");
if (result == DialogResult.No)
{
if (newRec)
{
RemoveRecord();
}
else
{
RefreshRecord();
}
return(true);
}
else if (result == DialogResult.Cancel)
{
return(false);
}
}
if (!ValidateAll())
{
return(false);
}
if (_selectedRecord.EntityState == EntityState.Detached)
{
_context.WAYPOINT.AddObject(_selectedRecord);
}
_context.SaveChanges();
EntityInstantFeedbackSource.Refresh();
ShowActionConfirmation("Record Saved");
}
return(true);
}
catch (Exception ex) {
var objectStateManager = _context.ObjectStateManager;
var fieldInfo = objectStateManager.GetType().GetField("_entriesWithConceptualNulls", BindingFlags.Instance | BindingFlags.NonPublic);
var conceptualNulls = fieldInfo.GetValue(objectStateManager);
DisplayHelper.DisplayError(this, ex);
RefreshRecord(); //pull it back from db because that is its current state
//We must also Load and rebind the related entities from the db because context.Refresh doesn't do that
SetBindings();
return(false);
}
}
