public static string NoteUpdate(NoteViews note)
{
try
{
using (WebdeNotEntities db = new WebdeNotEntities())
{
TblNote upnote = db.TblNote.Find(note.ID);
if (upnote != null)
{
upnote.Title = note.Title;
upnote.Description = note.Description;
upnote.ReminderDate = note.ReminderDate;
upnote.İmportantyDegree = note.İmportantyDegree;
db.SaveChanges();
return("+ note guncellendi.");
}
else
{
return("- note bulunamadi.");
}
}
}
catch (Exception ex)
{
return("- " + ex.Message);
}
}
public static userView Login(string nickName, string pass)
{
try
{
using (WebdeNotEntities db = new WebdeNotEntities())
{
userView u = (from ku in db.TblUser where ku.Nickname == nickName && ku.Password == pass && ku.Existing == true ||
ku.Email == nickName && ku.Password == pass && ku.Existing == true select new userView {
Surname = ku.Surname,
Nickname = ku.Nickname,
Name = ku.Name,
Email = ku.Email,
Photo = ku.Photo,
ID = ku.ID
}).SingleOrDefault();
if (u != null)
{
return(u);
}
else
{
return(null);
}
};
}
catch (Exception ex)
{
return(null);
}
}
public static string SignUp(userView newUser)
{
try
{
using (WebdeNotEntities db = new WebdeNotEntities())
{
TblUser nUser = new TblUser {
Name = newUser.Name, Email = newUser.Email, Nickname = newUser.Nickname, Photo = newUser.Photo, Password = newUser.Password, Surname = newUser.Surname, BirthDate = newUser.BirtDate
};
nUser.JoinDate = DateTime.Now;
nUser.Existing = true;
db.TblUser.Add(nUser);
db.SaveChanges();
return("+ okey");
};
}
catch (Exception ex)
{
return("- " + ex.Message);
}
}
public static List <NoteViews> listNote(int ID)
{
try
{
using (WebdeNotEntities db = new WebdeNotEntities())
{
List <NoteViews> listnote = new List <NoteViews>();
var n = (from note in db.TblNote where note.UserID == ID orderby note.WritingDate select note).ToList();
foreach (var item in n)
{
listnote.Add(new NoteViews {
ID = item.ID, Title = item.Title, Description = item.Description, ReminderDate = (DateTime)item.ReminderDate,
WritingDate = (DateTime)item.WritingDate, İmportantyDegree = (int)item.İmportantyDegree
});
}
return(listnote);
}
}
catch (Exception)
{
return(null);
}
}
public static string NoteAdd(NoteViews newnote)
{
try
{
using (WebdeNotEntities db = new WebdeNotEntities())
{
TblNote new_note = new TblNote
{
Title = newnote.Title,
Description = newnote.Description,
ReminderDate = newnote.ReminderDate,
İmportantyDegree = newnote.İmportantyDegree,
};
db.TblNote.Add(new_note);
db.SaveChanges();
return("+ Note eklendi");
}
}
catch (Exception ex)
{
return("- " + ex.Message);
}
}
public static string DeleteNote(int noteID)
{
try
{
using (WebdeNotEntities db = new WebdeNotEntities())
{
TblNote delnote = db.TblNote.Find(noteID);
if (delnote != null)
{
delnote.Existing = false;
return("+ Silindi.");
}
else
{
return("- not bulunamadı.");
}
db.SaveChanges();
}
}
catch (Exception ex)
{
return("- " + ex.Message);
}
}
public userView getUser(int UID)
{
try
{
using (WebdeNotEntities db = new WebdeNotEntities())
{
TblUser getUser = db.TblUser.Find(UID);
return(new userView
{
Surname = getUser.Surname,
Nickname = getUser.Nickname,
Name = getUser.Name,
Email = getUser.Email,
Photo = getUser.Photo,
ID = getUser.ID,
Age = Convert.ToDateTime(DateTime.Now - getUser.BirthDate).Year
});
};
}
catch (Exception ex)
{
return(null);
}
}