public bool Insert(ProjectRequests data)
{
try
{
using (SqlConnection sqlConn = new SqlConnection(GlobalBLL.GetConnectionString()))
{
string query = "vx.ProjectRequests_Insert";
DynamicParameters parameters = new DynamicParameters();
parameters.Add("ID", data.ID);
parameters.Add("ProjectName", data.ProjectName);
parameters.Add("Description", data.Description);
parameters.Add("ClientName", data.ClientName);
parameters.Add("StartDate", data.StartDate);
parameters.Add("ExpectedEndDate", data.ExpectedEndDate);
parameters.Add("CreatedBy", data.CreatedBy);
parameters.Add("CreatedDate", data.CreatedDate);
parameters.Add("ModifiedBy", data.ModifiedBy);
parameters.Add("ModifiedDate", data.ModifiedDate);
parameters.Add("Status", string.Empty, direction: System.Data.ParameterDirection.Output);
var result = sqlConn.Execute(query, parameters, commandType: System.Data.CommandType.StoredProcedure);
string status = parameters.Get <string>("Status");
if (status.Equals("Success", StringComparison.InvariantCultureIgnoreCase))
{
return(true);
}
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
public ProjectState(User Teamhead)
{
InitializeComponent();
CurrentProjects = ProjectRequests.GetAllProjectsByTeamHead(Teamhead.UserId);
cmb_workers.DataSource = CurrentProjects;
cmb_workers.DisplayMember = "ProjectName";
chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Pie;
}
public SetPermission()
{
InitializeComponent();
cmb_workers.DataSource = UserRequests.GetAllUsers();
cmb_workers.DisplayMember = "userName";
cmb_projects.DataSource = ProjectRequests.GetAllProjects();
cmb_projects.DisplayMember = "ProjectName";
}
public WorkerScreen(User worker)
{
this.worker = worker;
InitializeComponent();
IsMdiContainer = true;
btn_logout.Enabled = false;
btn_login.Enabled = false;
cmb_myProjects.DataSource = ProjectRequests.GetAllProjectsByWorker(worker.UserId);
cmb_myProjects.DisplayMember = "ProjectName";
}
private Task <bool> InsertData(ProjectRequests req)
{
if (_projectRequestBLL.Insert(req))
{
return(Task.FromResult <bool>(true));
}
else
{
return(Task.FromResult <bool>(false));
}
}
private void cmb_workers_SelectedIndexChanged(object sender, EventArgs e)
{
List <Models.Task> currentTasks = new List <Models.Task>();
int projectId = ((sender as ComboBox).SelectedItem as Project).ProjectId;
currentTasks = Requests.TaskRequests.GetAllTasksByProjectId(projectId);
dataGridView1.DataSource = currentTasks.Select(p => new { p.userName, p.ReservingHours, p.GivenHours }).ToList();
decimal precents = ProjectRequests.GetAllProjectState(projectId);
chart1.Series[0].Points.DataBindXY(new string[] { "Done: " + precents + "%", "Todo " + (100 - precents) + "%" }, new decimal[] { precents, 100 - precents });
}
private Task <bool> UpdateData(ProjectRequests req)
{
if (_projectRequestBLL.Update(req))
{
SelectedData = req;
return(Task.FromResult <bool>(true));
}
else
{
return(Task.FromResult <bool>(false));
}
}
private void ListViewProjectRequset_SelectedIndexChanged(object sender, EventArgs e)
{
if (ListViewProjectRequset.SelectedItems.Count > 0)
{
ListViewItem selectedItem = ListViewProjectRequset.SelectedItems[0];
if (selectedItem != null)
{
SelectedData = selectedItem.Tag as ProjectRequests;
TextBoxProjectName.Text = SelectedData.ProjectName;
TextBoxDescription.Text = SelectedData.Description;
TextBoxClientName.Text = SelectedData.ClientName;
DateTimePickerStartDate.Text = SelectedData.StartDate.ToLongDateString();
DateTimePickerEndDate.Text = SelectedData.ExpectedEndDate.ToLongDateString();
}
}
}
private async void ButtonDelete_Click(object sender, EventArgs e)
{
if (SelectedData != null)
{
if (MessageBox.Show("Are you sure want to delete the selected row?", "Update Data", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
GroupBoxContainer.Enabled = false;
ListViewProjectRequset.Enabled = false;
bool success = await DeleteData(SelectedData.ID);
if (success)
{
SelectedData = null;
ListViewProjectRequset.SelectedItems[0].Remove();
Control[] textControls = new Control[]
{
TextBoxProjectName,
TextBoxDescription,
TextBoxClientName,
DateTimePickerStartDate,
DateTimePickerEndDate
};
foreach (Control control in textControls)
{
control.Text = "";
}
MessageBox.Show("Data has been deleted successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Failed to delete data", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
GroupBoxContainer.Enabled = true;
ListViewProjectRequset.Enabled = true;
}
}
else
{
MessageBox.Show("Please select any row to delete", "Error", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
public bool Update(ProjectRequests data)
{
try
{
using (SqlConnection sqlConn = new SqlConnection(GlobalBLL.GetConnectionString()))
{
string query = "UPDATE vx.ProjectRequests " +
"SET ProjectName=@ProjectName, " +
"Description=@Description," +
"ClientName=@ClientName," +
"StartDate=@StartDate," +
"ExpectedEndDate=@ExpectedEndDate," +
"CreatedBy=@CreatedBy," +
"CreatedDate=@CreatedDate," +
"ModifiedBy=@ModifiedBy," +
"ModifiedDate=@ModifiedDate " +
"WHERE ID=@ID;";
var result = sqlConn.Execute(query, new
{
ID = data.ID,
ProjectName = data.ProjectName,
Description = data.Description,
ClientName = data.ClientName,
StartDate = data.StartDate,
ExpectedEndDate = data.ExpectedEndDate,
CreatedBy = data.CreatedBy,
CreatedDate = data.CreatedDate,
ModifiedBy = data.ModifiedBy,
ModifiedDate = data.ModifiedDate
});
if (result > 0)
{
return(true);
}
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
public void CreateProjects()
{
_control.Value.ClearMessages();
ProjectCreator creator = null;
BackgroundWorker worker = new BackgroundWorker();
worker.WorkerReportsProgress = true;
worker.DoWork += (sender, e) =>
{
creator = new ProjectCreator(ProjectRequests, SelectedProjectTemplate);
creator.ProgressChanged += (sender2, e2) => { worker.ReportProgress(e2.ProgressPercentage); };
creator.MessageReported += (sender2, e2) => { ReportMessage(e2.Project, e2.Message); };
creator.Execute();
};
worker.ProgressChanged += (sender, e) =>
{
PercentComplete = e.ProgressPercentage;
};
worker.RunWorkerCompleted += (sender, e) =>
{
if (e.Error != null)
{
MessageBox.Show(e.Error.ToString());
}
else
{
foreach (Tuple <ProjectRequest, FileBasedProject> request in creator.SuccessfulRequests)
{
// accept the request
ContentConnector.Instance.RequestAccepted(request.Item1);
// remove the request from the list of requests
ProjectRequests.Remove(request.Item1);
OnProjectRequestsChanged();
}
}
};
worker.RunWorkerAsync();
}
public void CreateProjects()
{
_control.Value.ClearMessages();
ProjectCreator creator = null;
BackgroundWorker worker = new BackgroundWorker();
worker.WorkerReportsProgress = true;
if (SelectedProjects == null || SelectedProjects.Count == 0)
{
MessageBox.Show(@"Please select a project");
}
else
{
if (SelectedProjects != null && SelectedProjects.Count != 0)
{
foreach (var selectedProject in SelectedProjects)
{
if (selectedProject.ProjectTemplate != null)
{
_hasTemplateList.Add(true);
}
else
{
_hasTemplateList.Add(false);
}
if (HasFiles(selectedProject.Path))
{
_hasFiles.Add(true);
}
else
{
_hasFiles.Add(false);
}
}
}
if (!_hasFiles.Contains(true))
{
if (!_hasTemplateList.Contains(false))
{
if (SelectedProjects != null && (SelectedProjects.Count != 0 && SelectedProjects != null))
{
worker.DoWork += (sender, e) =>
{
if (SelectedProjects.Count != 0 && SelectedProjects != null)
{
creator = new ProjectCreator(SelectedProjects, SelectedProjectTemplate);
}
else
{
creator = new ProjectCreator(ProjectRequests, SelectedProjectTemplate);
}
creator.ProgressChanged +=
(sender2, e2) => { worker.ReportProgress(e2.ProgressPercentage); };
creator.MessageReported += (sender2, e2) => { ReportMessage(e2.Project, e2.Message); };
creator.Execute();
};
worker.ProgressChanged += (sender, e) =>
{
PercentComplete = e.ProgressPercentage;
};
worker.RunWorkerCompleted += (sender, e) =>
{
if (e.Error != null)
{
MessageBox.Show(e.Error.ToString());
}
else
{
foreach (
Tuple <ProjectRequest, FileBasedProject> request in creator.SuccessfulRequests)
{
// accept the request
InSource.Instance.RequestAccepted(request.Item1);
// remove the request from the list of requests
ProjectRequests.Remove(request.Item1);
OnProjectRequestsChanged();
}
}
};
worker.RunWorkerAsync();
}
}
else
{
MessageBox.Show(@"Please choose a custom template");
_hasTemplateList.Clear();
}
}
else
{
MessageBox.Show(
@"Watch folders should contain only folders, please put the files in a directory, and after that click CHECK PROJECT REQUESTS BUTTON ");
_hasFiles.Clear();
}
}
}
private async void ButtonAdd_Click(object sender, EventArgs e)
{
Control[] buttonControls = new Control[]
{
ButtonUpdate,
ButtonDelete,
ButtonDetails
};
if (ButtonAdd.Text.Equals("Add New"))
{
Control[] textControls = new Control[]
{
TextBoxProjectName,
TextBoxDescription,
TextBoxClientName,
DateTimePickerStartDate,
DateTimePickerEndDate
};
foreach (Control control in textControls)
{
control.Text = "";
}
foreach (Control control in buttonControls)
{
control.Enabled = false;
}
ButtonCancel.Enabled = true;
ButtonAdd.Text = "Save";
ListViewProjectRequset.Enabled = false;
}
else
{
ProjectRequests newData = new ProjectRequests();
if (!string.IsNullOrEmpty(TextBoxProjectName.Text) ||
!string.IsNullOrEmpty(TextBoxDescription.Text) ||
!string.IsNullOrEmpty(TextBoxClientName.Text) ||
!string.IsNullOrEmpty(DateTimePickerStartDate.Text) ||
!string.IsNullOrEmpty(DateTimePickerEndDate.Text)
)
{
newData.ID = Guid.NewGuid();
newData.ProjectName = TextBoxProjectName.Text;
newData.Description = TextBoxDescription.Text;
newData.ClientName = TextBoxClientName.Text;
newData.StartDate = DateTime.Parse(DateTimePickerStartDate.Text);
newData.ExpectedEndDate = DateTime.Parse(DateTimePickerEndDate.Text);
newData.CreatedBy = CoreGlobal.LoggedUser;
newData.CreatedDate = DateTime.Now;
newData.ModifiedBy = CoreGlobal.LoggedUser;
newData.ModifiedDate = DateTime.Now;
bool success = await InsertData(newData);
if (success)
{
MessageBox.Show("Data has been inserted successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
await Task.Run(() => LoadData());
}
else
{
MessageBox.Show("Failed to insert data", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
foreach (Control control in buttonControls)
{
control.Enabled = true;
}
ButtonCancel.Enabled = false;
ButtonAdd.Text = "Add New";
ListViewProjectRequset.Enabled = true;
}
else
{
MessageBox.Show("Please complete all fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public HoursChart(Models.Worker teamHead)
{
InitializeComponent();
cmb_projects.DataSource = ProjectRequests.GetAllProjectsByTeamHead(teamHead.WorkerId);
cmb_projects.DisplayMember = "ProjectName";
}
