public ActionResult _ForgotPasswordFor([Bind(Include = "Email")] ForgotPasswordModel forgotpassword)
{
Session["err"] = "Error, Please Check Input Fields";
Session["msg"] = "";
if (ModelState.IsValid)
{
User superadminuser = db.Users.Find(1);
User user = db.Users.Where(u => u.Email == forgotpassword.Email).FirstOrDefault();
if (user == null)
{
Session["err"] = "Email is not available";
Session["msg"] = "";
}
else
{
try
{
string To = forgotpassword.Email, WebsiteUrl, Ssl, UserID, Password, SMTPPort, Host;
CommanFunctions.AppSettings(out WebsiteUrl, out Ssl, out UserID, out Password, out SMTPPort, out Host);
string subject = "Reset Password";
string body = "Hi,";
body += "<br/> Your password is : " + user.Password;
body += "<br/> <br/> ----------------------";
body += "<br/> Admin";
body += "<br/> <a href=" + WebsiteUrl + ">" + WebsiteUrl + "</a>";
CommanFunctions.SendEmail(UserID, subject, body, superadminuser.Email, To, Ssl, UserID, Password, SMTPPort, Host);
Session["err"] = "";
Session["msg"] = "Password was sent to your Email";
}
catch {
Session["err"] = "Email sending failed, please check smtp configuration.";
}
}
return(RedirectToAction("Login"));
}
return(Json(Session["err"], JsonRequestBehavior.AllowGet));
}
public ActionResult Edit([Bind(Include = "EmployeeID,Name,IdCard,HouseNo,BuildingName,Street,Area,Location,CityID,CountryID,PinCode,Landline,Mobile,Photo,SchoolID,UserID,LeavesToAvail,Salary,Status,Email,Password")] EmployeeModel employeemodel, HttpPostedFileBase uploadlogo, string newlogo, string existingemail)
{
errordata data = new errordata();
data.type = "error";
Session["err"] = "Error, Please Check Input Fields";
Session["msg"] = "";
try
{
if (ModelState.IsValid)
{
if (employeemodel.Email != existingemail)
{
User employeeold = db.Users.Where(s => s.Email == employeemodel.Email).FirstOrDefault();
if (employeeold != null)
{
Session["err"] = "Email already exists";
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
if (newlogo != "")
{
employeemodel.Photo = newlogo;
}
User superadminuser = db.Users.Find(1);
User user = db.Users.Find(employeemodel.UserID);
user.Email = employeemodel.Email;
user.Password = employeemodel.Password;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
Employee employee = db.Employees.Find(employeemodel.EmployeeID);
employee.Name = employeemodel.Name;
employee.IdCard = employeemodel.IdCard;
employee.HouseNo = employeemodel.HouseNo;
employee.BuildingName = employeemodel.BuildingName;
employee.Street = employeemodel.Street;
employee.Area = employeemodel.Area;
employee.Location = employeemodel.Location;
employee.CityID = employeemodel.CityID;
employee.CountryID = employeemodel.CountryID;
employee.PinCode = employeemodel.PinCode;
employee.Landline = employeemodel.Landline;
employee.Mobile = employeemodel.Mobile;
employee.Photo = employeemodel.Photo;
employee.SchoolID = employeemodel.SchoolID;
employee.UserID = employeemodel.UserID;
employee.LeavesToAvail = employeemodel.LeavesToAvail;
employee.Salary = employeemodel.Salary;
employee.Status = employeemodel.Status;
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
string To = employeemodel.Email, WebsiteUrl, Ssl, UserID, Password, SMTPPort, Host;
CommanFunctions.AppSettings(out WebsiteUrl, out Ssl, out UserID, out Password, out SMTPPort, out Host);
string subject = "Employee Modified";
string body = "Hi,";
body += "<br/> Employee was modified. Please login using these credentials, and update employee profile. <br/> Login email : " + employeemodel.Email;
body += "<br/> Login password : "******"<br/> <br/> ----------------------";
body += "<br/> Admin";
body += "<br/> <a href=" + WebsiteUrl + ">" + WebsiteUrl + "</a>";
try { CommanFunctions.SendEmail(UserID, subject, body, superadminuser.Email, To, Ssl, UserID, Password, SMTPPort, Host); }
catch
{
//Session["err"] = "Email sending failed, please check smtp configuration.";
//data.message = Session["err"].ToString();
//return Json(data, JsonRequestBehavior.AllowGet);
}
Session["err"] = "";
Session["msg"] = "Modified Successfully";
}
}
catch {
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
data.message = "/Employee/Index";
data.type = "success";
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult Create([Bind(Include = "EmployeeID,Name,IdCard,HouseNo,BuildingName,Street,Area,Location,CityID,CountryID,PinCode,Landline,Mobile,Photo,SchoolID,UserID,LeavesToAvail,Salary,Status,Email,Password")] EmployeeModel employeemodel, HttpPostedFileBase uploadlogo, string newlogo)
{
errordata data = new errordata();
data.type = "error";
Session["err"] = "Error, Please Check Input Fields";
Session["msg"] = "";
if (employeemodel.Salary <= 0)
{
Session["err"] = "Salary required";
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
if (employeemodel.Name != null)
{
try
{
User employeeold = db.Users.Where(s => s.Email == employeemodel.Email).FirstOrDefault();
if (employeeold != null)
{
Session["err"] = "Email already exists";
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
else
{
if (newlogo != "")
{
employeemodel.Photo = newlogo;
}
User superadminuser = db.Users.Find(1);
User user = new User();
user.Email = employeemodel.Email;
user.Password = employeemodel.Password;
user.CanCreate = false;
user.CanEdit = false;
user.CanDelete = false;
user.CanPrint = false;
user.Status = false;
user.CreatedOn = DateTime.Now;
user.LastLoggedOn = null;
db.Users.Add(user);
db.SaveChanges();
Role role = db.Roles.Where(r => r.Name == "Employee").FirstOrDefault();
UserRole userroles = new UserRole();
userroles.UserID = user.UserID;
userroles.RoleID = role.RoleID;
db.UserRoles.Add(userroles);
db.SaveChanges();
Employee employee = new Employee();
employee.Name = employeemodel.Name;
employee.IdCard = employeemodel.IdCard;
employee.HouseNo = employeemodel.HouseNo;
employee.BuildingName = employeemodel.BuildingName;
employee.Street = employeemodel.Street;
employee.Area = employeemodel.Area;
employee.Location = employeemodel.Location;
employee.CityID = employeemodel.CityID;
employee.CountryID = employeemodel.CountryID;
employee.PinCode = employeemodel.PinCode;
employee.Landline = employeemodel.Landline;
employee.Mobile = employeemodel.Mobile;
employee.Photo = employeemodel.Photo;
employee.SchoolID = employeemodel.SchoolID;
employee.UserID = user.UserID;
employee.LeavesToAvail = employeemodel.LeavesToAvail;
employee.Salary = employeemodel.Salary;
employee.Status = employeemodel.Status;
db.Employees.Add(employee);
db.SaveChanges();
int schoolid = Convert.ToInt16(Session["SchoolID"].ToString());
School school = db.Schools.Find(schoolid);
employee.IdCard = "" + school.ShortName.ToUpper() + "TEA" + employee.EmployeeID.ToString("D" + 6);
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
user.Status = true;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
string To = employeemodel.Email, WebsiteUrl, Ssl, UserID, Password, SMTPPort, Host;
CommanFunctions.AppSettings(out WebsiteUrl, out Ssl, out UserID, out Password, out SMTPPort, out Host);
string subject = "New Employee Created";
string body = "Hi,";
body += "<br/> Employee was created. Please login using these credentials, and update employee profile. <br/> Login email : " + employeemodel.Email;
body += "<br/> Login password : "******"<br/> <br/> ----------------------";
body += "<br/> Admin";
body += "<br/> <a href=" + WebsiteUrl + ">" + WebsiteUrl + "</a>";
try { CommanFunctions.SendEmail(UserID, subject, body, superadminuser.Email, To, Ssl, UserID, Password, SMTPPort, Host); }
catch {
//Session["err"] = "Email sending failed, please check smtp configuration.";
//data.message = Session["err"].ToString();
//return Json(data, JsonRequestBehavior.AllowGet);
}
Session["err"] = "";
Session["msg"] = "Created Successfully";
}
}
catch
{
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
data.message = "/Employee/Index";
data.type = "success";
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit([Bind(Include = "StudentID,Name,IdCard,Dob,Mobile,ClassID,SectionID,GuardianName,GuardianMobile,GuardianEmail,Parent2Name,Parent2Mobile,Parent2Email,Photo,SchoolID,ParentID,UserID,Status,Fee,FeeInstalments,Email,Password")] StudentModel studentmodel, HttpPostedFileBase uploadlogo, string newlogo, string existingemail)
{
errordata data = new errordata();
data.type = "error";
Session["err"] = "Error, Please Check Input Fields";
Session["msg"] = "";
try
{
if (studentmodel.Email != "")
{
if (studentmodel.Email != existingemail)
{
User studentold = db.Users.Where(s => s.Email == studentmodel.Email).FirstOrDefault();
if (studentold != null)
{
Session["err"] = "Email already exists";
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
if (newlogo != "")
{
studentmodel.Photo = newlogo;
}
User superadminuser = db.Users.Find(1);
User user = db.Users.Find(studentmodel.UserID);
user.Email = studentmodel.Email;
user.Password = studentmodel.Password;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
Student student = db.Students.Find(studentmodel.StudentID);
student.Name = studentmodel.Name;
student.Dob = studentmodel.Dob;
student.Mobile = studentmodel.Mobile;
student.IdCard = studentmodel.IdCard;
student.ClassID = studentmodel.ClassID;
student.SectionID = studentmodel.SectionID;
student.Photo = studentmodel.Photo;
student.SchoolID = studentmodel.SchoolID;
student.ParentID = studentmodel.ParentID;
student.UserID = studentmodel.UserID;
student.Fee = studentmodel.Fee;
student.FeeInstalments = studentmodel.FeeInstalments;
student.Status = studentmodel.Status;
student.GuardianName = studentmodel.GuardianName;
student.GuardianMobile = studentmodel.GuardianMobile;
student.GuardianEmail = studentmodel.GuardianEmail;
student.Parent2Name = studentmodel.Parent2Name;
student.Parent2Mobile = studentmodel.Parent2Mobile;
student.Parent2Email = studentmodel.Parent2Email;
db.Entry(student).State = EntityState.Modified;
db.SaveChanges();
string To = studentmodel.Email, WebsiteUrl, Ssl, UserID, Password, SMTPPort, Host;
CommanFunctions.AppSettings(out WebsiteUrl, out Ssl, out UserID, out Password, out SMTPPort, out Host);
string subject = "Student Modified";
string body = "Hi,";
body += "<br/> Student was modified. Please login using these credentials, and update student profile. <br/> Login email : " + studentmodel.Email;
body += "<br/> Login password : "******"<br/> <br/> ----------------------";
body += "<br/> Admin";
body += "<br/> <a href=" + WebsiteUrl + ">" + WebsiteUrl + "</a>";
try { CommanFunctions.SendEmail(UserID, subject, body, superadminuser.Email, To, Ssl, UserID, Password, SMTPPort, Host); }
catch
{
//Session["err"] = "Email sending failed, please check smtp configuration.";
//data.message = Session["err"].ToString();
//return Json(data, JsonRequestBehavior.AllowGet);
}
Session["err"] = "";
Session["msg"] = "Modified Successfully";
}
}
catch {
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
data.message = "/Student/Index";
data.type = "success";
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult Create([Bind(Include = "StudentID,Name,IdCard,Dob,Mobile,ClassID,SectionID,GuardianName,GuardianMobile,GuardianEmail,Parent2Name,Parent2Mobile,Parent2Email,Photo,SchoolID,ParentID,UserID,Fee,FeeInstalments,Status,Email,Password")] StudentModel studentmodel, HttpPostedFileBase uploadlogo, string newlogo)
{
errordata data = new errordata();
data.type = "error";
Session["err"] = "Error, Please Check Input Fields";
Session["msg"] = "";
if (studentmodel.Fee <= 0)
{
Session["err"] = "Fee required";
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
if (studentmodel.Name != null)
{
try
{
User studentold = db.Users.Where(s => s.Email == studentmodel.Email).FirstOrDefault();
if (studentold != null)
{
Session["err"] = "Email already exists";
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
else
{
if (newlogo != "")
{
studentmodel.Photo = newlogo;
}
User superadminuser = db.Users.Find(1);
User user = new User();
user.Email = studentmodel.Email;
user.Password = studentmodel.Password;
user.CanCreate = false;
user.CanEdit = false;
user.CanDelete = false;
user.CanPrint = false;
user.Status = false;
user.CreatedOn = DateTime.Now;
user.LastLoggedOn = null;
db.Users.Add(user);
db.SaveChanges();
Role role = db.Roles.Where(r => r.Name == "Student").FirstOrDefault();
UserRole userroles = new UserRole();
userroles.UserID = user.UserID;
userroles.RoleID = role.RoleID;
db.UserRoles.Add(userroles);
db.SaveChanges();
Student student = new Student();
student.Name = studentmodel.Name;
student.IdCard = studentmodel.IdCard;
student.Dob = studentmodel.Dob;
student.Mobile = studentmodel.Mobile;
student.ClassID = studentmodel.ClassID;
student.SectionID = studentmodel.SectionID;
student.Photo = studentmodel.Photo;
student.SchoolID = studentmodel.SchoolID;
student.ParentID = studentmodel.ParentID;
student.UserID = user.UserID;
student.Fee = studentmodel.Fee;
student.FeeInstalments = studentmodel.FeeInstalments;
student.Status = studentmodel.Status;
student.GuardianName = studentmodel.GuardianName;
student.GuardianMobile = studentmodel.GuardianMobile;
student.GuardianEmail = studentmodel.GuardianEmail;
student.Parent2Name = studentmodel.Parent2Name;
student.Parent2Mobile = studentmodel.Parent2Mobile;
student.Parent2Email = studentmodel.Parent2Email;
db.Students.Add(student);
db.SaveChanges();
int schoolid = Convert.ToInt16(Session["SchoolID"].ToString());
School school = db.Schools.Find(schoolid);
student.IdCard = "" + school.ShortName.ToUpper() + "STU" + student.StudentID.ToString("D" + 6);
db.Entry(student).State = EntityState.Modified;
db.SaveChanges();
user.Status = true;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
string To = studentmodel.Email, WebsiteUrl, Ssl, UserID, Password, SMTPPort, Host;
CommanFunctions.AppSettings(out WebsiteUrl, out Ssl, out UserID, out Password, out SMTPPort, out Host);
string subject = "New Student Created";
string body = "Hi,";
body += "<br/> Student was created. Please login using these credentials, and update student profile. <br/> Login email : " + studentmodel.Email;
body += "<br/> Login password : "******"<br/> <br/> ----------------------";
body += "<br/> Admin";
body += "<br/> <a href=" + WebsiteUrl + ">" + WebsiteUrl + "</a>";
try { CommanFunctions.SendEmail(UserID, subject, body, superadminuser.Email, To, Ssl, UserID, Password, SMTPPort, Host); }
catch {
//Session["err"] = "Email sending failed, please check smtp configuration.";
//data.message = Session["err"].ToString();
//return Json(data, JsonRequestBehavior.AllowGet);
}
Session["err"] = "";
Session["msg"] = "Created Successfully";
}
}
catch
{
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
data.message = "/Student/Index";
data.type = "success";
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult Create([Bind(Include = "ParentID,Name,HouseNo,BuildingName,Street,Area,Location,CityID,CountryID,PinCode,Landline,Mobile,Photo,SchoolID,UserID,Status,Email,Password")] ParentModel parentmodel, HttpPostedFileBase uploadlogo, string newlogo)
{
errordata data = new errordata();
data.type = "error";
Session["err"] = "Error, Please Check Input Fields";
Session["msg"] = "";
if (parentmodel.Name != null)
{
try
{
User parentold = db.Users.Where(s => s.Email == parentmodel.Email).FirstOrDefault();
if (parentold != null)
{
Session["err"] = "Email already exists";
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
else
{
if (newlogo != "")
{
parentmodel.Photo = newlogo;
}
User superadminuser = db.Users.Find(1);
User user = new User();
user.Email = parentmodel.Email;
user.Password = parentmodel.Password;
user.CanCreate = false;
user.CanEdit = false;
user.CanDelete = false;
user.CanPrint = false;
user.Status = false;
user.CreatedOn = DateTime.Now;
user.LastLoggedOn = null;
db.Users.Add(user);
db.SaveChanges();
Role role = db.Roles.Where(r => r.Name == "Parent").FirstOrDefault();
UserRole userroles = new UserRole();
userroles.UserID = user.UserID;
userroles.RoleID = role.RoleID;
db.UserRoles.Add(userroles);
db.SaveChanges();
Parent parent = new Parent();
parent.Name = parentmodel.Name;
parent.HouseNo = parentmodel.HouseNo;
parent.BuildingName = parentmodel.BuildingName;
parent.Street = parentmodel.Street;
parent.Area = parentmodel.Area;
parent.Location = parentmodel.Location;
parent.CityID = parentmodel.CityID;
parent.CountryID = parentmodel.CountryID;
parent.PinCode = parentmodel.PinCode;
parent.Landline = parentmodel.Landline;
parent.Mobile = parentmodel.Mobile;
parent.Photo = parentmodel.Photo;
parent.SchoolID = parentmodel.SchoolID;
parent.UserID = user.UserID;
parent.Status = parentmodel.Status;
db.Parents.Add(parent);
db.SaveChanges();
user.Status = true;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
string To = parentmodel.Email, WebsiteUrl, Ssl, UserID, Password, SMTPPort, Host;
CommanFunctions.AppSettings(out WebsiteUrl, out Ssl, out UserID, out Password, out SMTPPort, out Host);
string subject = "New Parent Created";
string body = "Hi,";
body += "<br/> Parent was created. Please login using these credentials, and update parent profile. <br/> Login email : " + parentmodel.Email;
body += "<br/> Login password : "******"<br/> <br/> ----------------------";
body += "<br/> Admin";
body += "<br/> <a href=" + WebsiteUrl + ">" + WebsiteUrl + "</a>";
try { CommanFunctions.SendEmail(UserID, subject, body, superadminuser.Email, To, Ssl, UserID, Password, SMTPPort, Host); }
catch {
//Session["err"] = "Email sending failed, please check smtp configuration.";
//data.message = Session["err"].ToString();
//return Json(data, JsonRequestBehavior.AllowGet);
}
Session["err"] = "";
Session["msg"] = "Created Successfully";
}
}
catch {
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
data.message = "/Parent/Index";
data.type = "success";
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit([Bind(Include = "SchoolID,Name,ShortName,HouseNo,BuildingName,Street,Area,Location,CityID,CountryID,PinCode,Landline,Mobile,Website,RegNo,Logo,Principal,UserID,CompanyAcademicYearID,Status,Email,Password")] SchoolModel schoolmodel, HttpPostedFileBase uploadlogo, string newlogo, string existingemail)
{
errordata data = new errordata();
data.type = "error";
Session["err"] = "Error, Please Check Input Fields";
Session["msg"] = "";
try
{
if (ModelState.IsValid)
{
if (schoolmodel.Email != existingemail)
{
User schoolold = db.Users.Where(s => s.Email == schoolmodel.Email).FirstOrDefault();
if (schoolold != null)
{
Session["err"] = "Email already exists";
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
//string newfilename = Guid.NewGuid().ToString();
//string logopath = schoolmodel.Logo;
//if (uploadlogo != null)
//{
// var fileName = Path.GetFileName(uploadlogo.FileName);
// var extention = Path.GetExtension(uploadlogo.FileName);
// var filenamewithoutextension = Path.GetFileNameWithoutExtension(uploadlogo.FileName);
// try
// {
// uploadlogo.SaveAs(Server.MapPath("/Uploads/" + newfilename + "." + extention));
// logopath = "/Uploads/" + newfilename + "." + extention;
// schoolmodel.Logo = logopath;
// }
// catch {
// Session["err"] = "Can't upload file, please contact support";
// data.message = Session["err"].ToString();
// return Json(data, JsonRequestBehavior.AllowGet);
// }
//}
if (newlogo != "")
{
schoolmodel.Logo = newlogo;
}
User superadminuser = db.Users.Find(1);
User user = db.Users.Find(schoolmodel.UserID);
user.Email = schoolmodel.Email;
user.Password = schoolmodel.Password;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
School school = db.Schools.Find(schoolmodel.SchoolID);
school.Name = schoolmodel.Name;
school.ShortName = schoolmodel.ShortName;
school.HouseNo = schoolmodel.HouseNo;
school.BuildingName = schoolmodel.BuildingName;
school.Street = schoolmodel.Street;
school.Area = schoolmodel.Area;
school.Location = schoolmodel.Location;
school.CityID = schoolmodel.CityID;
school.CountryID = schoolmodel.CountryID;
school.PinCode = schoolmodel.PinCode;
school.Landline = schoolmodel.Landline;
school.Mobile = schoolmodel.Mobile;
school.Website = schoolmodel.Website;
school.RegNo = schoolmodel.RegNo;
school.Logo = schoolmodel.Logo;
school.Principal = schoolmodel.Principal;
school.UserID = schoolmodel.UserID;
school.CompanyAcademicYearID = schoolmodel.CompanyAcademicYearID;
school.Status = schoolmodel.Status;
db.Entry(school).State = EntityState.Modified;
db.SaveChanges();
string To = schoolmodel.Email, WebsiteUrl, Ssl, UserID, Password, SMTPPort, Host;
CommanFunctions.AppSettings(out WebsiteUrl, out Ssl, out UserID, out Password, out SMTPPort, out Host);
string subject = "School Modified";
string body = "Hi,";
body += "<br/> School was modified. Please login using these credentials, and update school profile. <br/> Login email : " + schoolmodel.Email;
body += "<br/> Login password : "******"<br/> <br/> ----------------------";
body += "<br/> Admin";
body += "<br/> <a href=" + WebsiteUrl + ">" + WebsiteUrl + "</a>";
try { CommanFunctions.SendEmail(UserID, subject, body, superadminuser.Email, To, Ssl, UserID, Password, SMTPPort, Host); }
catch
{
//Session["err"] = "Email sending failed, please check smtp configuration.";
//data.message = Session["err"].ToString();
//return Json(data, JsonRequestBehavior.AllowGet);
}
Session["err"] = "";
Session["msg"] = "Modified Successfully";
}
}
catch {
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
data.message = "/School/Index";
data.type = "success";
return(Json(data, JsonRequestBehavior.AllowGet));
}
public IHttpActionResult PostStudent(StudentModel studentmodel, string newlogo, int academicyearid)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
User studentold = db.Users.Where(s => s.Email == studentmodel.Email).FirstOrDefault();
if (studentold != null)
{
return(Json("Email already exists"));
}
else
{
if (newlogo != "")
{
studentmodel.Photo = newlogo;
}
try
{
User superadminuser = db.Users.Find(1);
User user = new User();
user.Email = studentmodel.Email;
user.Password = studentmodel.Password;
user.CanCreate = false;
user.CanEdit = false;
user.CanDelete = false;
user.CanPrint = false;
user.Status = false;
user.CreatedOn = DateTime.Now;
user.LastLoggedOn = null;
db.Users.Add(user);
db.SaveChanges();
Role role = db.Roles.Where(r => r.Name == "Student").FirstOrDefault();
UserRole userroles = new UserRole();
userroles.UserID = user.UserID;
userroles.RoleID = role.RoleID;
db.UserRoles.Add(userroles);
db.SaveChanges();
Student student = new Student();
student.Name = studentmodel.Name;
student.Mobile = studentmodel.Mobile;
student.IdCard = studentmodel.IdCard;
student.ClassID = studentmodel.ClassID;
student.SectionID = studentmodel.SectionID;
student.Photo = studentmodel.Photo;
student.SchoolID = studentmodel.SchoolID;
student.UserID = user.UserID;
student.Status = studentmodel.Status;
db.Students.Add(student);
db.SaveChanges();
School school = db.Schools.Find(studentmodel.SchoolID);
studentmodel.IdCard = "" + school.ShortName + "-" + student.StudentID.ToString("D" + 6);
db.Entry(student).State = EntityState.Modified;
db.SaveChanges();
user.Status = true;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
string To = studentmodel.Email, WebsiteUrl, Ssl, UserID, Password, SMTPPort, Host;
CommanFunctions.AppSettings(out WebsiteUrl, out Ssl, out UserID, out Password, out SMTPPort, out Host);
string subject = "New Student Created";
string body = "Hi,";
body += "<br/> Student was created. Please login using these credentials, and update student profile. <br/> Login email : " + studentmodel.Email;
body += "<br/> Login password : "******"<br/> <br/> ----------------------";
body += "<br/> Admin";
body += "<br/> <a href=" + WebsiteUrl + ">" + WebsiteUrl + "</a>";
try { CommanFunctions.SendEmail(UserID, subject, body, superadminuser.Email, To, Ssl, UserID, Password, SMTPPort, Host); }
catch { }
}
catch
{
return(Json("Error in creating"));
}
}
return(Json("Created Successfully"));
}
public IHttpActionResult PostTeacher(TeacherModel teachermodel, string newlogo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
User teacherold = db.Users.Where(s => s.Email == teachermodel.Email).FirstOrDefault();
if (teacherold != null)
{
return(Json("Email already exists"));
}
else
{
if (newlogo != "")
{
teachermodel.Photo = newlogo;
}
try
{
User superadminuser = db.Users.Find(1);
User user = new User();
user.Email = teachermodel.Email;
user.Password = teachermodel.Password;
user.CanCreate = false;
user.CanEdit = false;
user.CanDelete = false;
user.CanPrint = false;
user.Status = false;
user.CreatedOn = DateTime.Now;
user.LastLoggedOn = null;
db.Users.Add(user);
db.SaveChanges();
Role role = db.Roles.Where(r => r.Name == "Teacher").FirstOrDefault();
UserRole userroles = new UserRole();
userroles.UserID = user.UserID;
userroles.RoleID = role.RoleID;
db.UserRoles.Add(userroles);
db.SaveChanges();
Teacher teacher = new Teacher();
teacher.Name = teachermodel.Name;
teacher.HouseNo = teachermodel.HouseNo;
teacher.BuildingName = teachermodel.BuildingName;
teacher.Street = teachermodel.Street;
teacher.Area = teachermodel.Area;
teacher.Location = teachermodel.Location;
teacher.CityID = teachermodel.CityID;
teacher.CountryID = teachermodel.CountryID;
teacher.PinCode = teachermodel.PinCode;
teacher.Landline = teachermodel.Landline;
teacher.Mobile = teachermodel.Mobile;
teacher.Photo = teachermodel.Photo;
teacher.SchoolID = teachermodel.SchoolID;
teacher.UserID = user.UserID;
teacher.Status = teachermodel.Status;
db.Teachers.Add(teacher);
db.SaveChanges();
user.Status = true;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
string To = teachermodel.Email, WebsiteUrl, Ssl, UserID, Password, SMTPPort, Host;
CommanFunctions.AppSettings(out WebsiteUrl, out Ssl, out UserID, out Password, out SMTPPort, out Host);
string subject = "New Teacher Created";
string body = "Hi,";
body += "<br/> Teacher was created. Please login using these credentials, and update teacher profile. <br/> Login email : " + teachermodel.Email;
body += "<br/> Login password : "******"<br/> <br/> ----------------------";
body += "<br/> Admin";
body += "<br/> <a href=" + WebsiteUrl + ">" + WebsiteUrl + "</a>";
try { CommanFunctions.SendEmail(UserID, subject, body, superadminuser.Email, To, Ssl, UserID, Password, SMTPPort, Host); }
catch { }
}
catch
{
return(Json("Error in creating"));
}
}
return(Json("Created Successfully"));
}
public IHttpActionResult PostSchool(SchoolModel schoolmodel, string newlogo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
User schoolold = db.Users.Where(s => s.Email == schoolmodel.Email).FirstOrDefault();
if (schoolold != null)
{
return(Json("Email already exists"));
}
else
{
if (newlogo != "")
{
schoolmodel.Logo = newlogo;
}
try
{
apiheaderdata apidata = APIAuthorizeAttribute.GetAuthorize(Request.Headers.GetValues("Token").First());
User superadminuser = db.Users.Find(1);
User user = new User();
user.Email = schoolmodel.Email;
user.Password = schoolmodel.Password;
user.CanCreate = false;
user.CanEdit = false;
user.CanDelete = false;
user.CanPrint = false;
user.Status = false;
user.CreatedOn = DateTime.Now;
user.LastLoggedOn = null;
db.Users.Add(user);
db.SaveChanges();
Role role = db.Roles.Where(r => r.Name == "SchoolAdmin").FirstOrDefault();
UserRole userroles = new UserRole();
userroles.UserID = user.UserID;
userroles.RoleID = role.RoleID;
db.UserRoles.Add(userroles);
db.SaveChanges();
School school = new School();
school.Name = schoolmodel.Name;
school.ShortName = schoolmodel.ShortName;
school.HouseNo = schoolmodel.HouseNo;
school.BuildingName = schoolmodel.BuildingName;
school.Street = schoolmodel.Street;
school.Area = schoolmodel.Area;
school.Location = schoolmodel.Location;
school.CityID = schoolmodel.CityID;
school.CountryID = schoolmodel.CountryID;
school.PinCode = schoolmodel.PinCode;
school.Landline = schoolmodel.Landline;
school.Mobile = schoolmodel.Mobile;
school.Website = schoolmodel.Website;
school.RegNo = schoolmodel.RegNo;
school.Logo = schoolmodel.Logo;
school.CompanyAcademicYearID = schoolmodel.CompanyAcademicYearID;
school.Principal = schoolmodel.Principal;
school.UserID = user.UserID;
CompanyAcademicYear companyacademicyear = db.CompanyAcademicYears.Include(c => c.CurrentCompany).Include(c => c.CurrentAcademicYear).Where(c => c.AcademicYearID == apidata.AcademicYearID).FirstOrDefault();
school.CompanyAcademicYearID = companyacademicyear.CompanyAcademicYearID;
school.Status = schoolmodel.Status;
db.Schools.Add(school);
db.SaveChanges();
user.Status = true;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
string To = schoolmodel.Email, WebsiteUrl, Ssl, UserID, Password, SMTPPort, Host;
CommanFunctions.AppSettings(out WebsiteUrl, out Ssl, out UserID, out Password, out SMTPPort, out Host);
string subject = "New School Created";
string body = "Hi,";
body += "<br/> School was created. Please login using these credentials, and update school profile. <br/> Login email : " + schoolmodel.Email;
body += "<br/> Login password : "******"<br/> <br/> ----------------------";
body += "<br/> Admin";
body += "<br/> <a href=" + WebsiteUrl + ">" + WebsiteUrl + "</a>";
try { CommanFunctions.SendEmail(UserID, subject, body, superadminuser.Email, To, Ssl, UserID, Password, SMTPPort, Host); }
catch { }
}
catch
{
return(Json("Error in creating"));
}
}
return(Json("Created Successfully"));
}
