public bool insertJob(IDBContext dbContext, string currentUser, DTOs.RDO rdo)
{
bool result = true;
DateTime date = DateTime.Now;
string INSERT_JOB_QUERY = $@"IF NOT EXISTS(SELECT TOP 1 * FROM [EDDSDBO].commentJob where comment_artifactid = @commentArtifactId)
BEGIN
insert into [EDDSDBO].commentJob (cojob_comment, cojob_createdBy, comment_artifactId, cojob_createdOn)
Values (@comment, @user, @commentArtifactId, @createdOn )
END";
System.Data.SqlClient.SqlParameter comment = new System.Data.SqlClient.SqlParameter("@comment", System.Data.SqlDbType.VarChar);
comment.Value = rdo.Fields[0].Value;
System.Data.SqlClient.SqlParameter user = new System.Data.SqlClient.SqlParameter("@user", System.Data.SqlDbType.VarChar);
user.Value = currentUser;
System.Data.SqlClient.SqlParameter commentArtifactId = new System.Data.SqlClient.SqlParameter("@commentArtifactId", System.Data.SqlDbType.Int);
commentArtifactId.Value = rdo.ArtifactID;
System.Data.SqlClient.SqlParameter createdOn = new System.Data.SqlClient.SqlParameter("@createdOn", System.Data.SqlDbType.DateTime);
createdOn.Value = DateTime.Now;
try
{
dbContext.ExecuteNonQuerySQLStatement(INSERT_JOB_QUERY, new System.Data.SqlClient.SqlParameter[] { commentArtifactId, comment, user, createdOn });
result = true;
}
catch (Exception e)
{
System.Console.WriteLine($"There was a problem in a Query: {e.Message}");
result = false;
}
return(result);
}
public bool deleteJob(IDBContext dbcontext, int artifactId)
{
bool result = true;
string DELETE_JOB_QUERY = "IF EXISTS(SELECT TOP 1 * FROM [EDDSDBO].commentJob where comment_artifactid = @artifactId)"
+ " BEGIN"
+ " DELETE from [EDDSDBO].commentJob"
+ " WHERE comment_artifactId = @artifactId"
+ " END";
System.Data.SqlClient.SqlParameter artifact = new System.Data.SqlClient.SqlParameter("@artifactId", System.Data.SqlDbType.Int);
artifact.Value = artifactId;
try
{
dbcontext.ExecuteNonQuerySQLStatement(DELETE_JOB_QUERY, new SqlParameter[] { artifact });
}
catch (Exception e)
{
throw;
}
return(result);
}
