public bool AddPrefixToDepartment(DepartmentPrefixItem entity)
        {
            bool result = false;

            using (ScheduleDataContext ctx = new ScheduleDataContext())
            {

                DepartmentPrefix misc = new DepartmentPrefix();

                misc.DepartmentID = entity.DepartmentId;
                misc.Prefix = entity.PrefixText;

                ctx.DepartmentPrefixes.InsertOnSubmit(misc);

                try
                {
                    ctx.SubmitChanges();
                    result = true;

                }
                catch (Exception ex)
                {
                    throw new Exception("Unable to add prefix: " + ex.Message);
                }

            }

            return result;
        }
 partial void UpdateDepartmentPrefix(DepartmentPrefix instance);
 partial void DeleteDepartmentPrefix(DepartmentPrefix instance);
 partial void InsertDepartmentPrefix(DepartmentPrefix instance);