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); } }