public List <QuestionBankMaster> GetQuestionBank()
{
var questionBankData = new List <QuestionBankMaster>();
using (var QuizContext = new TestEngineEntities())
{
QuizContext.Configuration.ProxyCreationEnabled = false;
questionBankData = QuizContext.QuestionBankMasters.ToList();
}
return(questionBankData);
}
public APIResponse UploadUserDetail(UsersDetails usersDetails)
{
UsersDetailsModel details = new UsersDetailsModel();
APIResponse response = new APIResponse();
try
{
using (TestEngineEntities testEngineEntities = new TestEngineEntities())
{
UserDetailMaster users = new UserDetailMaster();
users.Id = Guid.NewGuid();
users.UserTitle = usersDetails.UserTitleName;
users.CreatedDate = DateTime.Now;
users.ModifiedDate = DateTime.Now;
users.IsDeleted = false;
testEngineEntities.UserDetailMasters.Add(users);
foreach (var item in usersDetails.UsersDetailsModel)
{
DefaultRegistation defaultRegistation = new DefaultRegistation();
defaultRegistation.ID = Guid.NewGuid();
defaultRegistation.UserDetailId = users.Id;
defaultRegistation.Name = item.Name;
defaultRegistation.Email = item.Email;
defaultRegistation.MobileNumber = item.MobileNumber;
defaultRegistation.Degree = item.Degree;
defaultRegistation.Institution = item.Institution;
defaultRegistation.Major = item.Major;
defaultRegistation.Percentage = item.Percentage;
defaultRegistation.Gender = item.Gender;
defaultRegistation.Address = item.Address;
defaultRegistation.CustomField1 = item.CustomField1;
defaultRegistation.CustomField2 = item.CustomField2;
defaultRegistation.CustomField3 = item.CustomField3;
defaultRegistation.CustomField4 = item.CustomField4;
defaultRegistation.CustomField5 = item.CustomField5;
defaultRegistation.CustomField6 = item.CustomField6;
defaultRegistation.CustomField7 = item.CustomField7;
defaultRegistation.CustomField8 = item.CustomField8;
defaultRegistation.CustomField9 = item.CustomField9;
defaultRegistation.CustomField10 = item.CustomField10;
testEngineEntities.DefaultRegistations.Add(defaultRegistation);
}
testEngineEntities.SaveChanges();
response.Result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public List <AdminDetail> GetAdminDetail()
{
List <AdminDetail> adminDetails = new List <AdminDetail>();
try
{
using (TestEngineEntities TestEngineDBContext = new TestEngineEntities())
{
adminDetails = TestEngineDBContext.AdminDetails.Where(x => x.IsSuperAdmin == false).ToList();
}
}
catch (Exception ex)
{
}
return(adminDetails);
}
public List <DefaultRegistation> GetUsersDetailList(Guid?UserDetailId)
{
List <DefaultRegistation> details = new List <DefaultRegistation>();
APIResponse response = new APIResponse();
try
{
using (TestEngineEntities testEngineEntities = new TestEngineEntities())
{
details = testEngineEntities.DefaultRegistations.Where(x => x.UserDetailId == UserDetailId).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(details);
}
public List <UserDetailMaster> GetUsersList()
{
List <UserDetailMaster> details = new List <UserDetailMaster>();
APIResponse response = new APIResponse();
try
{
using (TestEngineEntities testEngineEntities = new TestEngineEntities())
{
details = testEngineEntities.UserDetailMasters.Where(x => x.IsDeleted == false).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(details);
}
public string SaveAdminDetails(AdminDetail adminDetail)
{
string result = Failed;
try
{
using (TestEngineEntities TestEngineDBContext = new TestEngineEntities())
{
var admin = TestEngineDBContext.AdminDetails.FirstOrDefault(x => x.ID == adminDetail.ID);
if (admin == null)
{
admin = new AdminDetail();
admin.CreatedDate = DateTime.Now;
admin.Email = adminDetail.Email;
admin.ID = Guid.NewGuid();
admin.Isdeleted = false;
admin.ModifiedDate = DateTime.Now;
admin.Password = adminDetail.Password;
admin.PhoneNumber = adminDetail.PhoneNumber;
admin.Role = adminDetail.Role;
admin.Name = adminDetail.Name;
admin.IsSuperAdmin = false;
TestEngineDBContext.AdminDetails.Add(admin);
}
else
{
admin.Email = adminDetail.Email;
admin.ModifiedDate = DateTime.Now;
admin.Password = adminDetail.Password;
admin.PhoneNumber = adminDetail.PhoneNumber;
admin.Role = adminDetail.Role;
admin.UserName = adminDetail.UserName;
admin.Name = adminDetail.Name;
}
TestEngineDBContext.SaveChanges();
result = Success;
}
}
catch (Exception ex)
{
}
return(result);
}
public string ValidateUser(string username, string password)
{
string result = Failed;
try
{
using (TestEngineEntities TestEngineDBContext = new TestEngineEntities())
{
var adminUserDetails = TestEngineDBContext.AdminDetails.FirstOrDefault(x => x.UserName == username && x.Password == password && x.Isdeleted == false);
if (adminUserDetails != null)
{
result = Success;
}
}
}
catch (Exception ex)
{
}
return(result);
}
public DashBoardDetailsView GetDashBoard(DashBoardRange range)
{
DashBoardDetailsView dashBoardDetailsView = new DashBoardDetailsView();
try
{
using (TestEngineEntities TestEngineDBContext = new TestEngineEntities())
{
var x = TestEngineDBContext.QuestionBankMasters.ToList();
var dashBoardDetails = TestEngineDBContext.Database.SqlQuery <DashBoardDetailsView>("Exec GetDashBoardDetails @StarDatetime,@EndDatetime"
, new SqlParameter("@StarDatetime", range.StartDatetime)
, new SqlParameter("@EndDatetime", range.EndDatetime)
).ToList();
dashBoardDetailsView = dashBoardDetails.FirstOrDefault();
}
}
catch (Exception)
{
}
return(dashBoardDetailsView);
}
public string DeleteAdmin(string id)
{
string result = Failed;
try
{
Guid adminID = new Guid(id);
using (TestEngineEntities TestEngineDBContext = new TestEngineEntities())
{
var admin = TestEngineDBContext.AdminDetails.FirstOrDefault(x => x.ID == adminID);
if (admin != null)
{
admin.ModifiedDate = DateTime.Now;
admin.Isdeleted = true;
TestEngineDBContext.SaveChanges();
result = Success;
}
}
}
catch (Exception ex)
{
}
return(result);
}
