尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
School Management System
Introduction
This software was built for a very prominent private school. The school already used an accounting and
time table generation software with some excellent feature. But the user interface was complex and it did
not provide certain important features or integration needed by the school. We developed a set of
applications to work on data form the accounting software and also incorporate many additional
modules to fulfill the requirements.
Objectives
 Understand requirements of eight departments
Develop modules accordingly
 Study database structure if accounting software and sync data
 Provide attendance mechanism
 Sync all lesson and other entries with exchange accounts of staff and students
 Provide the user interface in school’s SharePoint portal
Migrate certain data from last two years into the system
Challenges
 Understanding a 3rd party database without any documentation and solely on explanation of functions
provided by IT team
 Synchronizing with 3rd party database without causing issue with it
 Providing an ASP.NET application inside a SharePoint portal
Synchronizing Exchange calendar of all staff and students with their calendar information
 A very diverse set of excel files used by departments to be migrated into the database
Solution
A detailed study of 3rd party database was done by profiling and observing behavior of data against
functions in the software. Based on this a sync mechanism was designed to fetch necessary data into
application database and also push required data back.
So as to host the solution in SharePoint portal, a generic web part was created to render ASP.NET user
controls. This was needed to reduce the cost of development and debugging of the application.
The project lead met with members of departments to understand the data they were managing in excel
files and how to best create features to give and much better and integrated user experience.
Exchange integration was done using EWS and the client library Microsoft provides. A sync application
was created which reads lesson and other schedules from the database and created, updated and
removed entries for Exchange calendars. A “control panel” was provided to monitor and manage both
sync services.
Data migration was done in two steps. First all data from all files of each department was gathered in an
intermediate database table and verified. Then the same was transformed and imported into system
database through an application written specifically for the job.
Technology Stack
 .Net framework 4.0 with C#
 ASP.NET Web services
 Windows services
 EWS Managed API
 SQL Server 2008 R2 and SQL Profiler
 Exchange Server 2007

More Related Content

What's hot

Dbms mini project
Dbms mini projectDbms mini project
Dbms mini project
Home
 
Hospital mangement system report file
Hospital mangement system report fileHospital mangement system report file
Hospital mangement system report file
Nausheen Hasan
 
DOCUMENTATION
DOCUMENTATIONDOCUMENTATION
DOCUMENTATION
Nithin Kakkireni
 
ERP on School Management System
ERP on School Management SystemERP on School Management System
ERP on School Management System
Amit Gandhi
 
Hospital management-system
Hospital management-systemHospital management-system
Hospital management-system
sam143143
 
School softwer slide
School softwer  slideSchool softwer  slide
School softwer slide
Proshanta Halder
 
Pharmacy management system by Asiqul Islam
Pharmacy management system by Asiqul IslamPharmacy management system by Asiqul Islam
Pharmacy management system by Asiqul Islam
AshiQulIslam34
 
School Management System
School Management SystemSchool Management System
School Management System
HATIM Bhagat
 
PATIENT MANAGEMENT SYSTEM project
PATIENT MANAGEMENT SYSTEM projectPATIENT MANAGEMENT SYSTEM project
PATIENT MANAGEMENT SYSTEM project
Laud Randy Amofah
 
Online Attendance Management System
Online Attendance Management SystemOnline Attendance Management System
Online Attendance Management System
RIDDHICHOUHAN2
 
Online school management system new
Online school management  system newOnline school management  system new
Online school management system new
easysolutionsindia
 
Hospital management-software-presentation
Hospital management-software-presentationHospital management-software-presentation
Hospital management-software-presentation
Face of Art Technologies Ltd
 
Online school mangment system
Online school mangment system Online school mangment system
Online school mangment system
Abdirizak hussein moh'ud gutaale
 
Hospital managment system
Hospital managment systemHospital managment system
Hospital managment system
kousar Rahman
 
Hospital management system
Hospital management systemHospital management system
Hospital management system
Adil Riaz Siddiqi
 
School management system
School management systemSchool management system
School management system
deva491
 
