Esempio n. 1
0
        public int InsertEmployment(Employments objEmployments)
        {
            objEmployments.EmploymentID = 1;
            BeginTransaction();

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

            return objEmployments.EmploymentID;
        }
Esempio n. 2
0
        public int UpdateEmployment(Employments objEmployments)
        {
            int rowsaffected = -1;
            BeginTransaction();
            try
            {
                String[] UpdateProperties = new String[] { "CompanyName", "CountryID", "EmploymentStartDate",
                                                            "WorkTypeID", "IncomeRangeID", 
                                                            "UpdatedBy", "UpdatedDate"
                                                            };
                rowsaffected = Update(objEmployments, UpdateProperties);

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

        }
Esempio n. 3
0
 public static int UpdateEmployment(Employments objEmployments)
 {
     return new EmploymentDAO().UpdateEmployment(objEmployments);
 }
Esempio n. 4
0
        public static Employments GetEmployment(int EmploymentID)
        {
            Employments objEmployments = new Employments();
            return (Employments)(new EmploymentDAO().FillDTO(objEmployments, "EmploymentID=" + EmploymentID));

        }
Esempio n. 5
0
 public static int InsertEmployment(Employments objEmployments)
 {
     return new EmploymentDAO().InsertEmployment(objEmployments);
 }