public static UserUrlList getUserList(string fromDate, Guid guid) { UserUrlList userUrlList = new UserUrlList(); userUrlList.urlLists = new List <TableShortedUrl>(); using (var db = new edShortenerModel()) { var queryResult = from url in db.ShortedUrls where url.Fk_idUsers == guid select url; queryResult.ToList().ForEach(shortedURl => { userUrlList.urlLists.Add(new TableShortedUrl { id = shortedURl.idShortedUrl, created = shortedURl.created, longUrl = shortedURl.longUrl, shortedUrl = shortedURl.shortedUrl1, pageStatus = shortedURl.pageStatus, lastStatusChange = shortedURl.lastStatusChange, clicks = shortedURl.Clicks.Where(click => click.created >= getDate(fromDate)).Count() } ); }); } return(userUrlList); }
public static Objects.User registerUser(string userName, string userPass, string userPass2) { if (userPass == userPass2) { using (var db = new edShortenerModel()) { Model.User user = new Model.User(); user.userName = userName; user.userPass = cryptDecrypt.cryptPass(userPass); user.idUser = Guid.NewGuid(); db.Users.Add(user); db.SaveChanges(); return(new Objects.User { id = user.idUser, name = user.userName, userUrlList = new UserUrlList { urlLists = new List <TableShortedUrl>() } }); } } return(null); }
public static int updateProfile(Objects.User user, bool changePass) { using (var db = new edShortenerModel()) { try { var original = db.Users.Find(user.id); original.dateB = user.dateB; original.gender = user.gender; original.imgScr = user.imgScr == null ? null : cryptDecrypt.cryptPass(user.imgScr); original.mail = user.mail; original.phone = user.phone; original.realName = user.realName; if (changePass) { string cryptedPass = cryptDecrypt.cryptPass(user.newPass1); original.userPass = cryptedPass; } return(db.SaveChanges()); } catch (Exception e) { return(0); } } }
public static Objects.User logInUser(string userName, string userPass) { using (var db = new edShortenerModel()) { var cryptedPass = cryptDecrypt.cryptPass(userPass); var queryResult = from User in db.Users where User.userName == userName && User.userPass == cryptedPass select User; if (queryResult.Count() == 1) { Objects.User user = new Objects.User(); var userResult = queryResult.FirstOrDefault(); user.id = userResult.idUser; user.name = userResult.userName; user.userUrlList = new UserUrlList(); user.userUrlList.urlLists = new List <TableShortedUrl>(); userResult.ShortedUrls.ToList().ForEach(url => { user.userUrlList.urlLists.Add(new TableShortedUrl { id = url.idShortedUrl, created = url.created, longUrl = url.longUrl, shortedUrl = url.shortedUrl1, pageStatus = url.pageStatus, lastStatusChange = url.lastStatusChange, clicks = url.Clicks.Where(click => click.created >= DateTime.Now.AddYears(-100)).Count() }); }); return(user); } } return(null); }
public static int addNewUrl(string longUrl, Guid guid) { try { if (pingUrl(longUrl) == HttpStatusCode.OK.ToString()) { string s = string.Empty; using (var db = new edShortenerModel()) { var newUrl = new ShortedUrl(); newUrl.created = DateTime.Now; newUrl.longUrl = longUrl; newUrl.shortedUrl1 = cryptDecrypt.Base64Encode(longUrl); newUrl.pageStatus = 200; newUrl.lastStatusChange = DateTime.Now; newUrl.Fk_idUsers = guid; db.ShortedUrls.Add(newUrl); return(db.SaveChanges()); } } else { return(0); } } catch (Exception e) { return(0); } }
public static Model.ShortedUrl urlAlreadyShorted(string longUrl, Guid guid) { using (var db = new edShortenerModel()) { var queryResult = from url in db.ShortedUrls where url.longUrl == longUrl && url.Fk_idUsers == guid select url; var urlResult = queryResult.FirstOrDefault(); return(urlResult); } }
internal static Objects.User getFullUserByGuid(Guid guid) { using (var db = new edShortenerModel()) { var original = db.Users.Find(guid); Objects.User user = new Objects.User(); user.dateB = original.dateB; user.gender = original.gender; user.id = original.idUser; user.imgScr = original.imgScr; user.mail = original.mail; user.name = original.userName; user.phone = original.phone; user.realName = original.realName; return(user); } }
internal static bool verifyOldPass(Objects.User user) { using (var db = new edShortenerModel()) { var queryResult = from User in db.Users where User.idUser == user.id select User; if (queryResult.Count() == 1) { var userResult = queryResult.FirstOrDefault(); return(userResult.userPass == cryptDecrypt.cryptPass(user.oldPasss)); } return(false); } }
public static int insertNewClick(int shortedUrlId) { try { using (var db = new edShortenerModel()) { var newClick = new Model.Click(); newClick.Fk_idShortedUrl = shortedUrlId; newClick.created = DateTime.Now; db.Clicks.Add(newClick); return(db.SaveChanges()); } } catch (Exception e) { return(0); } }
public static UrlObject getUrlTableDetails(int id) { UrlObject urlTable = new UrlObject(); using (var db = new edShortenerModel()) { var queryResult = from url in db.ShortedUrls where url.idShortedUrl == id select url; var urlResult = queryResult.FirstOrDefault(); urlTable.idShortedUrl = urlResult.idShortedUrl; urlTable.longUrl = urlResult.longUrl; urlTable.shortedUrl = urlResult.shortedUrl1; urlTable.created = urlResult.created; } return(urlTable); }
public static userIdentity getDummyCurrentUser() { using (var db = new edShortenerModel()) { var queryResult = from User in db.Users where User.userName == "dummyDefault" select User; userIdentity ui = new userIdentity(); if (queryResult.Count() == 1) { var userResult = queryResult.FirstOrDefault(); ui.guid = userResult.idUser; ui.UserName = userResult.userName; return(ui); } return(null); } }
public static Guid getGuidByName(string name) { using (var db = new edShortenerModel()) { var queryResult = from User in db.Users where User.userName == name select User; userIdentity ui = new userIdentity(); if (queryResult.Count() == 1) { var userResult = queryResult.FirstOrDefault(); ui.guid = userResult.idUser; ui.UserName = userResult.userName; return(ui.guid); } return(new Guid()); } }
public static UrlObject getUrlObjectIdByShorted(string shortedUrl) { UrlObject urlItem = new UrlObject(); using (var db = new edShortenerModel()) { var queryResult = from url in db.ShortedUrls where url.shortedUrl1 == shortedUrl select url; var urlResult = queryResult.FirstOrDefault(); urlItem.idShortedUrl = urlResult.idShortedUrl; urlItem.longUrl = urlResult.longUrl; urlItem.shortedUrl = urlResult.shortedUrl1; urlItem.created = urlResult.created; urlItem.status = urlResult.pageStatus; urlItem.lastStatusCHanged = urlResult.lastStatusChange; } return(urlItem); }