internal void AddExam(Exam s, int user_id)
{
using (SimpleDataBase db = new SimpleDataBase())
{
if (db.Exam.AsParallel().WithDegreeOfParallelism(4).Where(x => x.NameOfSub.Equals(s.NameOfSub) && x.Professor.Equals(s.Professor)).FirstOrDefault() == null)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);
using (conn)
{
conn.Open();
string sql = "Insert Into Exam(NameOfSub, Professor, Date) Values(@param1, @param2, @param3)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@param1", SqlDbType.NVarChar, 50).Value = s.NameOfSub;
cmd.Parameters.Add("@param2", SqlDbType.NVarChar, 50).Value = s.Professor;
cmd.Parameters.Add("@param3", SqlDbType.NVarChar, 20).Value = s.Date;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
}
int exam_id = db.Exam.AsParallel().WithDegreeOfParallelism(4).Where(x => x.NameOfSub.Equals(s.NameOfSub) && x.Professor.Equals(s.Professor)).First().ID;
if (db.SubjectGroup.Where(x => x.ID_EXAM == exam_id && x.ID_USER == user_id).FirstOrDefault() == null)
{
AddUserToGroupExam(exam_id, user_id);
}
else
{
throw new Exception("Jestes już zapisany na egzamin");
}
}
}
internal void MakeHTMLTable()
{
using (SimpleDataBase db = new SimpleDataBase())
{
_table = db.Subject.AsParallel().WithDegreeOfParallelism(4).ToList();
}
}
// GET: Schedule
public ActionResult Index()
{
List <Course> courses = new List <Course>();
List <Person> people;
int userID = int.Parse((String)Session["ID"]);
using (SimpleDataBase db = new SimpleDataBase())
{
// select users courses
var temp = db.UserToCourse.Where(x => x.UserID == userID).ToList();
// get users courses from db
foreach (var course in db.Course)
{
foreach (var c in temp)
{
if (course.ID == c.CourseID)
{
courses.Add(course);
break;
}
}
}
// people details from db
people = db.Person.ToList();
}
ScheduleViewModel scheduleViewModel = new ScheduleViewModel
{
Courses = courses,
People = people,
DaysOfWeek = new string[] { "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday" }
};
return(View(scheduleViewModel));
}
public static BuyForECTS BuyForECTSFunction(int user_id)
{
User user;
using (SimpleDataBase nd = new SimpleDataBase())
{
user = nd.User.Where(x => x.ID == user_id).FirstOrDefault();
}
switch (user.Department)
{
case "FAIS":
{
return(new FAIS());
}
case "WMII":
{
return(new WMII());
}
default:
break;
}
return(null);
}
internal int?FindUserECTS(int user_id)
{
User user;
using (SimpleDataBase db = new SimpleDataBase())
{
user = db.User.Where(x => x.ID == user_id).FirstOrDefault();
}
return(user.ECTS);
}
public override User Request(User objUser)
{
using (SimpleDataBase db = new SimpleDataBase())
{
var obj = db.User.Where(a => a.Login.Equals(objUser.Login) && a.Hash.Equals(objUser.Hash)).FirstOrDefault();
if (obj != null)
{
return(obj);
}
}
return(null);
}
public ActionResult Cancel(Data.Subject sub)
{
using (SimpleDataBase db = new SimpleDataBase())
{
if (sub == null)
{
db.Entry(sub).State = EntityState.Modified;
db.SaveChanges();
return(View());
}
}
return(View(sub));
}
public ConcreteSubject(int userID)
{
_subjects = new List <Exam>();
using (SimpleDataBase db = new SimpleDataBase())
{
db.SubjectGroup.ToList().ForEach(x =>
{
if (x.ID_USER == userID)
{
_subjects.Add(db.Exam.Where(y => y.ID == x.ID_EXAM).FirstOrDefault());
}
});
}
}
// GET: SearchForCourse
public ActionResult Index()
{
using (SimpleDataBase db = new SimpleDataBase())
{
var courseTable = db.Course;
var personTable = db.Person;
var viewModel = new SearchForCourseViewModel {
courses = courseTable.ToList(),
people = personTable.ToList()
};
return(View(viewModel));
}
}
public void TestInitialize()
{
dataBase = new SimpleDataBase();
controller = new DataBaseController(dataBase);
dataBase.AddServer(new Server("test-8080", "test server", "DM", "TDM"));
dataBase.AddServer(new Server("test2-8080", "] My P3rfect Server [", "DM"));
var scoreBoard = new List <ScoreBoardUnit>()
{
new ScoreBoardUnit("Player1", 20, 21, 3),
new ScoreBoardUnit("Player2", 2, 2, 21)
};
dataBase.PutMatch("test-8080", "2017-01-22T15:17:00Z",
new MatchInfo("DM-HelloWorld", "DM", 20, 20, 12.345678, scoreBoard));
}
internal void RemoveExam(int id_user, Subject sub)
{
using (SimpleDataBase db = new SimpleDataBase())
{
User user = db.User.Where(x => x.ID == id_user).FirstOrDefault();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);
using (conn)
{
conn.Open();
string sql = "Update [User] Set ECTS = ECTS + @param1 WHERE ID = @param2";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@param1", SqlDbType.Int).Value = sub.ECTS;
cmd.Parameters.Add("@param2", SqlDbType.Int).Value = id_user;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
}
}
public string ExamsInDay(int id_user, string date)
{
string ret = "";
using (SimpleDataBase db = new SimpleDataBase())
{
List <Exam> temp = db.Exam.Where(exam => exam.Date.Equals(date)).ToList();
List <int> list = db
.SubjectGroup
.Where(x => x.ID_USER == id_user)
.Select(x => x.ID_EXAM)
.ToList();
List <Exam> final = temp.Where(x => list.Any(y => y == x.ID)).ToList();
if (final != null)
{
final.ForEach(z => ret += "<li>" + z.ToString() + "</li>");
}
}
return(ret);
}
public ActionResult Cancel(int id = 0)
{
Data.Subject sub;
using (SimpleDataBase db = new SimpleDataBase())
{
sub = db.Subject.Find(id);
if (sub == null)
{
return(HttpNotFound());
}
}
Receiver receiver = new Receiver();
Command.Command command = new ConcreteCommand(receiver);
Invoker invoker = new Invoker();
invoker.SetCommand(command);
invoker.RemoveExam(int.Parse((string)Session["ID"]), sub);
Session["ECTS"] = invoker.ExecuteCommand(int.Parse((string)Session["ID"]));
return(View(sub));
}
public ActionResult Autherize(User user)
{
using (SimpleDataBase db = new SimpleDataBase())
{
User userDetails = null;
var users = db.User.Where(u => u.Login == user.Login && u.Hash == user.Hash);
if (users != null && users.Count() != 0)
{
userDetails = users.First();
}
if (userDetails == null)
{
user.LoginErrorMessage = "Wrong login or password";
Console.WriteLine("QQQQ");
return(View("Index", user));
}
else
{
user.LoginErrorMessage = "";
Data.Singleton.Singleton singleton = Data.Singleton.Singleton.Instance;
User obj = singleton.Subject(user);
if (obj != null)
{
IClient permission = new Factory().Run(obj.Flag);
Session["LoginAs"] = permission.GetName();
ITarget target = new Adapterr.Adapterr();
Session["ID"] = obj.ID.ToString();
Session["ECTS"] = obj.ECTS;
Session["Login"] = obj.Login.ToString();
Session["LogSub"] = SendMessage.Main(obj.ID);
Session["Exams"] = target.SafeData(DateTime.Now.Month + "-" + DateTime.Now.Year, int.Parse((string)Session["ID"]));
}
return(RedirectToAction("Index", "Home"));
}
}
}
public void SetUp()
{
dataBase = new SimpleDataBase();
controller = new DataBaseController(dataBase);
}
public BestPlayersCommand(SimpleDataBase dataBase)
{
this.dataBase = dataBase;
}
public RecentMatchesCommand(SimpleDataBase dataBase)
{
this.dataBase = dataBase;
}
public ServersInfoCommand(SimpleDataBase dataBase)
{
this.dataBase = dataBase;
}
public PopularServersCommand(SimpleDataBase dataBase)
{
this.dataBase = dataBase;
}
public PlayerStatsCommand(SimpleDataBase dataBase)
{
this.dataBase = dataBase;
}
