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