public ActionResult Sudent_Register(Tbl_Student svw, HttpPostedFileBase imgfile)
{
Tbl_Student s = new Tbl_Student();
//try
//{
s.S_UserName = svw.S_UserName;
s.S_Password = svw.S_Password;
s.S_FirstName = svw.S_FirstName;
s.S_LastName = svw.S_LastName;
s.S_EmailID = svw.S_EmailID;
s.S_ContactNo = svw.S_ContactNo;
s.S_Birthdate = svw.S_Birthdate;
s.S_Age = svw.S_Age;
s.S_img = uploadimage(imgfile);
db.Tbl_Student.Add(s);
db.SaveChanges();
return(RedirectToAction("slogin"));
// }
//catch (Exception)
//{
// ViewBag.msg = "Data could not insert";
//}
// return View();
}
public IHttpActionResult Get(string id)
{
var item = context.Tbl_Student.Where(p => p.StudentID == id).FirstOrDefault();
if (item == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
Tbl_Student cat = new Tbl_Student();
cat.SerialID = item.SerialID;
cat.StudentID = item.StudentID;
cat.FirstName = item.FirstName;
cat.LastName = item.LastName;
cat.BirthDate = item.BirthDate;
cat.DepartmentID = item.DepartmentID;
cat.FatherName = item.FatherName;
cat.MotherName = item.MotherName;
cat.PresentAddress = item.PresentAddress;
cat.PermanentAddress = item.PermanentAddress;
cat.Phone = item.Phone;
cat.Email = item.Email;
cat.Sex = item.Sex;
cat.Nationality = item.Nationality;
cat.Religion = item.Religion;
cat.MaritalStatus = item.MaritalStatus;
cat.BloodGroup = item.BloodGroup;
cat.AdmissionDate = item.AdmissionDate;
cat.GraduationDate = item.GraduationDate;
cat.PerSemesterRecordID = item.PerSemesterRecordID;
cat.DocumentsGiven = item.DocumentsGiven;
cat.Password = item.Password;
cat.Picture = item.Picture;
cat.Type = item.Type;
cat.links.Add(new Links()
{
HRef = "http://localhost:57254/api/Students", Method = "GET", Rel = "Self"
});
cat.links.Add(new Links()
{
HRef = "http://localhost:57254/api/Students/" + cat.StudentID, Method = "GET", Rel = "Specific Resource"
});
cat.links.Add(new Links()
{
HRef = "http://localhost:57254/api/Students/" + cat.StudentID, Method = "PUT", Rel = "Resource Edit"
});
cat.links.Add(new Links()
{
HRef = "http://localhost:57254/api/Students/" + cat.StudentID, Method = "DELETE", Rel = "Resource Delete"
});
cat.links.Add(new Links()
{
HRef = "http://localhost:57254/api/Students", Method = "POST", Rel = "Resource Create"
});
return(Ok(cat));
}
}
public IHttpActionResult Get()
{
var list = context.Tbl_Student.ToList();
List <Tbl_Student> categories = new List <Tbl_Student>();
foreach (var item in list)
{
Tbl_Student cat = new Tbl_Student();
cat.SerialID = item.SerialID;
cat.StudentID = item.StudentID;
cat.FirstName = item.FirstName;
cat.LastName = item.LastName;
cat.BirthDate = item.BirthDate;
cat.DepartmentID = item.DepartmentID;
cat.FatherName = item.FatherName;
cat.MotherName = item.MotherName;
cat.PresentAddress = item.PresentAddress;
cat.PermanentAddress = item.PermanentAddress;
cat.Phone = item.Phone;
cat.Email = item.Email;
cat.Sex = item.Sex;
cat.Nationality = item.Nationality;
cat.Religion = item.Religion;
cat.MaritalStatus = item.MaritalStatus;
cat.BloodGroup = item.BloodGroup;
cat.AdmissionDate = item.AdmissionDate;
cat.GraduationDate = item.GraduationDate;
cat.PerSemesterRecordID = item.PerSemesterRecordID;
cat.DocumentsGiven = item.DocumentsGiven;
cat.Password = item.Password;
cat.Picture = item.Picture;
cat.Type = item.Type;
cat.links.Add(new Links()
{
HRef = "http://localhost:57254/api/Students", Method = "GET", Rel = "Self"
});
cat.links.Add(new Links()
{
HRef = "http://localhost:57254/api/Students/" + cat.StudentID, Method = "GET", Rel = "Specific Resource"
});
cat.links.Add(new Links()
{
HRef = "http://localhost:57254/api/Students/" + cat.StudentID, Method = "PUT", Rel = "Resource Edit"
});
cat.links.Add(new Links()
{
HRef = "http://localhost:57254/api/Students/" + cat.StudentID, Method = "DELETE", Rel = "Resource Delete"
});
cat.links.Add(new Links()
{
HRef = "http://localhost:57254/api/Students", Method = "POST", Rel = "Resource Create"
});
categories.Add(cat);
}
return(Ok(categories));
}
public ActionResult Index(Model_TakeTurn model)
{
int ID = Convert.ToInt32(model.Sheft);
Tbl_TurnTimeSheet _TurnTimeSheet = db.Tbl_TurnTimeSheet.Where(a => a.TTS_ID == ID).SingleOrDefault();
Tbl_Student _Student = db.Tbl_Student.Where(a => a.Student_Code == User.Identity.Name).SingleOrDefault();
if (_Student.Student_TakeTurn)
{
return(RedirectToAction("index", "Portal"));
}
if (_TurnTimeSheet.TTS_MaxSize > _TurnTimeSheet.Tbl_TakeTurn.Count())
{
Tbl_TakeTurn _TakeTurn = new Tbl_TakeTurn()
{
TT_Guid = Guid.NewGuid(),
TT_StudentID = _Student.Student_ID,
TT_TTSID = _TurnTimeSheet.TTS_ID,
};
db.Tbl_TakeTurn.Add(_TakeTurn);
_Student.Student_TakeTurn = true;
db.Entry(_Student).State = EntityState.Modified;
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "عملیات با موفقیت انجام شده";
return(RedirectToAction("index", "Portal"));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(RedirectToAction("Index"));
}
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "ظرفیت این تایم تکمیل شده است";
return(RedirectToAction("Index"));
}
}
public ActionResult ImportStudentFromExcel(HttpPostedFileBase file)
{
if (file != null && file.ContentLength > 0)
{
try
{
string path = Path.Combine(Server.MapPath("~/Images"), Path.GetFileName(file.FileName));
file.SaveAs(path);
}
catch
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(View());
}
}
else
{
ViewBag.Message = "You have not specified a file.";
}
Microsoft_Excel excel = new Microsoft_Excel(@"C:\2.xlsx");
excel.Open(1);
int row_count = excel.Get_RowCount();
string[,] ex = excel.Get_Range(1, 1, row_count, 2);
excel.Close();
for (int i = 0; i < row_count; i++)
{
Tbl_Student _Student = new Tbl_Student()
{
Student_Code = ex[i, 0],
Student_NationalCode = ex[i, 1],
Student_Guid = Guid.NewGuid()
};
db.Tbl_Student.Add(_Student);
}
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "ثبت نام با موفقیت انجام شده";
return(View());
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(View());
}
}
public ActionResult Index(Model_StudentInfo model)
{
Tbl_Student _Student = db.Tbl_Student.Where(a => a.Student_Code == User.Identity.Name).SingleOrDefault();
if (_Student.Student_SIID != null || _Student.Student_Info)
{
return(RedirectToAction("ShowForm", "PortalForms", new { ID = "c78afdf3-a647-4e54-95e8-94869576b7e5" }));
}
Tbl_StudentInfo _info = new Tbl_StudentInfo()
{
SI_Name = model.Name,
SI_Family = model.Family,
SI_Phone = model.Phone,
SI_Mobile = model.Mobile,
SI_Email = model.Email,
SI_BirthdayLocation = model.BirthLocation,
SI_BeforeUniversity = model.BeforeUniversity,
SI_Guid = Guid.NewGuid(),
SI_InsuranceCodeID = Convert.ToInt32(model.Insurance),
SI_BloodCodeID = Convert.ToInt32(model.Blood),
SI_GenderCodeID = Convert.ToInt32(model.Gender),
SI_NationalCodeID = Convert.ToInt32(model.National),
SI_HomeTypeCodeID = Convert.ToInt32(model.HomeType),
SI_MarriageCodeID = Convert.ToInt32(model.Marriage),
SI_BranchID = Convert.ToInt32(model.Branch),
SI_BirthYearCodeID = Convert.ToInt32(model.BirthYear),
};
db.Tbl_StudentInfo.Add(_info);
_Student.Tbl_StudentInfo = _info;
_Student.Student_Info = true;
db.Entry(_Student).State = EntityState.Modified;
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "عملیات با موفقیت انجام شده";
return(RedirectToAction("ShowForm", "PortalForms", new { ID = "c78afdf3-a647-4e54-95e8-94869576b7e5" }));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(RedirectToAction("Index"));
}
}
public void Tbl_Student_CompareTwoAsserts_AreEqual()
{
var actual = new Tbl_Student {
S_ID = 1, S_UserName = "******", S_Password = "******", S_FirstName = "abc", S_LastName = "lmn", S_EmailID = "*****@*****.**", S_Age = 22
};
Assert.AreEqual(1, actual.S_ID);
Assert.AreEqual("abc", actual.S_UserName);
Assert.AreEqual("xyz", actual.S_Password);
Assert.AreEqual("abc", actual.S_FirstName);
Assert.AreEqual("lmn", actual.S_LastName);
Assert.AreEqual("*****@*****.**", actual.S_EmailID);
Assert.AreEqual(22, actual.S_Age);
}
public ActionResult slogin(Tbl_Student s)
{
Tbl_Student std = db.Tbl_Student.Where(x => x.S_UserName == s.S_UserName && x.S_Password == s.S_Password).SingleOrDefault();
if (std == null)
{
ViewBag.msg = "Invalid Username or Password";
}
else
{
Session["S_ID"] = std.S_ID;
return(RedirectToAction("StudentExam"));
}
return(View());
}
public ActionResult Login(Tbl_Student student)
{
var log = db.Tbl_Student.Where(n => n.SuserName == student.SuserName &&
n.Spassword == student.Spassword).FirstOrDefault();
if (log != null)
{
Session["id"] = log.SID;
Session["name"] = log.SuserName.ToString();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "User Name or Password is wrong");
}
return(View());
}
public ActionResult Registation(Tbl_Student student)
{
if (ModelState.IsValid)
{
if (db.Tbl_Student.Any(x => x.Stid == student.Stid || x.SuserName == student.SuserName))
{
ViewBag.show = " Student already exist";
RedirectToAction("Registation", "Student");
}
else
{
db.Tbl_Student.Add(student);
db.SaveChanges();
ModelState.Clear();
ViewBag.show2 = student.Sname + " Successfully Add";
}
}
return(View());
}
public ActionResult Create(Model_StudentCreate model)
{
if (ModelState.IsValid)
{
if (db.Tbl_Student.Where(x => x.Student_Code == model.Student_Code).Any())
{
TempData["TosterState"] = "info";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "اطلاعات دانشجوی مورد نظر قبلا در سامانه ثبت شده است.";
return(RedirectToAction("Index"));
}
Tbl_Student Student = new Tbl_Student()
{
Student_Guid = Guid.NewGuid(),
Student_Code = model.Student_Code,
Student_NationalCode = model.Student_NationalCode
};
db.Tbl_Student.Add(Student);
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "ثبت شد";
return(RedirectToAction("Index"));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "ثبت نشد";
return(RedirectToAction("Index"));
}
}
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
public IHttpActionResult Post([FromBody] Tbl_PreStudent pre)
{
var item = context.Tbl_PreStudent.Where(x => x.StudentID == pre.StudentID).FirstOrDefault();
Tbl_Student cat = new Tbl_Student();
cat.StudentID = item.StudentID;
cat.FirstName = item.FirstName;
cat.LastName = item.LastName;
cat.BirthDate = item.BirthDate;
cat.DepartmentID = item.DepartmentID;
cat.FatherName = item.FatherName;
cat.MotherName = item.MotherName;
cat.PresentAddress = item.PresentAddress;
cat.PermanentAddress = item.PermanentAddress;
cat.Phone = item.Phone;
cat.Email = item.Email;
cat.Sex = item.Sex;
cat.Nationality = item.Nationality;
cat.Religion = item.Religion;
cat.MaritalStatus = item.MaritalStatus;
cat.BloodGroup = item.BloodGroup;
cat.AdmissionDate = item.AdmissionDate;
cat.GraduationDate = item.GraduationDate;
cat.PerSemesterRecordID = item.PerSemesterRecordID;
cat.DocumentsGiven = item.DocumentsGiven;
cat.Password = item.Password;
cat.Picture = item.Picture;
cat.Type = item.Type;
Tbl_Accounts1 ac = new Tbl_Accounts1();
ac.UserID = pre.StudentID;
ac.Password = item.Password;
ac.Type = item.Type;
context.Tbl_Student.Add(cat);
context.Tbl_Accounts1.Add(ac);
context.Tbl_PreStudent.Remove(item);
context.SaveChanges();
return(Created(Url.Link("GetStudentById", new { id = cat.StudentID }), cat));
}
public ActionResult ConfirmStudent(int id, Tbl_Student tbl, Tbl_PreStudent tbl1, Tbl_Accounts1 tbl2)
{
Tbl_PreStudent k = _unitOfWork.GetRepositoryInstance <Tbl_PreStudent>().GetAllRecordsIQueryable().Where(x => x.ConfrimID == id).FirstOrDefault();
tbl.StudentID = k.StudentID;
tbl.FatherName = k.FatherName;
tbl.FirstName = k.FirstName;
tbl.LastName = k.LastName;
tbl.MotherName = k.MotherName;
tbl.GraduationDate = k.GraduationDate;
tbl.MaritalStatus = k.MaritalStatus;
tbl.Nationality = k.Nationality;
tbl.Password = k.Password;
tbl.PresentAddress = k.PresentAddress;
tbl.PermanentAddress = k.PermanentAddress;
tbl.Phone = k.Phone;
tbl.Picture = k.Picture;
tbl.Religion = k.Religion;
tbl.Sex = k.Sex;
tbl.Email = k.Email;
tbl.DocumentsGiven = k.DocumentsGiven;
tbl.DepartmentID = k.DepartmentID;
tbl.BloodGroup = k.BloodGroup;
tbl.BirthDate = k.BirthDate;
tbl.Type = k.Type;
tbl.AdmissionDate = k.AdmissionDate;
tbl.PerSemesterRecordID = k.PerSemesterRecordID;
_unitOfWork.GetRepositoryInstance <Tbl_Student>().Add(tbl);
_unitOfWork.GetRepositoryInstance <Tbl_PreStudent>().Remove(k);
tbl2.Status = "Active";
tbl2.Password = tbl.Password;
tbl2.Type = tbl.Type;
tbl2.UserID = tbl.StudentID;
_unitOfWork.GetRepositoryInstance <Tbl_Accounts1>().Add(tbl2);
return(RedirectToAction("StudentRegistrationConfirm"));
}
public IHttpActionResult Put([FromUri] string id, [FromBody] Tbl_Student item)
{
var cat = context.Tbl_Student.Where(p => p.StudentID == id).FirstOrDefault();
if (cat == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
cat.SerialID = item.SerialID;
cat.StudentID = item.StudentID;
cat.FirstName = item.FirstName;
cat.LastName = item.LastName;
cat.BirthDate = item.BirthDate;
cat.DepartmentID = item.DepartmentID;
cat.FatherName = item.FatherName;
cat.MotherName = item.MotherName;
cat.PresentAddress = item.PresentAddress;
cat.PermanentAddress = item.PermanentAddress;
cat.Phone = item.Phone;
cat.Email = item.Email;
cat.Sex = item.Sex;
cat.Nationality = item.Nationality;
cat.Religion = item.Religion;
cat.MaritalStatus = item.MaritalStatus;
cat.BloodGroup = item.BloodGroup;
cat.AdmissionDate = item.AdmissionDate;
cat.GraduationDate = item.GraduationDate;
cat.PerSemesterRecordID = item.PerSemesterRecordID;
cat.DocumentsGiven = item.DocumentsGiven;
cat.Password = item.Password;
cat.Picture = item.Picture;
cat.Type = item.Type;
return(Ok(item));
}
}
