Example #1
0
        public bool SaveStudent(string Name, string stuCode, TestExcelImportEntities db)
        {
            var result = false;

            try
            {
                if (db.Student.Where(x => x.Code.Equals(stuCode)).Count() == 0)
                {
                    var stu = new Student();
                    stu.Name = Name;
                    stu.Code = stuCode;
                    db.Student.Add(stu);
                    db.SaveChanges();
                    result = true;
                }
            }
            catch (Exception x)
            {
            }
            return(result);
        }
Example #2
0
        public bool ImportData(out int count, ExcelPackage package)
        {
            count = 0;
            var result = false;

            try
            {
                int                     startColumn = 1;
                int                     startRow    = 4;
                ExcelWorksheet          workSheet   = package.Workbook.Worksheets[1];
                object                  data        = null;
                TestExcelImportEntities db          = new TestExcelImportEntities();

                do
                {
                    data = workSheet.Cells[startRow, startColumn].Value;
                    object studentName = workSheet.Cells[startRow, startColumn + 1].Value;
                    object studentCode = workSheet.Cells[startRow, startColumn + 2].Value;

                    if (data != null)
                    {
                        var isSuccess = SaveStudent(studentName.ToString(), studentCode.ToString(), db);
                        if (isSuccess)
                        {
                            count++;
                        }
                    }
                    startRow++;
                } while (data != null);
            }
            catch (Exception x)
            {
                throw;
            }
            return(result);
        }