public StateTypeVo insert(StateTypeVo input)
        {
            using (var db = new MainDb())
            {

                db.stateTypes.Add(input);
                db.SaveChanges();

                return input;
            }
        }
        public StateTypeVo update(StateTypeVo input, int? stateTypeId= null)
        {
            using (var db = new MainDb())
            {

                if (stateTypeId == null)
                    stateTypeId = input.stateTypeId;

                var res = db.stateTypes.FirstOrDefault(e => e.stateTypeId == stateTypeId);

                if (res == null) return null;

                input.created = res.created;
               // input.createdBy = res.createdBy;
                db.Entry(res).CurrentValues.SetValues(input);

                db.SaveChanges();
                return res;

            }
        }