// GET api/maritalstatus
 public IEnumerable<MaritalStatus> Get()
 {
     List<MaritalStatus> listMaritalStatus = new List<MaritalStatus>();
     DataView dvMaritalStatus = MaritalStatusBO.GetMaritalStatusIDForSync();
     foreach (DataRowView drvEducationalStatus in dvMaritalStatus)
     {
         MaritalStatus status = new MaritalStatus();
         listMaritalStatus.Add(MaritalStatusBO.GetMaritalStatus(Convert.ToInt32(drvEducationalStatus["MaritalStatusID"])));
     }
     return listMaritalStatus;
 }
        public int InsertMaritalStatus(MaritalStatus objStatus)
        {
            objStatus.MaritalStatusID = 1;
            BeginTransaction();

            try
            {
                objStatus.MaritalStatusID = Insert(objStatus);
                CommitTransaction();
            }
            catch (Exception ex)
            {
                RollBackTransaction();
                objStatus.MaritalStatusID = -1;
            }

            return objStatus.MaritalStatusID;
        }
        // POST api/maritalstatus
        public MaritalStatus Post(MaritalStatus status)
        {
            if (status.GUID > 0)
            {
                status.MaritalStatusID = status.GUID;
                int rowResult = MaritalStatusBO.UpdateMaritalStatus(status);

                //Return Back to The Client               
                return status;
            }
            else
            {
                
                int rowResult = MaritalStatusBO.InsertmaritalStatus(status);

                //Return Back to The Client               
                return status;
            }
        }
        public int UpdateMaritalStatus(MaritalStatus objStatus)
        {
            int rowsaffected = -1;
            BeginTransaction();
            try
            {
                String[] UpdateProperties = new String[] { "MaritalStatusDesc", "UpdatedBy", "UpdatedDate", "GUID", "SyncStatus" };
                rowsaffected = Update(objStatus, UpdateProperties);

                CommitTransaction();
            }
            catch (Exception e)
            {
                RollBackTransaction();
                rowsaffected = -1;
            }
            return rowsaffected;

        }
        public static int UpdateMaritalStatus(MaritalStatus objStatus)
        {

            return new MaritalStatusDAO().UpdateMaritalStatus(objStatus);
        }
        public static int InsertmaritalStatus(MaritalStatus objStatus)
        {

            return new MaritalStatusDAO().InsertMaritalStatus(objStatus);
        }
 public static MaritalStatus GetMaritalStatus(int MaritalStatusID)
 {
     MaritalStatus obj = new MaritalStatus();
     return (MaritalStatus)(new MaritalStatusDAO().FillDTO(obj, "MaritalStatusID=" + MaritalStatusID));
 }