HealthInformationProgram.Data.Repositories.RevisitRepository.Update C# (CSharp) Method

Update() public method

public Update ( lkup_rvisit entity ) : int
entity HealthInformationProgram.Data.Tables.lkup_rvisit
return int
        public int Update(lkup_rvisit entity)
        {
            try
            {
                using ( var ctx = new ClinicDataContext(connString) )
                {
                    var lookupRevisit = new lkup_rvisit();
                    lookupRevisit = ctx.lkup_rvisit.FirstOrDefault(x => x.rvisit_id == entity.rvisit_id);
                    if ( lookupRevisit == null )
                    {
                        throw new Exception("Record doesn't exist and cannot be updated");
                    }
                    // lookupRevisit.rvisit_id = entity.rvisit_id;
                    lookupRevisit.rvisit_descn = entity.rvisit_descn;
                    lookupRevisit.rec_updt_dt = entity.rec_updt_dt;
                    lookupRevisit.rec_updt_user_id_cd = entity.rec_updt_user_id_cd;
                    lookupRevisit.rvisit_ind = entity.rvisit_ind;

                    ctx.Entry(lookupRevisit).State = System.Data.Entity.EntityState.Modified;

                    int result = ctx.SaveChanges();

                    return result;
                }
            }
            catch ( DbEntityValidationException ex )
            {
                throw ex;
            }
            catch ( EntityException ex )
            {
                throw ex;
            }
            catch ( Exception ex )
            {
                throw ex;
            }
        }

Usage Example

Beispiel #1
0
        public int UpdateRevisit(RevisitModel model)
        {
            var repo = new RevisitRepository();
            var dataModel = new HealthInformationProgram.Data.Tables.lkup_rvisit();

            dataModel.rvisit_id = Convert.ToDecimal(model.RevisitId);
            dataModel.rvisit_ind = model.Indicator;
            dataModel.rvisit_descn = model.Description;
            dataModel.user_intrfc_sort_ord = Convert.ToDecimal(model.SortOrder);
            dataModel.rec_updt_dt = DateTime.Now;
            dataModel.rec_updt_user_id_cd = "dbadmin"; //TODO: change to use AD when wired up

            try
            {

                var returnCode = repo.Update(dataModel);
                return returnCode;
            }
            catch ( Exception ex )
            {
                throw ex;
            }
        }