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); }