private void LoadDb() { if (database == null) { database = new AccessLayer(HttpContext.Current.Server.MapPath("App_Data\\Sqlite.db3")); } }
/// <summary> /// Enables processing of HTTP Web requests by a custom HttpHandler that implements the <see cref="T:System.Web.IHttpHandler" /> interface. /// </summary> /// <param name="context">An <see cref="T:System.Web.HttpContext" /> object that provides references to the intrinsic server objects (for example, Request, Response, Session, and Server) used to service HTTP requests.</param> public void ProcessRequest(HttpContext context) { try { String url = Convert.ToString(context.Request.Url); this.AccessLayer = new AccessLayer(); switch (context.Request.HttpMethod) { case "GET": Read(context); break; case "POST": Create(context); break; case "PUT": Update(context); break; case "DELETE": Delete(context); break; default: break; } } catch (Exception e) { Console.WriteLine(e.Message); context.Response.Write(e.Message); } }
public IEnumerable <T> GetAll(Expression <Func <T, bool> > filter = null) { if (filter != null) { return(AccessLayer.Set <T>().Where(filter)); } return(DbSet); }
public List <AdditionalUserDetails> GetAdditionalUserDetailsEF(Int32 userID) { var accessLayer = new AccessLayer(); var additonal = accessLayer.GetAdditionalUserDetailsEF(userID); return(additonal.Select(r => new AdditionalUserDetails() { Address = r.Address, Phone = (long)r.PhoneNumber }).ToList()); }
internal static Uri GetAuthenticationUri(Configuration configuration, ServerInfo server) { var uri = AccessLayer.GetImplicitGrantAuthenticationUri( AuthServer, "/oauth/authorize", DemoAppClientId, server.RemoteHostId.ToString(), "", configuration.Alias); return(uri); }
public string RetriveVerificationKeyEF(string email) { var accessLayer = new AccessLayer(); List <EmailVerification> emails = accessLayer.RetriveVerificationKeyEF(email); string code = ""; foreach (EmailVerification item in emails) { code = item.ActivationCode; } return(code); }
public bool CheckDoctorInDBEF(Int32 doctorID, Int32 userID) { var accessLayer = new AccessLayer(); if (accessLayer.CheckDoctorInDBEF(doctorID, userID).Count == 1) { return(true); } else { return(false); } }
public bool CheckCredentialEF(string email, string password) { var accessLayer = new AccessLayer(); var credentials = accessLayer.CheckCredentialEF(email, password); if (credentials.Count == 1) { return(true); } else { return(false); } }
public string GetProfilePictureEF(Int32 userID) { var accessLayer = new AccessLayer(); List <ProfilePicture> profilePic = new List <ProfilePicture>(); profilePic = accessLayer.GetProfilePictureEF(userID); string url = ""; foreach (ProfilePicture item in profilePic) { url = item.PictureURL; } return(url); }
public List <UserDetailsModel> GetUserModelList(string email) { var accessLayer = new AccessLayer(); var credential = accessLayer.GetUserDetailsFromCredentialEF(email); UserDetailsModel user = new UserDetailsModel(); return(credential.Select(r => new UserDetailsModel() { userId = (int)r.UserID, firstName = r.FirstName, lastName = r.LastName, email = r.EmailID, password = r.Password }).ToList()); }
public List <ReportModel> GetReportBasedOnDateEF(string fromDate, string toDate, Int32 userID) { var accessLayer = new AccessLayer(); var reports = accessLayer.GetReportBasedOnDateEF(fromDate, toDate, userID); return(reports.Select(r => new ReportModel() { reportID = (int)r.ReportID, reportType = r.ReportType, date = r.Date, doctor = r.Doctor, hospital = r.Hospital, userID = (int)r.UserID, upload = r.FileURL }).ToList()); }
//Report public List <ReportModel> GetRepotDetailsOfUserEF(Int32 userID) { var accessLayer = new AccessLayer(); var reports = accessLayer.GetRepotDetailsOfUserEF(userID); return(reports.Select(r => new ReportModel() { reportID = (int)r.ReportID, reportType = r.ReportType, date = r.Date, doctor = r.Doctor, hospital = r.Hospital, userID = (int)r.UserID, upload = r.FileURL }).ToList()); }
public List <HospitalForTableModel> GetHospitalEF(Int32 ID) { var accessLayer = new AccessLayer(); var hospitals = accessLayer.GetHospital(ID); return(hospitals.Select(r => new HospitalForTableModel() { HospitalID = (int)r.HospitalID, HospitalName = r.HospitalName, EmailID = r.EmailID, Address = r.Address, Contact1 = (long)r.ContactNumber1, Contact2 = (long)r.ContactNumber2, PrimaryMark = r.PrimaryMark, UserID = (int)r.UserID }).ToList()); }
public static ServerInfo GetServer(string friendlyName) { var connection = ConnectionPreferenceType.CloudOnly; var response = AccessLayer.Discovery( ResourceServer, friendlyName, ref connection, "", TimeSpan.FromSeconds(10d)); return(new ServerInfo { FriendlyName = friendlyName, RemoteHostId = response.RemoteHostId, LocalIp = response.LocalHostIpAddress, }); }
public void UpdateDoctorInEF(DoctorDetailsModel docModel, Int32 userID) { var accessLayer = new AccessLayer(); UserDoctor udModel = new UserDoctor(); udModel.DoctorID = docModel.doctorID; udModel.FirstName = docModel.firstName; udModel.LastName = docModel.lastName; udModel.EmailID = docModel.email; udModel.RelatedHostpital = docModel.relatedHospital; udModel.Specialty = docModel.specialty; udModel.Address = docModel.address; udModel.ContactNumber1 = docModel.contactNumber1; udModel.ContactNumber2 = docModel.contactNumber2; udModel.PrimaryDoctorMark = docModel.primaryDoctorMark; udModel.UserID = docModel.userID; accessLayer.UpdateDoctorInEF(udModel, userID); }
public List <DoctorForTable> GetDoctorListEF(Int32 ID) { var accessLayer = new AccessLayer(); var doctors = accessLayer.GetDoctors(ID); return(doctors.Select(r => new DoctorForTable() { DoctorID = (int)r.DoctorID, FirstName = r.FirstName, LastName = r.LastName, EmailID = r.EmailID, Address = r.Address, Specialty = r.Specialty, RelatedHospital = r.RelatedHostpital, ContactNumber1 = (long)r.ContactNumber1, ContactNumber2 = (long)r.ContactNumber2, PrimaryDoctorMark = r.PrimaryDoctorMark, }).ToList()); }
public void SetToken(Token newToken) { this.token = newToken; // // ACCESS DATA FROM NOAH // this.accessLayer = new AccessLayer( ConnectionHelper.ResourceServer, this.connectedServer.RemoteHostId.ToString(), ConnectionHelper.DemoAppClientId, DemoAppModuleId, token); var registration = this.accessLayer.RegisterApp(this.configuration.Alias, "0.1", "DemoApp"); // // SUCCESSFULL CONNECTION // this.isConnected = true; this.isConnecting = false; Connected(this, EventArgs.Empty); }
//Entity Framework public bool CheckEmailVerificationEF(string email) { List <EmailVerification> emailList = new List <EmailVerification>(); var accessLayer = new AccessLayer(); var emailCheck = accessLayer.CheckEmailVerificationEF(email); bool result = false; emailList = emailCheck.Select(r => new EmailVerification() { EmailID = r.EmailID, VarificationStatus = r.VarificationStatus, ActivationCode = r.ActivationCode }).ToList(); foreach (EmailVerification item in emailList) { if (item.VarificationStatus.Equals("verified")) { result = true; } } return(result); }
public List <string> GetSpecialistEF() { var accessLayer = new AccessLayer(); return(accessLayer.GetSpecialistEF()); }
public async Task SaveChangesAsync() { await AccessLayer.SaveChangesAsync(); }
public void UpdatePrimaryMarkEF(Int32 userID, Int32 hospitalID) { var accessLayer = new AccessLayer(); accessLayer.UpdatePrimaryMarkEF(userID, hospitalID); }
}//Update Doctor Primary Mark public void UpdateDoctorPrimaryMarkEF(Int32 userID, Int32 doctorID) { var accessLayer = new AccessLayer(); accessLayer.UpdateDoctorPrimaryMarkED(userID, doctorID); }
public List <string> GetHospitalForDDLEF(Int32 userID) { var accessLayer = new AccessLayer(); return(accessLayer.GetHospitalForDDLEF(userID)); }
//Enity FrameWork public void SetHospitalDetailsEF(HospitalDetailsModel hospital) { var accessLayer = new AccessLayer(); accessLayer.AddNewHositalEF(hospital); }
public void AddNewReportEF(ReportModel report) { var accessLayer = new AccessLayer(); accessLayer.AddNewReportEF(report); }
public void AddNewDoctorEF(DoctorDetailsModel doctor) { var accessLayer = new AccessLayer(); accessLayer.AddNewDoctorEF(doctor); }
public void UpdateHospitalDetailsEF(HospitalForTableModel hospital) { var accessLayer = new AccessLayer(); accessLayer.UpdateHospitalDetailsEF(hospital); }
public void DeleteDoctorDetailsEF(Int32 doctorID, Int32 userID) { var accessLayer = new AccessLayer(); accessLayer.DeleteDoctorDetailsEF(doctorID, userID); }
public ActionResult Index() { var results = AccessLayer.GetTypeData(); return(View()); }
//EF Verifiaction Status and Key Setup public void SetVerificationKeyEF(string email, string status, string code) { var accessLayer = new AccessLayer(); accessLayer.SetVerificationKeyEF(email, status, code); }