public static List <BugModel> LoadBugs()
{
string sql = @"select * from
dbo.BugRecords";
return(BugSqlDataAccess.LoadData <BugModel>(sql));
}
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 List <CatalogModel> ViewCatalog(string id)
{
string sql = "select dbo.BugRecords.Id,Title, Source, Description, DeadlineFinal, Status, dbo.EmpAuth.Username from dbo.BugRecords inner join dbo.EmpAuth " +
"on dbo.BugRecords.Source=dbo.EmpAuth.Project ";
List <CatalogModel> nq = BugSqlDataAccess.LoadData <CatalogModel>(sql);
List <CatalogModel> bq = new List <CatalogModel>();
foreach (var row in nq)
{
if (row.Username == id)
{
bq.Add(row);
}
}
return(bq);
}
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));
}
public static List <BugModel> UpdateBug(int id, string title, string source, string description, int priority, DateTime deadline1, string deadline2,
DateTime deadlinefinal, string errormsg, string assignteam, string patchdetails, string isresolved, string status)
{
BugModel data = new BugModel
{
ID = id,
Title = title,
Source = source,
Description = description,
Priority = priority,
Deadline1 = deadline1.ToString("dd/MM/yyyy"),
Deadline2 = deadline2,
DeadLineFinal = deadlinefinal.ToString("dd/MM/yyyy"),
ErrorMsg = errormsg,
AssignTeam = assignteam,
PatchDetails = patchdetails,
IsResolved = "false",
Status = status
};
return(BugSqlDataAccess.LoadData2(data));
}
public static List <AnalyticsModel> Getstats()
{
string sql = "select count(Source) as Tres, Title from dbo.BugRecords group by Title";
return(BugSqlDataAccess.SqlStat(sql));
}
public static List <BugModel> GetUpdates()
{
string sql = "select Priority,Title, Source, ErrorMsg from dbo.BugRecords group by Priority, Title, Source, ErrorMsg order by Priority desc";
return(BugSqlDataAccess.SqlFetch(sql));
}
public static int RemoveById(int id)
{
string sql = "delete from dbo.BugRecords where Id= " + id;
return(BugSqlDataAccess.SqlRemove(sql));
}
public static List <BugModel> RemoveBug(int id)
{
return(BugSqlDataAccess.DataRemove(id));
}
