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")); }