E commerce application using asp.net mvc4
E commerce application using asp.net mvc4E commerce application using asp.net mvc4
E commerce application using asp.net mvc4
Manusha Dilan
 
Student Management System
Student Management SystemStudent Management System
Student Management System
HamaQarani
 
OpenERP Health & Hospital Management System
OpenERP Health & Hospital Management SystemOpenERP Health & Hospital Management System
OpenERP Health & Hospital Management System
Apagen Solutions Pvt. Ltd.
 
Ignou MCA mini project report
Ignou MCA mini project reportIgnou MCA mini project report
Ignou MCA mini project report
Hitesh Jangid
 

What's hot (20)

Dbms mini project
Dbms mini projectDbms mini project
Dbms mini project
 
Hospital mangement system report file
Hospital mangement system report fileHospital mangement system report file
Hospital mangement system report file
 
DOCUMENTATION
DOCUMENTATIONDOCUMENTATION
DOCUMENTATION
 
ERP on School Management System
ERP on School Management SystemERP on School Management System
ERP on School Management System
 
Hospital management-system
Hospital management-systemHospital management-system
Hospital management-system
 
School softwer slide
School softwer  slideSchool softwer  slide
School softwer slide
 
Pharmacy management system by Asiqul Islam
Pharmacy management system by Asiqul IslamPharmacy management system by Asiqul Islam
Pharmacy management system by Asiqul Islam
 
School Management System
School Management SystemSchool Management System
School Management System
 
PATIENT MANAGEMENT SYSTEM project
PATIENT MANAGEMENT SYSTEM projectPATIENT MANAGEMENT SYSTEM project
PATIENT MANAGEMENT SYSTEM project
 
Online Attendance Management System
Online Attendance Management SystemOnline Attendance Management System
Online Attendance Management System
 
Online school management system new
Online school management  system newOnline school management  system new
Online school management system new
 
Hospital management-software-presentation
Hospital management-software-presentationHospital management-software-presentation
Hospital management-software-presentation
 
Online school mangment system
Online school mangment system Online school mangment system
Online school mangment system
 
Hospital managment system
Hospital managment systemHospital managment system
Hospital managment system
 
Hospital management system
Hospital management systemHospital management system
Hospital management system
 
School management system
School management systemSchool management system
School management system
 
E commerce application using asp.net mvc4
E commerce application using asp.net mvc4E commerce application using asp.net mvc4
E commerce application using asp.net mvc4
 
Student Management System
Student Management SystemStudent Management System
Student Management System
 
OpenERP Health & Hospital Management System
OpenERP Health & Hospital Management SystemOpenERP Health & Hospital Management System
OpenERP Health & Hospital Management System
 
Ignou MCA mini project report
Ignou MCA mini project reportIgnou MCA mini project report
Ignou MCA mini project report
 

Similar to white paper : School Management System

Social Intranet Using Share Point Implementation
Social Intranet Using Share Point ImplementationSocial Intranet Using Share Point Implementation
Social Intranet Using Share Point Implementation
Grey Matter India Technologies PVT LTD
 
Resume-Srikanth_Jogula
Resume-Srikanth_JogulaResume-Srikanth_Jogula
Resume-Srikanth_Jogula
Srikanth Jogula
 
Business Intelligence Portfolio
Business Intelligence PortfolioBusiness Intelligence Portfolio
Business Intelligence Portfolio
pleeloy
 
Memos Case Study Nestle
Memos Case Study NestleMemos Case Study Nestle
Memos Case Study Nestle
Apro Software
 
Yuping Liu Resume - August 2016
Yuping Liu Resume - August 2016Yuping Liu Resume - August 2016
Yuping Liu Resume - August 2016
Yuping Liu
 
UBS Tech Talk:Excel Services
UBS Tech Talk:Excel ServicesUBS Tech Talk:Excel Services
UBS Tech Talk:Excel Services
Quek Lilian
 
Cloud Computing Based System Integration in Education
Cloud Computing Based System Integration in EducationCloud Computing Based System Integration in Education
Cloud Computing Based System Integration in Education
IRJET Journal
 
SharePoint for Teaching and Learning
SharePoint for Teaching and LearningSharePoint for Teaching and Learning
SharePoint for Teaching and Learning
Eduserv
 
