public HttpResponseMessage Post([FromBody] Division d) { try { Division div = new Division(); div.Name = d.Name; if (d != null) { using (var context = new StudentManagementContext()) { context.Divisions.Add(div); context.SaveChanges(); return(new HttpResponseMessage(HttpStatusCode.OK)); } } else { return(new HttpResponseMessage(HttpStatusCode.Unauthorized)); } } catch (Exception e) { return(new HttpResponseMessage(HttpStatusCode.Unauthorized)); } }
public void Setup() { var logindetails = new List <LoginCredentials> { new LoginCredentials { UserName = "******", Password = "******", Role = "Admin" }, new LoginCredentials { UserName = "******", Password = "******", Role = "Teacher" }, new LoginCredentials { UserName = "******", Password = "******", Role = "Student" } }; var logindata = logindetails.AsQueryable(); var mockSetLogin = new Mock <DbSet <LoginCredentials> >(); mockSetLogin.As <IQueryable <LoginCredentials> >().Setup(m => m.Provider).Returns(logindata.Provider); mockSetLogin.As <IQueryable <LoginCredentials> >().Setup(m => m.Expression).Returns(logindata.Expression); mockSetLogin.As <IQueryable <LoginCredentials> >().Setup(m => m.ElementType).Returns(logindata.ElementType); mockSetLogin.As <IQueryable <LoginCredentials> >().Setup(m => m.GetEnumerator()).Returns(logindata.GetEnumerator()); var mockContext = new Mock <StudentManagementContext>(); mockContext.Setup(c => c.LoginCredentials).Returns(mockSetLogin.Object); db = mockContext.Object; }
public IEnumerable <Division> Get() { using (var context = new StudentManagementContext()) { return(context.Divisions.ToList()); } }
public HttpResponseMessage Edit([FromBody] Student s) { using (var context = new StudentManagementContext()) { try { if (s != null) { Student stu = new Student(); stu = context.Students.Find(s.Id); stu.RollNumber = s.RollNumber; stu.Fullname = s.Fullname; stu.Attendance = s.Attendance; stu.DivisionId = s.DivisionId; stu.Standard = s.Standard; stu.Gpa = s.Gpa; stu.DateOfBirth = s.DateOfBirth; stu.IsActive = s.IsActive; context.SaveChanges(); return(new HttpResponseMessage(HttpStatusCode.OK)); } else { return(new HttpResponseMessage(HttpStatusCode.Unauthorized)); } } catch { return(new HttpResponseMessage(HttpStatusCode.Unauthorized)); } } }
public IEnumerable <Student> Get() { using (var context = new StudentManagementContext()) { return(context.Students.ToList()); } }
public void Setup() { var marksdetails = new List <MarksDetails> { new MarksDetails { Id = 1, CurrentYear = 1, Sem1 = 20, Sem2 = 20, Sem3 = 20, Sem4 = 20, Sem5 = 20, Sem6 = 20, Sem7 = 20, Sem8 = 20, TotalMaxMarks = 400, TotalObtainedMarks = 160, Percentage = 40 }, new MarksDetails { Id = 2, CurrentYear = 2, Sem1 = 30, Sem2 = 30, Sem3 = 30, Sem4 = 30, Sem5 = 30, Sem6 = 30, Sem7 = 30, Sem8 = 30, TotalMaxMarks = 400, TotalObtainedMarks = 240, Percentage = 48 }, new MarksDetails { Id = 3, CurrentYear = 3, Sem1 = 40, Sem2 = 40, Sem3 = 40, Sem4 = 40, Sem5 = 40, Sem6 = 40, Sem7 = 40, Sem8 = 40, TotalMaxMarks = 400, TotalObtainedMarks = 320, Percentage = 64 }, new MarksDetails { Id = 4, CurrentYear = 4, Sem1 = 50, Sem2 = 50, Sem3 = 50, Sem4 = 50, Sem5 = 50, Sem6 = 50, Sem7 = 50, Sem8 = 50, TotalMaxMarks = 400, TotalObtainedMarks = 400, Percentage = 100 } }; var marksdata = marksdetails.AsQueryable(); var mockSetMarks = new Mock <DbSet <MarksDetails> >(); mockSetMarks.As <IQueryable <MarksDetails> >().Setup(m => m.Provider).Returns(marksdata.Provider); mockSetMarks.As <IQueryable <MarksDetails> >().Setup(m => m.Expression).Returns(marksdata.Expression); mockSetMarks.As <IQueryable <MarksDetails> >().Setup(m => m.ElementType).Returns(marksdata.ElementType); mockSetMarks.As <IQueryable <MarksDetails> >().Setup(m => m.GetEnumerator()).Returns(marksdata.GetEnumerator()); var mockContext = new Mock <StudentManagementContext>(); mockContext.Setup(c => c.MarksDetails).Returns(mockSetMarks.Object); db = mockContext.Object; }
private async void btnSave_Click(object sender, EventArgs e) { var id = txtIdNo.Text; var name = txtFullName.Text; var address = txtAddress.Text; var contactNo = txtContact.Text; var email = txtEmail.Text; var dateOfJoin = dateTimePicker.Text; var gpa = txtGPA.Text; using (var context = new StudentManagementContext()) { var emp = new Student(id, name, address, contactNo, email, dateOfJoin, gpa); context.Employees.Add(emp); await context.SaveChangesAsync(); } //instance event args and value has been passed var args = new IdentityEventArgs(id, name, address, contactNo, email, dateOfJoin, gpa); //Event has be raised with update arguments of delegate IdentityUpdated?.Invoke(this, args); this.Hide(); }
public void GetEmployees() { using (var context = new StudentManagementContext()) { List <Student> employees = context.Employees.ToList <Student>(); if (employees.Count > 1) { foreach (Student emp in employees) { var count = dataGridView.Rows.Count - 1; dataGridView.Rows.Add(); dataGridView.Rows[count].Cells[0].Value = emp.EmployeeID; dataGridView.Rows[count].Cells[1].Value = emp.FullName; dataGridView.Rows[count].Cells[2].Value = emp.Address; dataGridView.Rows[count].Cells[3].Value = emp.Contact; dataGridView.Rows[count].Cells[4].Value = emp.Email; dataGridView.Rows[count].Cells[5].Value = emp.Designation; dataGridView.Rows[count].Cells[6].Value = emp.Department; dataGridView.Rows[count].Cells[7].Value = emp.DateOfJoin; dataGridView.Rows[count].Cells[8].Value = emp.WageRate; dataGridView.Rows[count].Cells[9].Value = emp.WorkedHour; count++; } } } }
public void Setup() { var details = new List <BasicDetails> { new BasicDetails { Id = 1, Name = "Dummy1", Gender = "Male", Address = "Dummy Address 1", DateOfBirth = DateTime.Parse("11/23/2010"), Phone = "1122334455", Email = "*****@*****.**", Course = "course1", CourseDuration = 4, FeeStatus = "Paid" }, new BasicDetails { Id = 2, Name = "Dummy2", Gender = "Female", Address = "Dummy Address 2", DateOfBirth = DateTime.Parse("12/28/2010"), Phone = "2233445566", Email = "*****@*****.**", Course = "course2", CourseDuration = 3, FeeStatus = "Due" }, new BasicDetails { Id = 3, Name = "Dummy3", Gender = "Male", Address = "Dummy Address 3", DateOfBirth = DateTime.Parse("05/14/2010"), Phone = "3344556677", Email = "*****@*****.**", Course = "course1", CourseDuration = 4, FeeStatus = "Paid" }, new BasicDetails { Id = 4, Name = "Dummy4", Gender = "Female", Address = "Dummy Address 4", DateOfBirth = DateTime.Parse("08/10/2010"), Phone = "4455667788", Email = "*****@*****.**", Course = "course2", CourseDuration = 3, FeeStatus = "Due" } }; var marksdetails = new List <MarksDetails> { new MarksDetails { Id = 1, CurrentYear = 1, Sem1 = 20, Sem2 = 20, Sem3 = 20, Sem4 = 20, Sem5 = 20, Sem6 = 20, Sem7 = 20, Sem8 = 20, TotalMaxMarks = 400, TotalObtainedMarks = 160, Percentage = 40 }, new MarksDetails { Id = 2, CurrentYear = 2, Sem1 = 30, Sem2 = 30, Sem3 = 30, Sem4 = 30, Sem5 = 30, Sem6 = 30, Sem7 = 30, Sem8 = 30, TotalMaxMarks = 400, TotalObtainedMarks = 240, Percentage = 48 }, new MarksDetails { Id = 3, CurrentYear = 3, Sem1 = 40, Sem2 = 40, Sem3 = 40, Sem4 = 40, Sem5 = 40, Sem6 = 40, Sem7 = 40, Sem8 = 40, TotalMaxMarks = 400, TotalObtainedMarks = 320, Percentage = 64 }, new MarksDetails { Id = 4, CurrentYear = 4, Sem1 = 50, Sem2 = 50, Sem3 = 50, Sem4 = 50, Sem5 = 50, Sem6 = 50, Sem7 = 50, Sem8 = 50, TotalMaxMarks = 400, TotalObtainedMarks = 400, Percentage = 100 } }; var detaildata = details.AsQueryable(); var mockSet = new Mock <DbSet <BasicDetails> >(); mockSet.As <IQueryable <BasicDetails> >().Setup(m => m.Provider).Returns(detaildata.Provider); mockSet.As <IQueryable <BasicDetails> >().Setup(m => m.Expression).Returns(detaildata.Expression); mockSet.As <IQueryable <BasicDetails> >().Setup(m => m.ElementType).Returns(detaildata.ElementType); mockSet.As <IQueryable <BasicDetails> >().Setup(m => m.GetEnumerator()).Returns(detaildata.GetEnumerator()); var mockContext = new Mock <StudentManagementContext>(); mockContext.Setup(c => c.BasicDetails).Returns(mockSet.Object); var marksdata = marksdetails.AsQueryable(); var mockSetMarks = new Mock <DbSet <MarksDetails> >(); mockSetMarks.As <IQueryable <MarksDetails> >().Setup(m => m.Provider).Returns(marksdata.Provider); mockSetMarks.As <IQueryable <MarksDetails> >().Setup(m => m.Expression).Returns(marksdata.Expression); mockSetMarks.As <IQueryable <MarksDetails> >().Setup(m => m.ElementType).Returns(marksdata.ElementType); mockSetMarks.As <IQueryable <MarksDetails> >().Setup(m => m.GetEnumerator()).Returns(marksdata.GetEnumerator()); //var mockContext = new Mock<StudentManagementContext>(); mockContext.Setup(c => c.MarksDetails).Returns(mockSetMarks.Object); db = mockContext.Object; }
public List <Student> Get(int id) { using (var context = new StudentManagementContext()) { List <Student> res = new List <Student>(); Student result = new Student(); result = context.Students.Find(id); res.Add(result); if (result == null) { return(null); } return(res); } }
public HttpResponseMessage Delete([FromBody] int id) { using (var context = new StudentManagementContext()) { Student stu = new Student(); stu = context.Students.Find(id); if (stu == null) { return(new HttpResponseMessage(HttpStatusCode.Unauthorized)); } context.Students.Remove(stu); context.SaveChanges(); return(new HttpResponseMessage(HttpStatusCode.OK)); } }
public StudentManagementManualTests() { // get test json config var configBuilder = new ConfigurationBuilder() .AddJsonFile("./appsettings.json", optional: false, reloadOnChange: true); Configuration = configBuilder.Build(); var conn = Configuration.GetConnectionString("SchoolDatabase"); var builder = new DbContextOptionsBuilder <StudentManagementContext>(); builder.UseSqlServer(conn); var opts = builder.Options; Cntx = new StudentManagementContext(opts); Repo = new StudentRepository(Cntx); }
public GenericRepository(StudentManagementContext context) { _studentRepositoryContext = context; }
public async void ImportEmployeeFromCsv() { using (var openFileDialog1 = new OpenFileDialog() { Filter = "CSV|*.csv", ValidateNames = true, Multiselect = false }) { if (openFileDialog1.ShowDialog() != DialogResult.OK) { return; } const char sepChar = ','; const char quoteChar = '"'; var employeeList = new List <string[]>(); try { using (Stream stream = null) { var rows = File.ReadAllLines(openFileDialog1.FileName); foreach (var csvRow in rows) { var inQuotes = false; var fields = new List <string>(); var field = ""; for (var i = 0; i < csvRow.Length; i++) { if (inQuotes) { if (i < csvRow.Length - 1 && csvRow[i] == quoteChar && csvRow[i + 1] == quoteChar) { i = i++; field += quoteChar; } else if (csvRow[i] == quoteChar) { inQuotes = false; } else { if (csvRow[i - 1] == quoteChar) { field = ""; field += csvRow[i]; } else { field += csvRow[i]; } } } else { if (csvRow[i] == quoteChar) { inQuotes = true; } if (csvRow[i] == sepChar) { fields.Add(field); field = ""; } else { field += csvRow[i]; } } } if (!string.IsNullOrEmpty(field)) { fields.Add(field); field = ""; } employeeList.Add(fields.ToArray()); } } } catch (Exception er) { MessageBox.Show(er.Message, "Error !", MessageBoxButtons.OK, MessageBoxIcon.Error); } foreach (var value in employeeList) { using (var context = new StudentManagementContext()) { dataGridView.Rows.Add(value[0], value[1], value[2], value[3], value[4], value[5], value[6], value[7], value[8], value[9]); var emp = new Student(value[0], value[1], value[2], value[3], value[4], value[5], value[6], value[7], value[8], value[9]); context.Employees.Add(emp); try { await context.SaveChangesAsync(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error !", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } }
public UnitOfWork(StudentManagementContext studentManagementContext) { _studentManagementContext = studentManagementContext; }
public Student(StudentManagementContext _db) { db = _db; }
public HomeController(StudentManagementContext context, IConfiguration config) { db = context; _config = config; _log4net = log4net.LogManager.GetLogger(typeof(HomeController)); }
public UserRepository(StudentManagementContext context) : base(context) { }
public LoginController(StudentManagementContext _db) { db = _db; _log4net = log4net.LogManager.GetLogger(typeof(LoginController)); }
public Admin(StudentManagementContext _db) { db = _db; }
public ResourceRepository(StudentManagementContext context) : base(context) { }
public CountryCodeRepository(StudentManagementContext context) : base(context) { }
public Teacher(StudentManagementContext _db) { db = _db; }