public static session CreateSession(user objUser) { try { using (ModelContext objContext = new ModelContext()) { Guid objGuid; do { objGuid = Guid.NewGuid(); } while (objContext.sessions.Where(s => s.sess_uuid__uniqueidentifier == objGuid).Count() > 0); date objDate = BDate.FindOrAddDate(DateTime.Now); session objSession; objSession = new session() { sess_uuid__uniqueidentifier = Guid.NewGuid(), sess_starttime__time = TimeSpan.Parse(DateTime.Now.Hour + ":" + DateTime.Now.Minute + ":" + DateTime.Now.Second), sess_lastactivity__time = TimeSpan.Parse(DateTime.Now.Hour + ":" + DateTime.Now.Minute + ":" + DateTime.Now.Second), sess_ipbatch01__tinyint = null, sess_ipbatch02__tinyint = null, sess_ipbatch03__tinyint = null, sess_ipbatch04__tinyint = null, sess_extradata__nvarchar = null, date_uuid__uniqueidentifier = objDate.date_uuid__uniqueidentifier, user_uuid_created__uniqueidentifier = objUser.user_uuid__uniqueidentifier }; objContext.sessions.Add(objSession); objContext.SaveChanges(); return(objContext.sessions.Where(s => s.sess_uuid__uniqueidentifier == objSession.sess_uuid__uniqueidentifier).FirstOrDefault()); } } catch { } return(null); }
public static bool Edit( user objUser, string stUsername, string stEmail, string stCellphone, string stPassword, string stFirstname, string stLastname, byte byRoleAccess, string stExtradata, string stNamePicture, byte[] byaPicture, DateTime objDateBirthday, string stState, string stCity, session objSession) { try { using (straad_generaldesktopapplication_pcpcpcpc_001Entities objContext = new straad_generaldesktopapplication_pcpcpcpc_001Entities()) { var vUserPrincipal = objContext.users.Where(u => u.user_uuid__uniqueidentifier == objUser.user_uuid__uniqueidentifier).FirstOrDefault(); var vLastBranch = objContext.proc_user_findAllBranches(objUser.user_uuid__uniqueidentifier).LastOrDefault(); // Add User Guid objGuidUserAux = Guid.NewGuid(); do { objGuidUserAux = Guid.NewGuid(); } while (FindByUUID(objGuidUserAux) != null); user objUserAux = new user() { user_uuid__uniqueidentifier = objGuidUserAux, user_username__nvarchar = vUserPrincipal.user_username__nvarchar, user_email__nvarchar = vUserPrincipal.user_email__nvarchar, user_cellphone__nvarchar = vUserPrincipal.user_cellphone__nvarchar, user_password__nvarchar = vUserPrincipal.user_password__nvarchar, user_firstname__nvarchar = vUserPrincipal.user_firstname__nvarchar, user_lastname__nvarchar = vUserPrincipal.user_lastname__nvarchar, user_roleaccess__tinyint = vUserPrincipal.user_roleaccess__tinyint, user_extradata__nvarchar = vUserPrincipal.user_extradata__nvarchar, reso_uuid_picture__uniqueidentifier = vUserPrincipal.reso_uuid_picture__uniqueidentifier, date_uuid_birthdate__uniqueidentifier = vUserPrincipal.date_uuid_birthdate__uniqueidentifier, city_uuid__uniqueidentifier = vUserPrincipal.city_uuid__uniqueidentifier, sess_uuid_used__uniqueidentifier = null, sess_uuid_created__uniqueidentifier = vUserPrincipal.sess_uuid_created__uniqueidentifier, user_uuid_root__uniqueidentifier = vLastBranch.user_uuid__uniqueidentifier, sess_uuid_deleted__uniqueidentifier = null }; objContext.users.Add(objUserAux); // Add Date Guid?objGuidDate = null; if (objDateBirthday.Year != DateTime.Now.Year) { objGuidDate = BDate.FindOrAddDate(objDateBirthday).date_uuid__uniqueidentifier; } // Add City Guid?objGuidCity = null; if (!string.IsNullOrEmpty(stCity)) { objGuidCity = BCity.FindByName(stCity, BState.FindByName(stState, BCountry.FindByCode("MX"))).city_uuid__uniqueidentifier; } // Add Resource Guid?objGuidResource = null; if (byaPicture != null && !string.IsNullOrEmpty(stNamePicture)) { objGuidResource = BResource.Add(stNamePicture, 1, null, byaPicture, null).reso_uuid__uniqueidentifier; } vUserPrincipal.user_username__nvarchar = stUsername; vUserPrincipal.user_email__nvarchar = stEmail; vUserPrincipal.user_cellphone__nvarchar = stCellphone; vUserPrincipal.user_password__nvarchar = stPassword != Preferences.GlobalTextToComparePasswords ? Tools.Encrypt(stPassword) : objUserAux.user_password__nvarchar; //txtPassword.Text != Preferences.GlobalTextToComparePasswords ? Tools.Encrypt(txtPassword.Text) : objUserSelectedPrincipalItem.user_password__nvarchar, //vUserPrincipal.user_password__nvarchar = Tools.GetDefaulHash(stPassword); vUserPrincipal.user_firstname__nvarchar = Tools.Encrypt(stFirstname); vUserPrincipal.user_lastname__nvarchar = Tools.Encrypt(stLastname); vUserPrincipal.user_roleaccess__tinyint = byRoleAccess; vUserPrincipal.user_extradata__nvarchar = stExtradata; vUserPrincipal.reso_uuid_picture__uniqueidentifier = objGuidResource; vUserPrincipal.date_uuid_birthdate__uniqueidentifier = objGuidDate; vUserPrincipal.city_uuid__uniqueidentifier = objGuidCity; vUserPrincipal.sess_uuid_used__uniqueidentifier = null; vUserPrincipal.sess_uuid_created__uniqueidentifier = objSession.sess_uuid__uniqueidentifier; vUserPrincipal.user_uuid_root__uniqueidentifier = null; vUserPrincipal.sess_uuid_deleted__uniqueidentifier = null; objContext.SaveChanges(); return(true); } } catch { } return(false); }
public static user Add( string stUsername, string stEmail, string stCellphone, string stPassword, string stFirstname, string stLastname, byte byRoleAccess, string stExtradata, string stNamePicture, byte[] byaPicture, DateTime objDateBirthday, string stState, string stCity, session objSessionCreator) { try { using (straad_generaldesktopapplication_pcpcpcpc_001Entities objContext = new straad_generaldesktopapplication_pcpcpcpc_001Entities()) { // Add Date Guid?objGuidDate = null; if (objDateBirthday.Year != DateTime.Now.Year) { objGuidDate = BDate.FindOrAddDate(objDateBirthday).date_uuid__uniqueidentifier; } // Add City Guid?objGuidCity = null; if (!string.IsNullOrEmpty(stCity)) { objGuidCity = BCity.FindByName(stCity, BState.FindByName(stState, BCountry.FindByCode("MX"))).city_uuid__uniqueidentifier; } // Add Resource Guid?objGuidResource = null; if (byaPicture != null && !string.IsNullOrEmpty(stNamePicture)) { objGuidResource = BResource.Add(stNamePicture, 1, null, byaPicture, null).reso_uuid__uniqueidentifier; } // Add User Guid objGuidUser = Guid.NewGuid(); do { objGuidUser = Guid.NewGuid(); } while (FindByUUID(objGuidUser) != null); objContext.users.Add(new user() { user_uuid__uniqueidentifier = objGuidUser, user_username__nvarchar = stUsername, user_email__nvarchar = stEmail, user_cellphone__nvarchar = stCellphone, user_password__nvarchar = Tools.GetDefaulHash(stPassword), user_firstname__nvarchar = Tools.Encrypt(stFirstname), user_lastname__nvarchar = Tools.Encrypt(stLastname), user_roleaccess__tinyint = byRoleAccess, user_extradata__nvarchar = stExtradata, reso_uuid_picture__uniqueidentifier = objGuidResource, date_uuid_birthdate__uniqueidentifier = objGuidDate, city_uuid__uniqueidentifier = objGuidCity, sess_uuid_used__uniqueidentifier = null, sess_uuid_created__uniqueidentifier = objSessionCreator.sess_uuid__uniqueidentifier, user_uuid_root__uniqueidentifier = null, sess_uuid_deleted__uniqueidentifier = null }); objContext.SaveChanges(); return(objContext.users.Where(u => u.user_uuid__uniqueidentifier == objGuidUser).FirstOrDefault()); } } catch { } return(null); }