public static List <CourseSon> GetAllCourseByStandardKey(string key)
{
var lstObj = new List <CourseSon>();
var query = new StringBuilder();
query.Append(" SELECT stancourse.StandardCourseKey, course.Name");
query.Append(" FROM dbo.StandardCourse stancourse");
query.Append(" LEFT JOIN dbo.Standards stan ");
query.Append(" ON stancourse.StandardFk = stan.StandardKey");
query.Append(" LEFT JOIN dbo.course course ");
query.Append(" ON stancourse.CourseFk = course.CourseKey");
query.Append(String.Format(" WHERE stancourse.StandardFk = '{0}'", key));
try
{
using (var objDal = new BaseDAL_II())
{
lstObj = objDal.consultar <CourseSon>(query.ToString());
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
return(lstObj);
}
public static List <Office> GetAllOffice()
{
var lstObj = new List <Office>();
try
{
using (var objDal = new BaseDAL_II())
{
lstObj = objDal.consultar <Office>(1, 3, "Orden ASC", "SELECT *FROM dbo.Office"); //consultarTodos<Office>();
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
return(lstObj);
}
public static List <Standards> GetAllStandardWhitCourse()
{
var query = new StringBuilder();
query.Append(" SELECT DISTINCT dbo.StandardCourse.StandardFk as StandardKey, dbo.Standards.Name");
query.Append(" FROM dbo.StandardCourse");
query.Append(" LEFT JOIN dbo.Standards ON dbo.StandardCourse.StandardFk = dbo.Standards.StandardKey");
try
{
using (var objDal = new BaseDAL_II())
{
return(objDal.consultar <Standards>(query.ToString()));
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
}
public static List <StatusCliente> GetAll()
{
var query = new StringBuilder();
query.Append(" SELECT *FROM dbo.StatusCliente");
query.Append(" Order by Orden ASC");
try
{
using (var objDal = new BaseDAL_II())
{
return(objDal.consultar <StatusCliente>(query.ToString()));
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
}
public static List <Cliente> GetAllCliente()
{
var lstObj = new List <Cliente>();
var query = new StringBuilder();
query.Append("SELECT *FROM dbo.Cliente");
query.Append(" ORDER BY RazonSocial ASC");
try
{
using (var objDal = new BaseDAL_II())
{
lstObj = objDal.consultar <Cliente>(query.ToString());
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
return(lstObj);
}
public static List <InterestType> GetAllInterest()
{
var query = new StringBuilder();
query.Append(" SELECT *FROM dbo.InterestType");
query.Append(" ORDER BY Name");
var lstObj = new List <InterestType>();
try
{
using (var objDal = new BaseDAL_II())
{
lstObj = objDal.consultar <InterestType>(query.ToString());
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
return(lstObj);
}
public static List <Cliente> GetAllCliente(int pag, int cantReg)
{
var lstObj = new List <Cliente>();
var query = new StringBuilder();
var orden = "NombreCliente";
query.Append(" SELECT cliente.ClaveCliente, cliente.NombreCliente, oficina.Name as 'OfficeName', cliente.Baja 'Status'");
query.Append(" FROM dbo.Cliente cliente ");
query.Append(" LEFT JOIN dbo.Office oficina ON cliente.OfficeFk = oficina.OfficeKey ");
query.Append(" WHERE cliente.Baja = 0");
try
{
using (var objDal = new BaseDAL_II())
{
lstObj = objDal.consultar <Cliente>(pag, cantReg, orden, query.ToString());
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
return(lstObj);
}
public static List <States> GetAllStates(string countryKey)
{
var query = new StringBuilder();
query.Append(" SELECT *FROM dbo.States");
query.Append(String.Format(" WHERE CountryFk = '{0}'", countryKey));
query.Append(" ORDER BY Name");
var lstObj = new List <States>();
try
{
using (var objDal = new BaseDAL_II())
{
lstObj = objDal.consultar <States>(query.ToString());
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
return(lstObj);
}