public static bool UpdateOnly(UserAccess ua, int project_id)
{
var cm = Constants.GetCachedCountyManager();
var c = new Comment
{
comment = "",
update_only = true,
project_id = project_id,
added_by = ua.user_name,
by_county_manager = (ua.employee_id == cm)
};
var query = @"
USE ProjectTracking;
INSERT INTO Comment
(project_id, comment, update_only, added_by, by_county_manager)
VALUES
(@project_id, @comment, @update_only, @added_by, @by_county_manager)";
return(Constants.Save_Data <Comment>(query, c));
}
public bool Update(UserAccess ua, Project existingProject)
{
string query = "";
if (!existingProject.completed && completed)
{
// we need to update the completed date too.
query = @"
UPDATE project
SET
project_name = @project_name,
priority = @priority,
needs_attention = @needs_attention,
estimated_completion_date = @estimated_completion_date,
department_id = @department_id,
funding_id = @funding_id,
commissioner_share = @commissioner_share,
infrastructure_share = @infrastructure_share,
legislative_tracking = @legislative_tracking,
completed = @completed,
date_completed = GETDATE()
WHERE
id=@id";
}
else
{
query = @"
UPDATE project
SET
project_name = @project_name,
department_id = @department_id,
funding_id = @funding_id,
commissioner_share = @commissioner_share,
infrastructure_share = @infrastructure_share,
legislative_tracking = @legislative_tracking,
completed = @completed,
priority = @priority,
needs_attention = @needs_attention,
estimated_completion_date = @estimated_completion_date
WHERE
id=@id";
}
// query += @"
// DELETE
// FROM phase_dates
// WHERE
// project_id=@id;
// INSERT INTO [dbo].[phase_dates]
// ([project_id]
// ,[phase_1_name]
// ,[phase_2_name]
// ,[phase_3_name]
// ,[phase_4_name]
// ,[phase_5_name]
// ,[phase_1_start]
// ,[phase_1_completion]
// ,[phase_2_start]
// ,[phase_2_completion]
// ,[phase_3_start]
// ,[phase_3_completion]
// ,[phase_4_start]
// ,[phase_4_completion]
// ,[phase_5_start]
// ,[phase_5_completion])
// VALUES
// (@id
// ,@phase_1_name
// ,@phase_2_name
// ,@phase_3_name
// ,@phase_4_name
// ,@phase_5_name
// ,@phase_1_start
// ,@phase_1_completion
// ,@phase_2_start
// ,@phase_2_completion
// ,@phase_3_start
// ,@phase_3_completion
// ,@phase_4_start
// ,@phase_4_completion
// ,@phase_5_start
// ,@phase_5_completion);
//";
// now let's add the comment / milestones
Comment.Save(ua, id, comment);
Milestone.SaveAll(id, milestones);
Phase.SaveAll(id, phases);
return(Constants.Save_Data <Project>(query, this));
}
public bool Save(UserAccess ua)
{
added_by = ua.user_name;
var dp = new DynamicParameters();
dp.Add("@project_id", dbType: DbType.Int32, direction: ParameterDirection.Output);
dp.Add("@project_name", project_name);
dp.Add("@department_id", department_id);
dp.Add("@priority", priority);
dp.Add("@needs_attention", needs_attention);
//dp.Add("@estimated_completion_date", estimated_completion_date == DateTime.MinValue ? (DateTime?)null : estimated_completion_date);
dp.Add("@estimated_completion_date", estimated_completion_date);
dp.Add("@funding_id", funding_id);
dp.Add("@timeline", timeline);
dp.Add("@commissioner_share", commissioner_share);
dp.Add("@infrastructure_share", infrastructure_share);
dp.Add("@legislative_tracking", legislative_tracking);
dp.Add("@completed", completed);
dp.Add("@added_by", added_by);
//dp.Add("@phase_1_name", phase_1_name);
//dp.Add("@phase_2_name", phase_2_name);
//dp.Add("@phase_3_name", phase_3_name);
//dp.Add("@phase_4_name", phase_4_name);
//dp.Add("@phase_5_name", phase_5_name);
//dp.Add("@phase_1_start", phase_1_start);
//dp.Add("@phase_1_completion", phase_1_completion);
//dp.Add("@phase_2_start", phase_2_start);
//dp.Add("@phase_2_completion", phase_2_completion);
//dp.Add("@phase_3_start", phase_3_start);
//dp.Add("@phase_3_completion", phase_3_completion);
//dp.Add("@phase_4_start", phase_4_start);
//dp.Add("@phase_4_completion", phase_4_completion);
//dp.Add("@phase_5_start", phase_5_start);
//dp.Add("@phase_5_completion", phase_5_completion);
string query = @"
INSERT INTO project (
project_name,
priority,
needs_attention,
estimated_completion_date,
department_id,
funding_id,
timeline,
commissioner_share,
infrastructure_share,
legislative_tracking,
completed,
added_on,
added_by
)
VALUES (
@project_name,
@priority,
@needs_attention,
@estimated_completion_date,
@department_id,
@funding_id,
@timeline,
@commissioner_share,
@infrastructure_share,
@legislative_tracking,
@completed,
GETDATE(),
@added_by
);";
//SET @project_id = SCOPE_IDENTITY();
//INSERT INTO [dbo].[phase_dates]
// ([project_id]
// ,[phase_1_name]
// ,[phase_2_name]
// ,[phase_3_name]
// ,[phase_4_name]
// ,[phase_5_name]
// ,[phase_1_start]
// ,[phase_1_completion]
// ,[phase_2_start]
// ,[phase_2_completion]
// ,[phase_3_start]
// ,[phase_3_completion]
// ,[phase_4_start]
// ,[phase_4_completion]
// ,[phase_5_start]
// ,[phase_5_completion])
// VALUES
// (@project_id
// ,@phase_1_name
// ,@phase_2_name
// ,@phase_3_name
// ,@phase_4_name
// ,@phase_5_name
// ,@phase_1_start
// ,@phase_1_completion
// ,@phase_2_start
// ,@phase_2_completion
// ,@phase_3_start
// ,@phase_3_completion
// ,@phase_4_start
// ,@phase_4_completion
// ,@phase_5_start
// ,@phase_5_completion); ";
int i = Constants.Exec_Query(query, dp);
if (i == -1)
{
return(false);
}
id = dp.Get <int>("@project_id");
// now let's add the comment / milestones
Comment.Save(ua, id, comment);
Milestone.SaveAll(id, milestones);
Phase.SaveAll(id, phases);
return(true);
}