Beispiel #1
0
        public int AddTestimonial(TestimonialsModel objTestimonial, HttpPostedFileBase file)
        {
            if (file != null)
            {
                MemoryStream target = new MemoryStream();
                file.InputStream.CopyTo(target);
                objTestimonial.PatientImage = target.ToArray();
            }

            objTestimonial.CreatedDate = DateTime.Now.Date;
            objTestimonial.UpdatedDate = DateTime.Now.Date;
            objTestimonial.IsActive    = true;
            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                try
                {
                    Testimonial testimonial = new Testimonial();
                    objTestimonial.CopyProperties(testimonial);
                    db.Testimonials.Add(testimonial);
                    return(db.SaveChanges());
                }
                catch (Exception ex)
                {
                    return(0);

                    throw ex;
                }
            }
        }
Beispiel #2
0
 public int AddEmployee(EmployeeModel employee, HttpPostedFileBase file)
 {
     if (file != null)
     {
         MemoryStream ms = new MemoryStream();
         file.InputStream.CopyTo(ms);
         employee.Image = ms.ToArray();
     }
     employee.CreatedDate = DateTime.Now.Date;
     employee.UpdatedDate = DateTime.Now.Date;
     employee.IsActive    = true;
     using (PhysioDevEntities db = new PhysioDevEntities())
     {
         try
         {
             Employee emp = new Employee();
             employee.CopyProperties(emp);
             db.Employees.Add(emp);
             db.SaveChanges();
             return(1);
         }
         catch (Exception)
         {
             return(0);
         }
     }
 }
Beispiel #3
0
        public int AddService(ServicesModel objSerive, HttpPostedFileBase file)
        {
            if (file != null)
            {
                MemoryStream target = new MemoryStream();
                file.InputStream.CopyTo(target);
                objSerive.Image = target.ToArray();
            }

            objSerive.CreatedDate = DateTime.Now.Date;
            objSerive.UpdatedDate = DateTime.Now.Date;
            objSerive.IsActive    = true;
            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                try
                {
                    Service service = new Service();
                    objSerive.CopyProperties(service);
                    db.Services.Add(service);
                    db.SaveChanges();
                    return(1);
                }
                catch (DbEntityValidationException ex)
                {
                    return(0);

                    throw ex;
                }
            }
        }
Beispiel #4
0
        public int CreateHistory(HistoryModel history)
        {
            //History objHistory = new History();
            history.IsActive    = true;
            history.CreatedDate = DateTime.Now.Date;
            history.UpdatedDate = DateTime.Now.Date;

            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                try
                {
                    History obj = new History();
                    history.CopyProperties(obj);
                    db.Histories.Add(obj);
                    db.SaveChanges();
                    return(1);
                }
                catch (Exception ex)
                {
                    return(0);

                    throw ex;
                }
            }
        }
Beispiel #5
0
        public int AddAbout(AboutClinicModel objAbout, HttpPostedFileBase file)
        {
            if (file != null)
            {
                MemoryStream target = new MemoryStream();
                file.InputStream.CopyTo(target);
                objAbout.Image = target.ToArray();
            }

            objAbout.CreatedDate = DateTime.Now.Date;
            objAbout.UpdatedDate = DateTime.Now.Date;
            objAbout.IsActive    = true;
            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                try
                {
                    AboutClinic obj = new AboutClinic();
                    objAbout.CopyProperties(obj);
                    db.AboutClinics.Add(obj);
                    db.SaveChanges();
                    return(1);
                }
                catch (DbEntityValidationException ex)
                {
                    return(0);

                    throw ex;
                }
            }
        }
Beispiel #6
0
 public void RemoveEmoployee(long empId)
 {
     using (PhysioDevEntities db = new PhysioDevEntities())
     {
         var emp = db.Employees.Where(m => m.EmpId == empId).FirstOrDefault();
         emp.IsActive = false;
         db.SaveChanges();
     }
 }
Beispiel #7
0
 public void DeleteHistory(long historyId)
 {
     using (PhysioDevEntities db = new PhysioDevEntities())
     {
         var history = db.Histories.Where(m => m.HistoryId == historyId).FirstOrDefault();
         history.IsActive    = false;
         history.UpdatedDate = DateTime.Now.Date;
         db.SaveChanges();
     }
 }
Beispiel #8
0
 public void DeleteTestimonial(int Id)
 {
     using (PhysioDevEntities db = new PhysioDevEntities())
     {
         var testimonial = db.Testimonials.Where(m => m.Id == Id).FirstOrDefault();
         testimonial.IsActive    = false;
         testimonial.UpdatedDate = DateTime.Now.Date;
         db.SaveChanges();
     }
 }
Beispiel #9
0
 public void DeleteAbout(long AboutId)
 {
     using (PhysioDevEntities db = new PhysioDevEntities())
     {
         var objAbout = db.AboutClinics.Where(m => m.Id == AboutId).FirstOrDefault();
         objAbout.IsActive    = false;
         objAbout.UpdatedDate = DateTime.Now.Date;
         db.SaveChanges();
     }
 }
