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