public static int UpdateBug2(BugModel model)
{
string sql = "UPDATE BugRecords set Title = @Title, BugRecords.Source = @Source, Description = @Description, Priority = @Priority, DeadLine1 = @DeadLine1, " +
"DeadLine2 = @DeadLine2, DeadLineFinal = @DeadLineFinal, ErrorMsg = @ErrorMsg,AssignTeam = @AssignTeam, PatchDetails = @PatchDetails," +
"IsResolved = @IsResolved, Status = @Status where Id = @ID";
return(BugSqlDataAccess.SaveData(sql, model));
}
public static int CreateBug(string title, string source, string description, int priority, DateTime deadline1, string deadline2,
DateTime deadlinefinal, string errormsg, string assignteam, string patchdetails, bool isresolved, string status)
{
string varbool = null;
if (isresolved == true)
{
varbool = "true";
}
else
{
varbool = "false";
}
BugModel data = new BugModel
{
Title = title,
Source = source,
Description = description,
Priority = priority,
DateCreated = DateTime.Now.ToString("dd/MM/yyyy"),
Deadline1 = deadline1.ToString("dd/MM/yyyy"),
Deadline2 = deadline2,
DeadLineFinal = deadlinefinal.ToString("dd/MM/yyyy"),
ErrorMsg = errormsg,
AssignTeam = assignteam,
PatchDetails = patchdetails,
IsResolved = varbool,
Status = status
};
string sql = @"insert into dbo.BugRecords (Title, Source, Description, Priority, DateCreated, DeadLine1, DeadLine2, DeadLineFinal, ErrorMsg,
AssignTeam, PatchDetails, IsResolved, Status)
values (@Title, @Source, @Description, @Priority, @DateCreated ,@DeadLine1, @DeadLine2, @DeadLineFinal, @ErrorMsg,
@AssignTeam, @PatchDetails, @IsResolved, @Status)";
return(BugSqlDataAccess.SaveData(sql, data));
}