Poushali_Mukherjee
Poushali_MukherjeePoushali_Mukherjee
Poushali_Mukherjee
Poushali Mukherjee
 
Census Bureau PBOCS
Census Bureau PBOCSCensus Bureau PBOCS
Census Bureau PBOCS
Tolu A Williams
 
Donation Toolbar Application for IE, Chrome & Firefox
Donation Toolbar Application for IE, Chrome & FirefoxDonation Toolbar Application for IE, Chrome & Firefox
Donation Toolbar Application for IE, Chrome & Firefox
Mike Taylor
 
Managing a complex database toolbar application for ie, chrome & firefox
Managing a complex database toolbar application for ie, chrome & firefoxManaging a complex database toolbar application for ie, chrome & firefox
Managing a complex database toolbar application for ie, chrome & firefox
Mike Taylor
 
GCharles_Resume_Summer_2016_SS_Short
GCharles_Resume_Summer_2016_SS_ShortGCharles_Resume_Summer_2016_SS_Short
GCharles_Resume_Summer_2016_SS_Short
sshgc
 
Introduction to SQL Report tool
Introduction to SQL Report toolIntroduction to SQL Report tool
Introduction to SQL Report tool
Russell Frearson
 
Public Library
Public LibraryPublic Library
Public Library
eclumson
 
MS Bi Portfolio Gregory Lee
MS Bi Portfolio Gregory LeeMS Bi Portfolio Gregory Lee
MS Bi Portfolio Gregory Lee
keeperx99
 
What’s New for IT Professionals in Microsoft® SharePoint® Server 2013 Day 2
What’s New for IT Professionals in Microsoft® SharePoint® Server 2013 Day 2What’s New for IT Professionals in Microsoft® SharePoint® Server 2013 Day 2
What’s New for IT Professionals in Microsoft® SharePoint® Server 2013 Day 2
Sayed Ali
 
Software Portfolio - SetFocus
Software Portfolio - SetFocusSoftware Portfolio - SetFocus
Software Portfolio - SetFocus
Alexander Vogel
 
Durgesh o level_2nd_part
Durgesh o level_2nd_partDurgesh o level_2nd_part
Durgesh o level_2nd_part
Durgesh Singh
 
Pretius Oracle Apex Primer
Pretius Oracle Apex PrimerPretius Oracle Apex Primer
Pretius Oracle Apex Primer
Pretius
 

Similar to white paper : School Management System (20)

Social Intranet Using Share Point Implementation
Social Intranet Using Share Point ImplementationSocial Intranet Using Share Point Implementation
Social Intranet Using Share Point Implementation
 
Resume-Srikanth_Jogula
Resume-Srikanth_JogulaResume-Srikanth_Jogula
Resume-Srikanth_Jogula
 
Business Intelligence Portfolio
Business Intelligence PortfolioBusiness Intelligence Portfolio
Business Intelligence Portfolio
 
Memos Case Study Nestle
Memos Case Study NestleMemos Case Study Nestle
Memos Case Study Nestle
 
Yuping Liu Resume - August 2016
Yuping Liu Resume - August 2016Yuping Liu Resume - August 2016
Yuping Liu Resume - August 2016
 
UBS Tech Talk:Excel Services
UBS Tech Talk:Excel ServicesUBS Tech Talk:Excel Services
UBS Tech Talk:Excel Services
 
Cloud Computing Based System Integration in Education
Cloud Computing Based System Integration in EducationCloud Computing Based System Integration in Education
Cloud Computing Based System Integration in Education
 
SharePoint for Teaching and Learning
SharePoint for Teaching and LearningSharePoint for Teaching and Learning
SharePoint for Teaching and Learning
 
Poushali_Mukherjee
Poushali_MukherjeePoushali_Mukherjee
Poushali_Mukherjee
 
Census Bureau PBOCS
Census Bureau PBOCSCensus Bureau PBOCS
Census Bureau PBOCS
 
