public ClientDepartmentBE SeleccionaDescripcion(int IdClient, string NameDivision)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientDepartment_SeleccionaDescripcion");
db.AddInParameter(dbCommand, "pidClient", DbType.Int32, IdClient);
db.AddInParameter(dbCommand, "pNameDivision", DbType.String, NameDivision);
IDataReader reader = db.ExecuteReader(dbCommand);
ClientDepartmentBE ClientDepartment = null;
while (reader.Read())
{
ClientDepartment = new ClientDepartmentBE();
ClientDepartment.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
ClientDepartment.IdClient = Int32.Parse(reader["IdClient"].ToString());
ClientDepartment.IdClientDepartment = Int32.Parse(reader["idClientDepartment"].ToString());
ClientDepartment.Code = reader["Code"].ToString();
ClientDepartment.NameDivision = reader["NameDivision"].ToString();
ClientDepartment.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(ClientDepartment);
}
public List <ClientDepartmentBE> ListaTodosActivo(int IdClient)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientDepartment_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, IdClient);
IDataReader reader = db.ExecuteReader(dbCommand);
List <ClientDepartmentBE> ClientDepartmentlist = new List <ClientDepartmentBE>();
ClientDepartmentBE ClientDepartment;
while (reader.Read())
{
ClientDepartment = new ClientDepartmentBE();
ClientDepartment.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
ClientDepartment.IdClient = Int32.Parse(reader["IdClient"].ToString());
ClientDepartment.IdClientDepartment = Int32.Parse(reader["idClientDepartment"].ToString());
ClientDepartment.Code = reader["Code"].ToString();
ClientDepartment.NameDivision = reader["NameDivision"].ToString();
ClientDepartment.FlagState = Boolean.Parse(reader["FlagState"].ToString());
ClientDepartment.FlagState = Boolean.Parse(reader["FlagState"].ToString());
ClientDepartment.TipoOper = 4; //CONSULTAR
ClientDepartmentlist.Add(ClientDepartment);
}
reader.Close();
reader.Dispose();
return(ClientDepartmentlist);
}
public void Elimina(ClientDepartmentBE pItem)
{
try
{
ClientDepartmentDL ClientDepartment = new ClientDepartmentDL();
ClientDepartment.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(ClientDepartmentBE pItem)
{
try
{
ClientDepartmentDL ClientDepartment = new ClientDepartmentDL();
ClientDepartment.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public ClientDepartmentBE SeleccionaDescripcion(int IdClient, string NameDivision)
{
try
{
ClientDepartmentDL ClientDepartment = new ClientDepartmentDL();
ClientDepartmentBE objEmp = ClientDepartment.SeleccionaDescripcion(IdClient, NameDivision);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public ClientDepartmentBE Selecciona(int IdClientDepartment)
{
try
{
ClientDepartmentDL ClientDepartment = new ClientDepartmentDL();
ClientDepartmentBE objEmp = ClientDepartment.Selecciona(IdClientDepartment);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(ClientDepartmentBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientDepartment_Elimina");
db.AddInParameter(dbCommand, "pIdClientDepartment", DbType.Int32, pItem.IdClientDepartment);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login);
db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine);
db.ExecuteNonQuery(dbCommand);
}
public void Actualiza(ClientDepartmentBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientDepartment_Actualiza");
db.AddInParameter(dbCommand, "pIdClientDepartment", DbType.Int32, pItem.IdClientDepartment);
db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, pItem.IdClient);
db.AddInParameter(dbCommand, "pCode", DbType.String, pItem.Code);
db.AddInParameter(dbCommand, "pNameDivision", DbType.String, pItem.NameDivision);
db.AddInParameter(dbCommand, "pFlagState", DbType.Boolean, pItem.FlagState);
db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login);
db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.ExecuteNonQuery(dbCommand);
}
public List <ClientDepartmentBE> ListaClient(int IdCompany)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientDepartment_ListaClient");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
IDataReader reader = db.ExecuteReader(dbCommand);
List <ClientDepartmentBE> ClientDepartmentlist = new List <ClientDepartmentBE>();
ClientDepartmentBE ClientDepartment;
while (reader.Read())
{
ClientDepartment = new ClientDepartmentBE();
ClientDepartment.IdClient = Int32.Parse(reader["IdClient"].ToString());
ClientDepartment.NameClient = reader["NameClient"].ToString();
ClientDepartmentlist.Add(ClientDepartment);
}
reader.Close();
reader.Dispose();
return(ClientDepartmentlist);
}
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();
}
}
