public static void UpdatePeriod(Model.Period period)
        {
            string query =
                "BEGIN " +
                "period_pkg.update_period(" + period.Id + ", " + period.Employee_Id + ", '" + period.Login_Time.ToString(string.Format("dd/MMM/yyyy")) + "', '" + period.Logout_Time.ToString(string.Format("dd/MMM/yyyy")) + "'); " +
                "END;";

            DB_Handler.ExecuteQuery(query);
        }
 public static Model.Period RowToEntity(DataRow row)
 {
     Model.Period period = new Model.Period
     {
         Id          = Int32.Parse(row["Id"].ToString()),
         Employee_Id = Int32.Parse(row["Employee_Id"].ToString()),
         Login_Time  = Convert.ToDateTime(row["Login_Time"]),
         Logout_Time = Convert.ToDateTime(row["Logout_Time"])
     };
     return(period);
 }