public Users GetByUsernameAndPassword(string username, string password)
{
using (var db = new Index.BloggingContext())
{
try
{
Users user = new Users();
var result =
(from u in db.Users
where u.Username == username && u.Pass == password
select u).FirstOrDefault();
Login.LoggedUser = result;
return(result);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
"Database operation Failed",
MessageBoxButtons.OK,
MessageBoxIcon.Asterisk,
MessageBoxDefaultButton.Button1);
}
return(null);
}
}
public List <Users> GetAllUsers()
{
using (var db = new Index.BloggingContext())
{
var result =
(from u in db.Users
select u).ToList();
return(result);
}
}
private List <MTasks> GetAllTasks()
{
using (var db = new Index.BloggingContext())
{
var result =
(from m in db.MTasks
select m).ToList();
return(result);
}
}
private List <TimeSpent> GetAllTime()
{
using (var db = new Index.BloggingContext())
{
var result =
(from t in db.TimeSpent
select t).ToList();
return(result);
}
}
public List <MTasks> GetAllNF()
{
using (var db = new Index.BloggingContext())
{
var result =
(from m in db.MTasks
where m.Final == false
select m).ToList();
return(result);
}
}
private void NewUser(Users obj)
{
using (var db = new Index.BloggingContext())
{
var item = new Users {
Username = obj.Username, Pass = obj.Pass, FName = obj.FName, LName = obj.LName
};
db.Users.Add(item);
db.SaveChanges();
}
}
private void DeleteTask(MTasks task)
{
using (var db = new Index.BloggingContext())
{
var item =
(from m in db.MTasks
where m.TaskId == task.TaskId
select m).First();
db.MTasks.Remove(item);
db.SaveChanges();
}
}
private void NewTask(MTasks task)
{
using (var db = new Index.BloggingContext())
{
var now = DateTime.Now;//.ToString("MM/dd/yyyy HH:mm:ss");
var item = new MTasks {
Title = task.Title, Description = task.Description, Creator = task.Creator, EstTime = task.EstTime, Assigned = task.Assigned, CreTime = now, Final = false
};
db.MTasks.Add(item);
db.SaveChanges();
}
}
private List <TimeSpent> GetTTime()
{
using (var db = new Index.BloggingContext())
{
MTasks user = (MTasks)tasksBindingSource1.Current;
var result =
(from t in db.TimeSpent
where t.TheTask == user.TaskId
select t).ToList();
return(result);
}
}
private void DeleteUser(Users user)
{
using (var db = new Index.BloggingContext())
{
var item =
(from u in db.Users
where u.UserId == user.UserId
select u).First();
db.Users.Remove(item);
db.SaveChanges();
}
}
public void DeleteTime(TimeSpent time)
{
using (var db = new Index.BloggingContext())
{
var item =
(from t in db.TimeSpent
where t.TSId == time.TSId
select t).First();
db.TimeSpent.Remove(item);
db.SaveChanges();
}
}
public void NewTime(TimeSpent time)
{
using (var db = new Index.BloggingContext())
{
var now = DateTime.Now;
var item = new TimeSpent {
TheAssi = time.TheAssi, TheTask = time.TheTask, FinTime = now, Hours = time.Hours
};
db.TimeSpent.Add(item);
db.SaveChanges();
}
}
private void FinishTask(MTasks task)
{
using (var db = new Index.BloggingContext())
{
var item =
(from m in db.MTasks
where m.TaskId == task.TaskId
select m).First();
db.Database.ExecuteSqlCommand("UPDATE MTasks" +
" SET Final={0}" +
" WHERE TaskId={1}", true, task.TaskId);
db.SaveChanges();
}
}
private void EditTask(MTasks task)
{
using (var db = new Index.BloggingContext())
{
var item =
(from m in db.MTasks
where m.TaskId == task.TaskId
select m).First();
db.Database.ExecuteSqlCommand("UPDATE MTasks" +
" SET Title={0},Description={1},EstTime={2},Assigned={3},Final={4}" +
" WHERE TaskId={5}", task.Title, task.Description,
task.EstTime, task.Assigned, task.Final, task.TaskId);
db.SaveChanges();
}
}
private void EditUser(Users user)
{
using (var db = new Index.BloggingContext())
{
var item =
(from u in db.Users
where u.UserId == user.UserId
select u).First();
db.Database.ExecuteSqlCommand("UPDATE Users" +
" SET Username={0},Pass={1},FName={2},LName={3}" +
" WHERE UserId={4}", user.Username, user.Pass, user.FName,
user.LName, user.UserId);
db.SaveChanges();
}
}