private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
WorkAreaBL objBL_Area = new WorkAreaBL();
WorkAreaBE objArea = new WorkAreaBE();
objArea.IdWorkArea = IdWorkArea;
objArea.NameWorkArea = txtDescripcion.Text;
objArea.FlagState = true;
objArea.Login = Parametros.strUsuarioLogin;
objArea.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objArea.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
{
objBL_Area.Inserta(objArea);
}
else
{
objBL_Area.Actualiza(objArea);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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())
{
WorkAreaBE objE_Area = new WorkAreaBE();
objE_Area.IdWorkArea = int.Parse(gvArea.GetFocusedRowCellValue("IdWorkArea").ToString());
objE_Area.Login = Parametros.strUsuarioLogin;
objE_Area.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_Area.IdCompany = Parametros.intEmpresaId;
WorkAreaBL objBL_Area = new WorkAreaBL();
objBL_Area.Elimina(objE_Area);
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 CargaTreeview()
{
tvwDatos.Nodes.Clear();
List <CompanyBE> lstEmpresa = null;
lstEmpresa = new CompanyBL().ListaTodosActivo(0);
foreach (var item in lstEmpresa)
{
TreeNode nuevoNodo = new TreeNode();
nuevoNodo.Text = item.NameCompany;
nuevoNodo.ImageIndex = 0;
nuevoNodo.SelectedImageIndex = 0;
nuevoNodo.Tag = "EMP" + item.IdCompany.ToString();
tvwDatos.Nodes.Add(nuevoNodo);
List <WorkAreaBE> lstWorkArea = null;
lstWorkArea = new WorkAreaBL().ListaTodosActivo(item.IdCompany);
foreach (var itemarea in lstWorkArea)
{
TreeNode nuevoNodoChild = new TreeNode();
nuevoNodoChild.ImageIndex = 2;
nuevoNodoChild.SelectedImageIndex = 2;
nuevoNodoChild.Text = itemarea.NameWorkArea;
nuevoNodoChild.Tag = "ARE" + itemarea.IdWorkArea.ToString();
nuevoNodo.Nodes.Add(nuevoNodoChild);
}
}
tvwDatos.ExpandAll();
}
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\\WorkArea.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 <WorkAreaBE> lstWorkArea = null;
lstWorkArea = new WorkAreaBL().ListaTodosActivo(Parametros.intEmpresaId);
if (lstWorkArea.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 lstWorkArea)
{
xlHoja.Cells[Row, 1] = item.IdWorkArea;
xlHoja.Cells[Row, 2] = item.NameWorkArea;
Row = Row + 1;
Secuencia = Secuencia + 1;
}
}
xlLibro.SaveAs("C:\\Excel\\WorkArea.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\\WorkArea.xlsx");
//XtraMessageBox.Show("It was imported correctly \n The file was generated C:\\Excel\\WorkArea.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 frmManAreaEdit_Load(object sender, EventArgs e)
{
if (pOperacion == Operacion.Nuevo)
{
this.Text = "Work Area - New";
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "Work Area - Update";
WorkAreaBE objE_Area = null;
objE_Area = new WorkAreaBL().Selecciona(Parametros.intEmpresaId, IdWorkArea);
if (objE_Area != null)
{
txtDescripcion.Text = objE_Area.NameWorkArea.Trim();
}
}
txtDescripcion.Select();
}
