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;
}