Donation Toolbar Application for IE, Chrome & Firefox
Donation Toolbar Application for IE, Chrome & FirefoxDonation Toolbar Application for IE, Chrome & Firefox
Donation Toolbar Application for IE, Chrome & Firefox
 
Managing a complex database toolbar application for ie, chrome & firefox
Managing a complex database toolbar application for ie, chrome & firefoxManaging a complex database toolbar application for ie, chrome & firefox
Managing a complex database toolbar application for ie, chrome & firefox
 
GCharles_Resume_Summer_2016_SS_Short
GCharles_Resume_Summer_2016_SS_ShortGCharles_Resume_Summer_2016_SS_Short
GCharles_Resume_Summer_2016_SS_Short
 
Introduction to SQL Report tool
Introduction to SQL Report toolIntroduction to SQL Report tool
Introduction to SQL Report tool
 
Public Library
Public LibraryPublic Library
Public Library
 
MS Bi Portfolio Gregory Lee
MS Bi Portfolio Gregory LeeMS Bi Portfolio Gregory Lee
MS Bi Portfolio Gregory Lee
 
What’s New for IT Professionals in Microsoft® SharePoint® Server 2013 Day 2
What’s New for IT Professionals in Microsoft® SharePoint® Server 2013 Day 2What’s New for IT Professionals in Microsoft® SharePoint® Server 2013 Day 2
What’s New for IT Professionals in Microsoft® SharePoint® Server 2013 Day 2
 
Software Portfolio - SetFocus
Software Portfolio - SetFocusSoftware Portfolio - SetFocus
Software Portfolio - SetFocus
 
Durgesh o level_2nd_part
Durgesh o level_2nd_partDurgesh o level_2nd_part
Durgesh o level_2nd_part
 
Pretius Oracle Apex Primer
Pretius Oracle Apex PrimerPretius Oracle Apex Primer
Pretius Oracle Apex Primer
 

Recently uploaded

Streamlining End-to-End Testing Automation
Streamlining End-to-End Testing AutomationStreamlining End-to-End Testing Automation
Streamlining End-to-End Testing Automation
Anand Bagmar
 
Extreme DDD Modelling Patterns - 2024 Devoxx Poland
Extreme DDD Modelling Patterns - 2024 Devoxx PolandExtreme DDD Modelling Patterns - 2024 Devoxx Poland
Extreme DDD Modelling Patterns - 2024 Devoxx Poland
Alberto Brandolini
 
Hi-Fi Call Girls In Hyderabad 💯Call Us 🔝 7426014248 🔝Independent Hyderabad Es...
Hi-Fi Call Girls In Hyderabad 💯Call Us 🔝 7426014248 🔝Independent Hyderabad Es...Hi-Fi Call Girls In Hyderabad 💯Call Us 🔝 7426014248 🔝Independent Hyderabad Es...
Hi-Fi Call Girls In Hyderabad 💯Call Us 🔝 7426014248 🔝Independent Hyderabad Es...
sapnasaifi408
 
Beginner's Guide to Observability@Devoxx PL 2024
Beginner's  Guide to Observability@Devoxx PL 2024Beginner's  Guide to Observability@Devoxx PL 2024
Beginner's Guide to Observability@Devoxx PL 2024
michniczscribd
 
What’s new in VictoriaMetrics - Q2 2024 Update
What’s new in VictoriaMetrics - Q2 2024 UpdateWhat’s new in VictoriaMetrics - Q2 2024 Update
What’s new in VictoriaMetrics - Q2 2024 Update
VictoriaMetrics
 
Female Bangalore Call Girls 👉 7023059433 👈 Vip Escorts Service Available
Female Bangalore Call Girls 👉 7023059433 👈 Vip Escorts Service AvailableFemale Bangalore Call Girls 👉 7023059433 👈 Vip Escorts Service Available
Female Bangalore Call Girls 👉 7023059433 👈 Vip Escorts Service Available
isha sharman06
 
The Ultimate Guide to Top 36 DevOps Testing Tools for 2024.pdf
The Ultimate Guide to Top 36 DevOps Testing Tools for 2024.pdfThe Ultimate Guide to Top 36 DevOps Testing Tools for 2024.pdf
The Ultimate Guide to Top 36 DevOps Testing Tools for 2024.pdf
kalichargn70th171
 
