public void AssignTechnologyToTask(int technologyID, int taskID)
{
try
{
CompanyDBDataContext dc = new CompanyDBDataContext();
bool taskPresent = ValidationHelper.IfTaskExist(taskID);
bool techPresent = ValidationHelper.IfTechnologyExist(technologyID);
if (taskPresent && techPresent)
{
TechTaskMap tech = new TechTaskMap();
tech.TaskID = taskID;
tech.TechID = technologyID;
dc.TechTaskMaps.InsertOnSubmit(tech);
dc.SubmitChanges();
}
else if (!taskPresent || !techPresent)
{
if (taskPresent)
{
throw new Exception(QueryResource.TechnologyNotexist);
}
else if (techPresent)
{
throw new Exception(QueryResource.TaskNotExist);
}
else
{
throw new Exception(QueryResource.TechAndTaskNotExit);
}
}
}
catch (Exception ex) { throw ex; }
}
public void insertTechTaskMap(int Id, int techId, int taskId)
{
DataClasses1DataContext dc = new DataClasses1DataContext();
TechTaskMap techTask = new TechTaskMap();
techTask.TechTaskMapID = Id;
techTask.TechID = techId;
techTask.TaskID = taskId;
}
public void AddTechTaskMap(TechTaskMap techTask)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
string dataValidate = ValidationHelper.CheckCompulsoryTechtaskColumn(techTask);
if (dataValidate != QueryResource.AllFieldsPresent)
{
throw new Exception(dataValidate);
}
dc.TechTaskMaps.InsertOnSubmit(techTask);
dc.SubmitChanges();
}
public static string CheckCompulsoryTechtaskColumn(TechTaskMap techTask)
{
if (techTask.TechTaskMapID == 0)
{
return(QueryResource.TechTaskMapIDMissing);
}
else if (techTask.TaskID == 0)
{
return(QueryResource.TaskIdMissing);
}
else if (techTask.TechID == 0)
{
return(QueryResource.TechIdMissing);
}
else
{
return(QueryResource.AllFieldsPresent);
}
}
public void UpdateTechnologiesForTask(List <int> technologyIDs, int taskID)
{
try
{
CompanyDBDataContext dc = new CompanyDBDataContext();
bool taskPresent = ValidationHelper.IfTaskExist(taskID);
if (taskPresent)
{
List <TechTaskMap> result = (from techtask in dc.TechTaskMaps where techtask.TaskID == taskID select techtask).ToList();
dc.TechTaskMaps.DeleteAllOnSubmit(result);
dc.SubmitChanges();
foreach (int techID in technologyIDs)
{
bool techPresent = ValidationHelper.IfTechnologyExist(techID);
if (techPresent)
{
TechTaskMap techTask = new TechTaskMap();
techTask.TaskID = taskID;
techTask.TechID = techID;
dc.TechTaskMaps.InsertOnSubmit(techTask);
}
else
{
throw new Exception(QueryResource.TechnologyNotexist);
}
}
dc.SubmitChanges();
}
else
{
throw new Exception(QueryResource.TaskNotExist);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void AddTechTask(TechTaskMap techTask, int mapID, int techID, int taskID)
{
try
{
DataManager dataManger = new DataManager();
int count = dataManger.GetAllTechnologyForTask(taskID);
if (count < 4)
{
TechTaskMap tt = new TechTaskMap();
dataManger.AddTechTaskMap(techTask);
}
else
{
throw new Exception(QueryResource.TechnologyTaskExceeds);
}
}
catch (Exception ex)
{
throw ex;
}
}
