private DataTable GetAssociatedProjects(int ClientId)
{
var id = Convert.ToInt32(drpClient.SelectedValue);
var dt = ClientXProjectDataManager.GetByClient(id, SessionVariables.RequestProfile.AuditId);
return(dt);
}
private DataTable GetProjectData(int clientId)
{
var dt = ClientXProjectDataManager.GetByClient(clientId, SessionVariables.RequestProfile.AuditId);
var projectdt = ProjectDataManager.GetList(SessionVariables.RequestProfile);
var resultdt = projectdt.Clone();
foreach (DataRow row in dt.Rows)
{
var rows = projectdt.Select("ProjectId = " + row[ProjectDataModel.DataColumns.ProjectId]);
resultdt.ImportRow(rows[0]);
}
return(resultdt);
}
private void UpdatedFKDepenedencies(int oldId, int newId)
{
try
{
var clientxprojectdt = ClientXProjectDataManager.GetByClient(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.DeleteByClient(oldId, SessionVariables.RequestProfile.AuditId);
ClientXProjectDataManager.CreateByClient(newId, projectIds, SessionVariables.RequestProfile);
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
private DataTable GetAssociatedProjects(int clientId)
{
var dt = ClientXProjectDataManager.GetByClient(clientId, SessionVariables.RequestProfile.AuditId);
return(dt);
}