protected void RegisterButton_Click(object sender, EventArgs e)
{
try
{
StudentRegister _StudentRegister = new StudentRegister();
_StudentRegister.EnrollId = txtEnrollId.Text;
decimal AlreadyRegister = _StudentRegisterManager.AlreadyRegister(_StudentRegister);
if (AlreadyRegister >= 1)
{
ShowMessage("You Are Already Registered", MessageType.Warning);
}
else
{
_StudentRegister.Email = txtemail.Text;
_StudentRegister.Password = txtpassword.Text;
int successRegister = _StudentRegisterManager.Register(_StudentRegister);
if (successRegister > 0)
{
txtEnrollId.Text = "";
txtemail.Text = "";
ShowMessage("Welcome!!..Complete Your Registration...Now Login", MessageType.Success);
}
else
{
ShowMessage("Failed Your Registration", MessageType.Failed);
}
}
}
catch (Exception ex)
{
ShowMessage("Catch : " + ex.Message, MessageType.Error);
}
}
public StudentRegister GenerateRegNumber(StudentRegister studentRegister)
{
string departmentCode = _departmentGateway.GetDepartmentCodeById(studentRegister.DepartmentId);
string symbol = "-";
string year = studentRegister.RegDate.ToString("yyyy");
int yearCount = 0;
List <StudentRegister> studentRegisters = GetStudentsByDeptId(studentRegister.DepartmentId);
int count = studentRegisters.Count;
if (count != 0)
{
foreach (StudentRegister register in studentRegisters)
{
string regYear = register.RegDate.ToString("yyyy");
if (regYear == year)
{
yearCount++;
}
}
}
yearCount++;
string regNumber = departmentCode + symbol + year + symbol +
yearCount.ToString().PadLeft(3, '0');
studentRegister.RegNumber = regNumber;
return(studentRegister);
}
public List <StudentRegister> GetStudentsByDeptId(int departmentId)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "select * from StudentsRegister where DeptID='" + departmentId + "' ";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <StudentRegister> studenList = new List <StudentRegister>();
while (reader.Read())
{
StudentRegister student = new StudentRegister();
//student.StudentName = reader["StudentName"].ToString();
//student.StudentEmail = reader["StudentEmail"].ToString();
student.RegDate = (DateTime)reader["RegDate"];
student.RegNumber = reader["RegNumber"].ToString();
studenList.Add(student);
}
reader.Close();
connection.Close();
return(studenList);
}
public List <StudentRegister> GetAllStudents()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "select * from StudentsRegister ";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <StudentRegister> studenList = new List <StudentRegister>();
while (reader.Read())
{
StudentRegister student = new StudentRegister();
//student.StudentName = reader["StudentName"].ToString();
//student.StudentEmail = reader["StudentEmail"].ToString();
student.StudentId = (int)reader["Id"];
student.RegNumber = reader["RegNumber"].ToString();
studenList.Add(student);
}
reader.Close();
connection.Close();
return(studenList);
}
public async Task <IActionResult> GetStudentDetails()
{
var StudentRegister = new StudentRegister
{
Age = 123,
Place = "qwertyuiop",
StudentName = "abc"
};
try
{
using (HttpClient client = new HttpClient())
{
string url = $"https://localhost:44352/api/Test/StudentDetails";
StringContent stringContent = new StringContent(GetXMLFromObject(StudentRegister), Encoding.UTF8, "application/xml");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/xml"));
var response = await client.PostAsync(url, stringContent);
var responseBody = await response.Content.ReadAsStringAsync();
StudentRegister = JsonConvert.DeserializeObject <StudentRegister>(responseBody);
}
}
catch (Exception ex)
{
}
return(Ok(StudentRegister));
}
public Students Post([FromBody] Students student)
{
IStudentRegister studentRegister = new StudentRegister(conn);
var studentNew = studentRegister.Register(student);
return(studentNew);
}
public IActionResult AddNewCourse(int id)
{
StudentRegister sr = new StudentRegister();
sr.student = StudentBusiness.GetByID(id);
sr.UnRegisteredCourses = studentRegisterBusiness.getUnRegisteredCourses(id);
return(View(sr));
}
public ActionResult RegisterStudent()
{
var departmentList = _departmentManager.GetAllDepartments();
ViewBag.Department = new SelectList(departmentList, "DepartmentId", "DepartmentName");
StudentRegister student = new StudentRegister();
student.RegDate = DateTime.Today;
return(View(student));
}
public IActionResult StudentDetails([FromBody] StudentRegister request)
{
var resp = new Student
{
StudentId = 1,
StudentName = "Abcd"
};
return(Ok(resp));
}
public void TestStudentPass()
{
//Arrange
StudentRegister check = new StudentRegister();
// Act
bool x = check.StudentPass("AbcdefghiI20158");
//Assert
Assert.IsTrue(x);
}
public void TestStudentusername()
{
//Arrange
StudentRegister check = new StudentRegister();
// Act
bool x = check.StudentUsername("Ibrahem1998");
//Assert
Assert.IsTrue(x);
}
public void TestStudentIdentity()
{
//Arrange
StudentRegister check = new StudentRegister();
// Act
bool x = check.StudentId("20715421");
//Assert
Assert.IsFalse(x);
}
public int InsertStudent(StudentRegister student)
{
if (IsEmailExist(student))
{
GenerateRegNumber(student);
student.DepartmentName = _departmentGateway.GetDepartmentNameById(student.DepartmentId);
return(_studentRegisterGateway.InsretStudent(student));
}
return(0);
}
protected void LoginButton_Click(object sender, EventArgs e)
{
try
{
StudentRegister _StudentRegister = new StudentRegister();
_StudentRegister.EnrollId = txtEnrollId.Text;
_StudentRegister.Password = txtpassword.Text;
decimal successLogin = _StudentRegisterManager.Login(_StudentRegister);
if (successLogin >= 1)
{
decimal checkingStatus = _StudentRegisterManager.CheckStatus(_StudentRegister);
if (checkingStatus >= 1)
{
if (RememeberCheckBox.Checked)
{
Response.Cookies["EnrollId"].Value = _StudentRegister.EnrollId;
Response.Cookies["Password"].Value = _StudentRegister.Password;
Response.Cookies["EnrollId"].Expires = DateTime.Now.AddDays(15);
Response.Cookies["Password"].Expires = DateTime.Now.AddDays(15);
Session["EnrollId"] = _StudentRegister.EnrollId;
ShowMessage("Login", MessageType.Success);
//Response.Redirect("~/Librarian/Books/Add");
}
else
{
Response.Cookies["EnrollId"].Expires = DateTime.Now.AddDays(-1);
Response.Cookies["Password"].Expires = DateTime.Now.AddDays(-1);
Session["EnrollId"] = _StudentRegister.EnrollId;
ShowMessage("কফ", MessageType.Success);
}
}
else
{
ShowMessage("Sorry!!...Your Account Still Pending....", MessageType.Failed);
}
}
else
{
ShowMessage("Login", MessageType.Failed);
}
}
catch (Exception ex)
{
ShowMessage("Catch : " + ex.Message, MessageType.Error);
}
}
public int InsretStudent(StudentRegister student)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO StudentsRegister VALUES('" + student.StudentName + "','" + student.StudentEmail + "','" + student.StudentContact + "','" + student.StudentAddress + "','" + student.RegDate.ToString("yyyy-MM-dd") + "','" + student.DepartmentId + "','" + student.RegNumber + "')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public void Insert(StudentRegisterViewModel model)
{
if (model == null)
{
throw new ArgumentNullException("StudentRegister");
}
StudentRegister studentRegister = new StudentRegister
{
RegNo = model.RegNo,
Name = model.Name,
Email = model.Email,
Mobile = model.Mobile,
Address = model.Address,
DepartmentId = model.DepartmentId,
CreatedAt = model.CreatedAt,
ModifiedAt = null
};
entities.Add(studentRegister);
_context.SaveChanges();
}
public bool IsEmailExist(StudentRegister student)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM StudentsRegister WHERE StudentEmail = '" + student.StudentEmail + "' ";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Close();
connection.Close();
return(false);
}
reader.Close();
connection.Close();
return(true);
}
public ActionResult RegisterStudent(StudentRegister studentRegister)
{
var departmentList = _departmentManager.GetAllDepartments();
ViewBag.Department = new SelectList(departmentList, "DepartmentId", "DepartmentName");
int rowAffected = _studentRegisterManager.InsertStudent(studentRegister);
ViewBag.StudentInfo = studentRegister;
if (ModelState.IsValid)
{
if (rowAffected > 0)
{
ViewBag.ValidationMsg = "Successfull.";
ModelState.Clear();
StudentRegister student = new StudentRegister();
student.RegDate = DateTime.Today;
return(View(student));
}
}
ViewBag.ValidationMsg = "This email already exist.Try a unique one.";
return(View(studentRegister));
}
public IActionResult Create([Bind("Student_ID,Student_Email,Student_FirstName,Student_LastName,Student_UniversityNumber,Student_ContactNumber,Student_Password,confirmPassword,University_Name,Campus_Name")] StudentRegister uc)
{
DBStudent cur = new DBStudent();
cur.Student_ID = uc.Student_ID;
cur.Student_FirstName = uc.Student_FirstName;
cur.Student_LastName = uc.Student_LastName;
cur.Student_Password = uc.Student_Password;
cur.Student_UniversityNumber = uc.Student_UniversityNumber;
cur.Student_Email = uc.Student_Email;
cur.Campus_ID = 1;
cur.Student_ContactNumber = uc.Student_ContactNumber;
try
{
_auc.Add(cur);
_auc.SaveChanges();
ViewBag.message = "You have successfully registered";
return(View());
}
catch (Exception e)
{
return(Index());
}
}
public decimal CheckStatus(StudentRegister _StudentRegister)
{
return(_StudentRegisterRepository.AlreadyRegister(_StudentRegister));
}
public decimal AlreadyRegister(StudentRegister _StudentRegister)
{
string query = "Select Count(*)from StudentRegister where EnrollId='" + _StudentRegister.EnrollId + "' ";
return(_MainRepository.ExecuteScalar(query, _MainRepository.ConnectionString()));
}
public decimal Login(StudentRegister _StudentRegister)
{
return(_StudentRegisterRepository.Login(_StudentRegister));
}
public int Register(StudentRegister _StudentRegister)
{
return(_StudentRegisterRepository.Register(_StudentRegister));
}
public bool IsEmailExist(StudentRegister student)
{
return(_studentRegisterGateway.IsEmailExist(student));
}
public JsonResult StudentRegister(StudentRegister stdModel)
{
var result = false;
var isEmailExists = false;
try
{
var containsEmail = db.OnlineUsers.Where(x => x.UserName == stdModel.Email).FirstOrDefault();
if (containsEmail != null)
{
isEmailExists = true;
return(Json(new { success = result, emailExists = isEmailExists }, JsonRequestBehavior.AllowGet));
}
else
{
int?maxLoginId = db.OnlineUsers.Max(x => x.LoginID);
int userRollId = db.UserRoles.Where(x => x.Code == "Student").Select(x => x.ID).SingleOrDefault();
if (maxLoginId == null)
{
maxLoginId = 0;
}
tblOnlineStudentMaster std = new tblOnlineStudentMaster();
std.StudentFirstName = stdModel.FirstName;
std.StudentLastName = stdModel.LastName;
std.AddressLine1 = stdModel.Address;
std.ContactNo1 = stdModel.MobileNo;
std.Email = stdModel.Email;
//std.LoginID = maxLoginId + 1;
std.District = stdModel.District;
std.PurchasedPaperCount = 0;
db.tblOnlineStudentMasters.Add(std);
OnlineUser user = new OnlineUser();
//user.LoginID = maxLoginId + 1;
user.UserName = stdModel.Email;
user.Password = stdModel.Password;
user.IsVerified = false;
user.VerificationCode = GetVerificationCode();
user.UserRoleId = userRollId;
user.ProfileCompletionPercentage = 50;
user.CreatedDate = DateTime.Now;
db.OnlineUsers.Add(user);
db.SaveChanges();
std.LoginID = (int)user.ID;
user.LoginID = (int)user.ID;
db.SaveChanges();
SendVerificationCode(stdModel.Email, user.VerificationCode);
result = true;
//var checkEmail = db.OnlineUsers.Where(x => x.UserName == stdModel.Email).FirstOrDefault();
//if (checkEmail == null)
//{
// return Json(new { success = result, message = "Email not exists" }, JsonRequestBehavior.AllowGet);
//}
//else
//{
// string emailPort = ConfigurationManager.AppSettings["EmailPort"]; ;
// string verifyCode = user.VerificationCode;
// var body = "<p>Email From: Disapamock</p><p>Message: Your verification code is : " + verifyCode + "</p>";
// var message = new MailMessage();
// message.To.Add(new MailAddress(stdModel.Email)); // replace with valid value
// message.From = new MailAddress("*****@*****.**"); // replace with valid value
// message.Subject = "Verify Account";
// message.Body = string.Format(body, "Disapamock", stdModel.Email, "Your code is : 000111");
// message.IsBodyHtml = true;
// using (var smtp = new SmtpClient())
// {
// var credential = new NetworkCredential
// {
// UserName = "******", // replace with valid value
// Password = "******" // replace with valid value
// };
// smtp.Credentials = credential;
// smtp.Host = "smtp.gmail.com";
// smtp.Port = Convert.ToInt32(emailPort);
// smtp.EnableSsl = true;
// smtp.Send(message);
// result = true;
// //return RedirectToAction("Sent");
// }
// return Json(new { success = result }, JsonRequestBehavior.AllowGet);
//}
return(Json(new { success = result, emailExists = isEmailExists, loginId = user.LoginID, email = stdModel.Email }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = result, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public decimal CheckStatus(StudentRegister _StudentRegister)
{
string query = "Select Count(*)from StudentRegister where EnrollId='" + _StudentRegister.EnrollId + "' And Password='******' And Status='Running' ";
return(_MainRepository.ExecuteScalar(query, _MainRepository.ConnectionString()));
}
private void GeneratePdf(int studentId)
{
//try
//{
Document pdfDoc = new Document(PageSize.A4, 25, 10, 25, 10);
string title = "ABC UNIVERSITY";
string subTitle = "Grade Sheet";
int columnNo = 3;
PdfPTable tableLayout = new PdfPTable(columnNo);
tableLayout.HorizontalAlignment = 1;
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
Font fTitle = new Font(Font.FontFamily.HELVETICA, 50.0f, Font.NORMAL, BaseColor.BLACK);
Font fSub = new Font(Font.FontFamily.TIMES_ROMAN, 35.0f, Font.UNDERLINE, BaseColor.BLACK);
Paragraph para = new Paragraph(title, fTitle);
para.Alignment = Element.ALIGN_CENTER;
pdfDoc.Add(para);
pdfDoc.Add(new Paragraph(" "));
Paragraph paraSub = new Paragraph(subTitle, fSub);
paraSub.Alignment = Element.ALIGN_CENTER;
pdfDoc.Add(paraSub);
pdfDoc.Add(new Paragraph(" \n\n"));
pdfDoc.Add(new Paragraph(" \n\n"));
StudentEnroll student = _studentEnrollManager.GetStudentByStudentId(studentId);
student.DepartmentName = _departmentManager.GetDepartmentNameById(student.DepartmentId);
var studentList = _studentRegisterManager.GetAllStudents();
StudentRegister aStudent = studentList.Where(a => a.StudentId == studentId).FirstOrDefault();
//string name = student.StudentName;
Font infoFont = new Font(Font.FontFamily.TIMES_ROMAN, 15.0f, Font.ITALIC, BaseColor.BLACK);
//Paragraph nameParagraph = new Paragraph("Student Name: " + name, infoFont);
pdfDoc.Add(new Paragraph("Student Name: " + student.StudentName, infoFont));
pdfDoc.Add(new Paragraph("Reg. Number: " + aStudent.RegNumber, infoFont));
pdfDoc.Add(new Paragraph("Department: " + student.DepartmentName, infoFont));
pdfDoc.Add(new Paragraph("Email: " + student.StudentEmail, infoFont));
pdfDoc.Add(new Paragraph(" \n\n"));
pdfDoc.Add(new Paragraph(" \n\n"));
//pdfDoc.Add(tableLayout);
pdfDoc.Add(Add_Content_To_PDF(tableLayout, studentId));
pdfDoc.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=GradeSheet.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Write(pdfDoc);
Response.End();
//}
//catch (Exception ex)
//{
// Response.Write(ex.Message);
//}
}
public int Register(StudentRegister _StudentRegister)
{
string query = "Insert Into StudentRegister(EnrollId,Email,Password,Status) Values ('" + _StudentRegister.EnrollId + "','" + _StudentRegister.Email + "','" + _StudentRegister.Password + "','Pending')";
return(_MainRepository.ExecuteNonQuery(query, _MainRepository.ConnectionString()));
}
