public JsonResult SaveNew(RepDTO dto)
        {
            bool succeeded = false;

            try
            {
                var model = new tbl_rep();

                model.rep_fname    = dto.rep_fname;
                model.rep_lname    = dto.rep_lname;
                model.rep_title    = dto.rep_title;
                model.rep_phone    = dto.rep_phone;
                model.rep_mobile   = dto.rep_mobile;
                model.rep_email    = dto.rep_email;
                model.rep_address1 = dto.rep_address1;
                model.rep_address2 = dto.rep_address2;
                model.rep_city     = dto.rep_city;
                model.rep_state    = dto.rep_state;
                model.rep_zip      = dto.rep_zip;
                model.rep_country  = dto.rep_country;
                model.rep_company  = dto.rep_company;

                UnitOfWork.TblRep.Add(model);

                UnitOfWork.Save();
                dto.id = model.id;
            }
            catch (Exception ex)
            {
                dto.id = 0;
            }
            return(Json(dto, JsonRequestBehavior.AllowGet));
        }
        public JsonResult Update(RepDTO dto)
        {
            bool succeeded = false;

            try
            {
                var model = UnitOfWork.TblRep.Get(dto.id);

                if (model != null)
                {
                    model.rep_fname    = dto.rep_fname;
                    model.rep_lname    = dto.rep_lname;
                    model.rep_title    = dto.rep_title;
                    model.rep_phone    = dto.rep_phone;
                    model.rep_mobile   = dto.rep_mobile;
                    model.rep_email    = dto.rep_email;
                    model.rep_address1 = dto.rep_address1;
                    model.rep_address2 = dto.rep_address2;
                    model.rep_city     = dto.rep_city;
                    model.rep_state    = dto.rep_state;
                    model.rep_zip      = dto.rep_zip;
                    model.rep_country  = dto.rep_country;
                    model.rep_company  = dto.rep_company;
                    UnitOfWork.Save();
                    succeeded = true;
                }
            }
            catch (Exception ex)
            {
                succeeded = false;
            }
            return(Json(succeeded, JsonRequestBehavior.AllowGet));
        }