public ActionResult Upload() { errordata data = new errordata(); data.type = "error"; try { string filename = Guid.NewGuid().ToString(); var file = Request.Files[0]; //var fileName = Path.GetFileName(file.FileName); var extention = Path.GetExtension(file.FileName); //var filenamewithoutextension = Path.GetFileNameWithoutExtension(file.FileName); file.SaveAs(Server.MapPath("/Uploads/" + filename + "" + extention + "")); data.message = "/Uploads/" + filename + "" + extention + ""; data.type = "success"; return(Json(data, JsonRequestBehavior.AllowGet)); //for (int i = 0; i < Request.Files.Count; i++) //{ //} } catch { data.message = "Can't upload file, please contact support"; } return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult _CreateFor([Bind(Include = "CurrencyID,Name,Symbol,NoOfDecimals,MonetaryUnit,CountryID,StatusBaseCurrency,ExchangeRate")] Currency currency, string frompage) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { Currency exist = db.Currencys.Where(c => c.Name == currency.Name).FirstOrDefault(); if (exist != null) { Session["err"] = "Currency name already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.Currencys.Add(currency); db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; return(RedirectToAction("_CurrencyPartial", frompage, new { id = currency.CurrencyID })); } ViewBag.CountryID = new SelectList(db.Countrys, "CountryID", "Name", currency.CountryID); data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult _Create([Bind(Include = "CountryID,CountryCode,Name,Nationality")] Country country) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { Country countryexist = db.Countrys.Where(c => c.Name == country.Name).FirstOrDefault(); if (countryexist != null) { Session["err"] = "Country name already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.Countrys.Add(country); db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; } data.message = "/Country/Index"; data.type = "success"; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult _Create([Bind(Include = "SubjectID,Name,ClassID")] Subject subject) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { Subject subjectexist = db.Subjects.Where(s => s.Name == subject.Name && s.ClassID == subject.ClassID).FirstOrDefault(); if (subjectexist != null) { Session["err"] = "Subject already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.Subjects.Add(subject); db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; } data.message = "/Subject/Index"; data.type = "success"; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult _CreateFor([Bind(Include = "TopicID,Name,ChapterID")] Topic topic, string frompage) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { Topic topicexist = db.Topics.Where(c => c.Name == topic.Name && c.ChapterID == topic.ChapterID).FirstOrDefault(); if (topicexist != null) { Session["err"] = "Topic name already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.Topics.Add(topic); db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; return(RedirectToAction("_TopicPartial", frompage, new { id = topic.TopicID })); } data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult _CreateGroupFor([Bind(Include = "AccountGroupID,Name,AccountCategoryID")] AccountGroup accountgroup) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { AccountGroup exist = db.AccountGroups.Where(c => c.Name == accountgroup.Name).FirstOrDefault(); if (exist != null) { Session["err"] = "Group already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.AccountGroups.Add(accountgroup); db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; } data.message = "/AccountHead/Index"; data.type = "success"; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult _CreateFor([Bind(Include = "TimeTableID,SchoolID,ClassID,SectionID,PeriodID,TeacherID,SubjectID,IsClassTeacher")] TimeTable timeTable, string frompage) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { TimeTable timeTableexist = db.TimeTables.Where(c => c.SchoolID == timeTable.SchoolID && c.ClassID == timeTable.ClassID && c.SectionID == timeTable.SectionID && c.PeriodID == timeTable.PeriodID).FirstOrDefault(); if (timeTableexist != null) { Session["err"] = "TimeTable already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.TimeTables.Add(timeTable); db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; return(RedirectToAction("_TimeTablePartial", frompage, new { id = timeTable.TimeTableID })); } data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult _Create([Bind(Include = "AttendanceTypeID,Name")] AttendanceType attendanceType) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { AttendanceType attendanceTypeexist = db.AttendanceTypes.Where(c => c.Name == attendanceType.Name).FirstOrDefault(); if (attendanceTypeexist != null) { Session["err"] = "AttendanceType name already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.AttendanceTypes.Add(attendanceType); db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; } data.message = "/AttendanceType/Index"; data.type = "success"; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult _CreateFor([Bind(Include = "ChapterID,Name,SubjectID")] Chapter chapter, string frompage) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { Chapter chapterexist = db.Chapters.Where(s => s.Name == chapter.Name && s.SubjectID == chapter.SubjectID).FirstOrDefault(); if (chapterexist != null) { Session["err"] = "Chapter already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.Chapters.Add(chapter); db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; return(RedirectToAction("_ChapterPartial", frompage, new { id = chapter.ChapterID })); } data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult _Create([Bind(Include = "ExamID,Name,SchoolID,SubjectID,Date,Remarks")] Exam exam) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { Exam examexist = db.Exams.Where(c => c.Name == exam.Name).FirstOrDefault(); if (examexist != null) { Session["err"] = "Exam name already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.Exams.Add(exam); db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; } data.message = "/Exam/Index"; data.type = "success"; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult _Create([Bind(Include = "PeriodID,Time,Name")] Period period) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { Period periodexist = db.Periods.Where(c => c.Name == period.Name).FirstOrDefault(); if (periodexist != null) { Session["err"] = "Period name already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.Periods.Add(period); db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; } data.message = "/Period/Index"; data.type = "success"; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult Create([Bind(Include = "ExamPortionID,ExamID,ChapterID,TopicID")] ExamPortion examportion) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { ExamPortion exist = db.ExamPortions.Where(s => s.TopicID == examportion.TopicID).FirstOrDefault(); if (exist != null) { Session["err"] = "Topic already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.ExamPortions.Add(examportion); db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; } data.message = Session["msg"].ToString(); data.type = "success"; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult _CreateFor([Bind(Include = "ClassID,Name")] Class classs, string frompage) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { Class classexist = db.Classes.Where(c => c.Name == classs.Name).FirstOrDefault(); if (classexist != null) { Session["err"] = "Class name already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.Classes.Add(classs); db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; return(RedirectToAction("_ClassPartial", frompage, new { id = classs.ClassID })); } data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit([Bind(Include = "CompanyID,Name,HouseNo,BuildingName,Street,Area,Location,CityID,CountryID,PinCode,Landline,Mobile,Email,Website,RegNo,CurrencyID,DefaultLanguage,AcademicYearID,Logo")] Company company, HttpPostedFileBase uploadLogo, string newlogo) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (company.Name != "") { //string newfilename = Guid.NewGuid().ToString(); //string logopath = company.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; // company.Logo = logopath; // } // catch { } //} try { if (newlogo != "") { company.Logo = newlogo; } db.Entry(company).State = EntityState.Modified; db.SaveChanges(); Session["err"] = ""; Session["msg"] = "Modified Successfully"; } catch { data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } } ViewBag.CityID = new SelectList(db.Citys, "CityID", "Name", company.CityID); ViewBag.CountryID = new SelectList(db.Countrys, "CountryID", "Name", company.CountryID); ViewBag.CurrencyID = new SelectList(db.Currencys, "CurrencyID", "Name", company.CurrencyID); data.message = "/Company/Edit/1"; data.type = "success"; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult _Create([Bind(Include = "CalendarID,Title,Description,StartDate,NoOfDays")] HolidayModel holiday) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { Calendar holidayexist = db.Calendars.Where(c => c.Date == holiday.StartDate && c.Title == holiday.Title).FirstOrDefault(); if (holidayexist != null) { Session["err"] = "Holiday title already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } int nofofdays = holiday.NoOfDays; DateTime startdate = holiday.StartDate; while (nofofdays != 0) { Calendar holidayupdate = db.Calendars.Where(c => c.Date == startdate && c.Title != "SUNDAY").FirstOrDefault(); if (holidayupdate != null) { holidayupdate.Title = holiday.Title; holidayupdate.Description = holiday.Description; holidayupdate.IsHoliday = true; db.Entry(holidayupdate).State = EntityState.Modified; db.SaveChanges(); } nofofdays = nofofdays - 1; startdate = startdate.AddDays(+1); } ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; } data.message = "/Holiday/Index"; data.type = "success"; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult Create([Bind(Include = "ExamID,Name,SchoolID,SubjectID,SubjectName,Date,ExamPortionID,ChapterID,ChapterName,TopicID,TopicName,Remarks")] ExamModel exammodel) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { Exam examexists = db.Exams.Where(c => c.Name == exammodel.Name).FirstOrDefault(); if (examexists != null) { Session["err"] = "TimeTable already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } Exam exam = new Exam(); exam.Name = exammodel.Name; exam.SchoolID = exammodel.SchoolID; exam.SubjectID = exammodel.SubjectID; exam.Date = exammodel.Date; exam.Remarks = exammodel.Remarks; db.Exams.Add(exam); db.SaveChanges(); //ExamPortion examportion = new ExamPortion(); //examportion.ExamID = exammodel.ExamID; //examportion.ChapterID = exammodel.ChapterID; //examportion.TopicID = exammodel.TopicID; //db.ExamPortions.Add(examportion); //db.SaveChanges(); ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; } data.message = "/TimeTable/Index"; data.type = "success"; return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult CreateUserPageView() { errordata data = new errordata(); data.type = "error"; try { int userid = 0; try { userid = Convert.ToInt16(System.Web.HttpContext.Current.Session["UserID"].ToString()); } catch { } string pageurl = Request.UrlReferrer.AbsolutePath; UserPageView userpageview = new UserPageView(); userpageview.UserID = userid; userpageview.PageUrl = pageurl; userpageview.DateAccessed = DateTime.Now; db.UserPageViews.Add(userpageview); db.SaveChanges(); } catch { data.message = "Error"; } 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 ActionResult Create([Bind(Include = "VideoID,Name,Description,VideoPath,FileExt,UserID,Dou")] learnersmate.Models.Video video, HttpPostedFileBase uploadvideo, string newlogo, bool IsYoutube) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (newlogo == "") { Session["err"] = "Video required"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } else { if (newlogo != "") { video.VideoPath = newlogo; var extention = Path.GetExtension(newlogo); video.FileExt = extention; } db.Videos.Add(video); db.SaveChanges(); if (IsYoutube) { try { //////ref https://console.developers.google.com/apis/api/youtube.googleapis.com/overview?project=webbased-document-management ///https://console.developers.google.com/apis/credentials?project=webbased-document-management ///https://www.slickremix.com/docs/get-api-key-for-youtube/ YouTubeRequestSettings settings; YouTubeRequest request; string devkey = ConfigurationManager.AppSettings.Get("youtubedevkey"); string username = ConfigurationManager.AppSettings.Get("youtubeusername"); string password = ConfigurationManager.AppSettings.Get("youtubepassword"); string filepath = Server.MapPath("/" + newlogo.PadLeft(1).Replace("/", "\\")); settings = new YouTubeRequestSettings("education", devkey, username, password) { Timeout = 999999999 }; request = new YouTubeRequest(settings); Google.YouTube.Video videoyoutube = new Google.YouTube.Video(); videoyoutube.Title = video.Name; videoyoutube.Description = video.Description; videoyoutube.Tags.Add(new MediaCategory("Education", YouTubeNameTable.CategorySchema)); videoyoutube.Keywords = "Education"; videoyoutube.Private = false; videoyoutube.MediaSource = new MediaFileSource(filepath, "video/flv"); Google.YouTube.Video createdVideo = request.Upload(videoyoutube); //In that createdVideo you will get uploaded video ID. video.YoutubePath = createdVideo.VideoId; db.Entry(video).State = EntityState.Modified; db.SaveChanges(); } catch (Exception exception) { Session["msg"] = "Cant upload youtube, Please check youtube api settings" + exception.Message; } } Session["err"] = ""; Session["msg"] += "Created Successfully"; } data.message = "/Video/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 _Create([Bind(Include = "UserID,Email,Password,RoleID,CanCreate,CanEdit,CanDelete,CanPrint,Status")] UserModel model) { errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { User cityexist = db.Users.Where(c => c.Email == model.Email).FirstOrDefault(); if (cityexist != null) { Session["err"] = "Email already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } //User user = new User(); //user.Email = model.Email; //user.Password = model.Password; //user.CanCreate = model.CanCreate; //user.CanEdit = model.CanEdit; //user.CanDelete = model.CanDelete; //user.CanPrint = model.CanPrint; //user.Status = true; //db.Users.Add(user); //db.SaveChanges(); //UserRole userrole = new UserRole(); //userrole.UserID = user.UserID; //userrole.RoleID = model.RoleID; //db.UserRoles.Add(userrole); //db.SaveChanges(); //User superadminuser = db.Users.Find(1); //int companyfinancialyearid = Convert.ToInt16(Session["CompanyFinancialYearID"].ToString()); //int branchid = Convert.ToInt16(Session["BranchID"].ToString()); //Employee employee = new Employee(); //employee.Name = "EMP"; //employee.EmpCode = "EMP-"; //employee.HouseNo = ""; //employee.BuildingName = ""; //employee.Street = ""; //employee.Area = ""; //employee.Location = ""; //employee.CityID = 1; //employee.CountryID = 1; //employee.PinCode = ""; //employee.Landline = ""; //employee.Mobile = ""; //employee.Website = ""; //employee.Logo = ""; //employee.BranchID = branchid; //employee.DesignationID = 1; //employee.DepartmentID = 1; //employee.UserID = user.UserID; //employee.DateOfBirth = null; //employee.JoiningDate = null; //employee.TerminationDate = null; //employee.EmployeeStatusID = 1; //db.Employees.Add(employee); //db.SaveChanges(); //employee.EmpCode = "EMP" + 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 = model.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 : " + model.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 //{ //} ModelState.Clear(); Session["err"] = ""; Session["msg"] = "Created Successfully"; } data.message = "/User/Index"; data.type = "success"; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult Create([Bind(Include = "SalaryInstalmentsID,TeacherID,Title,Amount,Dop")] SalaryBookTeacher salaryinstalments) { bool result = false; errordata data = new errordata(); data.type = "error"; Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; if (ModelState.IsValid) { SalaryBookTeacher exist = db.SalaryBookTeachers.Where(s => s.Title == salaryinstalments.Title && s.TeacherID == salaryinstalments.TeacherID).FirstOrDefault(); if (exist != null) { Session["err"] = "Salary Instalment already exists"; data.message = Session["err"].ToString(); return(Json(data, JsonRequestBehavior.AllowGet)); } db.SalaryBookTeachers.Add(salaryinstalments); db.SaveChanges(); ModelState.Clear(); result = true; if (result == true) { //Account int feedebitaccount = 0; int salarydebitaccount = 0; int feecreditaccount = 0; int salarycreditaccount = 0; var acheadassignList = db.AccountHeadAssigns.ToList(); foreach (AccountHeadAssign acheadassign in acheadassignList) { if (acheadassign.HeadAssignID == 1) { feedebitaccount = acheadassign.AccountHeadID; } if (acheadassign.HeadAssignID == 2) { feecreditaccount = acheadassign.AccountHeadID; } if (acheadassign.HeadAssignID == 3) { salarydebitaccount = acheadassign.AccountHeadID; } if (acheadassign.HeadAssignID == 4) { salarycreditaccount = acheadassign.AccountHeadID; } } Teacher teacher = db.Teachers.Find(salaryinstalments.TeacherID); string voucherno = "EM" + teacher.IdCard + "-" + salaryinstalments.SalaryBookID.ToString(); var accountjournals = db.AccountJournals.Where(a => a.VoucherNo == voucherno).ToList(); foreach (AccountJournal accountjournal1 in accountjournals) { var accountjournaldetails = db.AccountJournalDetails.Where(a => a.AccountJournalID == accountjournal1.AccountJournalID).ToList(); foreach (AccountJournalDetail accountjournaldetail1 in accountjournaldetails) { db.AccountJournalDetails.Remove(accountjournaldetail1); } db.SaveChanges(); db.AccountJournals.Remove(accountjournal1); } db.SaveChanges(); AccountJournal accountjournal = new AccountJournal(); accountjournal.VoucherNo = voucherno; accountjournal.VoucherType = voucherno.Substring(0, 2); accountjournal.TransactionDate = salaryinstalments.Dop; accountjournal.BranchID = int.Parse(Session["SchoolID"].ToString()); accountjournal.FinancialYearID = int.Parse(Session["AcademicYearID"].ToString()); accountjournal.UserID = Session["UserID"].ToString(); accountjournal.Remarks = "Teacher Salary"; db.AccountJournals.Add(accountjournal); db.SaveChanges(); //debit AccountJournalDetail accountjournaldetail = new AccountJournalDetail(); if (salaryinstalments.Amount > 0) { accountjournaldetail.AccountJournalID = accountjournal.AccountJournalID; accountjournaldetail.AccountHeadID = feedebitaccount; accountjournaldetail.AnalysisHeadID = 0; accountjournaldetail.Amount = salaryinstalments.Amount; accountjournaldetail.Remarks = "Teacher Salary: " + teacher.Name + ", Detail: " + salaryinstalments.Title + ", salary Debit"; db.AccountJournalDetails.Add(accountjournaldetail); db.SaveChanges(); } //credit if (salaryinstalments.Amount > 0) { accountjournaldetail = new AccountJournalDetail(); accountjournaldetail.AccountJournalID = accountjournal.AccountJournalID; accountjournaldetail.AccountHeadID = feecreditaccount; accountjournaldetail.AnalysisHeadID = 0; accountjournaldetail.Amount = salaryinstalments.Amount * -1; accountjournaldetail.Remarks = "Teacher Salary: " + teacher.Name + ", Detail: " + salaryinstalments.Title + ", salary credit"; db.AccountJournalDetails.Add(accountjournaldetail); db.SaveChanges(); } } Session["err"] = ""; Session["msg"] = "Created Successfully"; } data.message = Session["msg"].ToString(); 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 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 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 = "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)); }