Secure-by-Design Using Hardware and Software Protection for FDA Compliance
Secure-by-Design Using Hardware and Software Protection for FDA ComplianceSecure-by-Design Using Hardware and Software Protection for FDA Compliance
Secure-by-Design Using Hardware and Software Protection for FDA Compliance
ICS
 
OpenChain Webinar - Open Source Due Diligence for M&A - 2024-06-17
OpenChain Webinar - Open Source Due Diligence for M&A - 2024-06-17OpenChain Webinar - Open Source Due Diligence for M&A - 2024-06-17
OpenChain Webinar - Open Source Due Diligence for M&A - 2024-06-17
Shane Coughlan
 
How GenAI Can Improve Supplier Performance Management.pdf
How GenAI Can Improve Supplier Performance Management.pdfHow GenAI Can Improve Supplier Performance Management.pdf
How GenAI Can Improve Supplier Performance Management.pdf
Zycus
 
🔥 Kolkata Call Girls  👉 9079923931 👫 High Profile Call Girls Whatsapp Number ...
🔥 Kolkata Call Girls  👉 9079923931 👫 High Profile Call Girls Whatsapp Number ...🔥 Kolkata Call Girls  👉 9079923931 👫 High Profile Call Girls Whatsapp Number ...
🔥 Kolkata Call Girls  👉 9079923931 👫 High Profile Call Girls Whatsapp Number ...
tinakumariji156
 
Folding Cheat Sheet #5 - fifth in a series
Folding Cheat Sheet #5 - fifth in a seriesFolding Cheat Sheet #5 - fifth in a series
Folding Cheat Sheet #5 - fifth in a series
Philip Schwarz
 
TheFutureIsDynamic-BoxLang-CFCamp2024.pdf
TheFutureIsDynamic-BoxLang-CFCamp2024.pdfTheFutureIsDynamic-BoxLang-CFCamp2024.pdf
TheFutureIsDynamic-BoxLang-CFCamp2024.pdf
Ortus Solutions, Corp
 
Introduction to Python and Basic Syntax.pptx
Introduction to Python and Basic Syntax.pptxIntroduction to Python and Basic Syntax.pptx
Introduction to Python and Basic Syntax.pptx
GevitaChinnaiah
 
🔥 Chennai Call Girls  👉 6350257716 👫 High Profile Call Girls Whatsapp Number ...
🔥 Chennai Call Girls  👉 6350257716 👫 High Profile Call Girls Whatsapp Number ...🔥 Chennai Call Girls  👉 6350257716 👫 High Profile Call Girls Whatsapp Number ...
🔥 Chennai Call Girls  👉 6350257716 👫 High Profile Call Girls Whatsapp Number ...
tinakumariji156
 
Call Girls in Varanasi || 7426014248 || Quick Booking at Affordable Price
Call Girls in Varanasi || 7426014248 || Quick Booking at Affordable PriceCall Girls in Varanasi || 7426014248 || Quick Booking at Affordable Price
Call Girls in Varanasi || 7426014248 || Quick Booking at Affordable Price
vickythakur209464
 
119321250-History-of-Computer-Programming.ppt
119321250-History-of-Computer-Programming.ppt119321250-History-of-Computer-Programming.ppt
119321250-History-of-Computer-Programming.ppt
lavesingh522
 
Going AOT: Everything you need to know about GraalVM for Java applications
Going AOT: Everything you need to know about GraalVM for Java applicationsGoing AOT: Everything you need to know about GraalVM for Java applications
Going AOT: Everything you need to know about GraalVM for Java applications
Alina Yurenko
 
Enhancing non-Perl bioinformatic applications with Perl
Enhancing non-Perl bioinformatic applications with PerlEnhancing non-Perl bioinformatic applications with Perl
Enhancing non-Perl bioinformatic applications with Perl
Christos Argyropoulos
 
