public void SaveUrl(ShortUrl shortUrl)
{
using (var ctx = new UrlDataDataContext()) {
uURL url = new uURL();
url.ShortName = shortUrl.ShortName;
url.URL = shortUrl.URL;
ctx.uURLs.InsertOnSubmit(url);
ctx.SubmitChanges();
}
}
public string GetShortName(string url)
{
string shortName = string.Empty;
using (var ctx = new UrlDataDataContext()) {
shortName = (from row in ctx.uURLs
where row.URL == url
select row.ShortName).FirstOrDefault();
}
return(shortName);
}
//TODO Use Base16 for now, find a better way to do this later.
public string GetNewShortName()
{
string shortName = string.Empty;
using (var ctx = new UrlDataDataContext()) {
var query = (from row in ctx.uURLs
orderby row.ID descending
select row.ID).Take(1);
shortName = System.Convert.ToString(query.FirstOrDefault() + 11111, 16);
}
return(shortName);
}
public string GetUrl(string shortName)
{
string url = string.Empty;
using (var ctx = new UrlDataDataContext()) {
url = (from row in ctx.uURLs
where row.ShortName == shortName
select row.URL).FirstOrDefault();
}
if (url != null && !url.Contains("://"))
{
url = @"http://" + url;
}
return(url);
}
