public List <ProjectTaskModel> GetAllProjectTasksByProjectd(string projectId)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetAllProjectTasksByProjectd(projectId);
return(MapProjectTaskDataTable(result));
}
/// <summary>
/// Populate comboBoxModule depending on the selected project
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void comboBoxProject_SelectedIndexChanged(object sender, EventArgs e)
{
comboBoxModule.Items.Clear();
List <Module> modules = new List <Module>();
if (DbConnector.OpenSQLConnection()) // Open connection to the database
{
// Connection opened
ProjectDataAccess project = new ProjectDataAccess();
int projectId = project.FindProjectByProjectName(comboBoxProject.Text);
ModuleDataAccess module = new ModuleDataAccess();
modules = module.FindModuleByProject(Convert.ToInt32(projectId));
}
else
{
// Connection could not be opened
MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (modules != null)
{
// Populate comboBoxes with data
foreach (Module m in modules)
{
comboBoxModule.Items.Add(m.ModuleName);
}
}
}
public ProjectModel GetCompleteProjectDetailWithTasks(string projectId)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetCompleteProjectDetailWithTasks(projectId);
return(MapProjectDetailsWithTasksAsList(result));
}
public List <ExpenseCategoryModel> GetAllExpenseCategory()
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetAllExpenseCategory();
return(MapDataTableToExpenseCategory(result));
}
public List <ProjectExpenseModel> GetAllProjectExpenses(string pageNumber, string searchTerm, string category)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetAllProjectExpenses(pageNumber, searchTerm, category);
return(MapProjectExpense(result));
}
/// <summary>
/// Populate the datagridview with search result
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSearchModules_Click(object sender, EventArgs e)
{
if (DbConnector.OpenSQLConnection()) // Open connection to the database
{
// Connection opened
ModuleDataAccess module = new ModuleDataAccess();
dgvModule.AutoGenerateColumns = false; // To only show the columns needed
dgvModule.DataSource = module.SearchModules(txtSearchModules.Text.Trim());
if (dgvModule.RowCount != 0)
{
ProjectDataAccess project = new ProjectDataAccess();
var result = project.FindProject(Convert.ToInt32(dgvModule.Rows[0].Cells[1].Value)).ProjectName;
for (int i = 0; i < dgvModule.RowCount; i++)
{
dgvModule.Rows[i].Cells[2].Value = result;
}
}
}
else
{
// Connection could not be opened
MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
DbConnector.CloseSQLConnection(); // Close connection to the database
}
/// <summary>
/// Method for populating the DataDridView
/// </summary>
public void populateDataGridView(int projectId)
{
this.projectId = projectId;
if (DbConnector.OpenSQLConnection()) // Open connection to the database
{
// Connection opened
ModuleDataAccess module = new ModuleDataAccess();
dgvModule.AutoGenerateColumns = false; // To only show the columns needed
dgvModule.DataSource = module.GetAllModules(projectId);
ProjectDataAccess project = new ProjectDataAccess();
projectName = project.FindProject(projectId).ProjectName;
for (int i = 0; i < dgvModule.RowCount; i++)
{
dgvModule.Rows[i].Cells[2].Value = projectName;
}
txtSearchModules.Text = "";
Modules_Tab_Child.getInstance().clearModuleText();
}
else
{
// Connection could not be opened
MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
DbConnector.CloseSQLConnection(); // Close connection to the database
}
public List <ProjectModel> GetAllProjects(int pageNumber, string searchTerm, int numberOfRecords, bool showHiddenProjects, string userID)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetAllProjects(pageNumber, searchTerm, numberOfRecords, showHiddenProjects, userID);
return(ConvertProjectDataTableToList(result));
}
//public List<ProjectSubTaskBasicModel> GetAllProjectSubTasksByUserId(string userId, string date)
//{
// ProjectDataAccess obj = new ProjectDataAccess();
// var result = obj.GetAllProjectSubTasksByUserId(userId, date);
// return ConvertProjectSubTasksDataTableToList(result);
//}
public ProjectSubTaskModel GetProjectSubTaskDetailsById(string subTaskId)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetProjectSubTaskDetailsById(subTaskId);
return(MapProjectSubTaskDetails(result));
}
public List <ProjectBasicModel> GetAllProjectNamesAndId(string userID)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetAllProjectNamesAndId(userID);
return(ConvertProjectBasicDataTableToList(result));
}
public bool CreateProjectSubTask(ProjectSubTaskModel subTask)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.CreateProjectSubTask(subTask);
return(result);
}
public bool UpdateProjectSubTask(ProjectSubTaskModel subTask, bool isPostponed, int reAssignedUserId)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.UpdateProjectSubTask(subTask);
return(result);
}
public List <ProjectSubTaskModel> GetAllProjectSubTasksByTaskIdAndUserId(string taskId, string userId)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetAllProjectSubTasksByTaskIdAndUserId(taskId, userId);
return(ConvertProjectSubTasksDataTableToList(result));
}
public List <ProjectTaskBasicModel> GetAllProjectTasksByPhasesId(string phaseId)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetAllProjectTasksByPhaseId(phaseId);
return(ConvertProjectTasksDataTableToList(result));
}
public List <ProjectPhaseBasicModel> GetAllProjectPhasesById(string projectId)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetAllProjectPhasesById(projectId);
return(ConvertProjectPhasesDataTableToList(result));
}
public List <ProjectIncome> GetAllProjectIncome(string pageNumber, string searchTerm, string fromDate, string toDate)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetAllProjectIncome(pageNumber, searchTerm, fromDate, toDate);
return(MapProjectIncome(result));
}
public ProjectModel GetProjectDetailsById(string projectId)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetProjectDetailsById(projectId);
return(MapProjectDetailsDataTable(result));
}
public int AddProjectTask(ProjectTaskModel taskModel, int phaseId)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.AddProjectTask(taskModel, phaseId);
return(result);
}
public byte[] GetProjectIncomeExcel(string pageNumber, string searchTerm, string fromDate, string toDate)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.GetAllProjectIncome(pageNumber, searchTerm, fromDate, toDate);
string[] columns = { Convert.ToString(result.Rows[0]["TotalIncome"]) };
return(EnquiryBusinessLogic.ExportExcel(MapDataTableForProjectIncome(result), "Project Income", false, columns));
}
public static async Task <IActionResult> ProjectDelete(
[HttpTrigger(AuthorizationLevel.Anonymous, "delete", Route = "projects/{projectId}")] HttpRequest req,
ILogger log, int projectId)
{
using (var da = new ProjectDataAccess(conStr))
{
return(new OkObjectResult(await da.QueryAsync <Project>(string.Format(SQLStatements.TemplateDelete, "Projects", projectId))));
}
}
public static async Task <IActionResult> ProjectGet(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = "projects")] HttpRequest req,
ILogger log)
{
using (var da = new ProjectDataAccess(conStr))
{
return(new OkObjectResult(await da.Get()));
}
}
public int AddProjectPhase(ProjectPhaseModel phaseModel, int projectId)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = obj.AddProjectPhase(phaseModel, projectId);
foreach (ProjectTaskModel taskModel in phaseModel.ProjectTasks)
{
AddProjectTask(taskModel, result);
}
return(result);
}
protected void EmployeeIDDropDownList_SelectedIndexchanged(object sender, EventArgs e)
{
ProjectDetailsModel projmodel = new ProjectDetailsModel();
ProjectDataAccess projdata = new ProjectDataAccess();
projmodel = projdata.GetProjectDetails(Convert.ToInt32(EmployeeIDDropDownList.SelectedValue));
Project_NameTextBox.Text = projmodel.Project_Name;
Client_NameTextBox.Text = projmodel.Client_Name;
LocationTextBox.Text = projmodel.Location;
RolesTextBox.Text = projmodel.Roles;
}
public MockBusiness(
UserDataAccess userDataAccess,
FeedbackSeasonDataAccess feedbackSeasonDataAccess,
ProjectDataAccess projectDataAccess,
CompetenceDataAccess competenceDataAccess
)
{
_userDataAccess = userDataAccess;
_feedbackSeasonDataAccess = feedbackSeasonDataAccess;
_projectDataAccess = projectDataAccess;
_competenceDataAccess = competenceDataAccess;
}
public static async Task <IActionResult> ProjectCreate(
[HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = "projects")] HttpRequest req,
ILogger log)
{
string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
dynamic data = JsonConvert.DeserializeObject <Project>(requestBody);
using (var da = new ProjectDataAccess(conStr))
{
return(new OkObjectResult(await da.CreateAsync(data)));
}
}
public int UpdateProject(ProjectModel project, string selectedUsers)
{
ProjectDataAccess obj = new ProjectDataAccess();
var projectId = project.ProjectId;
obj.UpdateProject(project);
foreach (ProjectPhaseModel phaseModel in project.ProjectPhases)
{
UpdateProjectPhase(phaseModel, projectId);
}
obj.UpdateUsersAccessToProject(selectedUsers, projectId, "1");
return(projectId);
}
public int AddNewProject(ProjectModel project, string selectedUsers)
{
selectedUsers = selectedUsers.TrimEnd(',').Trim();
ProjectDataAccess obj = new ProjectDataAccess();
var projectId = obj.AddNewProject(project);
foreach (ProjectPhaseModel phaseModel in project.ProjectPhases)
{
AddProjectPhase(phaseModel, projectId);
}
obj.ProvideUsersAccessToProject(selectedUsers, projectId, "1");
return(projectId);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ProjectDataAccess obj = new ProjectDataAccess();
List <int> EmpIDList = obj.GetEmployeeID();
int i = 0;
foreach (int EmpID in EmpIDList)
{
EmployeeIDDropDownList.Items.Insert(i, new ListItem(EmpID.ToString()));
i++;
}
}
UnobtrusiveValidationMode = UnobtrusiveValidationMode.None;
}
public string GetUsersWithAccessForProject(string projectId)
{
ProjectDataAccess obj = new ProjectDataAccess();
var dt = obj.GetUsersWithAccessForProject(projectId);
var result = string.Empty;
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
result += dr["UserId"].ToString() + ",";
}
}
return(result.TrimEnd(',').Trim());
}
public int UpdateProjectTask(ProjectTaskModel taskModel, int phaseId)
{
ProjectDataAccess obj = new ProjectDataAccess();
var result = 0;
if (taskModel.ProjectTaskId > 0)
{
result = taskModel.ProjectTaskId;
obj.UpdateProjectTask(taskModel);
}
else
{
result = obj.AddProjectTask(taskModel, phaseId);
}
return(result);
}