Trailhead Talks_ Journey of an All-Star Ranger .pptx
Trailhead Talks_ Journey of an All-Star Ranger .pptxTrailhead Talks_ Journey of an All-Star Ranger .pptx
Trailhead Talks_ Journey of an All-Star Ranger .pptx
ImtiazBinMohiuddin
 

Recently uploaded (20)

Streamlining End-to-End Testing Automation
Streamlining End-to-End Testing AutomationStreamlining End-to-End Testing Automation
Streamlining End-to-End Testing Automation
 
Extreme DDD Modelling Patterns - 2024 Devoxx Poland
Extreme DDD Modelling Patterns - 2024 Devoxx PolandExtreme DDD Modelling Patterns - 2024 Devoxx Poland
Extreme DDD Modelling Patterns - 2024 Devoxx Poland
 
Hi-Fi Call Girls In Hyderabad 💯Call Us 🔝 7426014248 🔝Independent Hyderabad Es...
Hi-Fi Call Girls In Hyderabad 💯Call Us 🔝 7426014248 🔝Independent Hyderabad Es...Hi-Fi Call Girls In Hyderabad 💯Call Us 🔝 7426014248 🔝Independent Hyderabad Es...
Hi-Fi Call Girls In Hyderabad 💯Call Us 🔝 7426014248 🔝Independent Hyderabad Es...
 
Beginner's Guide to Observability@Devoxx PL 2024
Beginner's  Guide to Observability@Devoxx PL 2024Beginner's  Guide to Observability@Devoxx PL 2024
Beginner's Guide to Observability@Devoxx PL 2024
 
What’s new in VictoriaMetrics - Q2 2024 Update
What’s new in VictoriaMetrics - Q2 2024 UpdateWhat’s new in VictoriaMetrics - Q2 2024 Update
What’s new in VictoriaMetrics - Q2 2024 Update
 
Female Bangalore Call Girls 👉 7023059433 👈 Vip Escorts Service Available
Female Bangalore Call Girls 👉 7023059433 👈 Vip Escorts Service AvailableFemale Bangalore Call Girls 👉 7023059433 👈 Vip Escorts Service Available
Female Bangalore Call Girls 👉 7023059433 👈 Vip Escorts Service Available
 
The Ultimate Guide to Top 36 DevOps Testing Tools for 2024.pdf
The Ultimate Guide to Top 36 DevOps Testing Tools for 2024.pdfThe Ultimate Guide to Top 36 DevOps Testing Tools for 2024.pdf
The Ultimate Guide to Top 36 DevOps Testing Tools for 2024.pdf
 
Secure-by-Design Using Hardware and Software Protection for FDA Compliance
Secure-by-Design Using Hardware and Software Protection for FDA ComplianceSecure-by-Design Using Hardware and Software Protection for FDA Compliance
Secure-by-Design Using Hardware and Software Protection for FDA Compliance
 
OpenChain Webinar - Open Source Due Diligence for M&A - 2024-06-17
OpenChain Webinar - Open Source Due Diligence for M&A - 2024-06-17OpenChain Webinar - Open Source Due Diligence for M&A - 2024-06-17
OpenChain Webinar - Open Source Due Diligence for M&A - 2024-06-17
 
How GenAI Can Improve Supplier Performance Management.pdf
How GenAI Can Improve Supplier Performance Management.pdfHow GenAI Can Improve Supplier Performance Management.pdf
How GenAI Can Improve Supplier Performance Management.pdf
 
🔥 Kolkata Call Girls  👉 9079923931 👫 High Profile Call Girls Whatsapp Number ...
🔥 Kolkata Call Girls  👉 9079923931 👫 High Profile Call Girls Whatsapp Number ...🔥 Kolkata Call Girls  👉 9079923931 👫 High Profile Call Girls Whatsapp Number ...
🔥 Kolkata Call Girls  👉 9079923931 👫 High Profile Call Girls Whatsapp Number ...
 
Folding Cheat Sheet #5 - fifth in a series
Folding Cheat Sheet #5 - fifth in a seriesFolding Cheat Sheet #5 - fifth in a series
Folding Cheat Sheet #5 - fifth in a series
 
