Esempio n. 1
0
        public JsonResult InsertStudent(IndexStudentsListVM obj)
        {
            var    result  = (dynamic)null;
            string message = (dynamic)null;

            try
            {
                if (obj.Students != null)
                {
                    var Students = new InsertStudent_Students()
                    {
                        ClassId          = obj.Students.ClassId,
                        GenderId         = obj.Students.GenderId,
                        RegistrationNo   = obj.Students.RegistrationNo,
                        FirstName        = obj.Students.FirstName,
                        LastName         = obj.Students.LastName,
                        FatherName       = obj.Students.FatherName,
                        MotherName       = obj.Students.MotherName,
                        IP300X200        = obj.Students.IP300X200,
                        Year             = obj.Students.Year,
                        PresentAddress   = obj.Students.PresentAddress,
                        PermanentAddress = obj.Students.PermanentAddress,
                        DOB          = obj.Students.DOB,
                        fleImage     = obj.Students.fleImage,
                        IsActive     = obj.Students.IsActive,
                        AddedBy      = 0,
                        AddedDate    = DateTime.Now,
                        ModifiedBy   = 0,
                        ModifiedDate = DateTime.Now,
                        DataType     = null
                    };

                    var StudentPromotions = new InsertStudent_StudentPromotions()
                    {
                        ClassId      = obj.Students.ClassId,
                        StudentId    = obj.Students.Id,
                        Year         = obj.Students.Year,
                        RollNo       = obj.StudentPromotions.RollNo,
                        IsActive     = obj.Students.IsActive,
                        AddedBy      = 0,
                        AddedDate    = DateTime.Now,
                        ModifiedBy   = 0,
                        ModifiedDate = DateTime.Now,
                        DataType     = null
                    };

                    var model = new InsertStudent()
                    {
                        WebRootPath       = _he.WebRootPath,
                        Students          = Students,
                        StudentPromotions = StudentPromotions
                    };

                    message = _studentsServ.InsertStudent(model);
                    result  = Json(new { success = true, Message = message });
                }
            }
            // catch (Exception)
            catch (Exception ex)
            {
                result = Json(new { success = false, Message = "ERROR101:Students/InsertStudent - " + ex.Message });
            }

            return(result);
        }
        public string InsertStudent(InsertStudent obj)
        {
            string returnResult = (dynamic)null;

            try
            {
                var studentsList    = _studentsRepo.GetAll().ToList();
                var getregistration = (from stu in studentsList
                                       where stu.RegistrationNo == obj.Students.RegistrationNo
                                       select stu).SingleOrDefault();
                //var Studentlist = _studentsRepo.Get(obj.Students.Id);
                //var query=(from stu)

                if (getregistration == null)
                {
                    if (obj != null)
                    {
                        var AdmittedYear = DateTime.ParseExact(obj.Students.Year, "yyyy", null);
                        //[Note: insert 'states' table]
                        if (obj.Students != null)
                        {
                            var Students = new InsertStudent_Students()
                            {
                                ClassId          = obj.Students.ClassId,
                                GenderId         = obj.Students.GenderId,
                                RegistrationNo   = obj.Students.RegistrationNo,
                                FirstName        = obj.Students.FirstName,
                                LastName         = obj.Students.LastName,
                                IP300X200        = obj.Students.IP300X200,
                                AdmittedYear     = AdmittedYear,
                                PresentAddress   = obj.Students.PresentAddress,
                                PermanentAddress = obj.Students.PermanentAddress,
                                DOB          = obj.Students.DOB,
                                IsActive     = obj.Students.IsActive,
                                AddedBy      = obj.Students.AddedBy = 0,
                                AddedDate    = DateTime.Now,
                                ModifiedBy   = 0,
                                ModifiedDate = DateTime.Now,
                                FatherName   = obj.Students.FatherName,
                                MotherName   = obj.Students.MotherName,
                                DataType     = null
                            };
                            //[NOTE: Student table]
                            _studentsRepo.Insert(Students);
                            if (obj.Students.fleImage != null)
                            {
                                string imagePathIP300X200 = "ClientDictionary/Students/IP300X200/";
                                string extension          = Path.GetExtension(obj.Students.fleImage.FileName);
                                var    lastAddingRecord   = _studentsRepo.GetAll().Last();
                                if (_commonServ.CommImage_ImageFormat(lastAddingRecord.Id.ToString(), obj.Students.fleImage, obj.WebRootPath, imagePathIP300X200, 200, 300, extension).Equals(true))
                                {
                                    //[NOTE:Update image file]
                                    var imgStudent = _studentsRepo.Get(lastAddingRecord.Id);
                                    imgStudent.IP300X200 = imagePathIP300X200 + lastAddingRecord.Id + extension;
                                    _studentsRepo.Update(imgStudent);
                                }
                            }
                        }
                        Int64 getLastId = _studentsRepo.GetLastId();

                        //[NOTE: Student promotion table table]
                        if (obj.StudentPromotions != null)
                        {
                            var StudentPromotions = new InsertStudent_StudentPromotions()
                            {
                                StudentId    = getLastId,
                                ClassId      = obj.Students.ClassId,
                                RollNo       = obj.StudentPromotions.RollNo,
                                ClassYear    = AdmittedYear,
                                IsActive     = obj.Students.IsActive,
                                AddedBy      = 0,
                                AddedDate    = DateTime.Now,
                                ModifiedBy   = 0,
                                ModifiedDate = DateTime.Now,
                                DataType     = null
                            };

                            _StudentPromotionsRepo.Insert(StudentPromotions);
                        }
                    }
                    returnResult = "Saved";
                }
                else
                {
                    returnResult = "this registration number already exist";
                }
            }
            catch (Exception ex)
            {
                returnResult = "ERROR102:Insert all required Info - " + ex.Message;
            }
            return(returnResult);
        }