public static bool AddOrUpdateUser(Usuario objUser, out string sIdCreated)
{
try
{
using (var objDal = new BaseDAL_II())
{
if (objUser.UsuarioKey == null || objUser.UsuarioKey.ToString().Trim().Equals("00000000-0000-0000-0000-000000000000"))
{
objUser.UsuarioKey = Guid.NewGuid();
sIdCreated = objUser.UsuarioKey.ToString();
objDal.guardar(objUser);
}
else
{
objDal.actualizar(objUser, "UsuarioKey");
}
}
}
catch (Exception ex)
{
sIdCreated = null;
return(false);
}
sIdCreated = null;
return(true);
}
public static List <string> GetAllContactMail()
{
var lstObj = new List <ContactSite>();
try
{
using (var objDal = new BaseDAL_II())
{
lstObj = objDal.consultarTodos <ContactSite>();
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
var lstContactMail = new List <string>();
foreach (var item in lstObj)
{
lstContactMail.Add(item.Email);
}
return(lstContactMail);
}
public static List <string> GetAllRazon()
{
var lstObj = new List <Cliente>();
try
{
using (var objDal = new BaseDAL_II())
{
lstObj = objDal.consultarTodos <Cliente>();
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
var lstNameClient = new List <string>();
foreach (var item in lstObj)
{
lstNameClient.Add(item.RazonSocial);
}
return(lstNameClient);
}
public static bool AddOrUpdateContact(ContactSite objContact, out string sIdCreated)
{
try
{
using (var objDal = new BaseDAL_II())
{
if (objContact.ContactSiteKey == null || objContact.ContactSiteKey.ToString().Trim().Equals("00000000-0000-0000-0000-000000000000"))
{
objContact.ContactSiteKey = Guid.NewGuid();
objDal.guardar(objContact);
}
else
{
objDal.actualizar(objContact, "ContactSiteKey");
}
}
}
catch (Exception ex)
{
sIdCreated = null;
return(false);
}
sIdCreated = objContact.ContactSiteKey.ToString();
return(true);
}
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 Usuario GetUsuarioByKey(string key)
{
try
{
using (var objDal = new BaseDAL_II())
{
return(objDal.consultarPorKey <Usuario>("UsuarioKey", key));
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
}
public static List <AplicationForm> GetAll()
{
try
{
using (var objDal = new BaseDAL_II())
{
return(objDal.consultarTodos <AplicationForm>());
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
}
private static Usuario GetUsuarioByUserName(string username)
{
try
{
using (var objDal = new BaseDAL_II())
{
return(objDal.consultarPorKey <Usuario>("Nickname", username));
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
}
public static AplicationForm GetAplicationByKey(string key)
{
try
{
using (var objDal = new BaseDAL_II())
{
return(objDal.consultarPorKey <AplicationForm>("AplicationFormkey", key));
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
}
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 <Usuario> GetAllUsers()
{
var lstObj = new List <Usuario>();
try
{
using (var objDal = new BaseDAL_II())
{
lstObj = objDal.consultarTodos <Usuario>();
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
return(lstObj);
}
public static List<Country> GetAllConuntry()
{
var lstObj = new List<Country>();
try
{
using (var objDal = new BaseDAL_II())
{
lstObj = objDal.consultarTodos<Country>();
}
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message);
}
return lstObj;
}
public static List <ContactType> GetAllTypeContact()
{
var lstObj = new List <ContactType>();
try
{
using (var objDal = new BaseDAL_II())
{
lstObj = objDal.consultarTodos <ContactType>();
}
}
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 <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);
}
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);
}
