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)); }