private void CargarClientDepartment()
{
tvwClientDepartment.Nodes.Clear();
List <ClientDepartmentBE> lstClientDepartment = null;
lstClientDepartment = new ClientDepartmentBL().ListaClient(Parametros.intEmpresaId);
foreach (var item in lstClientDepartment)
{
TreeNode nuevoNodo = new TreeNode();
nuevoNodo.Text = item.NameClient;
nuevoNodo.ImageIndex = 0;
nuevoNodo.SelectedImageIndex = 0;
nuevoNodo.Tag = item.IdClient.ToString();
tvwClientDepartment.Nodes.Add(nuevoNodo);
List <ClientDepartmentBE> lstClientDepartmentName = null;
lstClientDepartmentName = new ClientDepartmentBL().ListaTodosActivo(item.IdClient);
foreach (var itemunidad in lstClientDepartmentName)
{
TreeNode nuevoNodoChild = new TreeNode();
nuevoNodoChild.ImageIndex = 1;
nuevoNodoChild.SelectedImageIndex = 1;
nuevoNodoChild.Text = itemunidad.NameDivision;
nuevoNodoChild.Tag = itemunidad.IdClientDepartment.ToString();
nuevoNodo.Nodes.Add(nuevoNodoChild);
}
}
tvwClientDepartment.ExpandAll();
}
private void ImportarExcel()
{
if (strFleExcel == "")
{
return;
}
Excel._Application xlApp;
Excel._Workbook xlLibro;
Excel._Worksheet xlHoja;
Excel.Sheets xlHojas;
xlApp = new Excel.Application();
xlLibro = xlApp.Workbooks.Open(strFleExcel, 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];
int Secuencia = 2;
int _row = 2;
int _totRow = 2;
try
{
List <StyleBE> lstStyle = new List <StyleBE>();
while (FuncionBase.IsNumeric((string)xlHoja.get_Range("A" + _row, Missing.Value).Text.ToString().Trim()))
{
//Declaracion de variables
int IdCompany = 0;
int intIdClient = 0;
string strNameClient = "";
string strNameStyle = "";
DateTime RevenueDate = new DateTime(2010, 1, 1);
string strDescription = "";
int intIdClientDepartment = 0;
string strNameDivision = "";
int IdMediaUnit = 0;
string strAbbreviate = "";
strNameClient = (string)xlHoja.get_Range("B" + _row, Missing.Value).Text.ToString().Trim();
ClientBE objE_Client = null;
objE_Client = new ClientBL().SeleccionaDescripcion(Parametros.intEmpresaId, strNameClient);
if (objE_Client != null)
{
intIdClient = objE_Client.IdClient;
strNameStyle = (string)xlHoja.get_Range("C" + _row, Missing.Value).Text.ToString().Trim();
RevenueDate = Convert.ToDateTime(xlHoja.get_Range("D" + _row, Missing.Value).Text.ToString().Trim());
strDescription = (string)xlHoja.get_Range("E" + _row, Missing.Value).Text.ToString().Trim();
strNameDivision = (string)xlHoja.get_Range("F" + _row, Missing.Value).Text.ToString().Trim();
ClientDepartmentBE objE_ClientDepartment = null;
objE_ClientDepartment = new ClientDepartmentBL().SeleccionaDescripcion(intIdClient, strNameDivision);
if (objE_ClientDepartment != null)
{
intIdClientDepartment = objE_ClientDepartment.IdClientDepartment;
}
else
{
XtraMessageBox.Show("N° Secuencia : " + Secuencia.ToString() + "\n Division: " + strNameDivision, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
xlLibro.Close(false, Missing.Value, Missing.Value);
xlApp.Quit();
this.Dispose();
this.Close();
}
strAbbreviate = (string)xlHoja.get_Range("G" + _row, Missing.Value).Text.ToString().Trim();
MediaUnitBE objE_MediaUnit = null;
objE_MediaUnit = new MediaUnitBL().SeleccionaAbreviatura(Parametros.intEmpresaId, strAbbreviate);
if (objE_MediaUnit != null)
{
IdMediaUnit = objE_MediaUnit.IdMediaUnit;
}
else
{
XtraMessageBox.Show("N° Secuencia : " + Secuencia.ToString() + "\n Media Unit: " + strAbbreviate, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
xlLibro.Close(false, Missing.Value, Missing.Value);
xlApp.Quit();
this.Dispose();
this.Close();
}
StyleBE objE_Style = new StyleBE();
objE_Style.IdStyle = 0;
objE_Style.IdCompany = Parametros.intEmpresaId;
objE_Style.IdClient = intIdClient;
objE_Style.NameStyle = strNameStyle;
objE_Style.RevenueDate = RevenueDate;
objE_Style.Description = strDescription;
objE_Style.IdClientDepartment = intIdClientDepartment;
objE_Style.IdMediaUnit = IdMediaUnit;
objE_Style.FlagState = true;
objE_Style.Login = Parametros.strUsuarioLogin;
objE_Style.Machine = WindowsIdentity.GetCurrent().Name.ToString();
lstStyle.Add(objE_Style);
}
Application.DoEvents();
_row++;
Secuencia++;
}
StyleBL objBL_Style = new StyleBL();
objBL_Style.InsertaMasivo(lstStyle);
XtraMessageBox.Show("Los Datos se guardaron conrrectamente.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
xlLibro.Close(false, Missing.Value, Missing.Value);
xlApp.Quit();
this.Close();
}
catch (Exception ex)
{
xlApp.Quit();
XtraMessageBox.Show(ex.Message + "\n N° Secuencia : " + Secuencia.ToString(), ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
