public AppointmentsController(EMSContext context)
{
_context = context;
manager = new AppointmentManager(context);
validator = new AppointmentValidation(context.Appointments);
patientValidator = new PatientValidation(context.Patients);
}
public JsonResult DeleteData(int Id)
{
string retn = String.Empty;
if (!String.IsNullOrEmpty(Id.ToString()))
{
using (EMSContext db = new EMSContext())
{
try
{
var exist = db.ClassFormats.Where(e => e.Id == Id).FirstOrDefault();
if (exist != null)
{
db.ClassFormats.Remove(exist);
db.SaveChanges();
retn = "Success.";
}
else
{
retn = "Format ID is not found.";
}
}
catch
{
retn = "Failed";
}
}
}
else
{
retn = "Failed";
}
return(Json(retn, JsonRequestBehavior.AllowGet));
}
//[HttpPost]
public JsonResult CreateData(Employee employee)
{
string retn = String.Empty;
using (EMSContext db = new EMSContext())
{
try
{
var currentEmp = db.Employees.Where(e => e.Name == employee.Name).FirstOrDefault();
if (currentEmp == null)
{
db.Employees.Add(employee);
db.SaveChanges();
retn = "Success";
}
else
{
retn = "This Name is already exist.";
}
}
catch
{
retn = "Failed";
}
}
return(Json(retn, JsonRequestBehavior.AllowGet));
}
public JsonResult GetDatas(int page = 1, int pageSize = 10, string sortBy = "Name", bool isAsc = true, string search = null)
{
using (EMSContext db = new EMSContext())
{
var results = db.ClassFormats.ToList();
if (!string.IsNullOrWhiteSpace(search))
{
search = search.ToLower();
results = results.Where(x =>
x.Name.ToLower().Contains(search)).ToList();
}
switch (sortBy)
{
case "Name":
results = isAsc ? results.OrderBy(e => e.Name).ToList() : results.OrderByDescending(e => e.Name).ToList();
break;
default:
results = isAsc ? results.OrderBy(e => e.Id).ToList() : results.OrderByDescending(e => e.Id).ToList();
break;
}
var TotalPages = (int)Math.Ceiling((double)results.Count() / pageSize);
results = results
.Skip((page - 1) * pageSize)
.Take(pageSize)
.ToList();
var result = new { TotalPages = TotalPages, Results = results, CurrentPage = page, PageSize = pageSize, Search = search };
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public JsonResult CreateData(Shift model)
{
string retn = String.Empty;
using (EMSContext db = new EMSContext())
{
try
{
var exist = db.Shifts.Where(e => e.ShiftName == model.ShiftName && e.MediumId == model.MediumId && e.InstId == InstId).FirstOrDefault();
if (exist == null)
{
var advanced = new Shift();
advanced.ShiftName = model.ShiftName;
advanced.InstId = InstId;
advanced.MediumId = model.MediumId;
advanced.ModifyId = CurrentUserId;
advanced.ModifyTime = DateTime.Now;
db.Shifts.Add(advanced);
db.SaveChanges();
retn = "Success";
}
else
{
retn = "This Name is already exist.";
}
}
catch
{
retn = "Failed";
}
}
return(Json(retn, JsonRequestBehavior.AllowGet));
}
public JsonResult CreateData(ClassFormat model)
{
//var CurrentUserInstituteId = CommonFunction.CurrentUserInstituteId();
string retn = String.Empty;
using (EMSContext db = new EMSContext())
{
try
{
var exist = db.ClassFormats.Where(e => e.Name == model.Name).FirstOrDefault();
if (exist == null)
{
var advanced = new ClassFormat();
advanced.Name = model.Name;
advanced.ModifyId = CurrentUserId;
advanced.ModifyTime = DateTime.Now;
db.ClassFormats.Add(advanced);
db.SaveChanges();
retn = "Success";
}
else
{
retn = "This Name is already exist.";
}
}
catch
{
retn = "Failed";
}
}
return(Json(retn, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
var db = new EMSContext();
var employees = db.People.Select(x => x.Gender == 'm');
return(View(employees));
}
public JsonResult DeleteData(int id)
{
string retn = String.Empty;
if (!String.IsNullOrEmpty(id.ToString()))
{
using (EMSContext db = new EMSContext())
{
try
{
var emp = db.Employees.Where(e => e.ID == id).FirstOrDefault();
if (emp != null)
{
db.Employees.Remove(emp);
db.SaveChanges();
retn = "Success.";
}
else
{
retn = "Employee ID is not found.";
}
}
catch
{
retn = "Failed";
}
}
}
else
{
retn = "Failed";
}
return(Json(retn, JsonRequestBehavior.AllowGet));
}
public AccountController(ILogger <AccountController> logger, SignInManager <Admin> signInManager, UserManager <Admin> userManager, EMSContext context, IConfiguration configuration)
{
this.logger = logger;
this.signInManager = signInManager;
this.userManager = userManager;
this.context = context;
this.config = configuration;
}
//[HttpPost]
public JsonResult UpdateData(Medium model)
{
string retn = String.Empty;
using (EMSContext db = new EMSContext())
{
try
{
if (model != null && model.Id > 0)
{
var exist = db.Mediums.Where(e => e.Id == model.Id).SingleOrDefault();
if (exist != null)
{
var duplicate = db.Mediums.Where(e => e.Id != model.Id && e.MediumName == model.MediumName && e.InstId == InstId).SingleOrDefault();
if (duplicate == null)
{
exist.Id = model.Id;
exist.InstId = InstId;
exist.MediumName = model.MediumName;
exist.ModifyId = CurrentUserId;
exist.ModifyTime = DateTime.Now;
db.Mediums.Attach(exist);
db.Entry(exist).State = EntityState.Modified;
db.SaveChanges();
//if (selectedShifts != null)
//{
// db.ShiftsMediums.RemoveRange(db.ShiftsMediums.Where(c => c.MediumId == model.Id));
// foreach (string shiftId in selectedShifts)
// {
// var shiftMedium = new ShiftMedium();
// shiftMedium.MediumId = model.Id;
// shiftMedium.ShiftId = Convert.ToInt32(shiftId);
// db.ShiftsMediums.Add(shiftMedium);
// }
// db.SaveChanges();
//}
retn = "Success.";
}
else
{
retn = "This Name Already Exist.";
}
}
else
{
retn = "Medium ID is not found.";
}
}
}
catch
{
retn = "Failed";
}
}
return(Json(retn, JsonRequestBehavior.AllowGet));
}
public UOW(EMSContext _eMSContext)
{
eMSContext = _eMSContext;
MajorsRepository = new MajorsRepository(eMSContext);
SubjectGroupRepository = new SubjectGroupRepository(eMSContext);
University_MajorsRepository = new University_MajorsRepository(eMSContext);
University_Majors_SubjectGroupRepository = new University_Majors_SubjectGroupRepository(eMSContext);
UniversityRepository = new UniversityRepository(eMSContext);
EntityFrameworkManager.ContextFactory = DbContext => eMSContext;
}
public JsonResult GetDatas(int page = 1, int pageSize = 10, string sortBy = "MediumName", bool isAsc = true, string search = null)
{
using (EMSContext db = new EMSContext())
{
var mediums = db.Mediums.Where(e => e.InstId == InstId).ToList();
if (!string.IsNullOrWhiteSpace(search))
{
search = search.ToLower();
mediums = mediums.Where(x =>
x.MediumName.ToLower().Contains(search)).ToList();
}
switch (sortBy)
{
case "MediumName":
mediums = isAsc ? mediums.OrderBy(e => e.MediumName).ToList() : mediums.OrderByDescending(e => e.MediumName).ToList();
break;
default:
mediums = isAsc ? mediums.OrderBy(e => e.Id).ToList() : mediums.OrderByDescending(e => e.Id).ToList();
break;
}
var TotalPages = (int)Math.Ceiling((double)mediums.Count() / pageSize);
mediums = mediums
.Skip((page - 1) * pageSize)
.Take(pageSize)
.ToList();
var mediumShifts = new List <MediumShiftsViewModel>();
foreach (var medium in mediums)
{
var r = new MediumShiftsViewModel
{
Id = medium.Id,
MediumName = medium.MediumName,
};
mediumShifts.Add(r);
}
//Get all the Roles for our users
foreach (var medium in mediumShifts)
{
//medium.ShiftName = db.GetRoles(users.First(s => s.UserName == user.UserName).Id);
medium.ShiftName = (from a in db.Shifts
join b in db.ShiftsMediums on a.Id equals b.ShiftId
where (b.MediumId == medium.Id)
select a.ShiftName).ToList();
}
var result = new { TotalPages = TotalPages, Mediums = mediumShifts, CurrentPage = page, PageSize = pageSize, Search = search };
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetShifts()
{
using (EMSContext db = new EMSContext())
{
var result = db.Shifts.Where(e => e.InstId == InstId).ToList();
if (result != null)
{
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { status = "Failed" }));
}
//[HttpPost]
public JsonResult UpdateData(Institute model)
{
string retn = String.Empty;
using (EMSContext db = new EMSContext())
{
try
{
if (model != null && model.Id > 0)
{
var exist = db.Institutes.Where(e => e.Id == model.Id).SingleOrDefault();
if (exist != null)
{
var duplicate = db.Institutes.Where(e => e.Id != model.Id && e.ShortName == model.ShortName).FirstOrDefault();
if (duplicate == null)
{
exist.Id = model.Id;
exist.Name = model.Name;
exist.ShortName = model.ShortName;
exist.Address = model.Address;
exist.Email = model.Email;
exist.Phone = model.Phone;
exist.Mobile = model.Mobile;
exist.Contact = model.Contact;
exist.IsActive = model.IsActive;
exist.JoinDate = model.JoinDate;
exist.ExpireDate = model.ExpireDate;
exist.ModifyId = CommonFunction.CurrentUserId();
exist.ModifyTime = DateTime.Now;
db.Institutes.Attach(exist);
db.Entry(exist).State = EntityState.Modified;
db.SaveChanges();
retn = "Success.";
}
else
{
retn = "This Short Name Already Exist.";
}
}
else
{
retn = "Institute Id is not found.";
}
}
}
catch
{
retn = "Failed";
}
}
return(Json(retn, JsonRequestBehavior.AllowGet));
}
public JsonResult GetFormats()
{
using (EMSContext db = new EMSContext())
{
var result = db.ClassFormats.ToList();
if (result != null)
{
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { status = "Failed" }));
}
public JsonResult GetMediums()
{
using (EMSContext db = new EMSContext())
{
var results = db.Mediums.Where(e => e.InstId == InstId).ToList();
if (results != null)
{
var result = results.Select(s => new { Id = s.Id, MediumName = s.MediumName }).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { status = "Failed" }));
}
public JsonResult GetData(int?Id)
{
if (Id.HasValue && Id.Value > 0)
{
EMSContext db = new EMSContext();
var result = db.Institutes.Where(e => e.Id == Id.Value).SingleOrDefault();
if (result != null)
{
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { status = "Failed" }));
}
public JsonResult GetInsts()
{
EMSContext db = new EMSContext();
var insts = db.Institutes.ToList();
if (insts != null)
{
return(Json(insts, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("No Result Found.", JsonRequestBehavior.AllowGet));
}
}
private void btn3_Click(object sender, EventArgs e)
{
Student std = new Student();
std.Firstname = txt3.Text;
std.Surname = txt4.Text;
std.Department = combo.Text;
EMSContext _db = new EMSContext();
_db.Students.Add(std);
_db.SaveChanges();
}
public JsonResult GetData(int?id)
{
if (id.HasValue && id.Value > 0)
{
using (EMSContext db = new EMSContext())
{
var result = db.Employees.Where(e => e.ID == id.Value).SingleOrDefault();
if (result != null)
{
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
}
return(Json(new { status = "Failed" }));
}
public JsonResult UpdateData(Shift model)
{
//var CurrentUserInstituteId = CommonFunction.CurrentUserInstituteId();
string retn = String.Empty;
using (EMSContext db = new EMSContext())
{
try
{
if (model != null && model.Id > 0)
{
var exist = db.Shifts.Where(e => e.Id == model.Id).SingleOrDefault();
if (exist != null)
{
var duplicate = db.Shifts.Where(e => e.Id != model.Id && e.ShiftName == model.ShiftName && e.MediumId == model.MediumId && e.InstId == InstId).SingleOrDefault();
if (duplicate == null)
{
exist.Id = model.Id;
exist.InstId = InstId;
exist.MediumId = model.MediumId;
exist.ShiftName = model.ShiftName;
exist.ModifyId = CurrentUserId;
exist.ModifyTime = DateTime.Now;
db.Shifts.Attach(exist);
db.Entry(exist).State = EntityState.Modified;
db.SaveChanges();
retn = "Success.";
}
else
{
retn = "This Name Already Exist.";
}
}
else
{
retn = "Shift ID is not found.";
}
}
}
catch
{
retn = "Failed";
}
}
return(Json(retn, JsonRequestBehavior.AllowGet));
}
//[HttpPost]
public JsonResult CreateData(Medium model)
{
string retn = String.Empty;
using (EMSContext db = new EMSContext())
{
try
{
var exist = db.Mediums.Where(e => e.MediumName == model.MediumName && e.InstId == InstId).FirstOrDefault();
if (exist == null)
{
var advanced = new Medium();
advanced.MediumName = model.MediumName;
advanced.InstId = InstId;
advanced.ModifyId = CurrentUserId;
advanced.ModifyTime = DateTime.Now;
db.Mediums.Add(advanced);
db.SaveChanges();
//if (selectedShifts != null)
//{
// foreach (string shiftId in selectedShifts)
// {
// var shiftMedium = new ShiftMedium();
// shiftMedium.MediumId = advanced.Id;
// shiftMedium.ShiftId = Convert.ToInt32(shiftId);
// db.ShiftsMediums.Add(shiftMedium);
// }
// db.SaveChanges();
//}
retn = "Success";
}
else
{
retn = "This Name is already exist.";
}
}
catch
{
retn = "Failed";
}
}
return(Json(retn, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateData(Class model)
{
string retn = String.Empty;
using (EMSContext db = new EMSContext())
{
try
{
if (model != null && model.Id > 0)
{
var exist = db.Classes.Where(e => e.Id == model.Id).SingleOrDefault();
if (exist != null)
{
var duplicate = db.Classes.Where(e => e.Id != model.Id && e.Name == model.Name && e.FormatId == model.FormatId).SingleOrDefault();
if (duplicate == null)
{
exist.Id = model.Id;
exist.Name = model.Name;
exist.FormatId = model.FormatId;
exist.ModifyId = CurrentUserId;
exist.ModifyTime = DateTime.Now;
db.Classes.Attach(exist);
db.Entry(exist).State = EntityState.Modified;
db.SaveChanges();
retn = "Success.";
}
else
{
retn = "This Name Already Exist.";
}
}
else
{
retn = "Class ID is not found.";
}
}
}
catch
{
retn = "Failed";
}
}
return(Json(retn, JsonRequestBehavior.AllowGet));
}
public UOW(EMSContext _context, ICurrentContext currentContext)
{
context = _context;
DistrictRepository = new DistrictRepository(context);
EthnicRepository = new EthnicRepository(context);
FormRepository = new FormRepository(context, currentContext);
HighSchoolRepository = new HighSchoolRepository(context);
MajorsRepository = new MajorsRepository(context);
ProvinceRepository = new ProvinceRepository(context);
TownRepository = new TownRepository(context);
SubjectGroupRepository = new SubjectGroupRepository(context);
StudentRepository = new StudentRepository(context);
University_MajorsRepository = new University_MajorsRepository(context);
University_Majors_SubjectGroupRepository = new University_Majors_SubjectGroupRepository(context);
UniversityRepository = new UniversityRepository(context);
UserRepository = new UserRepository(context);
EntityFrameworkManager.ContextFactory = DbContext => context;
}
private void btn7_Click(object sender, EventArgs e)
{
EMSContext _db = new EMSContext();
EmailDetail ed = new EmailDetail();
Student std = new Student();
User use = new User();
ed.Email = txt6.Text;
ed.Password = txt7.Text;
//ed.StudentID = Convert.ToInt32(std.StudentID);
//ed.StudentUserID = Convert.ToInt32(use.UserID);
_db.EmailDetails.Add(ed);
_db.SaveChanges();
this.Close();
}
//[HttpPost]
public JsonResult UpdateData(Employee employee)
{
string retn = String.Empty;
using (EMSContext db = new EMSContext())
{
try
{
if (employee != null && employee.ID > 0)
{
var CurrentEmployee = db.Employees.Where(e => e.ID == employee.ID).SingleOrDefault();
if (CurrentEmployee != null)
{
var UpdateEmployee = db.Employees.Where(e => e.ID != employee.ID && e.Name == employee.Name).SingleOrDefault();
if (UpdateEmployee == null)
{
CurrentEmployee.ID = employee.ID;
CurrentEmployee.Name = employee.Name;
CurrentEmployee.Address = employee.Address;
db.Employees.Attach(CurrentEmployee);
db.Entry(CurrentEmployee).State = EntityState.Modified;
db.SaveChanges();
retn = "Success.";
}
else
{
retn = "This Name Already Exist.";
}
}
else
{
retn = "Employee ID is not found.";
}
}
}
catch
{
retn = "Failed";
}
}
return(Json(retn, JsonRequestBehavior.AllowGet));
}
//[HttpPost]
public JsonResult CreateData(Institute model)
{
string retn = String.Empty;
EMSContext db = new EMSContext();
var exist = db.Institutes.Where(e => e.ShortName == model.ShortName).FirstOrDefault();
if (exist == null)
{
string Message, fileName, actualFileName;
Message = fileName = actualFileName = string.Empty;
bool flag = false;
if (Request.Files != null)
{
var file = Request.Files[0];
actualFileName = file.FileName;
fileName = model.ShortName + Path.GetExtension(file.FileName);
int size = file.ContentLength;
}
var advanced = new Institute();
advanced.Name = model.Name;
advanced.ShortName = model.ShortName;
advanced.Address = model.Address;
advanced.Email = model.Email;
advanced.Phone = model.Phone;
advanced.Mobile = model.Mobile;
advanced.Contact = model.Contact;
advanced.IsActive = model.IsActive;
advanced.JoinDate = model.JoinDate;
advanced.ExpireDate = Convert.ToDateTime(model.ExpireDate);
advanced.ModifyId = CommonFunction.CurrentUserId();
advanced.ModifyTime = DateTime.Now;
db.Institutes.Add(advanced);
db.SaveChanges();
retn = "Success";
}
else
{
retn = "This Short Name is already exist.";
}
return(Json(retn, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveFiles(UploadedFile model)
{
string Message, fileName, actualFileName;
Message = fileName = actualFileName = string.Empty;
bool flag = false;
if (Request.Files != null)
{
var file = Request.Files[0];
actualFileName = file.FileName;
fileName = Guid.NewGuid() + Path.GetExtension(file.FileName);
int size = file.ContentLength;
try
{
file.SaveAs(Path.Combine(Server.MapPath("~/images/insts"), fileName));
UploadedFile f = new UploadedFile
{
FileName = actualFileName,
FilePath = fileName,
Description = model.Description,
FileSize = size
};
using (EMSContext dc = new EMSContext())
{
dc.UploadedFiles.Add(f);
dc.SaveChanges();
Message = "File uploaded successfully";
flag = true;
}
}
catch (Exception)
{
Message = "File upload failed! Please try again";
}
}
return(new JsonResult {
Data = new { Message = Message, Status = flag }
});
}
private static async Task CreateDefaultAccountAsync(IHost host)
{
using (IServiceScope scopeFactory = host.Services.CreateScope())
{
IServiceProvider services = scopeFactory.ServiceProvider;
try
{
UserManager <Admin> userManager = services.GetRequiredService <UserManager <Admin> >();
EMSContext context = services.GetRequiredService <EMSContext>();
context.Database.EnsureCreated();
Admin admin = await userManager.FindByNameAsync("admin");
if (admin == null)
{
admin = new Admin
{
UserName = "******",
PasswordChangeRequired = true
};
IdentityResult result = await userManager.CreateAsync(admin, "EMSadmin123");
if (!result.Succeeded)
{
throw new InvalidOperationException("Error creating default user");
}
else
{
var claim = new Claim("PasswordChangeRequired", "true");
await userManager.AddClaimAsync(admin, claim);
}
}
}
catch (Exception e)
{
ILogger <Program> logger = services.GetRequiredService <ILogger <Program> >();
logger.LogError("Error creating default user", e);
}
}
}
public JsonResult GetDatas(int page = 1, int pageSize = 10, string sortBy = "ShiftName", bool isAsc = true, string search = null)
{
using (EMSContext db = new EMSContext())
{
var shifts = db.Shifts.Include(e => e.Medium).Where(e => e.InstId == InstId).ToList();
if (!string.IsNullOrWhiteSpace(search))
{
search = search.ToLower();
shifts = shifts.Where(x =>
x.ShiftName.ToLower().Contains(search)).ToList();
}
switch (sortBy)
{
case "ShiftName":
shifts = isAsc ? shifts.OrderBy(e => e.ShiftName).ToList() : shifts.OrderByDescending(e => e.ShiftName).ToList();
break;
default:
shifts = isAsc ? shifts.OrderBy(e => e.Id).ToList() : shifts.OrderByDescending(e => e.Id).ToList();
break;
}
var TotalPages = (int)Math.Ceiling((double)shifts.Count() / pageSize);
shifts = shifts
.Skip((page - 1) * pageSize)
.Take(pageSize)
.ToList();
var shiftsList = shifts.Select(s => new { Id = s.Id, ShiftName = s.ShiftName, MediumName = s.Medium.MediumName }).ToList();
var result = new { TotalPages = TotalPages, Shifts = shiftsList, CurrentPage = page, PageSize = pageSize, Search = search };
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
