public void insertTechProjectMap(int Id, int techID, int projectId)
{
DataClasses1DataContext dc = new DataClasses1DataContext();
TechProjectMap techProject = new TechProjectMap();
techProject.TechProjectMapID = Id;
techProject.TechID = techID;
techProject.ProjectID = projectId;
dc.TechProjectMaps.InsertOnSubmit(techProject);
dc.SubmitChanges();
}
public void AddTechProjectMap(TechProjectMap techProject)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
string dataValidate = ValidationHelper.CheckCompulsoryTechProjectColumn(techProject);
if (dataValidate != QueryResource.AllFieldsPresent)
{
throw new Exception(dataValidate);
}
dc.TechProjectMaps.InsertOnSubmit(techProject);
dc.SubmitChanges();
}
public static string CheckCompulsoryTechProjectColumn(TechProjectMap techProject)
{
if (techProject.TechProjectMapID == 0)
{
return(QueryResource.TechProjectIDMissing);
}
else if (techProject.ProjectID == 0)
{
return(QueryResource.ProjectIdMissing);
}
else if (techProject.TechID == 0)
{
return(QueryResource.TechIdMissing);
}
else
{
return(QueryResource.AllFieldsPresent);
}
}