Beispiel #10
0
 public void DeletePartialPage(long PartialPageId)
 {
     using (PhysioDevEntities db = new PhysioDevEntities())
     {
         var partialPage = db.PartialPages.Where(m => m.PartialPageId == PartialPageId).FirstOrDefault();
         partialPage.IsActive    = false;
         partialPage.UpdatedDate = DateTime.Now.Date;
         db.SaveChanges();
     }
 }
Beispiel #11
0
 public void DeleteService(long ServiceId)
 {
     using (PhysioDevEntities db = new PhysioDevEntities())
     {
         var service = db.Services.Where(m => m.ServiceId == ServiceId).FirstOrDefault();
         service.IsActive    = false;
         service.UpdatedDate = DateTime.Now.Date;
         db.SaveChanges();
     }
 }
Beispiel #12
0
        public EmployeeModel GetEmployee(long?empId)
        {
            EmployeeModel objemp = new EmployeeModel();

            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                var employee = db.Employees.Where(m => m.EmpId == empId).FirstOrDefault();
                employee.CopyProperties(objemp);
            }
            return(objemp);
        }
Beispiel #13
0
        public ServicesModel GetService(long?ServiceId)
        {
            ServicesModel objServicesModel = new ServicesModel();

            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                var service = db.Services.Where(m => m.ServiceId == ServiceId).FirstOrDefault();
                service.CopyProperties(objServicesModel);
            }
            return(objServicesModel);
        }
Beispiel #14
0
        public Models.PartialPageModel GetPartialPage(long?PartialPageId)
        {
            PartialPageModel objPartialPageModel = new PartialPageModel();

            if (PartialPageId != null)
            {
                using (PhysioDevEntities db = new PhysioDevEntities())
                {
                    var partialPage = db.PartialPages.Where(m => m.PartialPageId == PartialPageId).FirstOrDefault();
                    partialPage.CopyProperties(objPartialPageModel);
                }
            }
            return(objPartialPageModel);
        }
Beispiel #15
0
        public Models.PartialPageModel GetPartialByPageCode(string PageCode)
        {
            PartialPageModel objPartialPageModel = new PartialPageModel();

            if (!string.IsNullOrEmpty(PageCode))
            {
                using (PhysioDevEntities db = new PhysioDevEntities())
                {
                    var partialPage = db.PartialPages.Where(m => m.PageCode == PageCode).FirstOrDefault();
                    partialPage.CopyProperties(objPartialPageModel);
                }
            }
            return(objPartialPageModel);
        }
Beispiel #16
0
        public AboutClinicModel GetAbout(long?AboutId)
        {
            AboutClinicModel objAboutClinicModel = new AboutClinicModel();

            if (AboutId != null)
            {
                using (PhysioDevEntities db = new PhysioDevEntities())
                {
                    var about = db.AboutClinics.Where(m => m.Id == AboutId).FirstOrDefault();
                    about.CopyProperties(objAboutClinicModel);
                }
            }
            return(objAboutClinicModel);
        }
Beispiel #17
0
        public HistoryModel GetHistory(long?historyId)
        {
            HistoryModel objhistory = new HistoryModel();

            if (historyId != null)
            {
                using (PhysioDevEntities db = new PhysioDevEntities())
                {
                    var Histor = db.Histories.Where(m => m.HistoryId == historyId).FirstOrDefault();
                    Histor.CopyProperties(objhistory);
                }
            }
            return(objhistory);
        }
        public Photo GetPhoto(int?PhotoId)
        {
            Photo objPhotoModel = new Photo();

            if (PhotoId != null)
            {
                using (PhysioDevEntities db = new PhysioDevEntities())
                {
                    var Photo = db.Galleries.Where(m => m.PhotoId == PhotoId).FirstOrDefault();
                    Photo.CopyProperties(objPhotoModel);
                }
            }

            return(objPhotoModel);
        }
Beispiel #19
0
        public TestimonialsModel GetTestimonial(int?Id)
        {
            TestimonialsModel objTestimonialsModel = new TestimonialsModel();

            if (Id != null)
            {
                using (PhysioDevEntities db = new PhysioDevEntities())
                {
                    var Testimonial = db.Testimonials.Where(m => m.Id == Id).FirstOrDefault();
                    Testimonial.CopyProperties(objTestimonialsModel);
                }
            }

            return(objTestimonialsModel);
        }
Beispiel #20
0
        public List <TestimonialsModel> GetAllTestimonial()
        {
            List <TestimonialsModel> lstTestimonialModel = new List <TestimonialsModel>();

            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                var lstTestimonials = db.Testimonials.Where(m => m.IsActive == true).OrderByDescending(m => m.Id).ToList();
                foreach (var testimonial in lstTestimonials)
                {
                    TestimonialsModel objTestimonial = new TestimonialsModel();
                    testimonial.CopyProperties(objTestimonial);
                    lstTestimonialModel.Add(objTestimonial);
                }
            }
            return(lstTestimonialModel);
        }
