public void UpdateSalaryUsingSP(int ecode, int salary)
{
//update using dal layer
AdoConnected dal = new AdoConnected();
dal.UpdateSalUsingSP(ecode, salary);
}
public int GetEmpSalUsingSP(int ecode)
{
int salary = 0;
AdoConnected dal = new AdoConnected();
salary = dal.GetEmpSalUsingSP(ecode);
return(salary);
}
public List <Category> GetAllCtas()
{
List <Category> lstCats = new List <Category>();
// AdoConnected dal = new AdoConnected();
AdoConnected dal = new AdoConnected();
lstCats = dal.GetAllCats();
return(lstCats);
}
public List <Recipe> GetResById(int id)
{
List <Recipe> lstRes = new List <Recipe>();
// AdoConnected dal = new AdoConnected();
AdoConnected dal = new AdoConnected();
lstRes = dal.GetRecipesById(id);
return(lstRes);
}
public List <Recipe> GetAllRes()
{
List <Recipe> lstRes = new List <Recipe>();
// AdoConnected dal = new AdoConnected();
AdoConnected dal = new AdoConnected();
lstRes = dal.GetAllRecipes();
return(lstRes);
}
public BLL()
//{
{
// dalCon2 = new AdoDisconnected();
dalCon = new AdoConnected();
}
public void DoTransaction()
{
AdoConnected dal = new AdoConnected();
dal.DoTransaction();
}
public string GetCategoryNameByid(int id)
{
AdoConnected dal = new AdoConnected();
return(dal.getCategoryNameById(id));
}