public void LoadProducts() { listProducts = productModel.getProductsToSale(); DataTable dtProduct = ConvertCustom.ListToDataTable <TblProductsDTO>(listProducts); bsProduct = new BindingSource() { DataSource = dtProduct }; //binding data to data grid view form.getBnProduct().BindingSource = bsProduct; form.getDgvProduct().DataSource = bsProduct; //hide unessesary column form.getDgvProduct().Columns["idProduct"].Visible = false; form.getDgvProduct().Columns["status"].Visible = false; form.getDgvProduct().Columns["idCategory"].Visible = false; form.getDgvProduct().Columns["categoryName"].Visible = false; List <TblCategoryDTO> listCategory = categoryModel.getAll(); foreach (var category in listCategory) { form.getCmbCategory().Items.Add(category.name); } foreach (DataGridViewColumn column in form.getDgvProduct().Columns) { column.SortMode = DataGridViewColumnSortMode.NotSortable; } }
public void getAllProduct() { try { List <TblProductsDTO> listProducts = productModel.getProducts(); DataTable dataTable = ConvertCustom.ListToDataTable(listProducts); bindingSourceProduct = new BindingSource() { DataSource = dataTable }; form.GetBindingNavigatorProduct().BindingSource = bindingSourceProduct; form.GetDataGridViewProduct().DataSource = bindingSourceProduct; form.GetDataGridViewProduct().Columns["idProduct"].Visible = false; form.GetDataGridViewProduct().Columns["idCategory"].Visible = false; form.GetDataGridViewProduct().Columns["status"].Visible = false; form.GetComboBoxTable().DataSource = bindingSourceCategory; form.GetComboBoxTable().DisplayMember = "name"; form.GetComboBoxTable().ValueMember = "idCategory"; clearDataBindingTextProduct(); bindingDataTextProduct(); } catch (Exception e) { MessageBox.Show(MessageUtil.ERROR + " Get All Product" + e.Message); } }
public void LoadCustomers() { List <TblCustomerDTO> listCustomers = customerModel.getCustomers(); if (listCustomers != null) { } DataTable dtCustomer = ConvertCustom.ListToDataTable <TblCustomerDTO>(listCustomers); bsCustomer = new BindingSource() { DataSource = dtCustomer }; //binding data to data grid view form.getBnCustomer().BindingSource = bsCustomer; form.getDgvCustomer().DataSource = bsCustomer; //hide unnecessary column form.getDgvCustomer().Columns["phone"].Visible = false; form.getDgvCustomer().Columns["address"].Visible = false; form.getDgvCustomer().Columns["point"].Visible = false; //clear and add new data binding clearDataBindingTextCustomer(); bindingDataTextCustomer(); }
public void SearchRevenues(DateTime date) { float total = orderModel.LoadTotal(date); List <RevenuesDTO> listDetail = orderModel.LoadOrderDetail(date); if (listDetail != null) { DataTable dtOrderDetail = ConvertCustom.ListToDataTable <RevenuesDTO>(listDetail); bsOrderdetail = new BindingSource() { DataSource = dtOrderDetail }; //binding data to data grid view form.getBnOrderDetail().BindingSource = bsOrderdetail; form.getDgvOrderDetail().DataSource = bsOrderdetail; form.gettotal().Text = total.ToString(); //hide unnecessary column form.getDgvOrderDetail().Columns["Customer"].Visible = false; form.getDgvOrderDetail().Columns["Salesman"].Visible = false; form.getDgvOrderDetail().Columns["total"].Visible = false; //clear and add new data binding clearDataBindingTextOrderdetail(); bindingDataTextOrderdetail(); } }
public void loadEmp() { try { List <TblEmployeesDTO> listEmp = model.getAll(); DataTable dataTable = ConvertCustom.ListToDataTable(listEmp); bsEmp = new BindingSource() { DataSource = dataTable }; bindingSource(); } catch (Exception e) { MessageBox.Show(MessageUtil.ERROR + " Get All Employee"); } }
public void LoadEmpByRole(frmManager_v2 form) { try { string role = form.getRole(); List <TblEmployeesDTO> list = model.LoadEmpByRole(role); DataTable dataTable = ConvertCustom.ListToDataTable(list); bsEmp = new BindingSource() { DataSource = dataTable }; bindingSource(); } catch (Exception e) { MessageBox.Show(MessageUtil.ERROR + " Load Employee By Role"); } }
public void getAllCategory() { try { List <TblCategoryDTO> categoryDTOs = categoryModel.getAll(); DataTable dataTable = ConvertCustom.ListToDataTable(categoryDTOs); bindingSourceCategory = new BindingSource() { DataSource = dataTable }; form.GetDataGridViewCategory().DataSource = bindingSourceCategory; form.GetDataGridViewCategory().Columns["idCategory"].Visible = false; form.GetBindingNavigatorCategory().BindingSource = bindingSourceCategory; clearDataBindingTextCategory(); bindingDataTextCategory(); } catch (Exception e) { MessageBox.Show(MessageUtil.ERROR + " Get All Category"); } }
public void LoadProductsOrder() { if (listProductOrder == null) { form.getDgvItemOfOrder().DataSource = null; form.getDgvItemOfOrder().Rows.Clear(); return; } DataTable dtProduct = ConvertCustom.ListToDataTable <CartItemDTO>(listProductOrder); //binding data to data grid view form.getDgvItemOfOrder().DataSource = dtProduct; form.getDgvItemOfOrder().Columns["idProduct"].Visible = false; foreach (DataGridViewColumn column in form.getDgvItemOfOrder().Columns) { column.SortMode = DataGridViewColumnSortMode.NotSortable; } }
private void SheetTrajectory(ref XLWorkbook workbook) { // This is invariant NumberFormatInfo format = new NumberFormatInfo(); // Set the 'splitter' for thousands format.NumberGroupSeparator = "."; // Set the decimal seperator format.NumberDecimalSeparator = ","; string sheetName = "Trajectory"; var worksheet01 = workbook.Worksheets.Add(sheetName); int numberLines = ExtendedStreamReader.LinesOfFile(dirServerDebug + @"\" + debugFile); //DADOS string line; List <Trajectory> trajectory = new List <Trajectory>(); int _MCStep = 0; using (ExtendedStreamReader file = new ExtendedStreamReader(dirServerDebug + @"\" + debugFile, this.param.dataToProcess.Guid, this.param.dataToProcess.crypt)) { double rg = 0; //Calculo acumulado do Raio de GIração int cont = 0; //Contador //int lastMove = 0; //valor do último movimento int contAdd = 1; //contador adicional while ((line = file.ReadLine()) != null) { if (String.IsNullOrEmpty(line)) { break; } if (cont > 0) { string[] col = line.Split('\t'); int numberMov = ConvertCustom.ToInt32(col[0]); if (numberMov < (delta * contAdd) + 1) { rg += double.Parse(col[3], format); //coluna no qual contêm valor do raio de giração _MCStep = ConvertCustom.ToInt32(col[0]); } else { double value = ((double)1 / delta) * rg; trajectory.Add(new Trajectory() { MCStep = _MCStep, rg = value }); contAdd++; rg = 0; rg += Convert.ToDouble(col[3]); //coluna no qual contêm valor do raio de giração } } cont++; } file.Close(); file.Dispose(); } //FIM DADOS //DATASHEET worksheet01.Cell("A1").Value = sheetName; worksheet01.Cell("A2").Value = "lines"; worksheet01.Cell("B2").Value = numberLines; worksheet01.Cell("A3").Value = "MCSteps"; worksheet01.Cell("B3").Value = MCSteps; worksheet01.Cell("A4").Value = "delta"; worksheet01.Cell("B4").Value = delta; worksheet01.Cell("A5").Value = "idx"; worksheet01.Cell("B5").Value = "MCSteps"; worksheet01.Cell("C5").Value = "SUM((1 / delta) * md)"; for (int i = 0; i < trajectory.Count; i++) { double value = trajectory[i].rg; _MCStep = trajectory[i].MCStep; worksheet01.Cell("A" + (i + 6)).Value = i; worksheet01.Cell("B" + (i + 6)).Value = _MCStep; worksheet01.Cell("C" + (i + 6)).Value = value; } }
private void SheetDistribution(ref XLWorkbook workbook) { // This is invariant NumberFormatInfo format = new NumberFormatInfo(); // Set the 'splitter' for thousands format.NumberGroupSeparator = "."; // Set the decimal seperator format.NumberDecimalSeparator = ","; string sheetName = "Distribution"; string fileName = "Distribution.dat"; string mask = ""; var worksheet01 = workbook.Worksheets.Add(sheetName); //DADOS string line; List <string> lines = new List <string>(); using (ExtendedStreamReader file = new ExtendedStreamReader(dirWebExcel + @"\" + fileName, this.param.dataToProcess.Guid, false)) { while ((line = file.ReadLine()) != null) { if (String.IsNullOrEmpty(line)) { break; } lines.Add(line); } file.Close(); file.Dispose(); } //FIM DADOS //HEADER worksheet01.Cell("A1").Value = sheetName; worksheet01.Cell("B1").Value = mask; worksheet01.Cell("C1").Value = mask; worksheet01.Cell("D1").Value = "idx"; worksheet01.Cell("E1").Value = "mcStep"; worksheet01.Cell("F1").Value = "rg2"; worksheet01.Cell("G1").Value = "rg2(accumulated)"; worksheet01.Cell("H1").Value = "<rg2>"; worksheet01.Cell("I1").Value = "e"; worksheet01.Cell("J1").Value = "e(accumulated)"; worksheet01.Cell("K1").Value = "<e>"; worksheet01.Cell("L1").Value = "U"; worksheet01.Cell("M1").Value = "U(accumulated)"; worksheet01.Cell("N1").Value = "<U>"; //INFOS string comment = string.Empty; double value = 0; int i = 0; //DATA long idx, mcstep = 0; double rg, U, eE, eRG, eU, e, aE, aU, aRG; rg = U = eE = eRG = eU = e = aE = aU = aRG = 0; //PRIMEIRA PARTE COM HEADER for (i = 0; i < 8; i++) { string[] temp = lines[i].Split(':'); comment = ConvertCustom.ToString(temp[0]); worksheet01.Cell("A" + (i + 2)).Value = comment; try { value = ConvertCustom.ToDouble(temp[1]); worksheet01.Cell("B" + (i + 2)).Value = value; } catch (FormatException) { string strValue = Convert.ToString(temp[1]); worksheet01.Cell("B" + (i + 2)).Value = strValue; } string[] tempResult = lines[i + 9].Split('\t'); idx = ConvertCustom.ToInt32(tempResult[0]); mcstep = ConvertCustom.ToInt32(tempResult[1]); rg = double.Parse(tempResult[2], format); aRG = double.Parse(tempResult[3], format); eRG = double.Parse(tempResult[4], format); e = double.Parse(tempResult[5], format); aE = double.Parse(tempResult[6], format); eE = double.Parse(tempResult[7], format); U = double.Parse(tempResult[8], format); aU = double.Parse(tempResult[9], format); eU = double.Parse(tempResult[10], format); worksheet01.Cell("C" + (i + 2)).Value = mask; worksheet01.Cell("D" + (i + 2)).Value = idx; worksheet01.Cell("E" + (i + 2)).Value = mcstep; worksheet01.Cell("F" + (i + 2)).Value = rg; worksheet01.Cell("G" + (i + 2)).Value = aRG; worksheet01.Cell("H" + (i + 2)).Value = eRG; worksheet01.Cell("I" + (i + 2)).Value = e; worksheet01.Cell("J" + (i + 2)).Value = aE; worksheet01.Cell("K" + (i + 2)).Value = eE; worksheet01.Cell("L" + (i + 2)).Value = U; worksheet01.Cell("M" + (i + 2)).Value = aU; worksheet01.Cell("N" + (i + 2)).Value = eU; } //SEGUNDA PARTE for (int j = i; j < (lines.Count() - 9); j++) { worksheet01.Cell("A" + (j + 2)).Value = mask; worksheet01.Cell("B" + (j + 2)).Value = mask; worksheet01.Cell("C" + (j + 2)).Value = mask; string[] tempResult = lines[j + 9].Split('\t'); idx = ConvertCustom.ToInt32(tempResult[0]); mcstep = ConvertCustom.ToInt32(tempResult[1]); rg = double.Parse(tempResult[2], format); aRG = double.Parse(tempResult[3], format); eRG = double.Parse(tempResult[4], format); e = double.Parse(tempResult[5], format); aE = double.Parse(tempResult[6], format); eE = double.Parse(tempResult[7], format); U = double.Parse(tempResult[8], format); aU = double.Parse(tempResult[9], format); eU = double.Parse(tempResult[10], format); worksheet01.Cell("D" + (j + 2)).Value = idx; worksheet01.Cell("E" + (j + 2)).Value = mcstep; worksheet01.Cell("F" + (j + 2)).Value = rg; worksheet01.Cell("G" + (j + 2)).Value = aRG; worksheet01.Cell("H" + (j + 2)).Value = eRG; worksheet01.Cell("I" + (j + 2)).Value = e; worksheet01.Cell("J" + (j + 2)).Value = aE; worksheet01.Cell("K" + (j + 2)).Value = eE; worksheet01.Cell("L" + (j + 2)).Value = U; worksheet01.Cell("M" + (j + 2)).Value = aU; worksheet01.Cell("N" + (j + 2)).Value = eU; } lines = null; //FIM DATASHEET }