Beispiel #21
0
        public List <Models.PartialPageModel> GetAllPartialPage()
        {
            List <PartialPageModel> lstPartialPageModel = new List <PartialPageModel>();

            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                var lstPartials = db.PartialPages.Where(m => m.IsActive == true).ToList();
                foreach (var Partial in lstPartials)
                {
                    PartialPageModel obj = new PartialPageModel();
                    Partial.CopyProperties(obj);
                    lstPartialPageModel.Add(obj);
                }
            }
            return(lstPartialPageModel);
        }
Beispiel #22
0
        public List <EmployeeModel> GetEmployees()
        {
            List <EmployeeModel> lstemp = new List <EmployeeModel>();

            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                var lstemployees = db.Employees.Where(m => m.IsActive == true).ToList();
                foreach (var employee in lstemployees)
                {
                    EmployeeModel objemp = new EmployeeModel();
                    employee.CopyProperties(objemp);
                    lstemp.Add(objemp);
                }
            }
            return(lstemp);
        }
        public List <Photo> GetAllPhoto()
        {
            List <Photo> lstPhotoModel = new List <Photo>();

            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                var lstPhoto = db.Galleries.Where(m => m.IsActive == true).ToList();
                foreach (var photo in lstPhoto)
                {
                    Photo objPhoto = new Photo();
                    photo.CopyProperties(objPhoto);
                    lstPhotoModel.Add(objPhoto);
                }
            }
            return(lstPhotoModel);
        }
Beispiel #24
0
        public List <HistoryModel> GetAllHistories()
        {
            List <HistoryModel> lstalllhistory = new List <HistoryModel>();

            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                var lsthistories = db.Histories.Where(m => m.IsActive == true).OrderByDescending(m => m.HistoryId).ToList();
                foreach (var history in lsthistories)
                {
                    HistoryModel objhistory = new HistoryModel();
                    history.CopyProperties(objhistory);
                    lstalllhistory.Add(objhistory);
                }
            }
            return(lstalllhistory);
        }
Beispiel #25
0
        public List <ServicesModel> GetAllServices()
        {
            List <ServicesModel> lstServicesModel = new List <ServicesModel>();

            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                var lstServices = db.Services.Where(m => m.IsActive == true).OrderByDescending(m => m.ServiceId).ToList();
                foreach (var service in lstServices)
                {
                    ServicesModel objservice = new ServicesModel();
                    service.CopyProperties(objservice);
                    lstServicesModel.Add(objservice);
                }
            }
            return(lstServicesModel);
        }
Beispiel #26
0
        public List <AboutClinicModel> GetAllAbout()
        {
            List <AboutClinicModel> lstAboutClinicModel = new List <AboutClinicModel>();

            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                var lstAbouts = db.AboutClinics.Where(m => m.IsActive == true).OrderByDescending(m => m.Id).ToList();
                foreach (var About in lstAbouts)
                {
                    AboutClinicModel objAbout = new AboutClinicModel();
                    About.CopyProperties(objAbout);
                    lstAboutClinicModel.Add(objAbout);
                }
            }
            return(lstAboutClinicModel);
        }
        public int AddPhoto(Photo objPhoto)
        {
            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                try
                {
                    Gallery gallery = new Gallery();
                    objPhoto.CopyProperties(gallery);
                    db.Galleries.Add(gallery);
                    return(db.SaveChanges());
                }
                catch (Exception ex)
                {
                    return(0);

                    throw ex;
                }
            }
        }
        public int DeletePhoto(int PhotoId)
        {
            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                try
                {
                    var Photo = db.Galleries.Where(m => m.PhotoId == PhotoId).FirstOrDefault();
                    db.Entry(Photo).State = EntityState.Deleted; //Delete forever
                    //galleries.IsActive = false;
                    return(db.SaveChanges());
                }
                catch (Exception ex)
                {
                    return(0);

                    throw ex;
                }
            }
        }
Beispiel #29
0
        public int UpdateAbout(AboutClinicModel objAbout)
        {
            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                objAbout.UpdatedDate = DateTime.Now.Date;

                try
                {
                    AboutClinic objAboutClinic = new AboutClinic();
                    objAbout.CopyProperties(objAboutClinic);
                    db.Entry(objAboutClinic).State = EntityState.Modified;
                    db.SaveChanges();
                    return(1);
                }
                catch (Exception ex)
                {
                    return(0);
                }
            }
        }
        public int UpdatePhoto(Photo objPhoto)
        {
            using (PhysioDevEntities db = new PhysioDevEntities())
            {
                objPhoto.CreatedOn = DateTime.Now.Date;
                try
                {
                    Photo photo = new Photo();
                    objPhoto.CopyProperties(photo);
                    db.Entry(photo).State = EntityState.Modified;
                    return(db.SaveChanges());
                }
                catch (Exception ex)
                {
                    return(0);

                    throw ex;
                }
            }
        }