private DataTable GetAssociatedNeeds(int projectId)
{
var id = Convert.ToInt32(drpProject.SelectedValue);
var dt = ProjectXNeedDataManager.GetByProject(id, SessionVariables.RequestProfile.AuditId);
return(dt);
}
private void SaveByProject(int projectId, List <int> needIds)
{
var id = Convert.ToInt32(drpProject.SelectedValue);
ProjectXNeedDataManager.DeleteByProject(id, SessionVariables.RequestProfile);
ProjectXNeedDataManager.CreateByProject(id, needIds.ToArray(), SessionVariables.RequestProfile);
}
private void UpdatedFKDepenedencies(int oldId, int newId)
{
try
{
var ClientXProjectdt = ClientXProjectDataManager.GetByProject(oldId, SessionVariables.RequestProfile.AuditId);
var ProjectIds = new int[ClientXProjectdt.Rows.Count];
for (var i = 0; i < ClientXProjectdt.Rows.Count; i++)
{
ProjectIds[i] = int.Parse(ClientXProjectdt.Rows[i][ClientXProjectDataModel.DataColumns.ProjectId].ToString());
}
if (ProjectIds.Length > 0)
{
ClientXProjectDataManager.DeleteByProject(oldId, SessionVariables.RequestProfile.AuditId);
ClientXProjectDataManager.CreateByProject(newId, ProjectIds, SessionVariables.RequestProfile);
}
var projectxneeddt = ClientXProjectDataManager.GetByProject(oldId, SessionVariables.RequestProfile.AuditId);
var needIds = new int[ClientXProjectdt.Rows.Count];
for (var i = 0; i < projectxneeddt.Rows.Count; i++)
{
needIds[i] = int.Parse(projectxneeddt.Rows[i][ProjectXNeedDataModel.DataColumns.NeedId].ToString());
}
if (needIds.Length > 0)
{
ProjectXNeedDataManager.DeleteByProject(oldId, SessionVariables.RequestProfile);
ProjectXNeedDataManager.CreateByProject(newId, needIds, SessionVariables.RequestProfile);
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
private DataTable GetAssociatedProjects(int needId)
{
var id = Convert.ToInt32(drpNeed.SelectedValue);
var dt = ProjectXNeedDataManager.GetByNeed(id, SessionVariables.RequestProfile);
return(dt);
}
private DataTable GetNeedData(int projectId)
{
var dt = ProjectXNeedDataManager.GetByProject(projectId, SessionVariables.RequestProfile.AuditId);
var needdt = NeedDataManager.GetList(SessionVariables.RequestProfile);
var resultdt = needdt.Clone();
foreach (DataRow row in dt.Rows)
{
var rows = needdt.Select("NeedId = " + row[NeedDataModel.DataColumns.NeedId]);
resultdt.ImportRow(rows[0]);
}
return(resultdt);
}
private void SaveProjectXNeed(int needId, List <int> projectIds)
{
ProjectXNeedDataManager.DeleteByNeed(needId, SessionVariables.RequestProfile);
ProjectXNeedDataManager.CreateByNeed(needId, projectIds.ToArray(), SessionVariables.RequestProfile);
}
private DataTable GetAssociatedProjects(int needId)
{
var dt = ProjectXNeedDataManager.GetByNeed(needId, SessionVariables.RequestProfile);
return(dt);
}
private void SaveNeedXProject(int projectId, List <int> NeedIds)
{
ProjectXNeedDataManager.DeleteByProject(projectId, SessionVariables.RequestProfile);
ProjectXNeedDataManager.CreateByProject(projectId, NeedIds.ToArray(), SessionVariables.RequestProfile);
}
private DataTable GetAssociatedNeeds(int projectId)
{
var dt = ProjectXNeedDataManager.GetByProject(projectId, SessionVariables.RequestProfile.AuditId);
return(dt);
}
