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