private void tlbMenu_DeleteClick() { try { Cursor = Cursors.WaitCursor; if (XtraMessageBox.Show("Be sure to delete the record?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (!ValidarIngreso()) { ClassificationBE objE_Classification = new ClassificationBE(); objE_Classification.IdClassification = int.Parse(gvClassification.GetFocusedRowCellValue("IdClassification").ToString()); objE_Classification.Login = Parametros.strUsuarioLogin; objE_Classification.Machine = WindowsIdentity.GetCurrent().Name.ToString(); objE_Classification.IdCompany = Parametros.intEmpresaId; ClassificationBL objBL_Classification = new ClassificationBL(); objBL_Classification.Elimina(objE_Classification); XtraMessageBox.Show("The record was successfully deleted.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); Cargar(); } } Cursor = Cursors.Default; } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnGrabar_Click(object sender, EventArgs e) { try { Cursor = Cursors.WaitCursor; if (!ValidarIngreso()) { ClassificationBL objBL_Classification = new ClassificationBL(); ClassificationBE objClassification = new ClassificationBE(); objClassification.IdClassification = IdClassification; objClassification.NameClassification = txtDescripcion.Text; objClassification.FlagState = true; objClassification.Login = Parametros.strUsuarioLogin; objClassification.Machine = WindowsIdentity.GetCurrent().Name.ToString(); objClassification.IdCompany = Parametros.intEmpresaId; if (pOperacion == Operacion.Nuevo) { objBL_Classification.Inserta(objClassification); } else { objBL_Classification.Actualiza(objClassification); } this.Close(); } } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
void ExportarExcel(string filename) { Excel._Application xlApp; Excel._Workbook xlLibro; Excel._Worksheet xlHoja; Excel.Sheets xlHojas; xlApp = new Excel.Application(); filename = Path.Combine(Directory.GetCurrentDirectory(), "Excel\\Classification.xlsx"); xlLibro = xlApp.Workbooks.Open(filename, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); xlHojas = xlLibro.Sheets; xlHoja = (Excel._Worksheet)xlHojas[1]; Cursor.Current = Cursors.WaitCursor; try { int Row = 6; int Secuencia = 1; List <ClassificationBE> lstClassification = null; lstClassification = new ClassificationBL().ListaTodosActivo(Parametros.intEmpresaId); if (lstClassification.Count > 0) { xlHoja.Shapes.AddPicture(Path.Combine(Directory.GetCurrentDirectory(), "Logo.jpg"), Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, 1, 1, 100, 60); foreach (var item in lstClassification) { xlHoja.Cells[Row, 1] = item.IdClassification; xlHoja.Cells[Row, 2] = item.NameClassification; Row = Row + 1; Secuencia = Secuencia + 1; } } xlLibro.SaveAs("C:\\Excel\\Classification.xlsx", Excel.XlFileFormat.xlWorkbookDefault, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlExclusive, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); xlLibro.Close(true, Missing.Value, Missing.Value); xlApp.Quit(); Cursor.Current = Cursors.Default; BSUtils.OpenExcel("C:\\Excel\\Classification.xlsx"); //XtraMessageBox.Show("It was imported correctly \n The file was generated C:\\Excel\\Classification.xlsx", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { xlLibro.Close(false, Missing.Value, Missing.Value); xlApp.Quit(); Cursor.Current = Cursors.Default; MessageBox.Show(ex.Message, ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void frmManClassificationEdit_Load(object sender, EventArgs e) { if (pOperacion == Operacion.Nuevo) { this.Text = "Classification - New"; } else if (pOperacion == Operacion.Modificar) { this.Text = "Classification - Update"; ClassificationBE objE_Classification = null; objE_Classification = new ClassificationBL().Selecciona(IdClassification); if (objE_Classification != null) { txtDescripcion.Text = objE_Classification.NameClassification.Trim(); } } txtDescripcion.Select(); }
private void CargaVendorClassificationNuevo() { List <ClassificationBE> lstClassification = null; lstClassification = new ClassificationBL().ListaTodosActivo(Parametros.intEmpresaId); foreach (ClassificationBE item in lstClassification) { CVendorClassification objE_VendorClassification = new CVendorClassification(); objE_VendorClassification.IdCompany = item.IdCompany; objE_VendorClassification.IdVendor = 0; objE_VendorClassification.IdVendorClassification = 0; objE_VendorClassification.IdClassification = item.IdClassification; objE_VendorClassification.NameClassification = item.NameClassification; objE_VendorClassification.FlagActive = false; objE_VendorClassification.TipoOper = (int)Operacion.Consultar; mListaVendorClassificationOrigen.Add(objE_VendorClassification); } bsListadoVendorClassification.DataSource = mListaVendorClassificationOrigen; gcVendorClassification.DataSource = bsListadoVendorClassification; gcVendorClassification.RefreshDataSource(); }