public ClientGoalBE Selecciona(int IdClientGoal)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientGoal_Selecciona");
db.AddInParameter(dbCommand, "pidClientGoal", DbType.Int32, IdClientGoal);
IDataReader reader = db.ExecuteReader(dbCommand);
ClientGoalBE ClientGoal = null;
while (reader.Read())
{
ClientGoal = new ClientGoalBE();
ClientGoal.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
ClientGoal.IdClient = Int32.Parse(reader["IdClient"].ToString());
ClientGoal.IdClientGoal = Int32.Parse(reader["idClientGoal"].ToString());
ClientGoal.Year = Int32.Parse(reader["Year"].ToString());
ClientGoal.Month = Int32.Parse(reader["Month"].ToString());
ClientGoal.Goal = Decimal.Parse(reader["Goal"].ToString());
ClientGoal.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(ClientGoal);
}
public List <ClientGoalBE> ListaTodosActivo(int IdClient)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientGoal_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, IdClient);
IDataReader reader = db.ExecuteReader(dbCommand);
List <ClientGoalBE> ClientGoallist = new List <ClientGoalBE>();
ClientGoalBE ClientGoal;
while (reader.Read())
{
ClientGoal = new ClientGoalBE();
ClientGoal.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
ClientGoal.IdClient = Int32.Parse(reader["IdClient"].ToString());
ClientGoal.IdClientGoal = Int32.Parse(reader["idClientGoal"].ToString());
ClientGoal.Year = Int32.Parse(reader["Year"].ToString());
ClientGoal.Month = Int32.Parse(reader["Month"].ToString());
ClientGoal.Goal = Decimal.Parse(reader["Goal"].ToString());
ClientGoal.FlagState = Boolean.Parse(reader["FlagState"].ToString());
ClientGoal.TipoOper = 4; //CONSULTAR
ClientGoallist.Add(ClientGoal);
}
reader.Close();
reader.Dispose();
return(ClientGoallist);
}
public void Elimina(ClientGoalBE pItem)
{
try
{
ClientGoalDL ClientGoal = new ClientGoalDL();
ClientGoal.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(ClientGoalBE pItem)
{
try
{
ClientGoalDL ClientGoal = new ClientGoalDL();
ClientGoal.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public ClientGoalBE Selecciona(int IdClientGoal)
{
try
{
ClientGoalDL ClientGoal = new ClientGoalDL();
ClientGoalBE objEmp = ClientGoal.Selecciona(IdClientGoal);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(ClientGoalBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientGoal_Elimina");
db.AddInParameter(dbCommand, "pIdClientGoal", DbType.Int32, pItem.IdClientGoal);
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(ClientGoalBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientGoal_Actualiza");
db.AddInParameter(dbCommand, "pIdClientGoal", DbType.Int32, pItem.IdClientGoal);
db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, pItem.IdClient);
db.AddInParameter(dbCommand, "pYear", DbType.Int32, pItem.Year);
db.AddInParameter(dbCommand, "pMonth", DbType.Int32, pItem.Month);
db.AddInParameter(dbCommand, "pGoal", DbType.Decimal, pItem.Goal);
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);
}
