void gridView2_DoubleClick(object sender, EventArgs e) { DevExpress.XtraGrid.Views.Grid.GridView gv = sender as DevExpress.XtraGrid.Views.Grid.GridView; Point pt = gv.GridControl.PointToClient(MousePosition); DevExpress.XtraGrid.Views.Grid.ViewInfo.GridHitInfo vi = gv.CalcHitInfo(pt); if (vi.InRowCell || vi.InRow) { var selecteddatarow = (BMS_DAL.DS.BMSDS.TFixturesRow)((DataRowView)this.bindingSource1.Current).Row; var datarowitem = (BMS_DAL.DS.BMSDS.TInvoicesRow)gv.GetDataRow(vi.RowHandle); datarowitem.OPER = BMS_Component.UserInfo.UserName; datarowitem.OP_DT = DateTime.Now; InvoiceItem item = new InvoiceItem(); item.Text = "Update Invoice"; item.FixDataRow = selecteddatarow; item.DataRowItem = datarowitem; item.InvoiceDetailDV = _ds.TInvoiceDetails.DefaultView; item.InvoiceDetailDV.RowFilter = string.Format("INVOICE_ID='{0}'", datarowitem.ID); switch (item.ShowDialog()) { case DialogResult.OK: MessageBox.Show(string.Format("Update {0} rows", this._daservice.UpdateFixtureWithRelation(_ds))); this._ds.TFixtures.Clear(); this._ds.TInvoices.Clear(); this._ds.TInvoiceDetails.Clear(); this._ds.Merge(_daservice.GetFixtureWithRelation()); this.BindData1(); this.BindData2(); break; case DialogResult.Cancel: this._ds.RejectChanges(); break; } } }
void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) { if (this.bindingSource1.Current == null) { MessageBox.Show("Please select a fix!"); return; } var selecteddatarow = (BMS_DAL.DS.BMSDS.TFixturesRow)((DataRowView)this.bindingSource1.Current).Row; var datarowitem = this._ds.TInvoices.NewTInvoicesRow(); datarowitem.VSL_ID = selecteddatarow.VSL_ID; datarowitem.CP_DATE = selecteddatarow.CP_DATE; datarowitem.CP_TYPE = selecteddatarow.CP_TYPE; datarowitem.CP_DESC = selecteddatarow.CP_DESC; datarowitem.MESSES = selecteddatarow.PAYER; datarowitem.HRORFRT = selecteddatarow.HRORFRT; datarowitem.DAYSORMT = selecteddatarow.DAYSORMT; datarowitem.BRKRATE_OWR = selecteddatarow.BRKRATE_OWR; datarowitem.BRKAMOUNT_OWR = selecteddatarow.BRKAMOUNT_OWR; datarowitem.BRKRATE_CHR = selecteddatarow.BRKRATE_CHR; datarowitem.BRKAMOUNT_CHR = selecteddatarow.BRKAMOUNT_CHR; datarowitem.OWR = selecteddatarow.OWR; datarowitem.CHR = selecteddatarow.CHR; datarowitem.FIXNO = selecteddatarow.FIXNO; datarowitem.STATUS = "PROGRESS"; datarowitem.REMARK = string.Empty; datarowitem.REFNO = string.Format("CW{0}", DateTime.Now.ToString("yyMMdd")); datarowitem.OPER = BMS_Component.UserInfo.UserName; datarowitem.INVOICE_DATE = DateTime.Now; datarowitem.CWNO = string.Empty; datarowitem.ATIN = string.Empty; datarowitem.RECEIVABLEAMOUNT = 0; datarowitem.RECEIVABLEDATE = DateTime.Now; datarowitem.PERIODS = "1"; datarowitem.BANKACCOUNT = "bromar"; datarowitem.FIX_ID = selecteddatarow.ID; datarowitem.REMARK = string.Empty; datarowitem.OP_DT = DateTime.Now; InvoiceItem item = new InvoiceItem(); item.Text = "Add Invoice"; item.FixDataRow = selecteddatarow; item.DataRowItem = datarowitem; item.InvoiceDetailDV = _ds.TInvoiceDetails.DefaultView; item.InvoiceDetailDV.RowFilter = string.Format("INVOICE_ID='{0}'", datarowitem.ID); this._ds.TInvoices.AddTInvoicesRow(datarowitem); switch (item.ShowDialog()) { case DialogResult.OK: MessageBox.Show(string.Format("Add {0} rows", this._daservice.UpdateFixtureWithRelation(this._ds))); this._ds.TFixtures.Clear(); this._ds.TInvoices.Clear(); this._ds.TInvoiceDetails.Clear(); this._ds.Merge(_daservice.GetFixtureWithRelation()); this.BindData1(); this.BindData2(); break; case DialogResult.Cancel: datarowitem = null; this._ds.RejectChanges(); break; } }