Пример #1
0
        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));
        }
Пример #2
0
        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));
        }
Пример #3
0
        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));
        }
Пример #4
0
        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));
        }
Пример #5
0
        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));
        }
Пример #6
0
        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));
        }
Пример #7
0
        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));
        }
Пример #8
0
        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));
        }
Пример #9
0
        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));
        }
Пример #10
0
        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));
        }
Пример #11
0
        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));
        }
Пример #12
0
        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));
        }
Пример #13
0
        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));
        }
Пример #14
0
        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));
        }
Пример #15
0
        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));
        }
Пример #16
0
        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));
        }
Пример #17
0
        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));
        }
Пример #18
0
        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));
        }
Пример #19
0
        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));
        }
Пример #20
0
        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));
        }
Пример #21
0
        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));
        }
Пример #23
0
        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));
        }
Пример #24
0
        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));
        }
Пример #25
0
        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));
        }
Пример #26
0
        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));
        }