public void AddEndorsementStatusRejDAL(string policynum)
 {
     try
     {
         Endorsement end = sq.Endorsements.Where(x => x.Policynumber == policynum).OrderByDescending(x => x.TransactionId).First();
         end.EndorsementStatus = "Changes Rejected";
         sq.SaveChanges();
     }
     catch (Exception)
     {
         throw;
     }
 }
        public bool AddEndorsementDAL(Endorsement end)
        {
            bool add = false;

            try
            {
                sq.Endorsements.Add(end);
                sq.SaveChanges();
                add = true;
            }
            catch (Exception)
            {
                throw;
            }
            return(add);
        }