public IActionResult CourseSinglePage(int id)
{
var course = rCourse.GetBy(c => c.Id == id);
Cart cart = null;
CourseMember courseMember = new CourseMember();
if (User.Identity.IsAuthenticated) // Sepete ekle
{
int uyeid = Convert.ToInt32(User.Claims.FirstOrDefault(f => f.Type == ClaimTypes.Sid).Value);
cart = rCart.GetBy(
x => x.MemberId == uyeid &&
x.CourseId == id);
courseMember = rCourseMember.GetBy(
x => x.MemberId == uyeid &&
x.CourseId == id);
}
Course courses = rCourse.GetBy(x => x.Id == id);
int? educatid = courses.EducatorID;
Educator educators = rEducator.GetBy(x => x.ID == educatid);
List <Lesson> lesson = rLesson.GetAllLazy(x => x.CourseID == id, includeProperties: "Videos").ToList();
//Image getir
Image img = myContext.Images.FirstOrDefault(i => i.CourseID == courses.Id);
LessonCoursesVM lessonCourses = new LessonCoursesVM {
Lessons = lesson, Courses = courses, Educator = educators, Cart = cart, courseMember = courseMember
};
return(View(lessonCourses));
}
public void newArray()
{
Educator.getConstGoal(Int32.Parse(difficultyField.text), true);
championScore.text = "Score: " + Educator.getConstTrainVal(mainSequence).ToString() +
"(T" + Educator.getConstTier().ToString() + ")\nOriginal:\t" + Educator.getConstGoal() + "\nReply:\t" + Educator.getConstReply();
lastScore = Educator.getConstTrainVal(mainSequence);
}
public IActionResult CreateCourse(Course course)
{
Image img = new Image();
foreach (var file in Request.Form.Files)
{
img.ImageTitle = file.FileName;
var yeniresimad = Guid.NewGuid() + img.ImageTitle.Replace(" ", "_");
var yuklenecekyer = Path.Combine(Directory.GetCurrentDirectory(),
"wwwroot/img/" + yeniresimad);
var stream = new FileStream(yuklenecekyer, FileMode.Create);
file.CopyTo(stream);
img.ImageData = yeniresimad;
}
string uyeid = User.Claims.FirstOrDefault(f => f.Type == ClaimTypes.Sid).Value;
Educator educator = rEducator.GetBy(x => x.MemberID == Convert.ToInt32(uyeid));
course.EducatorID = educator.ID;
course.ImageURL = img.ImageData;
course.CourseDate = DateTime.Now;
rCourse.Add(course);
rCategory.GetBy(x => x.Id == course.CategoryID).Count++;
rCategory.Save();
img.CourseID = course.Id;
rImage.Add(img);
course.ImageID = img.Id;
rCourse.Update(course);
return(RedirectToAction("CreateLesson"));
}
public void SecondarySchool_Happy_Days()
{
var secondarySchool = Educator.SecondarySchool();
Assert.IsFalse(string.IsNullOrWhiteSpace(secondarySchool));
Assert.Greater(RegexMatchesCount(secondarySchool, " "), 0);
}
protected void insertButton_Click(object sender, EventArgs e)
{
Educator newEdu = new Educator(addFN.Text, addLN.Text, addEmail.Text, addPhone.Text, "Active", addJob.SelectedItem.Text);
newEdu.setFN(addFN.Text);
newEdu.setLN(addLN.Text);
newEdu.setEM(addEmail.Text);
newEdu.setPH(addPhone.Text);
newEdu.setJob(addJob.SelectedItem.Text);
sc.Open();
System.Data.SqlClient.SqlCommand createUser = new System.Data.SqlClient.SqlCommand();
createUser.Connection = sc;
String countdata = "select count(*) From [dbo].[Educator]";
createUser = new SqlCommand(countdata, sc);
Int32 countItem = (Int32)createUser.ExecuteScalar();
int readcount = (int)countItem + 1;
string insert = "insert into [dbo].[Educator] values(@EducatorID, @FirstName, @LastName, @eduEmail, @eduPhone, @Status, @LastUpdatedBy, @LastUpdated, @EmployeeLevel)";
SqlCommand insertcmd = new SqlCommand(insert, sc);
insertcmd.Parameters.AddWithValue("@EducatorID", readcount);
insertcmd.Parameters.AddWithValue("@FirstName", newEdu.getFN());
insertcmd.Parameters.AddWithValue("@LastName", newEdu.getLN());
insertcmd.Parameters.AddWithValue("@eduEmail", newEdu.getEM());
insertcmd.Parameters.AddWithValue("@eduPhone", newEdu.getPH());
insertcmd.Parameters.AddWithValue("@Status", newEdu.getStatus());
insertcmd.Parameters.AddWithValue("@EmployeeLevel", newEdu.getJob());
insertcmd.Parameters.AddWithValue("@LastUpdatedBy", Session["User"]);
insertcmd.Parameters.AddWithValue("@LastUpdated", DateTime.Now);
insertcmd.ExecuteNonQuery();
EducatorGridView.DataBind();
sc.Close();
}
public void Campus_Happy_Days()
{
var campus = Educator.Campus();
Assert.IsFalse(string.IsNullOrWhiteSpace(campus));
Assert.Greater(RegexMatchesCount(campus, " "), 0);
}
public IActionResult UploadPicture()
{
string uyeid = User.Claims.FirstOrDefault(f => f.Type == ClaimTypes.Sid).Value;
Member member = rMember.GetBy(x => x.ID == Convert.ToInt32(uyeid));
Picture img = rPicture.Bul(member.PictureID);
foreach (var file in Request.Form.Files)
{
img.ImageTitle = file.FileName;
var yeniresimad = Guid.NewGuid() + img.ImageTitle.Replace(" ", "_");
var yuklenecekyer = Path.Combine(Directory.GetCurrentDirectory(),
"wwwroot/Picture/" + yeniresimad);
var stream = new FileStream(yuklenecekyer, FileMode.Create);
file.CopyTo(stream);
img.ImageData = yeniresimad;
}
member.PictureURL = img.ImageData;
Educator ed = rEducator.GetBy(x => x.MemberID == member.ID);
ed.PictureURL = rMember.GetBy(x => x.ID == member.ID).PictureURL;
rEducator.Update(ed);
rPicture.Update(img);
rMember.Update(member);
return(RedirectToAction("Profil", new { member.ID }));
}
public IActionResult Index()
{
string uyeid = User.Claims.FirstOrDefault(f => f.Type == ClaimTypes.Sid).Value;
Educator educator = rEducator.GetBy(x => x.MemberID == Convert.ToInt32(uyeid));
List <Course> courses = rCourse.GetAllLazy(x => x.EducatorID == educator.ID, includeProperties: "Lessons").ToList();//kursa lessoncount eklenince lazy loading ile commentler cekilecek.
/*List<Comment> comments = new List<Comment>();
* //rComment.GetAll(x => x.CourseID == 1);
* foreach (var item in courses)
* {
* foreach (var item2 in comments)
* {
* item2.UserComment = rComment.GetBy(x=>x.CourseID== item.Id).UserComment;
* item2.MemberName = rComment.GetBy(x=>x.CourseID== item.Id).MemberName;
* item2.CommentDate = rComment.GetBy(x=>x.CourseID== item.Id).CommentDate;
* item2.Rate = rComment.GetBy(x=>x.CourseID== item.Id).Rate;
* rComment.Save();
* }
* }*/
LessonCoursesVM lessonCoursesVM = new LessonCoursesVM
{
Educator = educator,
Coursess = courses
};
return(View(lessonCoursesVM));
}
protected void EditButton_Click(object sender, EventArgs e)
{
Educator editEdu = new Educator(editFN.Text, editLN.Text, editEM.Text, editPH.Text, ddlStatus.SelectedItem.Value, ddlJob.SelectedItem.Text);
editEdu.setFN(editFN.Text);
editEdu.setLN(editLN.Text);
editEdu.setEM(editEM.Text);
editEdu.setPH(editPH.Text);
editEdu.setJob(ddlJob.SelectedItem.Text);
sc.Open();
string update = "update [dbo].[Educator] set FirstName=@FirstName, LastName=@LastName, eduEmail=@eduEmail, eduPhone=@eduPhone, Status=@Status, EmployeeLevel=@EmployeeLevel, LastUpdatedBy=@LastUpdatedBy, LastUpdated=@LastUpdated where EducatorID=@EducatorID";
SqlCommand updatecmd = new SqlCommand(update, sc);
updatecmd.Parameters.AddWithValue("@EducatorID", EducatorGridView.SelectedRow.Cells[6].Text);
updatecmd.Parameters.AddWithValue("@FirstName", editEdu.getFN());
updatecmd.Parameters.AddWithValue("@LastName", editEdu.getLN());
updatecmd.Parameters.AddWithValue("@eduEmail", editEdu.getEM());
updatecmd.Parameters.AddWithValue("@eduPhone", editEdu.getPH());
updatecmd.Parameters.AddWithValue("@Status", editEdu.getStatus());
updatecmd.Parameters.AddWithValue("@EmployeeLevel", editEdu.getJob());
updatecmd.Parameters.AddWithValue("@LastUpdatedBy", Session["User"]);
updatecmd.Parameters.AddWithValue("@LastUpdated", DateTime.Now);
updatecmd.ExecuteNonQuery();
EducatorGridView.DataBind();
sc.Close();
}
public IActionResult Index()
{
Educator educator = educatorRepo.Get(2);
List <Education> identityEducation = educationRepo.EducationsByEducator(educator);
HomeIndexViewModel model = new HomeIndexViewModel {
Date = DateTime.Now,
IsChecked = false,
CourseList = new List <Course>(),
EducationList = new List <Education>()
};
foreach (Education education in identityEducation)
{
List <Course> courseList = new List <Course>();
foreach (Student student in education.Students)
{
foreach (StudentCourse studentCourse in student.StudentCourses)
{
courseList.Add(studentCourse.Course);
}
}
courseList = courseList.Distinct().ToList();
DayOfWeekCheck(courseList, education, model);
}
model.EducationList = model.EducationList.Distinct().ToList();
model.CheckedEducation = absenceRepo.EducationHasAbsence(model.EducationList, model.Date);
ViewBag.TypeOfView = "education";
return(View("Index", model));
}
public IActionResult Profile()
{
string uyeid = User.Claims.FirstOrDefault(f => f.Type == ClaimTypes.Sid).Value;
Educator educator = rEducator.GetBy(x => x.MemberID == Convert.ToInt32(uyeid));
return(View(educator));
}
public void University_Happy_Days()
{
var university = Educator.University();
Assert.IsFalse(string.IsNullOrWhiteSpace(university));
Assert.Greater(RegexMatchesCount(university, " "), 0);
}
public ActionResult Create(FormCollection collection, Educator educator)
{
HeaderInfo.Instance.UserID = SessionInfo.UserIDLogged;
HeaderInfo.Instance.CurrentDateTime = DateTime.Today;
try
{
if (string.IsNullOrEmpty(educator.FirstName))
{
// do nothing
}
else
{
// codeType.ConnectionStringUsed = ConnectionString.GetConnectionString("makkframework");
var workerAddRequest = new WorkerAddRequest();
workerAddRequest.XHeaderInfo = HeaderInfo.Instance;
workerAddRequest.XEducator = educator;
var workAddResponse = educator.Add(workerAddRequest);
if (workAddResponse.XResponseStatus.ReturnCode < 0000)
{
ModelState.AddModelError("Error", workAddResponse.XResponseStatus.Message);
return(View());
}
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public void Course_Happy_Days()
{
var course = Educator.Course();
Assert.IsFalse(string.IsNullOrWhiteSpace(course));
Assert.Greater(RegexMatchesCount(course, " "), 0);
}
public async Task <ActionResult> PostEducator(EducatorInsertDTO educator)
{
try
{
UserAccount newAccount = new UserAccount(educator.Username, educator.Password, 2, educator.AvatarUrl);
int newAccountId = await _userAccountRepository.AddUserAccount(newAccount);
if (newAccountId != 0)
{
Educator newEducator = new Educator(educator.FirstName, educator.LastName,
educator.Email, educator.Phone, newAccountId, educator.Title, educator.CourseFieldId);
var edcId = await _educatorRepository.AddEducator(newEducator);
return(Ok());
}
return(BadRequest());
}
catch (Exception ex)
{
throw ex;
}
}
public EducatorDialogView(Educator educator)
{
InitializeComponent();
DataContext = new EducatorDialogViewModel()
{
Educator = educator
};
}
public void DataCheck(Educator data)
{
if (data == null)
{
MessageBox.Show("Трябва да селектирате запис от таблицата");
return;
}
}
public IActionResult CourseList()
{
string uyeid = User.Claims.FirstOrDefault(f => f.Type == ClaimTypes.Sid).Value;
Educator educator = rEducator.GetBy(x => x.MemberID == Convert.ToInt32(uyeid));
List <Course> courses = rCourse.GetAll(x => x.EducatorID == educator.ID).ToList();
return(View(courses));
}
public async Task <int> AddEducator(Educator educator)
{
var e = _context.Educators.Add(educator);
_context.SaveChanges();
return(educator.Id);
}
public IActionResult ConfirmationCancelEducator(int id)
{
Educator educator = rEducator.GetBy(x => x.ID == id);
educator.State = false;
rEducator.Save();
return(RedirectToAction("EducatorList"));
}
public IActionResult RegisterEducator(Educator ed)
{
int uyeid = Convert.ToInt32(User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value);
ed.PictureURL = rMember.GetBy(x => x.ID == uyeid).PictureURL;
rEducator.Add(ed);
return(RedirectToAction("Index"));
}
//
// GET: /Worker/Edit/5
public ActionResult Edit(int id)
{
var worker = new Educator();
worker.UID = id;
worker.Read();
return(View(worker));
}
public IActionResult CreateLesson()
{
string uyeid = User.Claims.FirstOrDefault(f => f.Type == ClaimTypes.Sid).Value;
Educator educator = rEducator.GetBy(x => x.MemberID == Convert.ToInt32(uyeid));
ViewBag.dgr = rCourse.GetAll(x => x.EducatorID == educator.ID).Select(s => new SelectListItem {
Text = s.Name, Value = s.Id.ToString()
});
return(View());
}
public void newSequence()
{
mainSequence = new Sequence();
inputField.text = mainSequence.save();
champion.text = Educator.getConstTrainAI(mainSequence).traverseTreeWithUnityCharacteristics();
lastScore = Educator.getConstTrainVal(mainSequence);
championScore.text = "Score: " + lastScore.ToString();
current.text = "";
currentScore.text = "";
}
public IActionResult Index(HomeIndexViewModel model)
{
Educator educator = educatorRepo.Get(2);
DateTime dateTime = model.Date;
model.CourseList = new List <Course>();
if (model.Direction == "Backward")
{
dateTime = model.Date.AddDays(-1);
}
else if (model.Direction == "Forward")
{
dateTime = model.Date.AddDays(1);
}
model.Date = dateTime;
if (model.IsChecked)
{
List <Course> identityCourses = courseRepo.CoursesByEducator(educator);
DayOfWeekCheck(identityCourses, null, model);
model.CheckedCourse = absenceRepo.CourseHasAbsence(model.CourseList, model.Date);
ViewBag.TypeOfView = "course";
}
else
{
model.EducationList = new List <Education>();
List <Education> identityEducation = educationRepo.EducationsByEducator(educator);
foreach (Education education in identityEducation)
{
List <Course> courseList = new List <Course>();
foreach (Student student in education.Students)
{
foreach (StudentCourse studentCourse in student.StudentCourses)
{
courseList.Add(studentCourse.Course);
}
}
courseList = courseList.Distinct().ToList();
DayOfWeekCheck(courseList, education, model);
}
model.EducationList = model.EducationList.Distinct().ToList();
model.CheckedEducation = absenceRepo.EducationHasAbsence(model.EducationList, model.Date);
ViewBag.TypeOfView = "education";
}
return(View("Index", model));
}
public async Task <IHttpActionResult> Post([FromBody] Educator educator)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
educator = await Service.CreateAsync(educator);
return(CreatedAtRoute("GetEducator", new { id = educator.EducatorId }, educator.EducatorId));
}
public ActionResult Index()
{
HeaderInfo.Instance.UserID = SessionInfo.UserIDLogged;
HeaderInfo.Instance.CurrentDateTime = System.DateTime.Today;
var ctl = new Educator();
ctl.List(SessionInfo.UserIDLogged);
return(View(ctl));
}
public async Task <Educator> CreateAsync(Educator entity)
{
var response = await _client.PostAsJsonAsync("/api/Educators", entity);
if (response.IsSuccessStatusCode)
{
var id = await response.Content.ReadAsAsync <int>();
return(await ReadAsync(id));
}
return(null);
}
//
// GET: /Worker/Details/5
public ActionResult Details(int id)
{
HeaderInfo.Instance.UserID = SessionInfo.UserIDLogged;
HeaderInfo.Instance.CurrentDateTime = System.DateTime.Today;
var ct = new Educator();
ct.UID = id;
ct.Read();
return(View(ct));
}
public async Task <ActionResult <EducatorDTO> > GetById(int id)
{
Educator educator = await _educatorRepository.GetById(id);
EducatorDTO educatorDTO = educator.ToDTO();
IEnumerable <EducatorRate> rates = await _educatorRepository.GetAllEducatorRates(educatorDTO.ID);
educatorDTO.Rates = rates.ToDTOList();
educatorDTO.AvgRate = rates.Count() > 0 ? rates.Average(x => x.Rate) : 0.0;
return(Ok(educatorDTO));
}
