public Boolean Check(String name,String pass)
{
FinalDataContext db = new FinalDataContext();
if ((db.Accounts.FirstOrDefault(x => x.username == name && x.password == pass)) == null)
return false;
return true;
}
public Boolean ModPass(String username, String password)
{
FinalDataContext db = new FinalDataContext();
Account acc = db.Accounts.FirstOrDefault(x => x.username == username);
acc.password = password;
db.SubmitChanges();//xác nhận chỉnh sửa
return true;
}
public Boolean InsertJob(String jobname, String company, String info)
{
FinalDataContext db = new FinalDataContext();
Job j = new Job();
j.jobname = jobname;
j.company = company;
j.info = info;
db.Jobs.InsertOnSubmit(j);
db.SubmitChanges();
return true;
}
public Boolean InsertAccount(String username, String password)
{
FinalDataContext db = new FinalDataContext();
if (db.Accounts.FirstOrDefault(x => x.username == username) != null) return false;
Account acc = new Account();
acc.username = username;
acc.password = password;
db.Accounts.InsertOnSubmit(acc);
db.SubmitChanges();
return true;
}
public Boolean ModUserInfo(String name, String dob, String job, int syear, int eyear)
{
FinalDataContext db = new FinalDataContext();
User user = db.Users.FirstOrDefault(x => x.username == name);
user.dob = dob;
user.job = job;
user.startyear = syear;
user.endyear = eyear;
db.SubmitChanges();
return true;
}
public Boolean InsertComment(String com, int topicid, String usercomment)
{
FinalDataContext db = new FinalDataContext();
Comment c = new Comment();
c.com = com;
c.topicid = topicid;
c.usercomment = usercomment;
db.Comments.InsertOnSubmit(c);
db.SubmitChanges();
return true;
}
public Boolean InsertTopic(String topicname, String owner, String topicinfo)
{
FinalDataContext db = new FinalDataContext();
Topic top = new Topic();
top.name = topicname;
top.owner = owner;
top.info = topicinfo;
db.Topics.InsertOnSubmit(top);
db.SubmitChanges();
return true;
}
public Boolean InsertInfo(String name, String dob, String job, int startyear, int endyear)
{
FinalDataContext db = new FinalDataContext();
if (db.Accounts.FirstOrDefault(x => x.username == name) == null) return false;
User inf = new User();
inf.username = name;
inf.dob = dob;
inf.job = job;
inf.startyear = startyear;
inf.endyear =endyear;
db.Users.InsertOnSubmit(inf);
db.SubmitChanges();
return true;
}
public Repository()
{
this.context = new FinalDataContext();
}
public List<Comment> GetComment(char c)
{
FinalDataContext db = new FinalDataContext();
return db.Comments.ToList();
}
public List<Topic> GetTopic(char t)
{
FinalDataContext db = new FinalDataContext();
return db.Topics.ToList();
}
public List<Job> GetInfoList(char j)
{
FinalDataContext db = new FinalDataContext();
return db.Jobs.ToList();
}
public User GetUser(String n)
{
FinalDataContext db = new FinalDataContext();
return db.Users.FirstOrDefault(x => x.username == n);
}
public List<User> GetAccList()
{
FinalDataContext db = new FinalDataContext();
return db.Users.ToList();
}
// GET: Coach
public ActionResult Index()
{
FinalDataContext context = new FinalDataContext();
return(View(context.Coaches.ToList()));
}
