public void AddEmployeeTaskMap(EmployeeTaskMap employeeTask)
        {
            CompanyDBDataContext dc = new CompanyDBDataContext();
            string dataValidate     = ValidationHelper.CheckCompulsoryEmployeeTaskColumn(employeeTask);

            if (dataValidate != QueryResource.AllFieldsPresent)
            {
                throw new Exception(dataValidate);
            }
            else
            {
                dc.EmployeeTaskMaps.InsertOnSubmit(employeeTask);
                dc.SubmitChanges();
            }
        }
 public static string CheckCompulsoryEmployeeTaskColumn(EmployeeTaskMap employeeTask)
 {
     if (employeeTask.EmployeeTaskMapID == 0)
     {
         return(QueryResource.EmpTaskIDMissing);
     }
     else if (employeeTask.TaskID == 0)
     {
         return(QueryResource.ProjectIdMissing);
     }
     else if (employeeTask.EmployeeID == 0)
     {
         return(QueryResource.EmployeeIdMissing);
     }
     else
     {
         return(QueryResource.AllFieldsPresent);
     }
 }