TheFutureIsDynamic-BoxLang-CFCamp2024.pdf
TheFutureIsDynamic-BoxLang-CFCamp2024.pdfTheFutureIsDynamic-BoxLang-CFCamp2024.pdf
TheFutureIsDynamic-BoxLang-CFCamp2024.pdf
 
Introduction to Python and Basic Syntax.pptx
Introduction to Python and Basic Syntax.pptxIntroduction to Python and Basic Syntax.pptx
Introduction to Python and Basic Syntax.pptx
 
🔥 Chennai Call Girls  👉 6350257716 👫 High Profile Call Girls Whatsapp Number ...
🔥 Chennai Call Girls  👉 6350257716 👫 High Profile Call Girls Whatsapp Number ...🔥 Chennai Call Girls  👉 6350257716 👫 High Profile Call Girls Whatsapp Number ...
🔥 Chennai Call Girls  👉 6350257716 👫 High Profile Call Girls Whatsapp Number ...
 
Call Girls in Varanasi || 7426014248 || Quick Booking at Affordable Price
Call Girls in Varanasi || 7426014248 || Quick Booking at Affordable PriceCall Girls in Varanasi || 7426014248 || Quick Booking at Affordable Price
Call Girls in Varanasi || 7426014248 || Quick Booking at Affordable Price
 
119321250-History-of-Computer-Programming.ppt
119321250-History-of-Computer-Programming.ppt119321250-History-of-Computer-Programming.ppt
119321250-History-of-Computer-Programming.ppt
 
Going AOT: Everything you need to know about GraalVM for Java applications
Going AOT: Everything you need to know about GraalVM for Java applicationsGoing AOT: Everything you need to know about GraalVM for Java applications
Going AOT: Everything you need to know about GraalVM for Java applications
 
Enhancing non-Perl bioinformatic applications with Perl
Enhancing non-Perl bioinformatic applications with PerlEnhancing non-Perl bioinformatic applications with Perl
Enhancing non-Perl bioinformatic applications with Perl
 
Trailhead Talks_ Journey of an All-Star Ranger .pptx
Trailhead Talks_ Journey of an All-Star Ranger .pptxTrailhead Talks_ Journey of an All-Star Ranger .pptx
Trailhead Talks_ Journey of an All-Star Ranger .pptx
 

white paper : School Management System

  • 1. School Management System Introduction This software was built for a very prominent private school. The school already used an accounting and time table generation software with some excellent feature. But the user interface was complex and it did not provide certain important features or integration needed by the school. We developed a set of applications to work on data form the accounting software and also incorporate many additional modules to fulfill the requirements. Objectives  Understand requirements of eight departments Develop modules accordingly  Study database structure if accounting software and sync data  Provide attendance mechanism  Sync all lesson and other entries with exchange accounts of staff and students  Provide the user interface in school’s SharePoint portal Migrate certain data from last two years into the system Challenges  Understanding a 3rd party database without any documentation and solely on explanation of functions provided by IT team  Synchronizing with 3rd party database without causing issue with it  Providing an ASP.NET application inside a SharePoint portal Synchronizing Exchange calendar of all staff and students with their calendar information  A very diverse set of excel files used by departments to be migrated into the database
  • 2. Solution A detailed study of 3rd party database was done by profiling and observing behavior of data against functions in the software. Based on this a sync mechanism was designed to fetch necessary data into application database and also push required data back. So as to host the solution in SharePoint portal, a generic web part was created to render ASP.NET user controls. This was needed to reduce the cost of development and debugging of the application. The project lead met with members of departments to understand the data they were managing in excel files and how to best create features to give and much better and integrated user experience. Exchange integration was done using EWS and the client library Microsoft provides. A sync application was created which reads lesson and other schedules from the database and created, updated and removed entries for Exchange calendars. A “control panel” was provided to monitor and manage both sync services. Data migration was done in two steps. First all data from all files of each department was gathered in an intermediate database table and verified. Then the same was transformed and imported into system database through an application written specifically for the job. Technology Stack  .Net framework 4.0 with C#  ASP.NET Web services  Windows services  EWS Managed API  SQL Server 2008 R2 and SQL Profiler  Exchange Server 2007
  翻译: