public void ShowBooking() { SQL.str = "Select * from ViewRommCheckIn where where BookingStatus='1' and BookingID='" + txtBookingID.Text + "'"; SQL.RunQuery(SQL.str); DGV.DataSource = SQL.ds.Tables[0]; DGV.Refresh(); }
public void ShowRoom() { string RoomStuts = ""; if (cmbStuts.SelectedIndex == 0) { RoomStuts = "0"; } else if (cmbStuts.SelectedIndex == 1) { RoomStuts = "1"; } else if (cmbStuts.SelectedIndex == 2) { RoomStuts = "2"; } else if (cmbStuts.SelectedIndex == 3) { RoomStuts = "3"; } SQL.str = "Select * from ViewCheckRoom where RoomStatus='" + RoomStuts + "'"; SQL.RunQuery(SQL.str); DGV.DataSource = SQL.ds.Tables[0]; DGV.Refresh(); }
private void ListartFrm_Load(object sender, EventArgs e) { L_ITEMS.Text = _controlador.TotItems; DGV.DataSource = _controlador.Source; DGV.Refresh(); printDialog1.Document = printDocument1; }
private void ImportarDoc() { _controlador.ImportarDoc(); ActualizarDatosTotales(); DGV.Refresh(); IniciarBusqueda(); }
private void BuscarFrm_Load(object sender, EventArgs e) { TB_CADENA.Text = ""; DGV.DataSource = _controlador.Source; DGV.Refresh(); L_ITEMS.Text = _controlador.Items; }
private void fEditarAsiento_EditarOk(object sender, int e) { var it = (OOB.Contable.Asiento.Ficha)bs.Current; var r01 = Globals.MyData.Asiento_GetById(e); if (r01.Result == OOB.Resultado.EnumResult.isError) { Helpers.Msg.Error(r01.Mensaje); return; } it.Id = r01.Entidad.Id; it.Comprobante = r01.Entidad.Comprobante; it.Detalle = r01.Entidad.Detalle; it.FechaEmision = r01.Entidad.FechaEmision; it.TipoAsiento = r01.Entidad.TipoAsiento; it.EstaAnulado = r01.Entidad.EstaAnulado; it.EstaProcesado = r01.Entidad.EstaProcesado; it.AutoGenerado = r01.Entidad.AutoGenerado; it.Importe = r01.Entidad.Importe; it.TipoDocumento = r01.Entidad.TipoDocumento; if (it.EstaProcesado == false) { L_PENDIENTE.Visible = true; } else { L_PENDIENTE.Visible = false; } DGV.Refresh(); }
private void AdministradorFrm_Load(object sender, EventArgs e) { DTP_DESDE.Value = _controlador.FechaDesde; DTP_HASTA.Value = _controlador.FechaHasta; TB_CADENA_BUS_PROV.Text = _controlador.Proveedor; CB_SUCURSAL.DataSource = _controlador.SucursalSource; CB_SUCURSAL.SelectedIndex = -1; CB_TIPO_DOC.DataSource = _controlador.TipoDocSource; CB_TIPO_DOC.SelectedIndex = -1; L_TITULO.Text = _controlador.Titulo; switch (_controlador.TipoAdministrador) { case enumerados.EnumTipoAdministrador.AdmDocumentos: InicializarGrid_1(); break; } Actualizar(); DGV.DataSource = _controlador.ItemsSource; DGV.Refresh(); DGV.Columns[0].Frozen = true; DGV.Columns[1].Frozen = true; DGV.Columns[2].Frozen = true; DGV.Columns[3].Frozen = true; }
private void RemisionFrm_Load(object sender, EventArgs e) { L_ITEMS.Text = _controlador.ItemEncontrados; L_PROVEEDOR.Text = _controlador.Proveedor; DGV.DataSource = _controlador.Source; DGV.Refresh(); }
private void fEditar_AsientoDetalleOk(object sender, List <Detalle> e) { var ficha = (OOB.Contable.Asiento.Generar.Ficha)bs.Current; var ln = new List <OOB.Contable.Asiento.Generar.FichaDetalle>(); int nr = 1; foreach (var it in e) { var nit = new OOB.Contable.Asiento.Generar.FichaDetalle() { IdCta = it.Cta.Id, CodigoCta = it.Codigo, DescripcionCta = it.Descripcion, Naturaleza = it.Cta.Naturaleza, MontoDebe = it.Debe, MontoHaber = it.Haber, Renglon = nr, Signo = ficha.Signo, }; ln.Add(nit); } ficha.IsOk = true; ficha.Detalles = ln; DGV.Refresh(); Limpiar_AsientoDetalles(); ActualizarTotales(); }
private void PrecioMayorFrm_Load(object sender, EventArgs e) { DGV.DataSource = _controlador.Source; DGV.Focus(); DGV.Refresh(); L_PRODUCTO.Text = _controlador.Producto; }
private void AjusteNivelFrm_Load(object sender, EventArgs e) { Inicializar(); DGV.DataSource = _controlador.Lista; DGV.Refresh(); L_ITEMS.Text = _controlador.Items; }
private void Buscar() { _controlador.Buscar(); DGV.Refresh(); ActualizarTotales(); TB_CADENA.Text = ""; TB_CADENA.Focus(); }
private void button1_Click(object sender, EventArgs e) { string sql = "Select MAGD,NGAY,KLMUA,GTMUA,KLBAN,GTBAN,KLGTRONG,GTGDRONG,ROOM,DANGSH from HR.SANGIAODICH "; this.ShowData(sql); DGV.Update(); DGV.Refresh(); }
private void LimpiarDocumento() { _controlador.LimpiarDocumento(); ActualizarDatosDocumento(); ActualizarDatosTotales(); DGV.Refresh(); IniciarBusqueda(); }
private void ListaFrm_Load(object sender, EventArgs e) { DGV.DataSource = _controlador.Source; DGV.Columns[3].Visible = _controlador.IsCantidadVisible; DGV.Columns[4].Visible = _controlador.IsPrecioVisible; DGV.Focus(); DGV.Refresh(); }
private void CommonUpdateTimer_Tick(object sender, EventArgs e) { DGV.Refresh(); //---------------------------------------------// if (_Model.TryGetSingleRunning(out var singleRunningRow)) { UpdatedSingleRunningRow?.Invoke(singleRunningRow); } }
private void DejarPendiente() { _controlador.DejarPendiente(); if (_controlador.DejarPendienteIsOk) { ActualizarDatosDocumento(); ActualizarDatosTotales(); DGV.Refresh(); IniciarBusqueda(); } }
private void Actualizar() { var nr = _controlador.Formato; L_PRODUCTO.Text = _controlador.Producto; L_EMPAQUE.Text = _controlador.EmpaqueDes; L_FISICA.Text = _controlador.ExFisica.ToString(nr); L_RESERVA.Text = _controlador.ExReserva.ToString(nr); L_DISPONIBLE.Text = _controlador.ExDisponible.ToString(nr); DGV.Refresh(); }
private void VerFrm_Load(object sender, EventArgs e) { DGV.DataSource = _controlador.Source; DGV.Focus(); DGV.Refresh(); L_DOCUMENTO_TIPO.Text = _controlador.DocumentoTipo; L_DOCUMENTO.Text = _controlador.DocumentoNro; L_FECHA.Text = _controlador.Fecha; L_CLIENTE.Text = _controlador.DatosCliente; L_TOTAL.Text = _controlador.TotalDocumento.ToString("n2"); }
private void Limpiar2() { CB_DEPOSITO.SelectedIndex = -1; CB_DEPARTAMENTO.SelectedIndex = -1; L_DEPOSITO.Text = _controlador.Deposito; BT_BUSCAR.Enabled = _controlador.IsBuscarHabilitado; CB_DEPOSITO.Enabled = _controlador.IsBuscarHabilitado; CB_DEPARTAMENTO.Enabled = _controlador.IsBuscarHabilitado; TB_CADENA.Enabled = _controlador.IsBuscarHabilitado; TB_CADENA.Text = ""; DGV.Refresh(); }
private void AdministradorFrm_Load(object sender, EventArgs e) { _modoInicializar = true; CB_SUCURSAL.DataSource = _controlador.SucursalSource; CB_TIPO_DOC.DataSource = _controlador.TipoDocSource; DTP_DESDE.Value = _controlador.FechaDesde; DTP_HASTA.Value = _controlador.FechaHasta; CB_SUCURSAL.SelectedValue = _controlador.SucursalID; CB_TIPO_DOC.SelectedValue = _controlador.TipoDocID; _modoInicializar = false; L_TITULO.Text = _controlador.Titulo; Actualizar(); DGV.DataSource = _controlador.Source; DGV.Refresh(); }
private void EliminarDocumento() { if (bs.Current != null) { var doc = (OOB.Contable.Asiento.Generar.Ficha)bs.Current; var msg = MessageBox.Show("Incluir Documento ?", "*** ALERTA ***", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (msg == System.Windows.Forms.DialogResult.Yes) { doc.Incluir = true; } else if (msg == System.Windows.Forms.DialogResult.No) { doc.Incluir = false; } DGV.Refresh(); ActualizarTotales(); } }
private void AdministradorFrm_Load(object sender, EventArgs e) { InicializarGrid(); _modoInicializa = true; CB_SUCURSAL.DataSource = _controlador.SucursalSource; CB_TIPO_DOC.DataSource = _controlador.TipoDocSource; DGV.DataSource = _controlador.ItemsSource; DGV.Refresh(); DGV.Columns[0].Frozen = true; DGV.Columns[1].Frozen = true; DGV.Columns[2].Frozen = true; DGV.Columns[3].Frozen = true; _modoInicializa = false; Actualizar(); ActualizarControles(); }
private void btnDelete_Click(object sender, EventArgs e) { try { if (Controller.PermissionController.CheckPermission(Model.PermissionType.PRODUCT_CATEGORY_DELETE)) { int id = int.Parse(DGV.SelectedRows[0].Cells[0].Value.ToString()); var cat = controller.GetCategory(id); controller.RemoveCategory(cat); txtDelete.Clear(); txtEdit.Clear(); DGV.Refresh(); } else { throw new Exception("Access Denied.!"); } } catch (Exception ex) { Helper.MessageHelper.AlertError(ex.Message); } }
private void DGV_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { if (e.ColumnIndex == 2) { _controlador.OrdenaPorDeposito(); } if (e.ColumnIndex == 1) { _controlador.OrdenaPorNombre(); } if (e.ColumnIndex == 3) { _controlador.OrdenaPorDepartamento(); } if (e.ColumnIndex == 4) { _controlador.OrdenaPorExistencia(); } if (e.ColumnIndex == 11) { _controlador.OrdenaPorCostoEdad(); } DGV.Refresh(); }
private void ListaFrm_Load(object sender, EventArgs e) { DGV.DataSource = bs; DGV.Focus(); DGV.Refresh(); }
private void PluFrm_Load(object sender, EventArgs e) { DGV.DataSource = _controlador.Source; DGV.Refresh(); L_ITEMS.Text = _controlador.ItemsEncontrados; }
private void AbrirPendienteFrm_Load(object sender, EventArgs e) { DGV.DataSource = _controlador.Source; DGV.Refresh(); IrFoco(); }
public void netposion(int tok, int lotsize, int Tlot, double b_s, double rate) { try { int t_1 = 0; query1 = Global.Instance.OrdetTable.AsEnumerable().Where(p => p.Field <string>("Status") == orderStatus.Traded.ToString() && Convert.ToInt32(p.Field <string>("TokenNo")) == tok).GroupBy(r => Convert.ToInt32(r.Field <string>("TokenNo"))) .Select(store => new SelectListItem { TredingSymbol = System.Text.ASCIIEncoding.ASCII.GetString(csv.CSV_Class.cimlist.First(tkn => tkn.Token == Convert.ToInt32(store.Key)).Name), TokenNo = Convert.ToInt32(store.Key), // InstrumentName = store.First().Field<string>("InstrumentName"), BuyQty = (store.Where(a => a.Field <String>("Buy_SellIndicator") == "BUY").Sum(p => Convert.ToInt32(p.Field <string>("Volume")))), BuyAvg = (store.Where(a => a.Field <String>("Buy_SellIndicator") == "BUY").Sum(p => ((Convert.ToInt32(p.Field <string>("Volume"))) * Convert.ToDouble(p.Field <string>("FillPrice")))) / ((store.Where(a => a.Field <String>("Buy_SellIndicator") == "BUY").Sum(p => Convert.ToInt32(p.Field <string>("Volume")))) == 0 ? 1 : (store.Where(a => a.Field <String>("Buy_SellIndicator") == "BUY").Sum(p8 => Convert.ToInt32(p8.Field <string>("Volume")))))), SellQty = (store.Where(a => a.Field <String>("Buy_SellIndicator") == "SELL").Sum(p => Convert.ToInt32(p.Field <string>("Volume")))), SellAvg = (store.Where(a => a.Field <String>("Buy_SellIndicator") == "SELL").Sum(p => (Convert.ToInt32(p.Field <string>("Volume"))) * Convert.ToDouble(p.Field <string>("FillPrice"))) / ((store.Where(a => a.Field <String>("Buy_SellIndicator") == "SELL").Sum(p => Convert.ToInt32(p.Field <string>("Volume")))) == 0 ? 1 : (store.Where(a => a.Field <String>("Buy_SellIndicator") == "SELL").Sum(p8 => Convert.ToInt32(p8.Field <string>("Volume")))))), NetQty = ((store.Where(a1 => a1.Field <String>("Buy_SellIndicator") == "BUY").Sum(p1 => Convert.ToInt32(p1.Field <string>("Volume"))))) - ((store.Where(a2 => a2.Field <String>("Buy_SellIndicator") == "SELL").Sum(p2 => Convert.ToInt32(p2.Field <string>("Volume"))))), }).ToList(); //if(b_s==1) //{ // query1.FirstOrDefault().buy_rate = rate; //} //else //{ // query1.FirstOrDefault().Sell_rate = rate; //} var TempList = csv.CSV_Class.cimlist.Where(a => a.Token == tok).ToList(); var checktok = TempList.First().EGMAGM; if (Global.Instance.NetBookTable.AsEnumerable().Where(p => p.Field <string>("TredingSymbol") == checktok).Count() > 0) { //var rows = Global.Instance.NetBookTable.AsEnumerable().ToList(); //var fg = (rows.FindIndex(a => Convert.ToString(a.Field<string>("Symbol")) == "Total")); //if (fg >= 0) //{ // Global.Instance.NetBookTable.Rows[fg].Delete(); //} var rowlist = Global.Instance.NetBookTable.AsEnumerable().Where(p => p.Field <string>("TredingSymbol") == checktok).ToList(); try { foreach (var i in rowlist) { i["Token"] = query1.FirstOrDefault().TokenNo; i["TredingSymbol"] = query1.FirstOrDefault().TredingSymbol; i["BuyQty"] = query1.FirstOrDefault().BuyQty; i["BuyAvg"] = query1.FirstOrDefault().BuyAvg; i["SellQty"] = -query1.FirstOrDefault().SellQty; i["SellAvg"] = query1.FirstOrDefault().SellAvg; //========================================================================== // i["NetQty"] = query1.FirstOrDefault().BuyQty + -query1.FirstOrDefault().SellQty; // i["NetValue"] = Math.Round(Convert.ToDouble((-query1.FirstOrDefault().SellAvg) * (-query1.FirstOrDefault().SellQty)), 3) + Math.Round(Convert.ToDouble((-query1.FirstOrDefault().BuyAvg) * (query1.FirstOrDefault().BuyQty)), 3); //------------------------------------------------------------------------------ i["InstrumentName"] = TempList.FirstOrDefault().InstrumentName; i["Symbol"] = TempList.FirstOrDefault().Symbol; i["OptionType"] = TempList.FirstOrDefault().OptionType; i["StrikePrice"] = Convert.ToDouble(TempList.FirstOrDefault().StrikePrice / 100); i["ExpiryDate"] = LogicClass.ConvertFromTimestamp(TempList.FirstOrDefault().ExpiryDate); i["LTP"] = Global.Instance.ltp[tok].LTP; i["Delta"] = Math.Round(Convert.ToDouble(Global.Instance.ltp[tok].Delta), 3); i["NetQtyDelta"] = Math.Round(Convert.ToDouble((query1.FirstOrDefault().NetQty) * (Global.Instance.ltp[tok].Delta)), 3); // i["BUYRATE"] = Math.Round(Convert.ToDouble(query1.FirstOrDefault().buy_rate),3); // i["SELLRATE"] = Math.Round(Convert.ToDouble(query1.FirstOrDefault().Sell_rate),3); i["BUYVALUE"] = Math.Round(Convert.ToDouble((-query1.FirstOrDefault().BuyAvg) * (query1.FirstOrDefault().BuyQty)), 3); i["SELLVALUE"] = Math.Round(Convert.ToDouble((-query1.FirstOrDefault().SellAvg) * (-query1.FirstOrDefault().SellQty)), 3); i["MTM"] = Math.Round((Convert.ToDouble((-query1.FirstOrDefault().SellAvg) * (-query1.FirstOrDefault().SellQty)) + Convert.ToDouble((-query1.FirstOrDefault().BuyAvg) * (query1.FirstOrDefault().BuyQty))) - ((Global.Instance.ltp[tok].LTP) * (-query1.FirstOrDefault().BuyQty + -query1.FirstOrDefault().SellQty)), 3); // //========================================= // Global.Instance.NetBookTable.Rows.Add("Total", "-", Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<int>("StrikePrice")), "-", "-", Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<int>("BuyQty")), //Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("BuyAvg")), Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("BUYVALUE")), Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<int>("SellQty")), // Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("SellAvg")), Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("SELLVALUE")), // 0, 0, // Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("MTM")), // Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("LTP")), Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("Delta")), Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("NetQtyDelta")), 0, 0); // //============= } } catch (Exception Ex) { MessageBox.Show(" Exception " + Ex.StackTrace.ToString()); } } else { //================================== === == == == == == == var rows = Global.Instance.NetBookTable.AsEnumerable().ToList(); //var fg = (rows.FindIndex(a => Convert.ToString(a.Field<string>("Symbol")) == "Total")); //if (fg >= 0) //{ // Global.Instance.NetBookTable.Rows[fg].Delete(); //} DataRow i = Global.Instance.NetBookTable.NewRow(); i["Token"] = query1.FirstOrDefault().TokenNo; i["TredingSymbol"] = query1.FirstOrDefault().TredingSymbol; i["BuyQty"] = query1.FirstOrDefault().BuyQty; i["BuyAvg"] = query1.FirstOrDefault().BuyAvg; i["SellQty"] = -query1.FirstOrDefault().SellQty; i["SellAvg"] = query1.FirstOrDefault().SellAvg; i["LTP"] = Global.Instance.ltp[tok].LTP; i["Delta"] = Math.Round(Convert.ToDouble(Global.Instance.ltp[tok].Delta), 3); i["NetQtyDelta"] = Math.Round(Convert.ToDouble((Convert.ToDouble(query1.FirstOrDefault().NetQty) * (Global.Instance.ltp[tok].Delta))), 3); i["InstrumentName"] = TempList.FirstOrDefault().InstrumentName; i["Symbol"] = TempList.FirstOrDefault().Symbol; i["OptionType"] = TempList.FirstOrDefault().OptionType; i["StrikePrice"] = Convert.ToDouble(TempList.FirstOrDefault().StrikePrice / 100); i["ExpiryDate"] = LogicClass.ConvertFromTimestamp(TempList.FirstOrDefault().ExpiryDate); i["BUYVALUE"] = Math.Round(Convert.ToDouble((-query1.FirstOrDefault().BuyAvg) * (query1.FirstOrDefault().BuyQty)), 3); i["SELLVALUE"] = Math.Round(Convert.ToDouble((-query1.FirstOrDefault().SellAvg) * (-query1.FirstOrDefault().SellQty)), 3); i["MTM"] = Math.Round((Convert.ToDouble((-query1.FirstOrDefault().SellAvg) * (-query1.FirstOrDefault().SellQty)) + Convert.ToDouble((-query1.FirstOrDefault().BuyAvg) * (query1.FirstOrDefault().BuyQty))) - ((Global.Instance.ltp[tok].LTP) * (-query1.FirstOrDefault().BuyQty + -query1.FirstOrDefault().SellQty)), 3); // i["MTM"] = Math.Round(Convert.ToDouble( (query1.FirstOrDefault().NetValue) - ((Global.Instance.ltp[tok].LTP) * (-query1.FirstOrDefault().NetQty))),3); Global.Instance.NetBookTable.Rows.Add(i); //Global.Instance.NetBookTable.Rows.Add("Total", "-", Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<int>("StrikePrice")), "-", "-", Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<int>("BuyQty")), // Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("BuyAvg")), Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("BUYVALUE")), Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<int>("SellQty")), // Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("SellAvg")), Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("SELLVALUE")), // 0, 0, // Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("MTM")), // Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("LTP")), Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("Delta")), Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("NetQtyDelta")), 0, 0); } //DataRow ii = Global.Instance.NetBookTable.NewRow(); //ii["InstrumentName"] = "Total"; //Global.Instance.NetBookTable.Rows.Add(ii); DGV.DataSource = Global.Instance.NetBookTable; } catch (Exception ex) { Task.Factory.StartNew(() => LogWriterClass.logwritercls.logs("tradeerror", ex.StackTrace.ToString())); } if (this.InvokeRequired) { MethodInvoker del = delegate { DGV.Refresh(); }; this.Invoke(del); return; } }
public void netposion2(int tok, int lotsize, int Tlot, double b_s, double rate) { try { int t_1 = 0; query1 = Global.Instance.OrdetTable.AsEnumerable().Where(p => p.Field <string>("Status") == orderStatus.Traded.ToString()).GroupBy(r => Convert.ToInt32(r.Field <string>("TokenNo"))) .Select(store => new SelectListItem { TredingSymbol = System.Text.ASCIIEncoding.ASCII.GetString(csv.CSV_Class.cimlist.First(tkn => tkn.Token == Convert.ToInt32(store.Key)).Name), TokenNo = Convert.ToInt32(store.Key), BuyQty = (store.Where(a => a.Field <String>("Buy_SellIndicator") == "BUY").Sum(p => Convert.ToInt32(p.Field <string>("Volume")))), BuyAvg = (store.Where(a => a.Field <String>("Buy_SellIndicator") == "BUY").Sum(p => ((Convert.ToInt32(p.Field <string>("Volume"))) * Convert.ToDouble(p.Field <string>("FillPrice")))) / ((store.Where(a => a.Field <String>("Buy_SellIndicator") == "BUY").Sum(p => Convert.ToInt32(p.Field <string>("Volume")))) == 0 ? 1 : (store.Where(a => a.Field <String>("Buy_SellIndicator") == "BUY").Sum(p8 => Convert.ToInt32(p8.Field <string>("Volume")))))), SellQty = (store.Where(a => a.Field <String>("Buy_SellIndicator") == "SELL").Sum(p => Convert.ToInt32(p.Field <string>("Volume")))), SellAvg = (store.Where(a => a.Field <String>("Buy_SellIndicator") == "SELL").Sum(p => (Convert.ToInt32(p.Field <string>("Volume"))) * Convert.ToDouble(p.Field <string>("FillPrice"))) / ((store.Where(a => a.Field <String>("Buy_SellIndicator") == "SELL").Sum(p => Convert.ToInt32(p.Field <string>("Volume")))) == 0 ? 1 : (store.Where(a => a.Field <String>("Buy_SellIndicator") == "SELL").Sum(p8 => Convert.ToInt32(p8.Field <string>("Volume")))))), NetQty = ((store.Where(a1 => a1.Field <String>("Buy_SellIndicator") == "BUY").Sum(p1 => Convert.ToInt32(p1.Field <string>("Volume"))))) - ((store.Where(a2 => a2.Field <String>("Buy_SellIndicator") == "SELL").Sum(p2 => Convert.ToInt32(p2.Field <string>("Volume"))))), }).ToList(); if (b_s == 1) { query1.FirstOrDefault().buy_rate = rate; } else { query1.FirstOrDefault().Sell_rate = rate; } //================================== === == == == == == == == == == == for (int j = 0; j < query1.Count(); j++) { var TempList = csv.CSV_Class.cimlist.Where(a => a.Token == query1[j].TokenNo).ToList(); var checktok = TempList.First().EGMAGM; DataRow i = Global.Instance.NetBookTable.NewRow(); i["Token"] = query1[j].TokenNo; i["TredingSymbol"] = query1[j].TredingSymbol; i["BuyQty"] = query1[j].BuyQty; i["BuyAvg"] = query1[j].BuyAvg; i["SellQty"] = query1[j].SellQty; i["SellAvg"] = query1[j].SellAvg; i["NetQty"] = query1[j].BuyAvg - query1[j].SellQty; // i["NetQty"] = query1[j].NetQty; // i["NetQty"] = query1[j].NetQty; // i["BEP"] = query1[j].BEP; // i["NetValue"] = query1[j].NetValue; i["NetValue"] = Math.Round(Convert.ToDouble((query1[j].Sell_rate) * (query1[j].SellQty)), 3) + Math.Round(Convert.ToDouble((query1[j].buy_rate) * (query1[j].BuyQty)), 3); i["InstrumentName"] = TempList.FirstOrDefault().InstrumentName; i["Symbol"] = TempList.FirstOrDefault().Symbol; i["OptionType"] = TempList.FirstOrDefault().OptionType; i["StrikePrice"] = Convert.ToDouble(TempList.FirstOrDefault().StrikePrice / 100); i["ExpiryDate"] = LogicClass.ConvertFromTimestamp(TempList.FirstOrDefault().ExpiryDate); i["LTP"] = 0; i["Delta"] = 0; i["NetQtyDelta"] = 0; i["BUYVALUE"] = Math.Round(Convert.ToDouble((-query1.FirstOrDefault().BuyAvg) * (query1.FirstOrDefault().BuyQty)), 3); i["SELLVALUE"] = Math.Round(Convert.ToDouble((-query1.FirstOrDefault().SellAvg) * (-query1.FirstOrDefault().SellQty)), 3); //i["BUYVALUE"] = Math.Round(Convert.ToDouble((query1[j].buy_rate) * (query1[j].BuyQty)), 3); //i["SELLVALUE"] = Math.Round(Convert.ToDouble((query1[j].Sell_rate) * (query1[j].SellQty)), 3); i["MTM"] = 0; //======= ========== ========= ============= ========== =========== ======================= ============ ========== // lblbq.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<int>("BuyQty")).ToString(); // lblsq.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<int>("SellQty")).ToString(); // lvlNetQt.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<int>("NetQty")).ToString(); // // lvelNetVal.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("NetValue")).ToString(); // lblstrike.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<int>("StrikePrice")).ToString(); // lvlLTP.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("LTP")).ToString(); // lvlDelta.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("Delta")).ToString(); // lvlNetQD.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("NetQtyDelta")).ToString(); // lbllblBR.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("BUYRATE")).ToString(); // lvlSealRate.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("SELLRATE")).ToString(); // lblBV.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("BUYVALUE")).ToString(); // lvlSealval.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("SELLVALUE")).ToString(); //// lvlMtm.Text = Global.Instance.NetBookTable.AsEnumerable().Sum(x => x.Field<double>("MTM")).ToString(); //============ ============ ========== ========= ======= ======= ================== ==================== ============= ======== ======= Global.Instance.NetBookTable.Rows.Add(i); } DGV.DataSource = Global.Instance.NetBookTable; } catch (Exception ex) { Task.Factory.StartNew(() => LogWriterClass.logwritercls.logs("tradeerror", ex.StackTrace.ToString())); } if (this.InvokeRequired) { MethodInvoker del = delegate { DGV.Refresh(); }; this.Invoke(del); return; } }