private bool IsExist(LabDetailModel model)
        {
            try
            {
                Expression <Func <LabDetail, bool> > predicate = null;

                using (var db = new HMSEntities())
                {
                    /* Build Predicate according to Create or Update */
                    if (!model.Id.HasValue)
                    {
                        predicate = o => o.Name == model.Name && o.IsActive == true && o.IsDeleted == false;//for Create Record
                    }
                    else
                    {
                        predicate = o => o.Name == model.Name && o.Id != model.Id && o.IsActive == true && o.IsDeleted == false;//for Update Record Record
                    }

                    /* return is Exist or not */
                    if (db.LabDetails.Any(predicate))
                    {
                        return(true);
                    }
                    else
                    {
                        return(false);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        private void FillFormData(Guid?id)
        {
            try
            {
                LabDetailModel model = service.GetById(id.Value);
                if (model != null)
                {
                    LabDetailOperations frm = new LabDetailOperations(model.Id);
                    frm.txtFullName.Text    = model.Name;
                    frm.txtAddress.Text     = model.Address;
                    frm.txtPathalogist.Text = model.PathelogistName;
                    frm.txtPhoneNumber.Text = model.PhoneNumber;
                    frm.chkInHouse.Checked  = model.IsInHouse.HasValue ? model.IsInHouse.Value : false;
                    frm.ShowDialog();
                    if (isSubmited)
                    {
                        Search();
                    }

                    isSubmited = false;
                }
            }
            catch (Exception ex)
            {
                isSubmited = false;
                Utility.ErrorLog.Logging("Lab List", ex.Message.ToString(), ex.StackTrace.ToString());
            }
        }
        public LabDetailModel GetById(Guid id)
        {
            try
            {
                LabDetailModel model = new LabDetailModel();
                using (var db = new HMSEntities())
                {
                    LabDetail entity = db.LabDetails.Find(id);
                    if (entity != null)
                    {
                        model.Id              = entity.Id;
                        model.Name            = entity.Name;
                        model.PathelogistName = entity.PathelogistName;
                        model.Address         = entity.Address;
                        model.PhoneNumber     = entity.PhoneNumber;
                        model.IsInHouse       = entity.IsInHouse;
                        model.IsActive        = entity.IsActive;
                        model.IsDeleted       = entity.IsDeleted;
                        model.CreatedOn       = entity.CreatedOn;
                        model.CreatedBy       = entity.CreatedBy;
                        model.ModifiedOn      = entity.ModifiedOn;
                        model.ModifiedBy      = entity.ModifiedBy;
                    }
                }

                return(model);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public bool Update(LabDetailModel model)
        {
            try
            {
                bool isSaved = false;

                if (!IsExist(model))
                {
                    using (var db = new HMSEntities())
                    {
                        //UpdateAllSequence(model.Id, model.Sequence.Value, model.PerentId);
                        LabDetail entity = db.LabDetails.Find(model.Id);
                        entity.Name            = model.Name;
                        entity.PathelogistName = model.PathelogistName;
                        entity.Address         = model.Address;
                        entity.PhoneNumber     = model.PhoneNumber;
                        entity.IsInHouse       = model.IsInHouse.HasValue ? model.IsInHouse.Value : false;
                        entity.ModifiedOn      = DateTime.Now;
                        entity.ModifiedBy      = UserDetailSession.Id;

                        db.SaveChanges();

                        isSaved = true;
                    }
                }


                return(isSaved);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public LabDetailModel GetByName(string name)
        {
            try
            {
                LabDetailModel model = new LabDetailModel();
                using (var db = new HMSEntities())
                {
                    LabDetail entity = db.LabDetails.FirstOrDefault(t => t.Name == name);
                    if (entity != null)
                    {
                        model.Id              = entity.Id;
                        model.Name            = entity.Name;
                        model.PathelogistName = entity.PathelogistName;
                        model.Address         = entity.Address;
                        model.PhoneNumber     = entity.PhoneNumber;
                        model.IsActive        = entity.IsActive;
                        model.IsDeleted       = entity.IsDeleted;
                        model.CreatedOn       = entity.CreatedOn;
                        model.CreatedBy       = entity.CreatedBy;
                        model.ModifiedOn      = entity.ModifiedOn;
                        model.ModifiedBy      = entity.ModifiedBy;
                    }
                }

                return(model);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 6
0
 private bool saveData()
 {
     try
     {
         LabDetailModel model = assignModel();
         if (model != null)
         {
             if (this.currentUserId.HasValue)
             {
                 return(service.Update(model));
             }
             else
             {
                 return(service.Create(model));
             }
         }
         else
         {
             return(false);
         }
     }
     catch (Exception ex)
     {
         ErrorLog.Logging("Lab Details", ex.Message.ToString(), ex.StackTrace.ToString());
         return(false);
     }
 }
Esempio n. 7
0
 public bool Update(LabDetailModel model)
 {
     try
     {
         LabDetail entity = new LabDetail();
         return(entity.Update(model));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 8
0
        private LabDetailModel assignModel()
        {
            LabDetailModel model = new LabDetailModel();

            try
            {
                model.Id              = this.currentUserId;
                model.Name            = txtFullName.Text;
                model.PathelogistName = txtPathalogist.Text;
                model.PhoneNumber     = txtPhoneNumber.Text;
                model.Address         = txtAddress.Text;
                model.IsInHouse       = chkInHouse.Checked;

                return(model);
            }
            catch (Exception ex)
            {
                ErrorLog.Logging("Lab Details", ex.Message.ToString(), ex.StackTrace.ToString());
                return(null);
            }
        }
        public bool Create(LabDetailModel model)
        {
            try
            {
                bool isSaved = false;

                if (!IsExist(model))
                {
                    using (var db = new HMSEntities())
                    {
                        LabDetail entity = new LabDetail();

                        entity.Name            = model.Name;
                        entity.PathelogistName = model.PathelogistName;
                        entity.Address         = model.Address;
                        entity.PhoneNumber     = model.PhoneNumber;
                        entity.IsInHouse       = model.IsInHouse.HasValue ? model.IsInHouse.Value : false;
                        entity.IsActive        = true;
                        entity.IsDeleted       = false;
                        entity.CreatedOn       = DateTime.Now;
                        entity.CreatedBy       = UserDetailSession.Id;

                        db.LabDetails.Add(entity);
                        db.SaveChanges();

                        isSaved = true;
                    }
                }


                return(isSaved);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }