public void AddComment(Bug bug)
{
var workItemDao = new WorkItemDao
{
Id = bug.Id,
Description = bug.Description,
};
var workItemSql = OperationsHelper.BuildUpdateStatement(workItemDao.GetTableName(), nameof(workItemDao.Id),
nameof(workItemDao.Description));
AddChange(workItemSql, workItemDao, OperationType.UPDATE);
var bugDao = new BugDao
{
Id = bug.Id,
IntegratedInBuild = bug.IntegratedInBuild,
FoundInBuild = bug.FoundInBuild,
SystemInfo = bug.SystemInfo
};
var bugSql =
OperationsHelper.BuildUpdateStatement(bugDao.GetTableName(), nameof(bug.Id),
nameof(bugDao.IntegratedInBuild), nameof(bugDao.FoundInBuild), nameof(bugDao.SystemInfo));
AddChange(bugSql, bugDao, OperationType.UPDATE);
}
public bool addBug(String bugName, int project_id, string packageName, String className, String methodName, int lineStart, int lineEnd, String codeBlock, byte[] image, DateTime
bugAddedDate, bool status, int user_id)
{
bug = new Bug();
bug.BugName = bugName;
bug.Project_id = project_id;
bug.PackageName = packageName;
bug.ClassName = className;
bug.MethodName = methodName;
bug.LineStart = lineStart;
bug.LineEnd = lineEnd;
bug.CodeBlock = codeBlock;
bug.Image = image;
bug.BugAddedDate = bugAddedDate;
bug.Status = status;
bug.User_id = user_id;
try
{
BugDao daobug = new BugDao();
bool sts = daobug.insert(bug);
if (sts)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex) { }
return(false);
}
public void ModifyEffort(Bug bug)
{
var bugDao = new BugDao(bug);
var bugSql =
OperationsHelper.BuildUpdateStatement(bugDao.GetTableName(), nameof(bug.Id),
nameof(bugDao.EffortOriginalEstimate), nameof(bugDao.EffortRemaining),
nameof(bugDao.EffortCompleted));
AddChange(bugSql, bugDao, OperationType.UPDATE);
}
public frmActualizarBug()
{
InitializeComponent();
BugDao = new BugDao();
GUIHelper.getHelper().llenarCombo(cboPrioridad, BDHelper.getBDHelper().ConsultaSQL("Select * from Prioridades"), "n_prioridad", "id_prioridad");
GUIHelper.getHelper().llenarCombo(cboCriticidad, BDHelper.getBDHelper().ConsultaSQL("Select * from Criticidades"), "n_criticidad", "id_criticidad");
GUIHelper.getHelper().llenarCombo(cboProducto, BDHelper.getBDHelper().ConsultaSQL("Select * from Productos"), "nombre", "id_producto");
}
public FixedBug getFixedBugById(int id)
{
BugDao daobug = new BugDao();
try
{
fixedBug = daobug.getFixedBugByID(id);
return(fixedBug);
}
catch (Exception e) { }
return(null);
}
public List <Bug> getAllBug()
{
List <Bug> allBug;
try
{
BugDao daobug = new BugDao();
allBug = daobug.getAllBug();
return(allBug);
}
catch (Exception ex) { }
return(null);
}
public Bug getBugById(int id)
{
BugDao daobug = new BugDao();
try
{
bug = daobug.getBugById(id);
return(bug);
}
catch (Exception e) { }
return(null);
}
public void ModifyPlanning(Bug bug)
{
var workItemDao = new WorkItemDao
{
Id = bug.Id,
PriorityId = (int)bug.Priority,
};
var workItemSql = OperationsHelper.BuildUpdateStatement(workItemDao.GetTableName(), nameof(workItemDao.Id),
nameof(workItemDao.PriorityId));
AddChange(workItemSql, workItemDao, OperationType.UPDATE);
var bugDao = new BugDao(bug);
var bugSql =
OperationsHelper.BuildUpdateStatement(bugDao.GetTableName(), nameof(bug.Id),
nameof(bugDao.StoryPoints), nameof(bugDao.SeverityId), nameof(bugDao.ActivityId));
AddChange(bugSql, bugDao, OperationType.UPDATE);
}
public bool InsertFixedBug(int bugID, String fixedCode, String fixedBy, DateTime fixedDate)
{
BugDao daoBug = new BugDao();
fixedBug = new FixedBug();
fixedBug.Bug_id = bugID;
fixedBug.FixedCode = fixedCode;
fixedBug.BugFixedBy = fixedBy;
fixedBug.FixedDate = fixedDate;
bool status = daoBug.insertFixedBug(fixedBug);
if (status == true)
{
return(true);
}
else
{
return(false);
}
}
public void Insert(Bug bug)
{
var workItemDao = new WorkItemDao(bug);
AddChange(workItemDao.BuildInsertStatement(), workItemDao, OperationType.INSERT);
var bugDao = new BugDao(bug);
AddChange(bugDao.BuildInsertStatement(), bugDao, OperationType.INSERT);
using (var enumerator = bug.Attachments.GetEnumerator())
{
while (enumerator.MoveNext())
{
var attachmentDao = new AttachmentDao
{
Path = enumerator.Current !.Path, FileName = enumerator.Current.FileName,
MimeType = enumerator.Current.MimeType, WorkItemId = bug.Id
};
AddChange(attachmentDao.BuildInsertStatement(), attachmentDao, OperationType.INSERT);
}
}
foreach (var tag in bug.Tags)
{
var tagDao = new TagDao {
Text = tag.Text, WorkItemId = bug.Id
};
AddChange(tagDao.BuildInsertStatement(), tagDao, OperationType.INSERT);
}
foreach (var relatedWork in bug.RelatedWorks)
{
var relatedWorkDao = new RelatedWorkDao(relatedWork, bugDao.Id);
AddChange(relatedWorkDao.BuildInsertStatement(), relatedWorkDao, OperationType.INSERT);
}
}
public BugService()
{
oBugDao = new BugDao();
}
public BugService()
{
oBugDao = new BugDao();
oHistorialBugDao = new HistorialBugDao();
}
