public string CheckPassword(Guid linkId, string password) { using (var dc = new LinkKSDataContext()) { return(dc.LINKs.Where(c => c.LINK_ID == linkId && c.LINK_PASSWORD == password).Select(c => c.LONG_LINK).FirstOrDefault()); } }
public void UpdateExpireDate(Guid linkId, DateTime?expireDate) { using (var dc = new LinkKSDataContext()) { var item = dc.LINKs.First(c => c.LINK_ID == linkId); item.EXPIRE_DATE = expireDate; dc.SubmitChanges(); } }
public void UpdateNotification(Guid linkId, bool notification) { using (var dc = new LinkKSDataContext()) { var item = dc.LINKs.First(c => c.LINK_ID == linkId); item.LINK_NOTIFICATION = notification; dc.SubmitChanges(); } }
public void UpdateOneShot(Guid linkId, bool oneshot) { using (var dc = new LinkKSDataContext()) { var item = dc.LINKs.First((c => c.LINK_ID == linkId)); item.ONE_SHOT = oneshot; dc.SubmitChanges(); } }
//private string GenerateShortLink() //{ // var rnd = new Random(); // var shortLink = ""; // for (int i = 0; i < 6; i++) // { // var index = rnd.Next(Link.ValidChars.Length); // shortLink += Link.ValidChars[index]; // } // return shortLink; //} public void UpdatePassword(Guid linkId, string password) { using (var dc = new LinkKSDataContext()) { var item = dc.LINKs.First(c => c.LINK_ID == linkId); item.LINK_PASSWORD = password; dc.SubmitChanges(); } }
public DTO_USER GetProfile(Guid userId) { using (var dc = new LinkKSDataContext()) { return(dc.USERs.Where(c => c.USERID == userId).Select(c => new DTO_USER { Name = c.USERNAME, EMail = c.E_MAIL, Password = c.USER_PASSWORD }).FirstOrDefault()); } }
public void UpdateOneShot(Guid linkId, bool oneShot) { using (var dc = new LinkKSDataContext()) { var item = dc.LINKs.First(c => c.Id == linkId); item.OneShot = oneShot; item.UpdateTime = DateTime.Now; dc.SubmitChanges(); } }
public void UpdateNotification(Guid linkId, bool notification) { using (var dc = new LinkKSDataContext()) { var item = dc.LINKs.First(c => c.Id == linkId); item.Notification = notification; item.UpdateTime = DateTime.Now; dc.SubmitChanges(); } }
public void UpdatePassword(Guid linkId, string password) { using (var dc = new LinkKSDataContext()) { var item = dc.LINKs.First(c => c.Id == linkId); item.Password = password; item.UpdateTime = DateTime.Now; dc.SubmitChanges(); } }
public void UpdateExpireDate(Guid linkId, DateTime?expireDate) { using (var dc = new LinkKSDataContext()) { var item = dc.LINKs.First(c => c.Id == linkId); item.ExpireDate = expireDate; item.UpdateTime = DateTime.Now; dc.SubmitChanges(); } }
public void UpdateProfile(Guid userId, string name, string email, string password) { using (var dc = new LinkKSDataContext()) { var item = dc.USERs.First(c => c.ID == userId); item.Name = name; item.EMail = email; item.Password = password; dc.SubmitChanges(); } }
public DTO_USER GetProfile(Guid userId) { using (var dc = new LinkKSDataContext()) { return(dc.USERs.Where(x => x.ID == userId).Select(c => new DTO_USER { Name = c.Name, Email = c.EMail, Password = c.Password }).FirstOrDefault()); } }
public void UpdateUser(Guid userId, string name, string email, string password) { using (var dc = new LinkKSDataContext()) { var item = dc.USERs.First(c => c.USERID == userId); item.USERNAME = name; item.E_MAIL = email; item.USER_PASSWORD = password; item.UPDATE_DATE = DateTime.Now; dc.SubmitChanges(); } }
public Guid?SignIn(string email, string password) { using (var dc = new LinkKSDataContext()) { var id = dc.USERs.Where(x => x.EMail == email && x.Password == password).Select(c => c.ID).FirstOrDefault(); if (id == Guid.Empty) // Empty=0 { return(null); } return(id); } }
public Guid?SignIn(string email, string password) { using (var dc = new LinkKSDataContext()) { //var id = dc.USERs.Where(c => c.E_MAIL == email && c.USER_PASSWORD == password).Select(c => c.USERID).FirstOrDefault(); var id = (from c in dc.USERs where c.E_MAIL == email select c.USERID).FirstOrDefault(); if (id == Guid.Empty) { return(null); } return(id); } }
public DTO_LINK_LOG[] ListLog(Guid linkId) { using (var dc = new LinkKSDataContext()) { return(dc.LINK_LOGs.Where(c => c.LINK_ID == linkId).Select(c => new DTO_LINK_LOG { IP = c.IP, Agent = c.AGENT, Date = c.LOG_DATE, Referrer = c.REFERRER }).ToArray()); } }
public Guid?SignIn(string eMail, string password) { using (var dc = new LinkKSDataContext()) { var userId = dc.USERs.Where(c => c.EMail == eMail && c.Password == password).Select(c => c.Id).FirstOrDefault(); if (userId == default(Guid)) { return(null); } return(userId); } }
public void Update(Guid userId, string name, string eMail, string password) { using (var dc = new LinkKSDataContext()) { var item = dc.USERs.Where(c => c.Id == userId).First(); item.Name = name; item.EMail = eMail; item.Password = password; item.UpdateDate = DateTime.Now; dc.SubmitChanges(); } }
public void Log(Guid linkId, string Ip, string Referer, string Agent, DateTime Date) { using (var dc = new LinkKSDataContext()) { var item = new LINK_LOG(); item.LOG_ID = Guid.NewGuid(); item.IP = Ip; item.LINK_ID = linkId; item.REFERRER = Referer; item.AGENT = Agent; item.LOG_DATE = DateTime.Now; dc.LINK_LOGs.InsertOnSubmit(item); dc.SubmitChanges(); } }
public Guid SignUp(string name, string email, string password) { using (var dc = new LinkKSDataContext()) { var item = new USER(); item.USERID = Guid.NewGuid(); item.USERNAME = name; item.E_MAIL = email; item.USER_PASSWORD = password; item.CREATE_DATE = DateTime.Now; dc.USERs.InsertOnSubmit(item); dc.SubmitChanges(); return(item.USERID); } }
public string GenerateShortLink(LinkKSDataContext dc) { var rnd = new Random(); while (true) { var shortLink = ""; for (int i = 0; i < 6; i++) { var index = rnd.Next(Link.ValidChars.Length); shortLink += Link.ValidChars[index]; } if (!dc.LINKs.Any(c => c.SHORT_LINK == shortLink)) { return(shortLink); } } }
public Guid SignUp(string name, string email, string password) { using (var dc = new LinkKSDataContext()) { var item = new USER(); item.ID = Guid.NewGuid(); item.Name = name; item.EMail = email; item.Password = password; item.CreatedDate = DateTime.Now; dc.USERs.InsertOnSubmit(item); dc.SubmitChanges(); return(item.ID); } }
//public void UpdateStatus() yazzzzz public DTO_LINK[] List(Guid userId) { using (var dc = new LinkKSDataContext()) { return(dc.LINKs.Where(c => c.USERID == userId).Select(c => new DTO_LINK { Id = c.LINK_ID, password = c.LINK_PASSWORD, shortLink = c.SHORT_LINK, longLink = c.LONG_LINK, expiredDate = c.EXPIRE_DATE, oneShot = c.ONE_SHOT, notification = c.LINK_NOTIFICATION, createDateLink = c.CREATE_DATE, STATUS = (Status)c.LINK_STATUS, ClickCount = c.LINK_LOGs.Count }).ToArray()); } }
public void Delete(Guid linkId) { using (var dc = new LinkKSDataContext()) { var item = dc.LINKs.Where(c => c.LINK_ID == linkId).Select(c => c); foreach (var i in item) { dc.LINKs.DeleteOnSubmit(i); } try { dc.SubmitChanges(); } catch (Exception e) { throw new Exception(e.Message); } } }
public string Shorten(string longLink, Guid?userId, string password) { using (var dc = new LinkKSDataContext()) { var item = new LINK(); item.ID = Guid.NewGuid(); item.LongLink = longLink; item.ShortLink = this.GenerateShortLink(dc); item.UserID = userId; item.Password = password; item.CreatedDate = DateTime.Now; dc.LINKs.InsertOnSubmit(item); dc.SubmitChanges(); return(item.ShortLink); } }
public string Shorten(string longLink, Guid?userId, string password, DateTime?expireDate, bool notification, bool oneshot, byte status) { using (var dc = new LinkKSDataContext()) { var item = new LINK(); item.LINK_ID = Guid.NewGuid(); item.SHORT_LINK = this.GenerateShortLink(dc); item.LONG_LINK = longLink; item.LINK_PASSWORD = password; item.USERID = userId; item.CREATE_DATE = DateTime.Now; item.EXPIRE_DATE = expireDate; item.LINK_NOTIFICATION = notification; item.ONE_SHOT = oneshot; item.LINK_STATUS = status; dc.LINKs.InsertOnSubmit(item); dc.SubmitChanges(); return(item.SHORT_LINK); } }
public string Shorten(string longLink, Guid?userId, string password, DateTime?expireDate, bool oneShot, bool notification) { using (var dc = new LinkKSDataContext()) { var item = new LINK(); //veri tabanında yeni satır oluşturduk item.Id = Guid.NewGuid(); item.LongLink = longLink; item.ShortLink = this.GenerateShortLink(dc); item.UserId = userId; item.Password = password; item.CreateDate = DateTime.Now; item.OneShot = oneShot; item.Notification = notification; dc.LINKs.InsertOnSubmit(item); dc.SubmitChanges(); return(item.ShortLink); } }
public DTO_LINK_CONTROL_RESULT GetLongLink(string shortLink) { using (var dc = new LinkKSDataContext()) { var item = dc.LINKs.Where(c => c.SHORT_LINK == shortLink).Select(c => new { c.LINK_ID, c.LONG_LINK, c.LINK_STATUS, c.LINK_PASSWORD, c.EXPIRE_DATE, c.ONE_SHOT, clicked = c.LINK_LOGs.Any() }).FirstOrDefault(); if (item == null) { return(null); } if (item.LINK_STATUS != (byte)Status.Active) { return(null); } if (item.EXPIRE_DATE < DateTime.Now) { return(null); } return(new DTO_LINK_CONTROL_RESULT { linkId = item.LINK_ID, longLink = item.LONG_LINK, password = item.LINK_PASSWORD != null, oneShot = item.ONE_SHOT && item.clicked }); } }