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